Closed alberttwong closed 3 months ago
StarRocks > select * from columns;
+---------------+--------------------+-------------------------+-------------------------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+------------------+------------+-------+------------+----------------+-------------+----------------+-----------------------+--------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE | COLUMN_KEY | EXTRA | PRIVILEGES | COLUMN_COMMENT | COLUMN_SIZE | DECIMAL_DIGITS | GENERATION_EXPRESSION | SRS_ID |
+---------------+--------------------+-------------------------+-------------------------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+------------------+------------+-------+------------+----------------+-------------+----------------+-----------------------+--------+
| NULL | demo | hudi_dimcustomer | _c0 | 1 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | customerkey | 2 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | geographykey | 3 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | firstname | 4 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | lastname | 5 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | birthdate | 6 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | maritalstatus | 7 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | gender | 8 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | yearlyincome | 9 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | totalchildren | 10 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | numberchildrenathome | 11 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | education | 12 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | occupation | 13 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | houseownerflag | 14 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | demo | hudi_dimcustomer | numbercarsowned | 15 | NULL | YES | varchar | 1048576 | 3145728 | NULL | NULL | NULL | NULL | NULL | varchar(1048576) | | | | | 1048576 | NULL | NULL | NULL |
| NULL | information_schema | tables | TABLE_CATALOG | 1 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | tables | TABLE_SCHEMA | 2 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | tables | TABLE_NAME | 3 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | tables | TABLE_TYPE | 4 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | tables | ENGINE | 5 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | tables | VERSION | 6 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | tables | ROW_FORMAT | 7 | NULL | YES | varchar | 10 | 30 | NULL | NULL | NULL | NULL | NULL | varchar(10) | | | | | 10 | NULL | NULL | NULL |
| NULL | information_schema | tables | TABLE_ROWS | 8 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | tables | AVG_ROW_LENGTH | 9 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | tables | DATA_LENGTH | 10 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | tables | MAX_DATA_LENGTH | 11 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | tables | INDEX_LENGTH | 12 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | tables | DATA_FREE | 13 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | tables | AUTO_INCREMENT | 14 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | tables | CREATE_TIME | 15 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | tables | UPDATE_TIME | 16 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | tables | CHECK_TIME | 17 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | tables | TABLE_COLLATION | 18 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | tables | CHECKSUM | 19 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | tables | CREATE_OPTIONS | 20 | NULL | YES | varchar | 255 | 765 | NULL | NULL | NULL | NULL | NULL | varchar(255) | | | | | 255 | NULL | NULL | NULL |
| NULL | information_schema | tables | TABLE_COMMENT | 21 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | table_privileges | GRANTEE | 1 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | table_privileges | TABLE_CATALOG | 2 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | table_privileges | TABLE_SCHEMA | 3 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | table_privileges | TABLE_NAME | 4 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | table_privileges | PRIVILEGE_TYPE | 5 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | table_privileges | IS_GRANTABLE | 6 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | referential_constraints | CONSTRAINT_CATALOG | 1 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | referential_constraints | CONSTRAINT_SCHEMA | 2 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | referential_constraints | CONSTRAINT_NAME | 3 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | referential_constraints | UNIQUE_CONSTRAINT_CATALOG | 4 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | referential_constraints | UNIQUE_CONSTRAINT_SCHEMA | 5 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | referential_constraints | UNIQUE_CONSTRAINT_NAME | 6 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | referential_constraints | MATCH_OPTION | 7 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | referential_constraints | UPDATE_RULE | 8 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | referential_constraints | DELETE_RULE | 9 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | referential_constraints | TABLE_NAME | 10 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | referential_constraints | REFERENCED_TABLE_NAME | 11 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | key_column_usage | CONSTRAINT_CATALOG | 1 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | key_column_usage | CONSTRAINT_SCHEMA | 2 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | key_column_usage | CONSTRAINT_NAME | 3 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | key_column_usage | TABLE_CATALOG | 4 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | key_column_usage | TABLE_SCHEMA | 5 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | key_column_usage | TABLE_NAME | 6 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | key_column_usage | COLUMN_NAME | 7 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | key_column_usage | ORDINAL_POSITION | 8 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | key_column_usage | POSITION_IN_UNIQUE_CONSTRAINT | 9 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | key_column_usage | REFERENCED_TABLE_SCHEMA | 10 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | key_column_usage | REFERENCED_TABLE_NAME | 11 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | key_column_usage | REFERENCED_COLUMN_NAME | 12 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | routines | SPECIFIC_NAME | 1 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | ROUTINE_CATALOG | 2 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | ROUTINE_SCHEMA | 3 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | ROUTINE_NAME | 4 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | ROUTINE_TYPE | 5 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | DTD_IDENTIFIER | 6 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | ROUTINE_BODY | 7 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | ROUTINE_DEFINITION | 8 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | EXTERNAL_NAME | 9 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | EXTERNAL_LANGUAGE | 10 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | PARAMETER_STYLE | 11 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | IS_DETERMINISTIC | 12 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | SQL_DATA_ACCESS | 13 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | SQL_PATH | 14 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | SECURITY_TYPE | 15 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | CREATED | 16 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | routines | LAST_ALTERED | 17 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | routines | SQL_MODE | 18 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | ROUTINE_COMMENT | 19 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | DEFINER | 20 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | CHARACTER_SET_CLIENT | 21 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | COLLATION_CONNECTION | 22 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | routines | DATABASE_COLLATION | 23 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | schemata | CATALOG_NAME | 1 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | schemata | SCHEMA_NAME | 2 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | schemata | DEFAULT_CHARACTER_SET_NAME | 3 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | schemata | DEFAULT_COLLATION_NAME | 4 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | schemata | SQL_PATH | 5 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | columns | TABLE_CATALOG | 1 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | columns | TABLE_SCHEMA | 2 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | columns | TABLE_NAME | 3 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | columns | COLUMN_NAME | 4 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | columns | ORDINAL_POSITION | 5 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | columns | COLUMN_DEFAULT | 6 | NULL | YES | varchar | 1024 | 3072 | NULL | NULL | NULL | NULL | NULL | varchar(1024) | | | | | 1024 | NULL | NULL | NULL |
| NULL | information_schema | columns | IS_NULLABLE | 7 | NULL | YES | varchar | 3 | 9 | NULL | NULL | NULL | NULL | NULL | varchar(3) | | | | | 3 | NULL | NULL | NULL |
| NULL | information_schema | columns | DATA_TYPE | 8 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | columns | CHARACTER_MAXIMUM_LENGTH | 9 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | columns | CHARACTER_OCTET_LENGTH | 10 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | columns | NUMERIC_PRECISION | 11 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | columns | NUMERIC_SCALE | 12 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | columns | DATETIME_PRECISION | 13 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | columns | CHARACTER_SET_NAME | 14 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | columns | COLLATION_NAME | 15 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | columns | COLUMN_TYPE | 16 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | columns | COLUMN_KEY | 17 | NULL | YES | varchar | 3 | 9 | NULL | NULL | NULL | NULL | NULL | varchar(3) | | | | | 3 | NULL | NULL | NULL |
| NULL | information_schema | columns | EXTRA | 18 | NULL | YES | varchar | 27 | 81 | NULL | NULL | NULL | NULL | NULL | varchar(27) | | | | | 27 | NULL | NULL | NULL |
| NULL | information_schema | columns | PRIVILEGES | 19 | NULL | YES | varchar | 80 | 240 | NULL | NULL | NULL | NULL | NULL | varchar(80) | | | | | 80 | NULL | NULL | NULL |
| NULL | information_schema | columns | COLUMN_COMMENT | 20 | NULL | YES | varchar | 255 | 765 | NULL | NULL | NULL | NULL | NULL | varchar(255) | | | | | 255 | NULL | NULL | NULL |
| NULL | information_schema | columns | COLUMN_SIZE | 21 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | columns | DECIMAL_DIGITS | 22 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | columns | GENERATION_EXPRESSION | 23 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | columns | SRS_ID | 24 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | character_sets | CHARACTER_SET_NAME | 1 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | character_sets | DEFAULT_COLLATE_NAME | 2 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | character_sets | DESCRIPTION | 3 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | character_sets | MAXLEN | 4 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | collations | COLLATION_NAME | 1 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | collations | CHARACTER_SET_NAME | 2 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | collations | ID | 3 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | collations | IS_DEFAULT | 4 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | collations | IS_COMPILED | 5 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | collations | SORTLEN | 6 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | table_constraints | CONSTRAINT_CATALOG | 1 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | table_constraints | CONSTRAINT_SCHEMA | 2 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | table_constraints | CONSTRAINT_NAME | 3 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | table_constraints | TABLE_SCHEMA | 4 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | table_constraints | TABLE_NAME | 5 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | table_constraints | CONSTRAINT_TYPE | 6 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | engines | ENGINE | 1 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | engines | SUPPORT | 2 | NULL | YES | varchar | 8 | 24 | NULL | NULL | NULL | NULL | NULL | varchar(8) | | | | | 8 | NULL | NULL | NULL |
| NULL | information_schema | engines | COMMENT | 3 | NULL | YES | varchar | 80 | 240 | NULL | NULL | NULL | NULL | NULL | varchar(80) | | | | | 80 | NULL | NULL | NULL |
| NULL | information_schema | engines | TRANSACTIONS | 4 | NULL | YES | varchar | 3 | 9 | NULL | NULL | NULL | NULL | NULL | varchar(3) | | | | | 3 | NULL | NULL | NULL |
| NULL | information_schema | engines | XA | 5 | NULL | YES | varchar | 3 | 9 | NULL | NULL | NULL | NULL | NULL | varchar(3) | | | | | 3 | NULL | NULL | NULL |
| NULL | information_schema | engines | SAVEPOINTS | 6 | NULL | YES | varchar | 3 | 9 | NULL | NULL | NULL | NULL | NULL | varchar(3) | | | | | 3 | NULL | NULL | NULL |
| NULL | information_schema | user_privileges | GRANTEE | 1 | NULL | YES | varchar | 81 | 243 | NULL | NULL | NULL | NULL | NULL | varchar(81) | | | | | 81 | NULL | NULL | NULL |
| NULL | information_schema | user_privileges | TABLE_CATALOG | 2 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | user_privileges | PRIVILEGE_TYPE | 3 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | user_privileges | IS_GRANTABLE | 4 | NULL | YES | varchar | 3 | 9 | NULL | NULL | NULL | NULL | NULL | varchar(3) | | | | | 3 | NULL | NULL | NULL |
| NULL | information_schema | schema_privileges | GRANTEE | 1 | NULL | YES | varchar | 81 | 243 | NULL | NULL | NULL | NULL | NULL | varchar(81) | | | | | 81 | NULL | NULL | NULL |
| NULL | information_schema | schema_privileges | TABLE_CATALOG | 2 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | schema_privileges | TABLE_SCHEMA | 3 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | schema_privileges | PRIVILEGE_TYPE | 4 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | schema_privileges | IS_GRANTABLE | 5 | NULL | YES | varchar | 3 | 9 | NULL | NULL | NULL | NULL | NULL | varchar(3) | | | | | 3 | NULL | NULL | NULL |
| NULL | information_schema | statistics | TABLE_CATALOG | 1 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | statistics | TABLE_SCHEMA | 2 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | statistics | TABLE_NAME | 3 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | statistics | NON_UNIQUE | 4 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | statistics | INDEX_SCHEMA | 5 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | statistics | INDEX_NAME | 6 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | statistics | SEQ_IN_INDEX | 7 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | statistics | COLUMN_NAME | 8 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | statistics | COLLATION | 9 | NULL | YES | varchar | 1 | 3 | NULL | NULL | NULL | NULL | NULL | varchar(1) | | | | | 1 | NULL | NULL | NULL |
| NULL | information_schema | statistics | CARDINALITY | 10 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | statistics | SUB_PART | 11 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | statistics | PACKED | 12 | NULL | YES | varchar | 10 | 30 | NULL | NULL | NULL | NULL | NULL | varchar(10) | | | | | 10 | NULL | NULL | NULL |
| NULL | information_schema | statistics | NULLABLE | 13 | NULL | YES | varchar | 3 | 9 | NULL | NULL | NULL | NULL | NULL | varchar(3) | | | | | 3 | NULL | NULL | NULL |
| NULL | information_schema | statistics | INDEX_TYPE | 14 | NULL | YES | varchar | 16 | 48 | NULL | NULL | NULL | NULL | NULL | varchar(16) | | | | | 16 | NULL | NULL | NULL |
| NULL | information_schema | statistics | COMMENT | 15 | NULL | YES | varchar | 16 | 48 | NULL | NULL | NULL | NULL | NULL | varchar(16) | | | | | 16 | NULL | NULL | NULL |
| NULL | information_schema | statistics | INDEX_COMMENT | 16 | NULL | YES | varchar | 1024 | 3072 | NULL | NULL | NULL | NULL | NULL | varchar(1024) | | | | | 1024 | NULL | NULL | NULL |
| NULL | information_schema | triggers | TRIGGER_CATALOG | 1 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | triggers | TRIGGER_SCHEMA | 2 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | triggers | TRIGGER_NAME | 3 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | triggers | EVENT_MANIPULATION | 4 | NULL | YES | varchar | 6 | 18 | NULL | NULL | NULL | NULL | NULL | varchar(6) | | | | | 6 | NULL | NULL | NULL |
| NULL | information_schema | triggers | EVENT_OBJECT_CATALOG | 5 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | triggers | EVENT_OBJECT_SCHEMA | 6 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | triggers | EVENT_OBJECT_TABLE | 7 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | triggers | ACTION_ORDER | 8 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | triggers | ACTION_CONDITION | 9 | NULL | YES | varchar | 65535 | 196605 | NULL | NULL | NULL | NULL | NULL | varchar(65535) | | | | | 65535 | NULL | NULL | NULL |
| NULL | information_schema | triggers | ACTION_STATEMENT | 10 | NULL | YES | varchar | 65535 | 196605 | NULL | NULL | NULL | NULL | NULL | varchar(65535) | | | | | 65535 | NULL | NULL | NULL |
| NULL | information_schema | triggers | ACTION_ORIENTATION | 11 | NULL | YES | varchar | 9 | 27 | NULL | NULL | NULL | NULL | NULL | varchar(9) | | | | | 9 | NULL | NULL | NULL |
| NULL | information_schema | triggers | ACTION_TIMING | 12 | NULL | YES | varchar | 6 | 18 | NULL | NULL | NULL | NULL | NULL | varchar(6) | | | | | 6 | NULL | NULL | NULL |
| NULL | information_schema | triggers | ACTION_REFERENCE_OLD_TABLE | 13 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | triggers | ACTION_REFERENCE_NEW_TABLE | 14 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | triggers | ACTION_REFERENCE_OLD_ROW | 15 | NULL | YES | varchar | 3 | 9 | NULL | NULL | NULL | NULL | NULL | varchar(3) | | | | | 3 | NULL | NULL | NULL |
| NULL | information_schema | triggers | ACTION_REFERENCE_NEW_ROW | 16 | NULL | YES | varchar | 3 | 9 | NULL | NULL | NULL | NULL | NULL | varchar(3) | | | | | 3 | NULL | NULL | NULL |
| NULL | information_schema | triggers | CREATED | 17 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | triggers | SQL_MODE | 18 | NULL | YES | varchar | 8192 | 24576 | NULL | NULL | NULL | NULL | NULL | varchar(8192) | | | | | 8192 | NULL | NULL | NULL |
| NULL | information_schema | triggers | DEFINER | 19 | NULL | YES | varchar | 77 | 231 | NULL | NULL | NULL | NULL | NULL | varchar(77) | | | | | 77 | NULL | NULL | NULL |
| NULL | information_schema | triggers | CHARACTER_SET_CLIENT | 20 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | triggers | COLLATION_CONNECTION | 21 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | triggers | DATABASE_COLLATION | 22 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | events | EVENT_CATALOG | 1 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | events | EVENT_SCHEMA | 2 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | events | EVENT_NAME | 3 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | events | DEFINER | 4 | NULL | YES | varchar | 77 | 231 | NULL | NULL | NULL | NULL | NULL | varchar(77) | | | | | 77 | NULL | NULL | NULL |
| NULL | information_schema | events | TIME_ZONE | 5 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | events | EVENT_BODY | 6 | NULL | YES | varchar | 8 | 24 | NULL | NULL | NULL | NULL | NULL | varchar(8) | | | | | 8 | NULL | NULL | NULL |
| NULL | information_schema | events | EVENT_DEFINITION | 7 | NULL | YES | varchar | 65535 | 196605 | NULL | NULL | NULL | NULL | NULL | varchar(65535) | | | | | 65535 | NULL | NULL | NULL |
| NULL | information_schema | events | EVENT_TYPE | 8 | NULL | YES | varchar | 9 | 27 | NULL | NULL | NULL | NULL | NULL | varchar(9) | | | | | 9 | NULL | NULL | NULL |
| NULL | information_schema | events | EXECUTE_AT | 9 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | events | INTERVAL_VALUE | 10 | NULL | YES | varchar | 256 | 768 | NULL | NULL | NULL | NULL | NULL | varchar(256) | | | | | 256 | NULL | NULL | NULL |
| NULL | information_schema | events | INTERVAL_FIELD | 11 | NULL | YES | varchar | 18 | 54 | NULL | NULL | NULL | NULL | NULL | varchar(18) | | | | | 18 | NULL | NULL | NULL |
| NULL | information_schema | events | SQL_MODE | 12 | NULL | YES | varchar | 8192 | 24576 | NULL | NULL | NULL | NULL | NULL | varchar(8192) | | | | | 8192 | NULL | NULL | NULL |
| NULL | information_schema | events | STARTS | 13 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | events | ENDS | 14 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | events | STATUS | 15 | NULL | YES | varchar | 18 | 54 | NULL | NULL | NULL | NULL | NULL | varchar(18) | | | | | 18 | NULL | NULL | NULL |
| NULL | information_schema | events | ON_COMPLETION | 16 | NULL | YES | varchar | 12 | 36 | NULL | NULL | NULL | NULL | NULL | varchar(12) | | | | | 12 | NULL | NULL | NULL |
| NULL | information_schema | events | CREATED | 17 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | events | LAST_ALTERED | 18 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | events | LAST_EXECUTED | 19 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | events | EVENT_COMMENT | 20 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | events | ORIGINATOR | 21 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | events | CHARACTER_SET_CLIENT | 22 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | events | COLLATION_CONNECTION | 23 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | events | DATABASE_COLLATION | 24 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | views | TABLE_CATALOG | 1 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | views | TABLE_SCHEMA | 2 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | views | TABLE_NAME | 3 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | NULL | NULL | varchar(64) | | | | | 64 | NULL | NULL | NULL |
| NULL | information_schema | views | VIEW_DEFINITION | 4 | NULL | YES | varchar | 65535 | 196605 | NULL | NULL | NULL | NULL | NULL | varchar(65535) | | | | | 65535 | NULL | NULL | NULL |
| NULL | information_schema | views | CHECK_OPTION | 5 | NULL | YES | varchar | 8 | 24 | NULL | NULL | NULL | NULL | NULL | varchar(8) | | | | | 8 | NULL | NULL | NULL |
| NULL | information_schema | views | IS_UPDATABLE | 6 | NULL | YES | varchar | 3 | 9 | NULL | NULL | NULL | NULL | NULL | varchar(3) | | | | | 3 | NULL | NULL | NULL |
| NULL | information_schema | views | DEFINER | 7 | NULL | YES | varchar | 77 | 231 | NULL | NULL | NULL | NULL | NULL | varchar(77) | | | | | 77 | NULL | NULL | NULL |
| NULL | information_schema | views | SECURITY_TYPE | 8 | NULL | YES | varchar | 7 | 21 | NULL | NULL | NULL | NULL | NULL | varchar(7) | | | | | 7 | NULL | NULL | NULL |
| NULL | information_schema | views | CHARACTER_SET_CLIENT | 9 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | views | COLLATION_CONNECTION | 10 | NULL | YES | varchar | 32 | 96 | NULL | NULL | NULL | NULL | NULL | varchar(32) | | | | | 32 | NULL | NULL | NULL |
| NULL | information_schema | partitions | TABLE_CATALOG | 1 | NULL | YES | varchar | 512 | 1536 | NULL | NULL | NULL | NULL | NULL | varchar(512) | | | | | 512 | NULL | NULL | NULL |
| NULL | information_schema | partitions | TABLE_SCHEMA | 2 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | partitions | TABLE_NAME | 3 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | partitions | PARTITION_NAME | 4 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | partitions | SUBPARTITION_NAME | 5 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | partitions | PARTITION_ORDINAL_POSITION | 6 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | partitions | PARTITION_METHOD | 7 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | partitions | SUBPARTITION_METHOD | 8 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | partitions | PARTITION_EXPRESSION | 9 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | partitions | SUBPARTITION_EXPRESSION | 10 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | partitions | PARTITION_DESCRIPTION | 11 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | partitions | TABLE_ROWS | 12 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | partitions | AVG_ROW_LENGTH | 13 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | partitions | DATA_LENGTH | 14 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | partitions | MAX_DATA_LENGTH | 15 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | partitions | INDEX_LENGTH | 16 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | partitions | DATA_FREE | 17 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | partitions | CREATE_TIME | 18 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | partitions | UPDATE_TIME | 19 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | partitions | CHECK_TIME | 20 | NULL | YES | datetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | datetime | | | | | NULL | NULL | NULL | NULL |
| NULL | information_schema | partitions | CHECKSUM | 21 | NULL | YES | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | | | | | 19 | 0 | NULL | NULL |
| NULL | information_schema | partitions | PARTITION_COMMENT | 22 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | partitions | NODEGROUP | 23 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | partitions | TABLESPACE_NAME | 24 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | column_privileges | GRANTEE | 1 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | column_privileges | TABLE_CATALOG | 2 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | column_privileges | TABLE_SCHEMA | 3 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | column_privileges | TABLE_NAME | 4 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | column_privileges | COLUMN_NAME | 5 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | column_privileges | PRIVILEGE_TYPE | 6 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
| NULL | information_schema | column_privileges | IS_GRANTABLE | 7 | NULL | YES | varchar | 2048 | 6144 | NULL | NULL | NULL | NULL | NULL | varchar(2048) | | | | | 2048 | NULL | NULL | NULL |
+---------------+--------------------+-------------------------+-------------------------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+------------------+------------+-------+------------+----------------+-------------+----------------+-----------------------+--------+
251 rows in set (0.10 sec)
does not have problems with iceberg.
StarRocks > drop catalog iceberg;
Query OK, 0 rows affected (0.02 sec)
StarRocks > CREATE EXTERNAL CATALOG iceberg
-> PROPERTIES
-> (
-> "type" = "iceberg",
-> "iceberg.catalog.type" = "hive",
-> "hive.metastore.uris" = "thrift://hive-metastore:9083",
-> "aws.s3.use_instance_profile" = "false",
-> "aws.s3.access_key" = "admin",
-> "aws.s3.secret_key" = "password",
-> "aws.s3.region" = "us-east-1",
-> "aws.s3.enable_ssl" = "false",
-> "aws.s3.enable_path_style_access" = "true",
-> "aws.s3.endpoint" = "http://minio:9000"
-> );
Query OK, 0 rows affected (0.02 sec)
StarRocks > set catalog iceberg;
Query OK, 0 rows affected (0.00 sec)
StarRocks > show databases;
+--------------------+
| Database |
+--------------------+
| default |
| demo |
| information_schema |
+--------------------+
3 rows in set (0.17 sec)
StarRocks > use demo;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
StarRocks > show tables;
+------------------+
| Tables_in_demo |
+------------------+
| hudi_dimcustomer |
+------------------+
1 row in set (0.05 sec)
StarRocks > select * from hudi_dimcustomer;
+------+-------------+--------------+-------------+---------------+------------+---------------+--------+--------------+---------------+----------------------+---------------------+----------------+----------------+-----------------+
| _c0 | CustomerKey | GeographyKey | FirstName | LastName | BirthDate | MaritalStatus | Gender | YearlyIncome | TotalChildren | NumberChildrenAtHome | Education | Occupation | HouseOwnerFlag | NumberCarsOwned |
+------+-------------+--------------+-------------+---------------+------------+---------------+--------+--------------+---------------+----------------------+---------------------+----------------+----------------+-----------------+
| 4096 | 12965 | 543 | Arturo | Nara | 1934-09-22 | S | M | 10000.0 | 1.0 | 0.0 | Graduate Degree | Manual | 1.0 | 0.0 |
| 4097 | 12966 | 483 | Dustin | Shan | 1962-07-26 | S | M | 10000.0 | 1.0 | 0.0 | Graduate Degree | Manual | 0.0 | 0.0 |
| 4098 | 12967 | 498 | Grant | Sharma | 1962-03-03 | M | M | 20000.0 | 1.0 | 0.0 | Graduate Degree | Manual | 0.0 | 0.0 |
@alberttwong I don't think col stats was enabled when writing out the hudi table so you'll likely need to work with starrocks to figure out how to handle that case.
Yes. I have this issue cross posted into our github for visibility.
Following https://onetable.dev/docs/demo/docker/ with PR https://github.com/onetable-io/onetable/pull/320
Trying to query from starrocks