Re: Index table in SYSTEM.CATALOG without DATA_TABLE_NAME and INDEX_TYPE

Thank you James! On Tue, Feb 6, 2018 at 10:21 AM James Taylor wrote: > Hi William, > The system catalog table changes as new features are implemented. The API > that you can count on being stable is JDBC and in particular for metadata, > our DatabaseMetaData

Re: Index table in SYSTEM.CATALOG without DATA_TABLE_NAME and INDEX_TYPE

Hi William, The system catalog table changes as new features are implemented. The API that you can count on being stable is JDBC and in particular for metadata, our DatabaseMetaData implementation. To understand how the system catalog changes from release to release you'd need to keep an eye on

Re: Index table in SYSTEM.CATALOG without DATA_TABLE_NAME and INDEX_TYPE

Looks like it is just how Phoenix 4.10 behaves different when creating an index...? Is there a place where we document the difference in how table metadata is handled for each release? Thanks in advance for your help! 0: jdbc:phoenix:labs-darth-journalnode-lv-101> create index test_users on

Index table in SYSTEM.CATALOG without DATA_TABLE_NAME and INDEX_TYPE

Hi everyone, I am investigating a strange looking entry in our SYSTEM.CATALOG table. The row is an index table (TABLE_TYPE = i) but it does not contain any other index information (no DATA_TABLE_NAME and INDEX_TYPE, etc.). Has anyone encountered similar situation, or is there any other way to