0: jdbc:ignite:thin://127.0.0.1/> select * from sys.tables; . . . . . . . . . . . . . . . . > select * from sys.table_columns; . . . . . . . . . . . . . . . . > select CACHE_NAME,SCHEMA_NAME,TABLE_NAME,INDEX_NAME,INDEX_TYPE,COLUMNS,IS_PK,IS_UNIQUE,INLINE_SIZE from sys.indexes; . . . . . . . . . . . . . . . . > select * from sys.binary_metadata; . . . . . . . . . . . . . . . . > select * from person; +----------------+------------------+------------+-------------+-------------+------------+---------------------+-----------+-------------+-----------------------------------------------------------------+ | CACHE_GROUP_ID | CACHE_GROUP_NAME | CACHE_ID | CACHE_NAME | SCHEMA_NAME | TABLE_NAME | AFFINITY_KEY_COLUMN | KEY_ALIAS | VALUE_ALIAS | KEY_TYPE_NAME | +----------------+------------------+------------+-------------+-------------+------------+---------------------+-----------+-------------+-----------------------------------------------------------------+ | 1215863053 | PersonCache | 1215863053 | PersonCache | PUBLIC | PERSON | ID | | | org.apache.ignite.internal.systemview.SqlIndexSystemViewReprodu | +----------------+------------------+------------+-------------+-------------+------------+---------------------+-----------+-------------+-----------------------------------------------------------------+ 1 row selected (0.008 seconds) +-------------+------------+-------------+-----------------+----------------+---------------+----------+-------+-----------+-------+------------------+ | COLUMN_NAME | TABLE_NAME | SCHEMA_NAME | AFFINITY_COLUMN | AUTO_INCREMENT | DEFAULT_VALUE | NULLABLE | PK | PRECISION | SCALE | TYPE | +-------------+------------+-------------+-----------------+----------------+---------------+----------+-------+-----------+-------+------------------+ | _KEY | PERSON | PUBLIC | false | false | | false | true | -1 | -1 | | | _VAL | PERSON | PUBLIC | false | false | | true | false | -1 | -1 | | | ID | PERSON | PUBLIC | true | false | null | true | false | -1 | -1 | java.lang.Long | | FIRSTNAME | PERSON | PUBLIC | false | false | null | true | false | -1 | -1 | java.lang.String | | LASTNAME | PERSON | PUBLIC | false | false | null | true | false | -1 | -1 | java.lang.String | | ORGNAME | PERSON | PUBLIC | false | false | null | true | false | -1 | -1 | java.lang.String | | CITYNAME | PERSON | PUBLIC | false | false | null | true | false | -1 | -1 | java.lang.String | | SALARY | PERSON | PUBLIC | false | false | null | true | false | -1 | -1 | java.lang.Double | +-------------+------------+-------------+-----------------+----------------+---------------+----------+-------+-----------+-------+------------------+ 8 rows selected (0.011 seconds) +-------------+-------------+------------+-------------------------+------------+-----------------------------------------------------------+-------+-----------+-------------+ | CACHE_NAME | SCHEMA_NAME | TABLE_NAME | INDEX_NAME | INDEX_TYPE | COLUMNS | IS_PK | IS_UNIQUE | INLINE_SIZE | +-------------+-------------+------------+-------------------------+------------+-----------------------------------------------------------+-------+-----------+-------------+ | PersonCache | PUBLIC | PERSON | _key_PK_hash | HASH | "ID" ASC, "FIRSTNAME" ASC, "LASTNAME" ASC, "ID" ASC | false | true | null | | PersonCache | PUBLIC | PERSON | __SCAN_ | SCAN | | false | false | null | | PersonCache | PUBLIC | PERSON | _key_PK | BTREE | "ID" ASC, "FIRSTNAME" ASC, "LASTNAME" ASC | true | true | 29 | | PersonCache | PUBLIC | PERSON | AFFINITY_KEY | BTREE | "ID" ASC, "FIRSTNAME" ASC, "LASTNAME" ASC | false | false | 29 | | PersonCache | PUBLIC | PERSON | PERSONINFO_CITYNAME_IDX | BTREE | "CITYNAME" ASC, "ID" ASC, "FIRSTNAME" ASC, "LASTNAME" ASC | false | false | 39 | +-------------+-------------+------------+-------------------------+------------+-----------------------------------------------------------+-------+-----------+-------------+ 5 rows selected (0.009 seconds) +------------+-----------------------------------------------------------------------------------+--------------------+--------------+-----------------------------+---------------+---------+ | TYPE_ID | TYPE_NAME | AFF_KEY_FIELD_NAME | FIELDS_COUNT | FIELDS | SCHEMAS_IDS | IS_ENUM | +------------+-----------------------------------------------------------------------------------+--------------------+--------------+-----------------------------+---------------+---------+ | -791318591 | org.apache.ignite.internal.systemview.SqlIndexSystemViewReproducerTest$PersonInfo | | 3 | [orgName, cityName, salary] | [-1344255676] | false | | -302619412 | org.apache.ignite.internal.systemview.SqlIndexSystemViewReproducerTest$PersonKey | ID | 3 | [ID, firstName, lastName] | [-1778187397] | false | +------------+-----------------------------------------------------------------------------------+--------------------+--------------+-----------------------------+---------------+---------+ 2 rows selected (0.01 seconds) +----+-----------+----------+----------+--------------+---------+ | ID | FIRSTNAME | LASTNAME | ORGNAME | CITYNAME | SALARY | +----+-----------+----------+----------+--------------+---------+ | 1 | John | Doe | OrgInc | Default City | 12000.0 | | 2 | Jane | Doe | OtherOrg | Other City | 14000.0 | +----+-----------+----------+----------+--------------+---------+ 2 rows selected (0.01 seconds)