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
investigate how the entry was created?
By the way, is there any documentation available on the SYSTEM.CATALOG,
that I can check to make I am understanding the information in this table
correctly?
Thanks!
We are running Phoenix 4.10 (upgraded previous from 4.8 and from 4.6)
Here is a few more details on this strange "index":
SELECT * from system.catalog where table_schem = 'prod' and data_table_name
is null and TABLE_TYPE = 'i';
TENANT_ID
TABLE_SCHEM prod
TABLE_NAME RULES
COLUMN_NAME
COLUMN_FAMILY IDX_ID_RULES
TABLE_SEQ_NUM 0
TABLE_TYPE i
PK_NAME
COLUMN_COUNT null
SALT_BUCKETS null
DATA_TABLE_NAME
INDEX_STATE
IMMUTABLE_ROWS
VIEW_STATEMENT
DEFAULT_COLUMN_FAMILY
DISABLE_WAL
MULTI_TENANT
VIEW_TYPE null
VIEW_INDEX_ID null
DATA_TYPE null
COLUMN_SIZE null
DECIMAL_DIGITS null
NULLABLE null
ORDINAL_POSITION null
SORT_ORDER null
ARRAY_SIZE null
VIEW_CONSTANT
IS_VIEW_REFERENCED
KEY_SEQ null
LINK_TYPE 1
TYPE_NAME
REMARKS
SELF_REFERENCING_COL_NAME
REF_GENERATION
BUFFER_LENGTH null
NUM_PREC_RADIX null
COLUMN_DEF
SQL_DATA_TYPE null
SQL_DATETIME_SUB null
CHAR_OCTET_LENGTH null
IS_NULLABLE
SCOPE_CATALOG
SCOPE_SCHEMA
SCOPE_TABLE
SOURCE_DATA_TYPE null
IS_AUTOINCREMENT
INDEX_TYPE null
INDEX_DISABLE_TIMESTAMP null
STORE_NULLS
BASE_COLUMN_COUNT null
IS_ROW_TIMESTAMP
TRANSACTIONAL
UPDATE_CACHE_FREQUENCY null
IS_NAMESPACE_MAPPED
AUTO_PARTITION_SEQ
APPEND_ONLY_SCHEMA
GUIDE_POSTS_WIDTH null
COLUMN_QUALIFIER
IMMUTABLE_STORAGE_SCHEME null
ENCODING_SCHEME null
QUALIFIER_COUNTER null
We actually have the normal-looking index IDX_ID_RULES created for the
RULES table, here:
SELECT * from system.catalog where table_schem = 'prod' and data_table_name
= 'RULES' and TABLE_TYPE = 'i';
TENANT_ID
TABLE_SCHEM prod
TABLE_NAME IDX_ID_RULES
COLUMN_NAME
COLUMN_FAMILY
TABLE_SEQ_NUM 0
TABLE_TYPE i
PK_NAME
COLUMN_COUNT 4
SALT_BUCKETS 255
DATA_TABLE_NAME RULES
INDEX_STATE a
IMMUTABLE_ROWS false
VIEW_STATEMENT
DEFAULT_COLUMN_FAMILY
DISABLE_WAL false
MULTI_TENANT false
VIEW_TYPE null
VIEW_INDEX_ID null
DATA_TYPE null
COLUMN_SIZE null
DECIMAL_DIGITS null
NULLABLE null
ORDINAL_POSITION null
SORT_ORDER null
ARRAY_SIZE null
VIEW_CONSTANT
IS_VIEW_REFERENCED
KEY_SEQ null
LINK_TYPE null
TYPE_NAME
REMARKS
SELF_REFERENCING_COL_NAME
REF_GENERATION
BUFFER_LENGTH null
NUM_PREC_RADIX null
COLUMN_DEF
SQL_DATA_TYPE null
SQL_DATETIME_SUB null
CHAR_OCTET_LENGTH null
IS_NULLABLE
SCOPE_CATALOG
SCOPE_SCHEMA
SCOPE_TABLE
SOURCE_DATA_TYPE null
IS_AUTOINCREMENT
INDEX_TYPE 1
INDEX_DISABLE_TIMESTAMP 0
STORE_NULLS false
BASE_COLUMN_COUNT -1
IS_ROW_TIMESTAMP
TRANSACTIONAL false
UPDATE_CACHE_FREQUENCY 0
IS_NAMESPACE_MAPPED false
AUTO_PARTITION_SEQ
APPEND_ONLY_SCHEMA false
GUIDE_POSTS_WIDTH null
COLUMN_QUALIFIER
IMMUTABLE_STORAGE_SCHEME 1
ENCODING_SCHEME 2
QUALIFIER_COUNTER null
|