+-----------------------+ | tab_name | +-----------------------+ | column_privileges | | columns | | compactions | | scheduled_executions | | scheduled_queries | | schemata | | table_privileges | | tables | | views | +-----------------------+ 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> describe formatted information_schema.views; INFO : Compiling command(queryId=hive_20231207212443_c0a1557b-8041-4444-89dd-35aa81ede5dd): describe formatted information_schema.views INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207212443_c0a1557b-8041-4444-89dd-35aa81ede5dd); Time taken: 0.029 seconds INFO : Executing command(queryId=hive_20231207212443_c0a1557b-8041-4444-89dd-35aa81ede5dd): describe formatted information_schema.views INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207212443_c0a1557b-8041-4444-89dd-35aa81ede5dd); Time taken: 0.027 seconds INFO : OK +-------------------------------+----------------------------------------------------+-----------------------+ | col_name | data_type | comment | +-------------------------------+----------------------------------------------------+-----------------------+ | table_catalog | string | | | table_schema | string | | | table_name | string | | | view_definition | string | | | check_option | string | | | is_updatable | boolean | | | is_insertable_into | boolean | | | is_trigger_updatable | boolean | | | is_trigger_deletable | boolean | | | is_trigger_insertable_into | boolean | | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | information_schema | NULL | | OwnerType: | USER | NULL | | Owner: | hive | NULL | | CreateTime: | Tue Dec 05 17:25:38 UTC 2023 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Table Type: | VIRTUAL_VIEW | NULL | | Table Parameters: | NULL | NULL | | | bucketing_version | 2 | | | transient_lastDdlTime | 1701797138 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | null | NULL | | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL | | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | | NULL | NULL | | # View Information | NULL | NULL | | Original Query: | SELECT DISTINCT 'default', D.NAME, T.TBL_NAME, T.VIEW_ORIGINAL_TEXT, CAST(NULL as string), false, false, false, false, false FROM sys.DBS D JOIN sys.TBLS T ON (D.DB_ID = T.DB_ID) LEFT JOIN sys.TBL_PRIVS P ON (T.TBL_ID = P.TBL_ID) WHERE length(T.VIEW_ORIGINAL_TEXT) > 0 AND (NOT restrict_information_schema() OR P.TBL_ID IS NOT NULL AND (P.PRINCIPAL_NAME=current_user() AND P.PRINCIPAL_TYPE='USER' OR ((array_contains(current_groups(), P.PRINCIPAL_NAME) OR P.PRINCIPAL_NAME = 'public') AND P.PRINCIPAL_TYPE='GROUP')) AND P.TBL_PRIV='SELECT' AND P.AUTHORIZER=current_authorizer()) | NULL | | Expanded Query: | SELECT `_c0` AS `table_catalog`, `name` AS `table_schema`, `tbl_name` AS `table_name`, `view_original_text` AS `view_definition`, `_c4` AS `check_option`, `_c5` AS `is_updatable`, `_c6` AS `is_insertable_into`, `_c7` AS `is_trigger_updatable`, `_c8` AS `is_trigger_deletable`, `_c9` AS `is_trigger_insertable_into` FROM (SELECT DISTINCT 'default', `d`.`name`, `t`.`tbl_name`, `t`.`view_original_text`, CAST(NULL as string), false, false, false, false, false FROM `sys`.`DBS` `D` JOIN `sys`.`TBLS` `T` ON (`d`.`db_id` = `t`.`db_id`) LEFT JOIN `sys`.`TBL_PRIVS` `P` ON (`t`.`tbl_id` = `p`.`tbl_id`) WHERE length(`t`.`view_original_text`) > 0 AND (NOT restrict_information_schema() OR `p`.`tbl_id` IS NOT NULL AND (`p`.`principal_name`=current_user() AND `p`.`principal_type`='USER' OR ((array_contains(current_groups(), `p`.`principal_name`) OR `p`.`principal_name` = 'public') AND `p`.`principal_type`='GROUP')) AND `p`.`tbl_priv`='SELECT' AND `p`.`authorizer`=current_authorizer())) `VIEWS` | NULL | +-------------------------------+----------------------------------------------------+-----------------------+ 35 rows selected (0.592 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> show create table information_schema.views; INFO : Compiling command(queryId=hive_20231207212507_68406b0e-3f89-4ea3-aad2-121049f7968c): show create table information_schema.views INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207212507_68406b0e-3f89-4ea3-aad2-121049f7968c); Time taken: 0.02 seconds INFO : Executing command(queryId=hive_20231207212507_68406b0e-3f89-4ea3-aad2-121049f7968c): show create table information_schema.views INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207212507_68406b0e-3f89-4ea3-aad2-121049f7968c); Time taken: 0.011 seconds INFO : OK +----------------------------------------------------+ | createtab_stmt | +----------------------------------------------------+ | CREATE VIEW `information_schema`.`views` AS SELECT `_c0` AS `table_catalog`, `name` AS `table_schema`, `tbl_name` AS `table_name`, `view_original_text` AS `view_definition`, `_c4` AS `check_option`, `_c5` AS `is_updatable`, `_c6` AS `is_insertable_into`, `_c7` AS `is_trigger_updatable`, `_c8` AS `is_trigger_deletable`, `_c9` AS `is_trigger_insertable_into` FROM (SELECT DISTINCT 'default', `d`.`name`, `t`.`tbl_name`, `t`.`view_original_text`, CAST(NULL as string), false, false, false, false, false FROM `sys`.`DBS` `D` JOIN `sys`.`TBLS` `T` ON (`d`.`db_id` = `t`.`db_id`) LEFT JOIN `sys`.`TBL_PRIVS` `P` ON (`t`.`tbl_id` = `p`.`tbl_id`) WHERE length(`t`.`view_original_text`) > 0 AND (NOT restrict_information_schema() OR `p`.`tbl_id` IS NOT NULL AND (`p`.`principal_name`=current_user() AND `p`.`principal_type`='USER' OR ((array_contains(current_groups(), `p`.`principal_name`) OR `p`.`principal_name` = 'public') AND `p`.`principal_type`='GROUP')) AND `p`.`tbl_priv`='SELECT' AND `p`.`authorizer`=current_authorizer())) `VIEWS` | +----------------------------------------------------+ 1 row selected (0.604 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> describe formatted information_schema.table_privileges; INFO : Compiling command(queryId=hive_20231207213026_6e67bd1f-f72e-41ee-9025-9e211c466930): describe formatted information_schema.table_privileges INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213026_6e67bd1f-f72e-41ee-9025-9e211c466930); Time taken: 0.025 seconds INFO : Executing command(queryId=hive_20231207213026_6e67bd1f-f72e-41ee-9025-9e211c466930): describe formatted information_schema.table_privileges INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213026_6e67bd1f-f72e-41ee-9025-9e211c466930); Time taken: 0.023 seconds INFO : OK +-------------------------------+----------------------------------------------------+-----------------------+ | col_name | data_type | comment | +-------------------------------+----------------------------------------------------+-----------------------+ | grantor | string | | | grantee | string | | | table_catalog | string | | | table_schema | string | | | table_name | string | | | privilege_type | string | | | is_grantable | string | | | with_hierarchy | string | | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | information_schema | NULL | | OwnerType: | USER | NULL | | Owner: | hive | NULL | | CreateTime: | Tue Dec 05 17:25:34 UTC 2023 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Table Type: | VIRTUAL_VIEW | NULL | | Table Parameters: | NULL | NULL | | | bucketing_version | 2 | | | transient_lastDdlTime | 1701797134 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | null | NULL | | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL | | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | | NULL | NULL | | # View Information | NULL | NULL | | Original Query: | SELECT DISTINCT P.GRANTOR, P.PRINCIPAL_NAME, 'default', D.NAME, T.TBL_NAME, P.TBL_PRIV, IF (P.GRANT_OPTION == 0, 'NO', 'YES'), 'NO' FROM sys.TBL_PRIVS P JOIN sys.TBLS T ON (P.TBL_ID = T.TBL_ID) JOIN sys.DBS D ON (T.DB_ID = D.DB_ID) LEFT JOIN sys.TBL_PRIVS P2 ON (P.TBL_ID = P2.TBL_ID) WHERE NOT restrict_information_schema() OR (P2.TBL_ID IS NOT NULL AND P.PRINCIPAL_NAME = P2.PRINCIPAL_NAME AND P.PRINCIPAL_TYPE = P2.PRINCIPAL_TYPE AND (P2.PRINCIPAL_NAME=current_user() AND P2.PRINCIPAL_TYPE='USER' OR ((array_contains(current_groups(), P2.PRINCIPAL_NAME) OR P2.PRINCIPAL_NAME = 'public') AND P2.PRINCIPAL_TYPE='GROUP')) AND P2.TBL_PRIV='SELECT' AND P.AUTHORIZER = current_authorizer() AND P2.AUTHORIZER = current_authorizer()) | NULL | | Expanded Query: | SELECT `grantor` AS `grantor`, `principal_name` AS `grantee`, `_c2` AS `table_catalog`, `name` AS `table_schema`, `tbl_name` AS `table_name`, `tbl_priv` AS `privilege_type`, `_c6` AS `is_grantable`, `_c7` AS `with_hierarchy` FROM (SELECT DISTINCT `p`.`grantor`, `p`.`principal_name`, 'default', `d`.`name`, `t`.`tbl_name`, `p`.`tbl_priv`, IF (`p`.`grant_option` == 0, 'NO', 'YES'), 'NO' FROM `sys`.`TBL_PRIVS` `P` JOIN `sys`.`TBLS` `T` ON (`p`.`tbl_id` = `t`.`tbl_id`) JOIN `sys`.`DBS` `D` ON (`t`.`db_id` = `d`.`db_id`) LEFT JOIN `sys`.`TBL_PRIVS` `P2` ON (`p`.`tbl_id` = `p2`.`tbl_id`) WHERE NOT restrict_information_schema() OR (`p2`.`tbl_id` IS NOT NULL AND `p`.`principal_name` = `p2`.`principal_name` AND `p`.`principal_type` = `p2`.`principal_type` AND (`p2`.`principal_name`=current_user() AND `p2`.`principal_type`='USER' OR ((array_contains(current_groups(), `p2`.`principal_name`) OR `p2`.`principal_name` = 'public') AND `p2`.`principal_type`='GROUP')) AND `p2`.`tbl_priv`='SELECT' AND `p`.`authorizer` = current_authorizer() AND `p2`.`authorizer` = current_authorizer())) `TABLE_PRIVILEGES` | NULL | +-------------------------------+----------------------------------------------------+-----------------------+ 33 rows selected (0.624 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> show create table information_schema.table_privileges; INFO : Compiling command(queryId=hive_20231207213037_2ef04fad-86dc-43ca-824c-5211d4140ac2): show create table information_schema.table_privileges INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213037_2ef04fad-86dc-43ca-824c-5211d4140ac2); Time taken: 0.019 seconds INFO : Executing command(queryId=hive_20231207213037_2ef04fad-86dc-43ca-824c-5211d4140ac2): show create table information_schema.table_privileges INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213037_2ef04fad-86dc-43ca-824c-5211d4140ac2); Time taken: 0.009 seconds INFO : OK +----------------------------------------------------+ | createtab_stmt | +----------------------------------------------------+ | CREATE VIEW `information_schema`.`table_privileges` AS SELECT `grantor` AS `grantor`, `principal_name` AS `grantee`, `_c2` AS `table_catalog`, `name` AS `table_schema`, `tbl_name` AS `table_name`, `tbl_priv` AS `privilege_type`, `_c6` AS `is_grantable`, `_c7` AS `with_hierarchy` FROM (SELECT DISTINCT `p`.`grantor`, `p`.`principal_name`, 'default', `d`.`name`, `t`.`tbl_name`, `p`.`tbl_priv`, IF (`p`.`grant_option` == 0, 'NO', 'YES'), 'NO' FROM `sys`.`TBL_PRIVS` `P` JOIN `sys`.`TBLS` `T` ON (`p`.`tbl_id` = `t`.`tbl_id`) JOIN `sys`.`DBS` `D` ON (`t`.`db_id` = `d`.`db_id`) LEFT JOIN `sys`.`TBL_PRIVS` `P2` ON (`p`.`tbl_id` = `p2`.`tbl_id`) WHERE NOT restrict_information_schema() OR (`p2`.`tbl_id` IS NOT NULL AND `p`.`principal_name` = `p2`.`principal_name` AND `p`.`principal_type` = `p2`.`principal_type` AND (`p2`.`principal_name`=current_user() AND `p2`.`principal_type`='USER' OR ((array_contains(current_groups(), `p2`.`principal_name`) OR `p2`.`principal_name` = 'public') AND `p2`.`principal_type`='GROUP')) AND `p2`.`tbl_priv`='SELECT' AND `p`.`authorizer` = current_authorizer() AND `p2`.`authorizer` = current_authorizer())) `TABLE_PRIVILEGES` | +----------------------------------------------------+ 1 row selected (0.618 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> describe formatted information_schema.tables; INFO : Compiling command(queryId=hive_20231207212800_064a2053-40a9-4ca6-830f-5c63a499a9e6): describe formatted information_schema.tables INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207212800_064a2053-40a9-4ca6-830f-5c63a499a9e6); Time taken: 0.023 seconds INFO : Executing command(queryId=hive_20231207212800_064a2053-40a9-4ca6-830f-5c63a499a9e6): describe formatted information_schema.tables INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207212800_064a2053-40a9-4ca6-830f-5c63a499a9e6); Time taken: 0.026 seconds INFO : OK +-------------------------------+----------------------------------------------------+-----------------------+ | col_name | data_type | comment | +-------------------------------+----------------------------------------------------+-----------------------+ | table_catalog | string | | | table_schema | string | | | table_name | string | | | table_type | string | | | self_referencing_column_name | string | | | reference_generation | string | | | user_defined_type_catalog | string | | | user_defined_type_schema | string | | | user_defined_type_name | string | | | is_insertable_into | string | | | is_typed | string | | | commit_action | string | | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | information_schema | NULL | | OwnerType: | USER | NULL | | Owner: | hive | NULL | | CreateTime: | Tue Dec 05 17:25:32 UTC 2023 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Table Type: | VIRTUAL_VIEW | NULL | | Table Parameters: | NULL | NULL | | | bucketing_version | 2 | | | transient_lastDdlTime | 1701797132 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | null | NULL | | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL | | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | | NULL | NULL | | # View Information | NULL | NULL | | Original Query: | SELECT DISTINCT 'default', D.NAME, T.TBL_NAME, IF(length(T.VIEW_ORIGINAL_TEXT) > 0, 'VIEW', 'BASE_TABLE'), cast(null as string), cast(null as string), cast(null as string), cast(null as string), cast(null as string), IF(length(T.VIEW_ORIGINAL_TEXT) > 0, 'NO', 'YES'), 'NO', cast(null as string) FROM sys.TBLS T JOIN sys.DBS D ON (D.DB_ID = T.DB_ID) LEFT JOIN sys.TBL_PRIVS P ON (T.TBL_ID = P.TBL_ID) WHERE NOT restrict_information_schema() OR P.TBL_ID IS NOT NULL AND (P.PRINCIPAL_NAME=current_user() AND P.PRINCIPAL_TYPE='USER' OR ((array_contains(current_groups(), P.PRINCIPAL_NAME) OR P.PRINCIPAL_NAME = 'public') AND P.PRINCIPAL_TYPE='GROUP')) AND P.TBL_PRIV='SELECT' AND P.AUTHORIZER=current_authorizer() | NULL | | Expanded Query: | SELECT `_c0` AS `table_catalog`, `name` AS `table_schema`, `tbl_name` AS `table_name`, `_c3` AS `table_type`, `_c4` AS `self_referencing_column_name`, `_c5` AS `reference_generation`, `_c6` AS `user_defined_type_catalog`, `_c7` AS `user_defined_type_schema`, `_c8` AS `user_defined_type_name`, `_c9` AS `is_insertable_into`, `_c10` AS `is_typed`, `_c11` AS `commit_action` FROM (SELECT DISTINCT 'default', `d`.`name`, `t`.`tbl_name`, IF(length(`t`.`view_original_text`) > 0, 'VIEW', 'BASE_TABLE'), cast(null as string), cast(null as string), cast(null as string), cast(null as string), cast(null as string), IF(length(`t`.`view_original_text`) > 0, 'NO', 'YES'), 'NO', cast(null as string) FROM `sys`.`TBLS` `T` JOIN `sys`.`DBS` `D` ON (`d`.`db_id` = `t`.`db_id`) LEFT JOIN `sys`.`TBL_PRIVS` `P` ON (`t`.`tbl_id` = `p`.`tbl_id`) WHERE NOT restrict_information_schema() OR `p`.`tbl_id` IS NOT NULL AND (`p`.`principal_name`=current_user() AND `p`.`principal_type`='USER' OR ((array_contains(current_groups(), `p`.`principal_name`) OR `p`.`principal_name` = 'public') AND `p`.`principal_type`='GROUP')) AND `p`.`tbl_priv`='SELECT' AND `p`.`authorizer`=current_authorizer()) `TABLES` | NULL | +-------------------------------+----------------------------------------------------+-----------------------+ 37 rows selected (0.585 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> show create table information_schema.tables; INFO : Compiling command(queryId=hive_20231207212814_09beada1-411f-4c73-85e7-f44ff1b12f66): show create table information_schema.tables INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207212814_09beada1-411f-4c73-85e7-f44ff1b12f66); Time taken: 0.023 seconds INFO : Executing command(queryId=hive_20231207212814_09beada1-411f-4c73-85e7-f44ff1b12f66): show create table information_schema.tables INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207212814_09beada1-411f-4c73-85e7-f44ff1b12f66); Time taken: 0.01 seconds INFO : OK +----------------------------------------------------+ | createtab_stmt | +----------------------------------------------------+ | CREATE VIEW `information_schema`.`tables` AS SELECT `_c0` AS `table_catalog`, `name` AS `table_schema`, `tbl_name` AS `table_name`, `_c3` AS `table_type`, `_c4` AS `self_referencing_column_name`, `_c5` AS `reference_generation`, `_c6` AS `user_defined_type_catalog`, `_c7` AS `user_defined_type_schema`, `_c8` AS `user_defined_type_name`, `_c9` AS `is_insertable_into`, `_c10` AS `is_typed`, `_c11` AS `commit_action` FROM (SELECT DISTINCT 'default', `d`.`name`, `t`.`tbl_name`, IF(length(`t`.`view_original_text`) > 0, 'VIEW', 'BASE_TABLE'), cast(null as string), cast(null as string), cast(null as string), cast(null as string), cast(null as string), IF(length(`t`.`view_original_text`) > 0, 'NO', 'YES'), 'NO', cast(null as string) FROM `sys`.`TBLS` `T` JOIN `sys`.`DBS` `D` ON (`d`.`db_id` = `t`.`db_id`) LEFT JOIN `sys`.`TBL_PRIVS` `P` ON (`t`.`tbl_id` = `p`.`tbl_id`) WHERE NOT restrict_information_schema() OR `p`.`tbl_id` IS NOT NULL AND (`p`.`principal_name`=current_user() AND `p`.`principal_type`='USER' OR ((array_contains(current_groups(), `p`.`principal_name`) OR `p`.`principal_name` = 'public') AND `p`.`principal_type`='GROUP')) AND `p`.`tbl_priv`='SELECT' AND `p`.`authorizer`=current_authorizer()) `TABLES` | +----------------------------------------------------+ 1 row selected (0.581 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> describe formatted information_schema.schemata; INFO : Compiling command(queryId=hive_20231207213152_7214f184-ad59-43e0-87c4-aaab7905f68f): describe formatted information_schema.schemata INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213152_7214f184-ad59-43e0-87c4-aaab7905f68f); Time taken: 0.022 seconds INFO : Executing command(queryId=hive_20231207213152_7214f184-ad59-43e0-87c4-aaab7905f68f): describe formatted information_schema.schemata INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213152_7214f184-ad59-43e0-87c4-aaab7905f68f); Time taken: 0.023 seconds INFO : OK +--------------------------------+----------------------------------------------------+-----------------------+ | col_name | data_type | comment | +--------------------------------+----------------------------------------------------+-----------------------+ | catalog_name | string | | | schema_name | string | | | schema_owner | string | | | default_character_set_catalog | string | | | default_character_set_schema | string | | | default_character_set_name | string | | | sql_path | string | | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | information_schema | NULL | | OwnerType: | USER | NULL | | Owner: | hive | NULL | | CreateTime: | Tue Dec 05 17:25:31 UTC 2023 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Table Type: | VIRTUAL_VIEW | NULL | | Table Parameters: | NULL | NULL | | | bucketing_version | 2 | | | transient_lastDdlTime | 1701797131 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | null | NULL | | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL | | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | | NULL | NULL | | # View Information | NULL | NULL | | Original Query: | SELECT DISTINCT 'default', D.NAME, D.OWNER_NAME, cast(null as string), cast(null as string), cast(null as string), DB_LOCATION_URI FROM sys.DBS D LEFT JOIN sys.TBLS T ON (D.DB_ID = T.DB_ID) LEFT JOIN sys.TBL_PRIVS P ON (T.TBL_ID = P.TBL_ID) WHERE NOT restrict_information_schema() OR P.TBL_ID IS NOT NULL AND (P.PRINCIPAL_NAME=current_user() AND P.PRINCIPAL_TYPE='USER' OR ((array_contains(current_groups(), P.PRINCIPAL_NAME) OR P.PRINCIPAL_NAME = 'public') AND P.PRINCIPAL_TYPE='GROUP')) AND current_authorizer() = P.AUTHORIZER | NULL | | Expanded Query: | SELECT `_c0` AS `catalog_name`, `name` AS `schema_name`, `owner_name` AS `schema_owner`, `_c3` AS `default_character_set_catalog`, `_c4` AS `default_character_set_schema`, `_c5` AS `default_character_set_name`, `db_location_uri` AS `sql_path` FROM (SELECT DISTINCT 'default', `d`.`name`, `d`.`owner_name`, cast(null as string), cast(null as string), cast(null as string), `d`.`db_location_uri` FROM `sys`.`DBS` `D` LEFT JOIN `sys`.`TBLS` `T` ON (`d`.`db_id` = `t`.`db_id`) LEFT JOIN `sys`.`TBL_PRIVS` `P` ON (`t`.`tbl_id` = `p`.`tbl_id`) WHERE NOT restrict_information_schema() OR `p`.`tbl_id` IS NOT NULL AND (`p`.`principal_name`=current_user() AND `p`.`principal_type`='USER' OR ((array_contains(current_groups(), `p`.`principal_name`) OR `p`.`principal_name` = 'public') AND `p`.`principal_type`='GROUP')) AND current_authorizer() = `p`.`authorizer`) `SCHEMATA` | NULL | +--------------------------------+----------------------------------------------------+-----------------------+ 32 rows selected (1.202 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> show create table information_schema.schemata; INFO : Compiling command(queryId=hive_20231207213202_ef999fb9-2b81-4ada-a905-93b1849e86b6): show create table information_schema.schemata INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213202_ef999fb9-2b81-4ada-a905-93b1849e86b6); Time taken: 0.022 seconds INFO : Executing command(queryId=hive_20231207213202_ef999fb9-2b81-4ada-a905-93b1849e86b6): show create table information_schema.schemata INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213202_ef999fb9-2b81-4ada-a905-93b1849e86b6); Time taken: 0.01 seconds INFO : OK +----------------------------------------------------+ | createtab_stmt | +----------------------------------------------------+ | CREATE VIEW `information_schema`.`schemata` AS SELECT `_c0` AS `catalog_name`, `name` AS `schema_name`, `owner_name` AS `schema_owner`, `_c3` AS `default_character_set_catalog`, `_c4` AS `default_character_set_schema`, `_c5` AS `default_character_set_name`, `db_location_uri` AS `sql_path` FROM (SELECT DISTINCT 'default', `d`.`name`, `d`.`owner_name`, cast(null as string), cast(null as string), cast(null as string), `d`.`db_location_uri` FROM `sys`.`DBS` `D` LEFT JOIN `sys`.`TBLS` `T` ON (`d`.`db_id` = `t`.`db_id`) LEFT JOIN `sys`.`TBL_PRIVS` `P` ON (`t`.`tbl_id` = `p`.`tbl_id`) WHERE NOT restrict_information_schema() OR `p`.`tbl_id` IS NOT NULL AND (`p`.`principal_name`=current_user() AND `p`.`principal_type`='USER' OR ((array_contains(current_groups(), `p`.`principal_name`) OR `p`.`principal_name` = 'public') AND `p`.`principal_type`='GROUP')) AND current_authorizer() = `p`.`authorizer`) `SCHEMATA` | +----------------------------------------------------+ 1 row selected (0.661 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> describe formatted information_schema.compactions; INFO : Compiling command(queryId=hive_20231207213359_13383c0c-4ad6-4d59-91a2-c3d7a4bfc26e): describe formatted information_schema.compactions INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213359_13383c0c-4ad6-4d59-91a2-c3d7a4bfc26e); Time taken: 0.025 seconds INFO : Executing command(queryId=hive_20231207213359_13383c0c-4ad6-4d59-91a2-c3d7a4bfc26e): describe formatted information_schema.compactions INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213359_13383c0c-4ad6-4d59-91a2-c3d7a4bfc26e); Time taken: 0.025 seconds INFO : OK +-------------------------------+----------------------------------------------------+-----------------------+ | col_name | data_type | comment | +-------------------------------+----------------------------------------------------+-----------------------+ | c_id | bigint | | | c_catalog | string | | | c_database | string | | | c_table | string | | | c_partition | string | | | c_type | string | | | c_state | string | | | c_worker_host | string | | | c_worker_id | string | | | c_worker_version | string | | | c_enqueue_time | string | | | c_start | string | | | c_duration | string | | | c_hadoop_job_id | string | | | c_run_as | string | | | c_error_message | string | | | c_next_txn_id | bigint | | | c_txn_id | bigint | | | c_commit_time | string | | | c_highest_write_id | bigint | | | c_initiator_host | string | | | c_initiator_id | string | | | c_initiator_version | string | | | c_cleaner_start | string | | | c_pool_name | string | | | c_number_of_buckets | string | | | c_tblproperties | string | | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | information_schema | NULL | | OwnerType: | USER | NULL | | Owner: | hive | NULL | | CreateTime: | Tue Dec 05 17:25:40 UTC 2023 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Table Type: | VIRTUAL_VIEW | NULL | | Table Parameters: | NULL | NULL | | | bucketing_version | 2 | | | transient_lastDdlTime | 1701797140 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | null | NULL | | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL | | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | | NULL | NULL | | # View Information | NULL | NULL | | Original Query: | SELECT DISTINCT C_ID, C_CATALOG, C_DATABASE, C_TABLE, C_PARTITION, C_TYPE, C_STATE, C_WORKER_HOST, C_WORKER_ID, C_WORKER_VERSION, C_ENQUEUE_TIME, C_START, C_DURATION, C_HADOOP_JOB_ID, C_RUN_AS, C_ERROR_MESSAGE, C_NEXT_TXN_ID, C_TXN_ID, C_COMMIT_TIME, C_HIGHEST_WRITE_ID, C_INITIATOR_HOST, C_INITIATOR_ID, C_INITIATOR_VERSION, C_CLEANER_START, C_POOL_NAME, C_NUMBER_OF_BUCKETS, C_TBLPROPERTIES FROM sys.COMPACTIONS C JOIN sys.TBLS T ON (C.C_TABLE = T.TBL_NAME) JOIN sys.DBS D ON (C.C_DATABASE = D.NAME) LEFT JOIN sys.TBL_PRIVS P ON (T.TBL_ID = P.TBL_ID) WHERE (NOT restrict_information_schema() OR P.TBL_ID IS NOT NULL AND (P.PRINCIPAL_NAME=current_user() AND P.PRINCIPAL_TYPE='USER' OR ((array_contains(current_groups(), P.PRINCIPAL_NAME) OR P.PRINCIPAL_NAME = 'public') AND P.PRINCIPAL_TYPE='GROUP')) AND P.TBL_PRIV='SELECT' AND P.AUTHORIZER=current_authorizer()) | NULL | | Expanded Query: | SELECT `c_id` AS `c_id`, `c_catalog` AS `c_catalog`, `c_database` AS `c_database`, `c_table` AS `c_table`, `c_partition` AS `c_partition`, `c_type` AS `c_type`, `c_state` AS `c_state`, `c_worker_host` AS `c_worker_host`, `c_worker_id` AS `c_worker_id`, `c_worker_version` AS `c_worker_version`, `c_enqueue_time` AS `c_enqueue_time`, `c_start` AS `c_start`, `c_duration` AS `c_duration`, `c_hadoop_job_id` AS `c_hadoop_job_id`, `c_run_as` AS `c_run_as`, `c_error_message` AS `c_error_message`, `c_next_txn_id` AS `c_next_txn_id`, `c_txn_id` AS `c_txn_id`, `c_commit_time` AS `c_commit_time`, `c_highest_write_id` AS `c_highest_write_id`, `c_initiator_host` AS `c_initiator_host`, `c_initiator_id` AS `c_initiator_id`, `c_initiator_version` AS `c_initiator_version`, `c_cleaner_start` AS `c_cleaner_start`, `c_pool_name` AS `c_pool_name`, `c_number_of_buckets` AS `c_number_of_buckets`, `c_tblproperties` AS `c_tblproperties` FROM (SELECT DISTINCT `c`.`c_id`, `c`.`c_catalog`, `c`.`c_database`, `c`.`c_table`, `c`.`c_partition`, `c`.`c_type`, `c`.`c_state`, `c`.`c_worker_host`, `c`.`c_worker_id`, `c`.`c_worker_version`, `c`.`c_enqueue_time`, `c`.`c_start`, `c`.`c_duration`, `c`.`c_hadoop_job_id`, `c`.`c_run_as`, `c`.`c_error_message`, `c`.`c_next_txn_id`, `c`.`c_txn_id`, `c`.`c_commit_time`, `c`.`c_highest_write_id`, `c`.`c_initiator_host`, `c`.`c_initiator_id`, `c`.`c_initiator_version`, `c`.`c_cleaner_start`, `c`.`c_pool_name`, `c`.`c_number_of_buckets`, `c`.`c_tblproperties` FROM `sys`.`COMPACTIONS` `C` JOIN `sys`.`TBLS` `T` ON (`c`.`c_table` = `t`.`tbl_name`) JOIN `sys`.`DBS` `D` ON (`c`.`c_database` = `d`.`name`) LEFT JOIN `sys`.`TBL_PRIVS` `P` ON (`t`.`tbl_id` = `p`.`tbl_id`) WHERE (NOT restrict_information_schema() OR `p`.`tbl_id` IS NOT NULL AND (`p`.`principal_name`=current_user() AND `p`.`principal_type`='USER' OR ((array_contains(current_groups(), `p`.`principal_name`) OR `p`.`principal_name` = 'public') AND `p`.`principal_type`='GROUP')) AND `p`.`tbl_priv`='SELECT' AND `p`.`authorizer`=current_authorizer())) `COMPACTIONS` | NULL | +-------------------------------+----------------------------------------------------+-----------------------+ 52 rows selected (1.205 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> show create table information_schema.compactions; INFO : Compiling command(queryId=hive_20231207213413_571e3239-538d-4bba-a8b7-a9c8cbc6e16f): show create table information_schema.compactions INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213413_571e3239-538d-4bba-a8b7-a9c8cbc6e16f); Time taken: 0.027 seconds INFO : Executing command(queryId=hive_20231207213413_571e3239-538d-4bba-a8b7-a9c8cbc6e16f): show create table information_schema.compactions INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213413_571e3239-538d-4bba-a8b7-a9c8cbc6e16f); Time taken: 0.011 seconds INFO : OK +----------------------------------------------------+ | createtab_stmt | +----------------------------------------------------+ | CREATE VIEW `information_schema`.`compactions` AS SELECT `c_id` AS `c_id`, `c_catalog` AS `c_catalog`, `c_database` AS `c_database`, `c_table` AS `c_table`, `c_partition` AS `c_partition`, `c_type` AS `c_type`, `c_state` AS `c_state`, `c_worker_host` AS `c_worker_host`, `c_worker_id` AS `c_worker_id`, `c_worker_version` AS `c_worker_version`, `c_enqueue_time` AS `c_enqueue_time`, `c_start` AS `c_start`, `c_duration` AS `c_duration`, `c_hadoop_job_id` AS `c_hadoop_job_id`, `c_run_as` AS `c_run_as`, `c_error_message` AS `c_error_message`, `c_next_txn_id` AS `c_next_txn_id`, `c_txn_id` AS `c_txn_id`, `c_commit_time` AS `c_commit_time`, `c_highest_write_id` AS `c_highest_write_id`, `c_initiator_host` AS `c_initiator_host`, `c_initiator_id` AS `c_initiator_id`, `c_initiator_version` AS `c_initiator_version`, `c_cleaner_start` AS `c_cleaner_start`, `c_pool_name` AS `c_pool_name`, `c_number_of_buckets` AS `c_number_of_buckets`, `c_tblproperties` AS `c_tblproperties` FROM (SELECT DISTINCT `c`.`c_id`, `c`.`c_catalog`, `c`.`c_database`, `c`.`c_table`, `c`.`c_partition`, `c`.`c_type`, `c`.`c_state`, `c`.`c_worker_host`, `c`.`c_worker_id`, `c`.`c_worker_version`, `c`.`c_enqueue_time`, `c`.`c_start`, `c`.`c_duration`, `c`.`c_hadoop_job_id`, `c`.`c_run_as`, `c`.`c_error_message`, `c`.`c_next_txn_id`, `c`.`c_txn_id`, `c`.`c_commit_time`, `c`.`c_highest_write_id`, `c`.`c_initiator_host`, `c`.`c_initiator_id`, `c`.`c_initiator_version`, `c`.`c_cleaner_start`, `c`.`c_pool_name`, `c`.`c_number_of_buckets`, `c`.`c_tblproperties` FROM `sys`.`COMPACTIONS` `C` JOIN `sys`.`TBLS` `T` ON (`c`.`c_table` = `t`.`tbl_name`) JOIN `sys`.`DBS` `D` ON (`c`.`c_database` = `d`.`name`) LEFT JOIN `sys`.`TBL_PRIVS` `P` ON (`t`.`tbl_id` = `p`.`tbl_id`) WHERE (NOT restrict_information_schema() OR `p`.`tbl_id` IS NOT NULL AND (`p`.`principal_name`=current_user() AND `p`.`principal_type`='USER' OR ((array_contains(current_groups(), `p`.`principal_name`) OR `p`.`principal_name` = 'public') AND `p`.`principal_type`='GROUP')) AND `p`.`tbl_priv`='SELECT' AND `p`.`authorizer`=current_authorizer())) `COMPACTIONS` | +----------------------------------------------------+ 1 row selected (0.594 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> describe formatted information_schema.columns; INFO : Compiling command(queryId=hive_20231207213459_40bbeae8-4e0a-4886-93da-8067ef8ebac7): describe formatted information_schema.columns INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213459_40bbeae8-4e0a-4886-93da-8067ef8ebac7); Time taken: 0.033 seconds INFO : Executing command(queryId=hive_20231207213459_40bbeae8-4e0a-4886-93da-8067ef8ebac7): describe formatted information_schema.columns INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213459_40bbeae8-4e0a-4886-93da-8067ef8ebac7); Time taken: 0.025 seconds INFO : OK +------------------------------------------+----------------------------------------------------+-----------------------+ | col_name | data_type | comment | +------------------------------------------+----------------------------------------------------+-----------------------+ | table_catalog | string | | | table_schema | string | | | table_name | string | | | column_name | string | | | ordinal_position | int | | | column_default | string | | | is_nullable | string | | | data_type | string | | | character_maximum_length | int | | | character_octet_length | int | | | numeric_precision | string | | | numeric_precision_radix | int | | | numeric_scale | string | | | datetime_precision | int | | | interval_type | string | | | interval_precision | string | | | character_set_catalog | string | | | character_set_schema | string | | | character_set_name | string | | | collation_catalog | string | | | collation_schema | string | | | collation_name | string | | | udt_catalog | string | | | udt_schema | string | | | udt_name | string | | | scope_catalog | string | | | scope_schema | string | | | scope_name | string | | | maximum_cardinality | string | | | dtd_identifier | bigint | | | is_self_referencing | string | | | is_identity | string | | | identity_generation | string | | | identity_start | string | | | identity_increment | string | | | identity_maximum | string | | | identity_minimum | string | | | identity_cycle | string | | | is_generated | string | | | generation_expression | string | | | is_system_time_period_start | string | | | is_system_time_period_end | string | | | system_time_period_timestamp_generation | string | | | is_updatable | string | | | declared_data_type | string | | | declared_numeric_precision | string | | | declared_numeric_scale | int | | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | information_schema | NULL | | OwnerType: | USER | NULL | | Owner: | hive | NULL | | CreateTime: | Tue Dec 05 17:25:36 UTC 2023 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Table Type: | VIRTUAL_VIEW | NULL | | Table Parameters: | NULL | NULL | | | bucketing_version | 2 | | | transient_lastDdlTime | 1701812540 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | null | NULL | | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL | | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | | NULL | NULL | | # View Information | NULL | NULL | | Original Query: | SELECT DISTINCT 'default', D.NAME, T.TBL_NAME, C.COLUMN_NAME, C.INTEGER_IDX, cast (null as string), 'YES', C.TYPE_NAME as TYPE_NAME, CASE WHEN lower(C.TYPE_NAME) like 'varchar%' THEN cast(regexp_extract(upper(C.TYPE_NAME), '^VARCHAR\\s*\\((\\d+)\\s*\\)$', 1) as int) WHEN lower(C.TYPE_NAME) like 'char%' THEN cast(regexp_extract(upper(C.TYPE_NAME), '^CHAR\\s*\\((\\d+)\\s*\\)$', 1) as int) ELSE null END, CASE WHEN lower(C.TYPE_NAME) like 'varchar%' THEN cast(regexp_extract(upper(C.TYPE_NAME), '^VARCHAR\\s*\\((\\d+)\\s*\\)$', 1) as int) WHEN lower(C.TYPE_NAME) like 'char%' THEN cast(regexp_extract(upper(C.TYPE_NAME), '^CHAR\\s*\\((\\d+)\\s*\\)$', 1) as int) ELSE null END, CASE WHEN lower(C.TYPE_NAME) = 'bigint' THEN 19 WHEN lower(C.TYPE_NAME) = 'int' THEN 10 WHEN lower(C.TYPE_NAME) = 'smallint' THEN 5 WHEN lower(C.TYPE_NAME) = 'tinyint' THEN 3 WHEN lower(C.TYPE_NAME) = 'float' THEN 23 WHEN lower(C.TYPE_NAME) = 'double' THEN 53 WHEN lower(C.TYPE_NAME) like 'decimal%' THEN regexp_extract(upper(C.TYPE_NAME), '^DECIMAL\\s*\\((\\d+)',1) WHEN lower(C.TYPE_NAME) like 'numeric%' THEN regexp_extract(upper(C.TYPE_NAME), '^NUMERIC\\s*\\((\\d+)',1) ELSE null END, CASE WHEN lower(C.TYPE_NAME) = 'bigint' THEN 10 WHEN lower(C.TYPE_NAME) = 'int' THEN 10 WHEN lower(C.TYPE_NAME) = 'smallint' THEN 10 WHEN lower(C.TYPE_NAME) = 'tinyint' THEN 10 WHEN lower(C.TYPE_NAME) = 'float' THEN 2 WHEN lower(C.TYPE_NAME) = 'double' THEN 2 WHEN lower(C.TYPE_NAME) like 'decimal%' THEN 10 WHEN lower(C.TYPE_NAME) like 'numeric%' THEN 10 ELSE null END, CASE WHEN lower(C.TYPE_NAME) like 'decimal%' THEN regexp_extract(upper(C.TYPE_NAME), '^DECIMAL\\s*\\((\\d+),(\\d+)',2) WHEN lower(C.TYPE_NAME) like 'numeric%' THEN regexp_extract(upper(C.TYPE_NAME), '^NUMERIC\\s*\\((\\d+),(\\d+)',2) ELSE null END, CASE WHEN lower(C.TYPE_NAME) = 'date' THEN 0 WHEN lower(C.TYPE_NAME) = 'timestamp' THEN 9 ELSE null END, cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), C.CD_ID, 'NO', 'NO', cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), 'NEVER', cast (null as string), 'NO', 'NO', cast (null as string), 'YES', C.TYPE_NAME as DECLARED_DATA_TYPE, CASE WHEN lower(C.TYPE_NAME) = 'bigint' THEN 19 WHEN lower(C.TYPE_NAME) = 'int' THEN 10 WHEN lower(C.TYPE_NAME) = 'smallint' THEN 5 WHEN lower(C.TYPE_NAME) = 'tinyint' THEN 3 WHEN lower(C.TYPE_NAME) = 'float' THEN 23 WHEN lower(C.TYPE_NAME) = 'double' THEN 53 WHEN lower(C.TYPE_NAME) like 'decimal%' THEN regexp_extract(upper(C.TYPE_NAME), '^DECIMAL\\s*\\((\\d+)',1) WHEN lower(C.TYPE_NAME) like 'numeric%' THEN regexp_extract(upper(C.TYPE_NAME), '^NUMERIC\\s*\\((\\d+)',1) ELSE null END, CASE WHEN lower(C.TYPE_NAME) = 'bigint' THEN 10 WHEN lower(C.TYPE_NAME) = 'int' THEN 10 WHEN lower(C.TYPE_NAME) = 'smallint' THEN 10 WHEN lower(C.TYPE_NAME) = 'tinyint' THEN 10 WHEN lower(C.TYPE_NAME) = 'float' THEN 2 WHEN lower(C.TYPE_NAME) = 'double' THEN 2 WHEN lower(C.TYPE_NAME) like 'decimal%' THEN 10 WHEN lower(C.TYPE_NAME) like 'numeric%' THEN 10 ELSE null END FROM sys.COLUMNS_V2 C JOIN sys.SDS S ON (C.CD_ID = S.CD_ID) JOIN sys.TBLS T ON (S.SD_ID = T.SD_ID) JOIN sys.DBS D ON (T.DB_ID = D.DB_ID) LEFT JOIN sys.TBL_COL_PRIVS P ON (T.TBL_ID = P.TBL_ID) WHERE NOT restrict_information_schema() OR P.TBL_ID IS NOT NULL AND C.COLUMN_NAME = P.COLUMN_NAME AND (P.PRINCIPAL_NAME=current_user() AND P.PRINCIPAL_TYPE='USER' OR ((array_contains(current_groups(), P.PRINCIPAL_NAME) OR P.PRINCIPAL_NAME = 'public') AND P.PRINCIPAL_TYPE='GROUP')) AND array_contains(split_map_privs(P.TBL_COL_PRIV),"SELECT") AND P.AUTHORIZER=current_authorizer() | NULL | | Expanded Query: | SELECT `_c0` AS `table_catalog`, `name` AS `table_schema`, `tbl_name` AS `table_name`, `column_name` AS `column_name`, `integer_idx` AS `ordinal_position`, `_c5` AS `column_default`, `_c6` AS `is_nullable`, `type_name` AS `data_type`, `_c8` AS `character_maximum_length`, `_c9` AS `character_octet_length`, `_c10` AS `numeric_precision`, `_c11` AS `numeric_precision_radix`, `_c12` AS `numeric_scale`, `_c13` AS `datetime_precision`, `_c14` AS `interval_type`, `_c15` AS `interval_precision`, `_c16` AS `character_set_catalog`, `_c17` AS `character_set_schema`, `_c18` AS `character_set_name`, `_c19` AS `collation_catalog`, `_c20` AS `collation_schema`, `_c21` AS `collation_name`, `_c22` AS `udt_catalog`, `_c23` AS `udt_schema`, `_c24` AS `udt_name`, `_c25` AS `scope_catalog`, `_c26` AS `scope_schema`, `_c27` AS `scope_name`, `_c28` AS `maximum_cardinality`, `cd_id` AS `dtd_identifier`, `_c30` AS `is_self_referencing`, `_c31` AS `is_identity`, `_c32` AS `identity_generation`, `_c33` AS `identity_start`, `_c34` AS `identity_increment`, `_c35` AS `identity_maximum`, `_c36` AS `identity_minimum`, `_c37` AS `identity_cycle`, `_c38` AS `is_generated`, `_c39` AS `generation_expression`, `_c40` AS `is_system_time_period_start`, `_c41` AS `is_system_time_period_end`, `_c42` AS `system_time_period_timestamp_generation`, `_c43` AS `is_updatable`, `declared_data_type` AS `declared_data_type`, `_c45` AS `declared_numeric_precision`, `_c46` AS `declared_numeric_scale` FROM (SELECT DISTINCT 'default', `d`.`name`, `t`.`tbl_name`, `c`.`column_name`, `c`.`integer_idx`, cast (null as string), 'YES', `c`.`type_name` as `TYPE_NAME`, CASE WHEN lower(`c`.`type_name`) like 'varchar%' THEN cast(regexp_extract(upper(`c`.`type_name`), '^VARCHAR\\s*\\((\\d+)\\s*\\)$', 1) as int) WHEN lower(`c`.`type_name`) like 'char%' THEN cast(regexp_extract(upper(`c`.`type_name`), '^CHAR\\s*\\((\\d+)\\s*\\)$', 1) as int) ELSE null END, CASE WHEN lower(`c`.`type_name`) like 'varchar%' THEN cast(regexp_extract(upper(`c`.`type_name`), '^VARCHAR\\s*\\((\\d+)\\s*\\)$', 1) as int) WHEN lower(`c`.`type_name`) like 'char%' THEN cast(regexp_extract(upper(`c`.`type_name`), '^CHAR\\s*\\((\\d+)\\s*\\)$', 1) as int) ELSE null END, CASE WHEN lower(`c`.`type_name`) = 'bigint' THEN 19 WHEN lower(`c`.`type_name`) = 'int' THEN 10 WHEN lower(`c`.`type_name`) = 'smallint' THEN 5 WHEN lower(`c`.`type_name`) = 'tinyint' THEN 3 WHEN lower(`c`.`type_name`) = 'float' THEN 23 WHEN lower(`c`.`type_name`) = 'double' THEN 53 WHEN lower(`c`.`type_name`) like 'decimal%' THEN regexp_extract(upper(`c`.`type_name`), '^DECIMAL\\s*\\((\\d+)',1) WHEN lower(`c`.`type_name`) like 'numeric%' THEN regexp_extract(upper(`c`.`type_name`), '^NUMERIC\\s*\\((\\d+)',1) ELSE null END, CASE WHEN lower(`c`.`type_name`) = 'bigint' THEN 10 WHEN lower(`c`.`type_name`) = 'int' THEN 10 WHEN lower(`c`.`type_name`) = 'smallint' THEN 10 WHEN lower(`c`.`type_name`) = 'tinyint' THEN 10 WHEN lower(`c`.`type_name`) = 'float' THEN 2 WHEN lower(`c`.`type_name`) = 'double' THEN 2 WHEN lower(`c`.`type_name`) like 'decimal%' THEN 10 WHEN lower(`c`.`type_name`) like 'numeric%' THEN 10 ELSE null END, CASE WHEN lower(`c`.`type_name`) like 'decimal%' THEN regexp_extract(upper(`c`.`type_name`), '^DECIMAL\\s*\\((\\d+),(\\d+)',2) WHEN lower(`c`.`type_name`) like 'numeric%' THEN regexp_extract(upper(`c`.`type_name`), '^NUMERIC\\s*\\((\\d+),(\\d+)',2) ELSE null END, CASE WHEN lower(`c`.`type_name`) = 'date' THEN 0 WHEN lower(`c`.`type_name`) = 'timestamp' THEN 9 ELSE null END, cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), `c`.`cd_id`, 'NO', 'NO', cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), 'NEVER', cast (null as string), 'NO', 'NO', cast (null as string), 'YES', `c`.`type_name` as `DECLARED_DATA_TYPE`, CASE WHEN lower(`c`.`type_name`) = 'bigint' THEN 19 WHEN lower(`c`.`type_name`) = 'int' THEN 10 WHEN lower(`c`.`type_name`) = 'smallint' THEN 5 WHEN lower(`c`.`type_name`) = 'tinyint' THEN 3 WHEN lower(`c`.`type_name`) = 'float' THEN 23 WHEN lower(`c`.`type_name`) = 'double' THEN 53 WHEN lower(`c`.`type_name`) like 'decimal%' THEN regexp_extract(upper(`c`.`type_name`), '^DECIMAL\\s*\\((\\d+)',1) WHEN lower(`c`.`type_name`) like 'numeric%' THEN regexp_extract(upper(`c`.`type_name`), '^NUMERIC\\s*\\((\\d+)',1) ELSE null END, CASE WHEN lower(`c`.`type_name`) = 'bigint' THEN 10 WHEN lower(`c`.`type_name`) = 'int' THEN 10 WHEN lower(`c`.`type_name`) = 'smallint' THEN 10 WHEN lower(`c`.`type_name`) = 'tinyint' THEN 10 WHEN lower(`c`.`type_name`) = 'float' THEN 2 WHEN lower(`c`.`type_name`) = 'double' THEN 2 WHEN lower(`c`.`type_name`) like 'decimal%' THEN 10 WHEN lower(`c`.`type_name`) like 'numeric%' THEN 10 ELSE null END FROM `sys`.`COLUMNS_V2` `C` JOIN `sys`.`SDS` `S` ON (`c`.`cd_id` = `s`.`cd_id`) JOIN `sys`.`TBLS` `T` ON (`s`.`sd_id` = `t`.`sd_id`) JOIN `sys`.`DBS` `D` ON (`t`.`db_id` = `d`.`db_id`) LEFT JOIN `sys`.`TBL_COL_PRIVS` `P` ON (`t`.`tbl_id` = `p`.`tbl_id`) WHERE NOT restrict_information_schema() OR `p`.`tbl_id` IS NOT NULL AND `c`.`column_name` = `p`.`column_name` AND (`p`.`principal_name`=current_user() AND `p`.`principal_type`='USER' OR ((array_contains(current_groups(), `p`.`principal_name`) OR `p`.`principal_name` = 'public') AND `p`.`principal_type`='GROUP')) AND array_contains(split_map_privs(`p`.`tbl_col_priv`),"SELECT") AND `p`.`authorizer`=current_authorizer()) `COLUMNS` | NULL | +------------------------------------------+----------------------------------------------------+-----------------------+ 72 rows selected (0.629 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> show create table information_schema.columns; INFO : Compiling command(queryId=hive_20231207213507_914747d4-fdbd-49c2-80d5-997419a3d88f): show create table information_schema.columns INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213507_914747d4-fdbd-49c2-80d5-997419a3d88f); Time taken: 0.025 seconds INFO : Executing command(queryId=hive_20231207213507_914747d4-fdbd-49c2-80d5-997419a3d88f): show create table information_schema.columns INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213507_914747d4-fdbd-49c2-80d5-997419a3d88f); Time taken: 0.012 seconds INFO : OK +----------------------------------------------------+ | createtab_stmt | +----------------------------------------------------+ | CREATE VIEW `information_schema`.`columns` AS SELECT `_c0` AS `table_catalog`, `name` AS `table_schema`, `tbl_name` AS `table_name`, `column_name` AS `column_name`, `integer_idx` AS `ordinal_position`, `_c5` AS `column_default`, `_c6` AS `is_nullable`, `type_name` AS `data_type`, `_c8` AS `character_maximum_length`, `_c9` AS `character_octet_length`, `_c10` AS `numeric_precision`, `_c11` AS `numeric_precision_radix`, `_c12` AS `numeric_scale`, `_c13` AS `datetime_precision`, `_c14` AS `interval_type`, `_c15` AS `interval_precision`, `_c16` AS `character_set_catalog`, `_c17` AS `character_set_schema`, `_c18` AS `character_set_name`, `_c19` AS `collation_catalog`, `_c20` AS `collation_schema`, `_c21` AS `collation_name`, `_c22` AS `udt_catalog`, `_c23` AS `udt_schema`, `_c24` AS `udt_name`, `_c25` AS `scope_catalog`, `_c26` AS `scope_schema`, `_c27` AS `scope_name`, `_c28` AS `maximum_cardinality`, `cd_id` AS `dtd_identifier`, `_c30` AS `is_self_referencing`, `_c31` AS `is_identity`, `_c32` AS `identity_generation`, `_c33` AS `identity_start`, `_c34` AS `identity_increment`, `_c35` AS `identity_maximum`, `_c36` AS `identity_minimum`, `_c37` AS `identity_cycle`, `_c38` AS `is_generated`, `_c39` AS `generation_expression`, `_c40` AS `is_system_time_period_start`, `_c41` AS `is_system_time_period_end`, `_c42` AS `system_time_period_timestamp_generation`, `_c43` AS `is_updatable`, `declared_data_type` AS `declared_data_type`, `_c45` AS `declared_numeric_precision`, `_c46` AS `declared_numeric_scale` FROM (SELECT DISTINCT 'default', `d`.`name`, `t`.`tbl_name`, `c`.`column_name`, `c`.`integer_idx`, cast (null as string), 'YES', `c`.`type_name` as `TYPE_NAME`, CASE WHEN lower(`c`.`type_name`) like 'varchar%' THEN cast(regexp_extract(upper(`c`.`type_name`), '^VARCHAR\\s*\\((\\d+)\\s*\\)$', 1) as int) WHEN lower(`c`.`type_name`) like 'char%' THEN cast(regexp_extract(upper(`c`.`type_name`), '^CHAR\\s*\\((\\d+)\\s*\\)$', 1) as int) ELSE null END, CASE WHEN lower(`c`.`type_name`) like 'varchar%' THEN cast(regexp_extract(upper(`c`.`type_name`), '^VARCHAR\\s*\\((\\d+)\\s*\\)$', 1) as int) WHEN lower(`c`.`type_name`) like 'char%' THEN cast(regexp_extract(upper(`c`.`type_name`), '^CHAR\\s*\\((\\d+)\\s*\\)$', 1) as int) ELSE null END, CASE WHEN lower(`c`.`type_name`) = 'bigint' THEN 19 WHEN lower(`c`.`type_name`) = 'int' THEN 10 WHEN lower(`c`.`type_name`) = 'smallint' THEN 5 WHEN lower(`c`.`type_name`) = 'tinyint' THEN 3 WHEN lower(`c`.`type_name`) = 'float' THEN 23 WHEN lower(`c`.`type_name`) = 'double' THEN 53 WHEN lower(`c`.`type_name`) like 'decimal%' THEN regexp_extract(upper(`c`.`type_name`), '^DECIMAL\\s*\\((\\d+)',1) WHEN lower(`c`.`type_name`) like 'numeric%' THEN regexp_extract(upper(`c`.`type_name`), '^NUMERIC\\s*\\((\\d+)',1) ELSE null END, CASE WHEN lower(`c`.`type_name`) = 'bigint' THEN 10 WHEN lower(`c`.`type_name`) = 'int' THEN 10 WHEN lower(`c`.`type_name`) = 'smallint' THEN 10 WHEN lower(`c`.`type_name`) = 'tinyint' THEN 10 WHEN lower(`c`.`type_name`) = 'float' THEN 2 WHEN lower(`c`.`type_name`) = 'double' THEN 2 WHEN lower(`c`.`type_name`) like 'decimal%' THEN 10 WHEN lower(`c`.`type_name`) like 'numeric%' THEN 10 ELSE null END, CASE WHEN lower(`c`.`type_name`) like 'decimal%' THEN regexp_extract(upper(`c`.`type_name`), '^DECIMAL\\s*\\((\\d+),(\\d+)',2) WHEN lower(`c`.`type_name`) like 'numeric%' THEN regexp_extract(upper(`c`.`type_name`), '^NUMERIC\\s*\\((\\d+),(\\d+)',2) ELSE null END, CASE WHEN lower(`c`.`type_name`) = 'date' THEN 0 WHEN lower(`c`.`type_name`) = 'timestamp' THEN 9 ELSE null END, cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), `c`.`cd_id`, 'NO', 'NO', cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), cast (null as string), 'NEVER', cast (null as string), 'NO', 'NO', cast (null as string), 'YES', `c`.`type_name` as `DECLARED_DATA_TYPE`, CASE WHEN lower(`c`.`type_name`) = 'bigint' THEN 19 WHEN lower(`c`.`type_name`) = 'int' THEN 10 WHEN lower(`c`.`type_name`) = 'smallint' THEN 5 WHEN lower(`c`.`type_name`) = 'tinyint' THEN 3 WHEN lower(`c`.`type_name`) = 'float' THEN 23 WHEN lower(`c`.`type_name`) = 'double' THEN 53 WHEN lower(`c`.`type_name`) like 'decimal%' THEN regexp_extract(upper(`c`.`type_name`), '^DECIMAL\\s*\\((\\d+)',1) WHEN lower(`c`.`type_name`) like 'numeric%' THEN regexp_extract(upper(`c`.`type_name`), '^NUMERIC\\s*\\((\\d+)',1) ELSE null END, CASE WHEN lower(`c`.`type_name`) = 'bigint' THEN 10 WHEN lower(`c`.`type_name`) = 'int' THEN 10 WHEN lower(`c`.`type_name`) = 'smallint' THEN 10 WHEN lower(`c`.`type_name`) = 'tinyint' THEN 10 WHEN lower(`c`.`type_name`) = 'float' THEN 2 WHEN lower(`c`.`type_name`) = 'double' THEN 2 WHEN lower(`c`.`type_name`) like 'decimal%' THEN 10 WHEN lower(`c`.`type_name`) like 'numeric%' THEN 10 ELSE null END FROM `sys`.`COLUMNS_V2` `C` JOIN `sys`.`SDS` `S` ON (`c`.`cd_id` = `s`.`cd_id`) JOIN `sys`.`TBLS` `T` ON (`s`.`sd_id` = `t`.`sd_id`) JOIN `sys`.`DBS` `D` ON (`t`.`db_id` = `d`.`db_id`) LEFT JOIN `sys`.`TBL_COL_PRIVS` `P` ON (`t`.`tbl_id` = `p`.`tbl_id`) WHERE NOT restrict_information_schema() OR `p`.`tbl_id` IS NOT NULL AND `c`.`column_name` = `p`.`column_name` AND (`p`.`principal_name`=current_user() AND `p`.`principal_type`='USER' OR ((array_contains(current_groups(), `p`.`principal_name`) OR `p`.`principal_name` = 'public') AND `p`.`principal_type`='GROUP')) AND array_contains(split_map_privs(`p`.`tbl_col_priv`),"SELECT") AND `p`.`authorizer`=current_authorizer()) `COLUMNS` | +----------------------------------------------------+ 1 row selected (0.571 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> describe formatted information_schema.column_privileges; INFO : Compiling command(queryId=hive_20231207213619_55814ef5-aa73-4fb6-a55c-8ec73c3fab2c): describe formatted information_schema.column_privileges INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213619_55814ef5-aa73-4fb6-a55c-8ec73c3fab2c); Time taken: 0.042 seconds INFO : Executing command(queryId=hive_20231207213619_55814ef5-aa73-4fb6-a55c-8ec73c3fab2c): describe formatted information_schema.column_privileges INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213619_55814ef5-aa73-4fb6-a55c-8ec73c3fab2c); Time taken: 0.034 seconds INFO : OK +-------------------------------+----------------------------------------------------+-----------------------+ | col_name | data_type | comment | +-------------------------------+----------------------------------------------------+-----------------------+ | grantor | string | | | grantee | string | | | table_catalog | string | | | table_schema | string | | | table_name | string | | | column_name | string | | | privilege_type | string | | | is_grantable | string | | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | information_schema | NULL | | OwnerType: | USER | NULL | | Owner: | hive | NULL | | CreateTime: | Tue Dec 05 17:25:37 UTC 2023 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Table Type: | VIRTUAL_VIEW | NULL | | Table Parameters: | NULL | NULL | | | bucketing_version | 2 | | | transient_lastDdlTime | 1701812541 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | null | NULL | | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL | | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | | NULL | NULL | | # View Information | NULL | NULL | | Original Query: | SELECT DISTINCT P.GRANTOR, P.PRINCIPAL_NAME, 'default', D.NAME, T.TBL_NAME, P.COLUMN_NAME, P.TBL_COL_PRIV, IF (P.GRANT_OPTION == 0, 'NO', 'YES') FROM (SELECT Q.GRANTOR, Q.GRANT_OPTION, Q.PRINCIPAL_NAME, Q.PRINCIPAL_TYPE, Q.AUTHORIZER, Q.COLUMN_NAME, TBL_COL_PRIV_TMP.TBL_COL_PRIV, Q.TBL_ID FROM sys.TBL_COL_PRIVS AS Q LATERAL VIEW explode(split_map_privs(Q.TBL_COL_PRIV)) TBL_COL_PRIV_TMP AS TBL_COL_PRIV) P JOIN sys.TBLS T ON (P.TBL_ID = T.TBL_ID) JOIN sys.DBS D ON (T.DB_ID = D.DB_ID) JOIN sys.SDS S ON (S.SD_ID = T.SD_ID) LEFT JOIN sys.TBL_PRIVS P2 ON (P.TBL_ID = P2.TBL_ID) WHERE NOT restrict_information_schema() OR P2.TBL_ID IS NOT NULL AND P.PRINCIPAL_NAME = P2.PRINCIPAL_NAME AND P.PRINCIPAL_TYPE = P2.PRINCIPAL_TYPE AND (P2.PRINCIPAL_NAME=current_user() AND P2.PRINCIPAL_TYPE='USER' OR ((array_contains(current_groups(), P2.PRINCIPAL_NAME) OR P2.PRINCIPAL_NAME = 'public') AND P2.PRINCIPAL_TYPE='GROUP')) AND P2.TBL_PRIV='SELECT' AND P.AUTHORIZER=current_authorizer() AND P2.AUTHORIZER=current_authorizer() | NULL | | Expanded Query: | SELECT `grantor` AS `grantor`, `principal_name` AS `grantee`, `_c2` AS `table_catalog`, `name` AS `table_schema`, `tbl_name` AS `table_name`, `column_name` AS `column_name`, `tbl_col_priv` AS `privilege_type`, `_c7` AS `is_grantable` FROM (SELECT DISTINCT `p`.`grantor`, `p`.`principal_name`, 'default', `d`.`name`, `t`.`tbl_name`, `p`.`column_name`, `p`.`tbl_col_priv`, IF (`p`.`grant_option` == 0, 'NO', 'YES') FROM (SELECT `q`.`grantor`, `q`.`grant_option`, `q`.`principal_name`, `q`.`principal_type`, `q`.`authorizer`, `q`.`column_name`, `tbl_col_priv_tmp`.`tbl_col_priv`, `q`.`tbl_id` FROM `sys`.`TBL_COL_PRIVS` AS `Q` LATERAL VIEW explode(split_map_privs(`q`.`tbl_col_priv`)) `TBL_COL_PRIV_TMP` AS `TBL_COL_PRIV`) `P` JOIN `sys`.`TBLS` `T` ON (`p`.`tbl_id` = `t`.`tbl_id`) JOIN `sys`.`DBS` `D` ON (`t`.`db_id` = `d`.`db_id`) JOIN `sys`.`SDS` `S` ON (`s`.`sd_id` = `t`.`sd_id`) LEFT JOIN `sys`.`TBL_PRIVS` `P2` ON (`p`.`tbl_id` = `p2`.`tbl_id`) WHERE NOT restrict_information_schema() OR `p2`.`tbl_id` IS NOT NULL AND `p`.`principal_name` = `p2`.`principal_name` AND `p`.`principal_type` = `p2`.`principal_type` AND (`p2`.`principal_name`=current_user() AND `p2`.`principal_type`='USER' OR ((array_contains(current_groups(), `p2`.`principal_name`) OR `p2`.`principal_name` = 'public') AND `p2`.`principal_type`='GROUP')) AND `p2`.`tbl_priv`='SELECT' AND `p`.`authorizer`=current_authorizer() AND `p2`.`authorizer`=current_authorizer()) `COLUMN_PRIVILEGES` | NULL | +-------------------------------+----------------------------------------------------+-----------------------+ 33 rows selected (0.603 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> show create table information_schema.column_privileges; INFO : Compiling command(queryId=hive_20231207213629_5b2c0e9f-f08f-4c96-963e-4a3e0b983fc4): show create table information_schema.column_privileges INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213629_5b2c0e9f-f08f-4c96-963e-4a3e0b983fc4); Time taken: 0.028 seconds INFO : Executing command(queryId=hive_20231207213629_5b2c0e9f-f08f-4c96-963e-4a3e0b983fc4): show create table information_schema.column_privileges INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213629_5b2c0e9f-f08f-4c96-963e-4a3e0b983fc4); Time taken: 0.011 seconds INFO : OK +----------------------------------------------------+ | createtab_stmt | +----------------------------------------------------+ | CREATE VIEW `information_schema`.`column_privileges` AS SELECT `grantor` AS `grantor`, `principal_name` AS `grantee`, `_c2` AS `table_catalog`, `name` AS `table_schema`, `tbl_name` AS `table_name`, `column_name` AS `column_name`, `tbl_col_priv` AS `privilege_type`, `_c7` AS `is_grantable` FROM (SELECT DISTINCT `p`.`grantor`, `p`.`principal_name`, 'default', `d`.`name`, `t`.`tbl_name`, `p`.`column_name`, `p`.`tbl_col_priv`, IF (`p`.`grant_option` == 0, 'NO', 'YES') FROM (SELECT `q`.`grantor`, `q`.`grant_option`, `q`.`principal_name`, `q`.`principal_type`, `q`.`authorizer`, `q`.`column_name`, `tbl_col_priv_tmp`.`tbl_col_priv`, `q`.`tbl_id` FROM `sys`.`TBL_COL_PRIVS` AS `Q` LATERAL VIEW explode(split_map_privs(`q`.`tbl_col_priv`)) `TBL_COL_PRIV_TMP` AS `TBL_COL_PRIV`) `P` JOIN `sys`.`TBLS` `T` ON (`p`.`tbl_id` = `t`.`tbl_id`) JOIN `sys`.`DBS` `D` ON (`t`.`db_id` = `d`.`db_id`) JOIN `sys`.`SDS` `S` ON (`s`.`sd_id` = `t`.`sd_id`) LEFT JOIN `sys`.`TBL_PRIVS` `P2` ON (`p`.`tbl_id` = `p2`.`tbl_id`) WHERE NOT restrict_information_schema() OR `p2`.`tbl_id` IS NOT NULL AND `p`.`principal_name` = `p2`.`principal_name` AND `p`.`principal_type` = `p2`.`principal_type` AND (`p2`.`principal_name`=current_user() AND `p2`.`principal_type`='USER' OR ((array_contains(current_groups(), `p2`.`principal_name`) OR `p2`.`principal_name` = 'public') AND `p2`.`principal_type`='GROUP')) AND `p2`.`tbl_priv`='SELECT' AND `p`.`authorizer`=current_authorizer() AND `p2`.`authorizer`=current_authorizer()) `COLUMN_PRIVILEGES` | +----------------------------------------------------+ 1 row selected (0.572 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> describe formatted information_schema.scheduled_executions; INFO : Compiling command(queryId=hive_20231207213734_261405bc-1d66-4a07-9bd6-54d019f73142): describe formatted information_schema.scheduled_executions INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213734_261405bc-1d66-4a07-9bd6-54d019f73142); Time taken: 0.029 seconds INFO : Executing command(queryId=hive_20231207213734_261405bc-1d66-4a07-9bd6-54d019f73142): describe formatted information_schema.scheduled_executions INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213734_261405bc-1d66-4a07-9bd6-54d019f73142); Time taken: 0.025 seconds INFO : OK +-------------------------------+----------------------------------------------------+-----------------------+ | col_name | data_type | comment | +-------------------------------+----------------------------------------------------+-----------------------+ | scheduled_execution_id | bigint | | | schedule_name | string | | | executor_query_id | string | | | state | string | | | start_time | string | | | end_time | string | | | elapsed | int | | | error_message | string | | | last_update_time | string | | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | information_schema | NULL | | OwnerType: | USER | NULL | | Owner: | hive | NULL | | CreateTime: | Tue Dec 05 17:25:41 UTC 2023 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Table Type: | VIRTUAL_VIEW | NULL | | Table Parameters: | NULL | NULL | | | bucketing_version | 2 | | | transient_lastDdlTime | 1701797141 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | null | NULL | | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL | | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | | NULL | NULL | | # View Information | NULL | NULL | | Original Query: | SELECT SCHEDULED_EXECUTION_ID, SCHEDULE_NAME, EXECUTOR_QUERY_ID, STATE, FROM_UNIXTIME(START_TIME) as START_TIME, FROM_UNIXTIME(END_TIME) as END_TIME, END_TIME-START_TIME as ELAPSED, ERROR_MESSAGE, FROM_UNIXTIME(LAST_UPDATE_TIME) AS LAST_UPDATE_TIME FROM SYS.SCHEDULED_EXECUTIONS SE JOIN SYS.SCHEDULED_QUERIES SQ WHERE SE.SCHEDULED_QUERY_ID=SQ.SCHEDULED_QUERY_ID | NULL | | Expanded Query: | SELECT `se`.`scheduled_execution_id`, `sq`.`schedule_name`, `se`.`executor_query_id`, `se`.`state`, FROM_UNIXTIME(`se`.`start_time`) as `START_TIME`, FROM_UNIXTIME(`se`.`end_time`) as `END_TIME`, `se`.`end_time`-`se`.`start_time` as `ELAPSED`, `se`.`error_message`, FROM_UNIXTIME(`se`.`last_update_time`) AS `LAST_UPDATE_TIME` FROM `SYS`.`SCHEDULED_EXECUTIONS` `SE` JOIN `SYS`.`SCHEDULED_QUERIES` `SQ` WHERE `se`.`scheduled_query_id`=`sq`.`scheduled_query_id` | NULL | +-------------------------------+----------------------------------------------------+-----------------------+ 34 rows selected (0.609 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> show create table information_schema.scheduled_executions; INFO : Compiling command(queryId=hive_20231207213744_91d2bbf8-a0b5-4436-af1e-7658798d77bc): show create table information_schema.scheduled_executions INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213744_91d2bbf8-a0b5-4436-af1e-7658798d77bc); Time taken: 0.023 seconds INFO : Executing command(queryId=hive_20231207213744_91d2bbf8-a0b5-4436-af1e-7658798d77bc): show create table information_schema.scheduled_executions INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213744_91d2bbf8-a0b5-4436-af1e-7658798d77bc); Time taken: 0.011 seconds INFO : OK +----------------------------------------------------+ | createtab_stmt | +----------------------------------------------------+ | CREATE VIEW `information_schema`.`scheduled_executions` AS SELECT `se`.`scheduled_execution_id`, `sq`.`schedule_name`, `se`.`executor_query_id`, `se`.`state`, FROM_UNIXTIME(`se`.`start_time`) as `START_TIME`, FROM_UNIXTIME(`se`.`end_time`) as `END_TIME`, `se`.`end_time`-`se`.`start_time` as `ELAPSED`, `se`.`error_message`, FROM_UNIXTIME(`se`.`last_update_time`) AS `LAST_UPDATE_TIME` FROM `SYS`.`SCHEDULED_EXECUTIONS` `SE` JOIN `SYS`.`SCHEDULED_QUERIES` `SQ` WHERE `se`.`scheduled_query_id`=`sq`.`scheduled_query_id` | +----------------------------------------------------+ 1 row selected (0.571 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> describe formatted information_schema.scheduled_queries; INFO : Compiling command(queryId=hive_20231207213912_2fb2ef85-c338-46e1-9fc8-87c8e91e2cfe): describe formatted information_schema.scheduled_queries INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213912_2fb2ef85-c338-46e1-9fc8-87c8e91e2cfe); Time taken: 0.026 seconds INFO : Executing command(queryId=hive_20231207213912_2fb2ef85-c338-46e1-9fc8-87c8e91e2cfe): describe formatted information_schema.scheduled_queries INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213912_2fb2ef85-c338-46e1-9fc8-87c8e91e2cfe); Time taken: 0.027 seconds INFO : OK +-------------------------------+----------------------------------------------------+-----------------------+ | col_name | data_type | comment | +-------------------------------+----------------------------------------------------+-----------------------+ | scheduled_query_id | bigint | | | schedule_name | string | | | enabled | boolean | | | cluster_namespace | string | | | schedule | string | | | user | string | | | query | string | | | next_execution | string | | | active_execution_id | bigint | | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | information_schema | NULL | | OwnerType: | USER | NULL | | Owner: | hive | NULL | | CreateTime: | Tue Dec 05 17:25:40 UTC 2023 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Table Type: | VIRTUAL_VIEW | NULL | | Table Parameters: | NULL | NULL | | | bucketing_version | 2 | | | transient_lastDdlTime | 1701797140 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | null | NULL | | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL | | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | | NULL | NULL | | # View Information | NULL | NULL | | Original Query: | select SCHEDULED_QUERY_ID , SCHEDULE_NAME , ENABLED, CLUSTER_NAMESPACE, SCHEDULE, USER, QUERY, FROM_UNIXTIME(NEXT_EXECUTION) as NEXT_EXECUTION, ACTIVE_EXECUTION_ID FROM SYS.SCHEDULED_QUERIES | NULL | | Expanded Query: | select `scheduled_queries`.`scheduled_query_id` , `scheduled_queries`.`schedule_name` , `scheduled_queries`.`enabled`, `scheduled_queries`.`cluster_namespace`, `scheduled_queries`.`schedule`, `scheduled_queries`.`user`, `scheduled_queries`.`query`, FROM_UNIXTIME(`scheduled_queries`.`next_execution`) as `NEXT_EXECUTION`, `scheduled_queries`.`active_execution_id` FROM `SYS`.`SCHEDULED_QUERIES` | NULL | +-------------------------------+----------------------------------------------------+-----------------------+ 34 rows selected (1.672 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> show create table information_schema.scheduled_queries; INFO : Compiling command(queryId=hive_20231207213924_9ab1a5e8-2c09-40b5-a7b8-d9de4ebc4d63): show create table information_schema.scheduled_queries INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207213924_9ab1a5e8-2c09-40b5-a7b8-d9de4ebc4d63); Time taken: 0.025 seconds INFO : Executing command(queryId=hive_20231207213924_9ab1a5e8-2c09-40b5-a7b8-d9de4ebc4d63): show create table information_schema.scheduled_queries INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207213924_9ab1a5e8-2c09-40b5-a7b8-d9de4ebc4d63); Time taken: 0.01 seconds INFO : OK +----------------------------------------------------+ | createtab_stmt | +----------------------------------------------------+ | CREATE VIEW `information_schema`.`scheduled_queries` AS select `scheduled_queries`.`scheduled_query_id` , `scheduled_queries`.`schedule_name` , `scheduled_queries`.`enabled`, `scheduled_queries`.`cluster_namespace`, `scheduled_queries`.`schedule`, `scheduled_queries`.`user`, `scheduled_queries`.`query`, FROM_UNIXTIME(`scheduled_queries`.`next_execution`) as `NEXT_EXECUTION`, `scheduled_queries`.`active_execution_id` FROM `SYS`.`SCHEDULED_QUERIES` | +----------------------------------------------------+ 1 row selected (0.595 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> =============== 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> describe formatted sys.dbs; INFO : Compiling command(queryId=hive_20231207221130_485a293c-74dc-4bfb-bb98-6129835530af): describe formatted sys.dbs INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207221130_485a293c-74dc-4bfb-bb98-6129835530af); Time taken: 0.033 seconds INFO : Executing command(queryId=hive_20231207221130_485a293c-74dc-4bfb-bb98-6129835530af): describe formatted sys.dbs INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207221130_485a293c-74dc-4bfb-bb98-6129835530af); Time taken: 0.145 seconds INFO : OK +-------------------------------+----------------------------------------------------+----------------------------------------------------+ | col_name | data_type | comment | +-------------------------------+----------------------------------------------------+----------------------------------------------------+ | db_id | bigint | from deserializer | | db_location_uri | string | from deserializer | | name | string | from deserializer | | owner_name | string | from deserializer | | owner_type | string | from deserializer | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | sys | NULL | | OwnerType: | USER | NULL | | Owner: | hive | NULL | | CreateTime: | Tue Dec 05 17:25:01 UTC 2023 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Location: | s3a://yingchen-dwx/wdata-12052023/warehouse/tablespace/external/hive/sys.db/dbs | NULL | | Table Type: | EXTERNAL_TABLE | NULL | | Table Parameters: | NULL | NULL | | | COLUMN_STATS_ACCURATE | {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"db_id\":\"true\",\"db_location_uri\":\"true\",\"name\":\"true\",\"owner_name\":\"true\",\"owner_type\":\"true\"}} | | | EXTERNAL | TRUE | | | bucketing_version | 2 | | | hive.sql.database.type | METASTORE | | | hive.sql.query | SELECT \"DB_ID\", \"DB_LOCATION_URI\", \"NAME\", \"OWNER_NAME\", \"OWNER_TYPE\" FROM \"DBS\" | | | numFiles | 0 | | | numRows | 0 | | | rawDataSize | 0 | | | storage_handler | org.apache.hive.storage.jdbc.JdbcStorageHandler | | | totalSize | 0 | | | transient_lastDdlTime | 1701797101 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | org.apache.hive.storage.jdbc.JdbcSerDe | NULL | | InputFormat: | null | NULL | | OutputFormat: | null | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | Storage Desc Params: | NULL | NULL | | | serialization.format | 1 | | | NULL | NULL | | # Constraints | NULL | NULL | | | NULL | NULL | | # Primary Key | NULL | NULL | | Table: | sys.dbs | NULL | | Constraint Name: | sys_pk_dbs | NULL | | Column Name: | db_id | NULL | +-------------------------------+----------------------------------------------------+----------------------------------------------------+ 45 rows selected (0.743 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> show create table sys.dbs; INFO : Compiling command(queryId=hive_20231207221155_be88579e-d032-402d-9d3c-2d617960c10b): show create table sys.dbs INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207221155_be88579e-d032-402d-9d3c-2d617960c10b); Time taken: 0.022 seconds INFO : Executing command(queryId=hive_20231207221155_be88579e-d032-402d-9d3c-2d617960c10b): show create table sys.dbs INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207221155_be88579e-d032-402d-9d3c-2d617960c10b); Time taken: 0.142 seconds INFO : OK +----------------------------------------------------+ | createtab_stmt | +----------------------------------------------------+ | CREATE EXTERNAL TABLE `sys`.`dbs`( | | `db_id` bigint COMMENT 'from deserializer', | | `db_location_uri` string COMMENT 'from deserializer', | | `name` string COMMENT 'from deserializer', | | `owner_name` string COMMENT 'from deserializer', | | `owner_type` string COMMENT 'from deserializer') | | ROW FORMAT SERDE | | 'org.apache.hive.storage.jdbc.JdbcSerDe' | | STORED BY | | 'org.apache.hive.storage.jdbc.JdbcStorageHandler' | | WITH SERDEPROPERTIES ( | | 'serialization.format'='1') | | TBLPROPERTIES ( | | 'bucketing_version'='2', | | 'hive.sql.database.type'='METASTORE', | | 'hive.sql.query'='SELECT "DB_ID", "DB_LOCATION_URI", "NAME", "OWNER_NAME", "OWNER_TYPE" FROM "DBS"', | | 'transient_lastDdlTime'='1701797101') | +----------------------------------------------------+ 17 rows selected (0.729 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> describe formatted sys.tbls; INFO : Compiling command(queryId=hive_20231207221524_6a3e89f5-0158-4eeb-b416-2f9656836e8c): describe formatted sys.tbls INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207221524_6a3e89f5-0158-4eeb-b416-2f9656836e8c); Time taken: 0.023 seconds INFO : Executing command(queryId=hive_20231207221524_6a3e89f5-0158-4eeb-b416-2f9656836e8c): describe formatted sys.tbls INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207221524_6a3e89f5-0158-4eeb-b416-2f9656836e8c); Time taken: 0.15 seconds INFO : OK +-------------------------------+----------------------------------------------------+----------------------------------------------------+ | col_name | data_type | comment | +-------------------------------+----------------------------------------------------+----------------------------------------------------+ | tbl_id | bigint | from deserializer | | create_time | int | from deserializer | | db_id | bigint | from deserializer | | last_access_time | int | from deserializer | | owner | string | from deserializer | | retention | int | from deserializer | | sd_id | bigint | from deserializer | | tbl_name | string | from deserializer | | tbl_type | string | from deserializer | | view_expanded_text | string | from deserializer | | view_original_text | string | from deserializer | | is_rewrite_enabled | boolean | from deserializer | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | sys | NULL | | OwnerType: | USER | NULL | | Owner: | hive | NULL | | CreateTime: | Tue Dec 05 17:25:13 UTC 2023 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Location: | s3a://yingchen-dwx/wdata-12052023/warehouse/tablespace/external/hive/sys.db/tbls | NULL | | Table Type: | EXTERNAL_TABLE | NULL | | Table Parameters: | NULL | NULL | | | COLUMN_STATS_ACCURATE | {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"create_time\":\"true\",\"db_id\":\"true\",\"is_rewrite_enabled\":\"true\",\"last_access_time\":\"true\",\"owner\":\"true\",\"retention\":\"true\",\"sd_id\":\"true\",\"tbl_id\":\"true\",\"tbl_name\":\"true\",\"tbl_type\":\"true\",\"view_expanded_text\":\"true\",\"view_original_text\":\"true\"}} | | | EXTERNAL | TRUE | | | bucketing_version | 2 | | | hive.sql.database.type | METASTORE | | | hive.sql.query | SELECT \"TBL_ID\", \"CREATE_TIME\", \"DB_ID\", \"LAST_ACCESS_TIME\", \"OWNER\", \"RETENTION\", \"SD_ID\", \"TBL_NAME\", \"TBL_TYPE\", \"VIEW_EXPANDED_TEXT\", \"VIEW_ORIGINAL_TEXT\", \"IS_REWRITE_ENABLED\" FROM \"TBLS\" | | | numFiles | 0 | | | numRows | 0 | | | rawDataSize | 0 | | | storage_handler | org.apache.hive.storage.jdbc.JdbcStorageHandler | | | totalSize | 0 | | | transient_lastDdlTime | 1701797113 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | org.apache.hive.storage.jdbc.JdbcSerDe | NULL | | InputFormat: | null | NULL | | OutputFormat: | null | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | Storage Desc Params: | NULL | NULL | | | serialization.format | 1 | | | NULL | NULL | | # Constraints | NULL | NULL | | | NULL | NULL | | # Primary Key | NULL | NULL | | Table: | sys.tbls | NULL | | Constraint Name: | sys_pk_tbls | NULL | | Column Name: | tbl_id | NULL | +-------------------------------+----------------------------------------------------+----------------------------------------------------+ 52 rows selected (1.304 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> show create table sys.tbls; INFO : Compiling command(queryId=hive_20231207221528_5fc084f6-8436-44a2-b7fe-a35b4b35853c): show create table sys.tbls INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207221528_5fc084f6-8436-44a2-b7fe-a35b4b35853c); Time taken: 0.02 seconds INFO : Executing command(queryId=hive_20231207221528_5fc084f6-8436-44a2-b7fe-a35b4b35853c): show create table sys.tbls INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207221528_5fc084f6-8436-44a2-b7fe-a35b4b35853c); Time taken: 0.142 seconds INFO : OK +----------------------------------------------------+ | createtab_stmt | +----------------------------------------------------+ | CREATE EXTERNAL TABLE `sys`.`tbls`( | | `tbl_id` bigint COMMENT 'from deserializer', | | `create_time` int COMMENT 'from deserializer', | | `db_id` bigint COMMENT 'from deserializer', | | `last_access_time` int COMMENT 'from deserializer', | | `owner` string COMMENT 'from deserializer', | | `retention` int COMMENT 'from deserializer', | | `sd_id` bigint COMMENT 'from deserializer', | | `tbl_name` string COMMENT 'from deserializer', | | `tbl_type` string COMMENT 'from deserializer', | | `view_expanded_text` string COMMENT 'from deserializer', | | `view_original_text` string COMMENT 'from deserializer', | | `is_rewrite_enabled` boolean COMMENT 'from deserializer') | | ROW FORMAT SERDE | | 'org.apache.hive.storage.jdbc.JdbcSerDe' | | STORED BY | | 'org.apache.hive.storage.jdbc.JdbcStorageHandler' | | WITH SERDEPROPERTIES ( | | 'serialization.format'='1') | | TBLPROPERTIES ( | | 'bucketing_version'='2', | | 'hive.sql.database.type'='METASTORE', | | 'hive.sql.query'='SELECT "TBL_ID", "CREATE_TIME", "DB_ID", "LAST_ACCESS_TIME", "OWNER", "RETENTION", "SD_ID", "TBL_NAME", "TBL_TYPE", "VIEW_EXPANDED_TEXT", "VIEW_ORIGINAL_TEXT", "IS_REWRITE_ENABLED" FROM "TBLS"', | | 'transient_lastDdlTime'='1701797113') | +----------------------------------------------------+ 24 rows selected (0.962 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> describe formatted sys.TBL_PRIVS; INFO : Compiling command(queryId=hive_20231207221825_1cfb08ea-8658-470b-9362-c62e99893fb0): describe formatted sys.TBL_PRIVS INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207221825_1cfb08ea-8658-470b-9362-c62e99893fb0); Time taken: 0.024 seconds INFO : Executing command(queryId=hive_20231207221825_1cfb08ea-8658-470b-9362-c62e99893fb0): describe formatted sys.TBL_PRIVS INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207221825_1cfb08ea-8658-470b-9362-c62e99893fb0); Time taken: 0.138 seconds INFO : OK +-------------------------------+----------------------------------------------------+----------------------------------------------------+ | col_name | data_type | comment | +-------------------------------+----------------------------------------------------+----------------------------------------------------+ | tbl_grant_id | bigint | from deserializer | | create_time | int | from deserializer | | grant_option | int | from deserializer | | grantor | string | from deserializer | | grantor_type | string | from deserializer | | principal_name | string | from deserializer | | principal_type | string | from deserializer | | tbl_priv | string | from deserializer | | tbl_id | bigint | from deserializer | | authorizer | string | from deserializer | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | sys | NULL | | OwnerType: | USER | NULL | | Owner: | hive | NULL | | CreateTime: | Tue Dec 05 17:25:14 UTC 2023 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Retention: | 0 | NULL | | Location: | s3a://yingchen-dwx/wdata-12052023/warehouse/tablespace/external/hive/sys.db/tbl_privs | NULL | | Table Type: | EXTERNAL_TABLE | NULL | | Table Parameters: | NULL | NULL | | | COLUMN_STATS_ACCURATE | {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"authorizer\":\"true\",\"create_time\":\"true\",\"grant_option\":\"true\",\"grantor\":\"true\",\"grantor_type\":\"true\",\"principal_name\":\"true\",\"principal_type\":\"true\",\"tbl_grant_id\":\"true\",\"tbl_id\":\"true\",\"tbl_priv\":\"true\"}} | | | EXTERNAL | TRUE | | | bucketing_version | 2 | | | hive.sql.database.type | METASTORE | | | hive.sql.query | SELECT \"TBL_GRANT_ID\", \"CREATE_TIME\", \"GRANT_OPTION\", \"GRANTOR\", \"GRANTOR_TYPE\", \"PRINCIPAL_NAME\", \"PRINCIPAL_TYPE\", \"TBL_PRIV\", \"TBL_ID\", \"AUTHORIZER\" FROM \"TBL_PRIVS\" | | | numFiles | 0 | | | numRows | 0 | | | rawDataSize | 0 | | | storage_handler | org.apache.hive.storage.jdbc.JdbcStorageHandler | | | totalSize | 0 | | | transient_lastDdlTime | 1701797114 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | org.apache.hive.storage.jdbc.JdbcSerDe | NULL | | InputFormat: | null | NULL | | OutputFormat: | null | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | Storage Desc Params: | NULL | NULL | | | serialization.format | 1 | | | NULL | NULL | | # Constraints | NULL | NULL | | | NULL | NULL | | # Primary Key | NULL | NULL | | Table: | sys.tbl_privs | NULL | | Constraint Name: | sys_pk_tbl_privs | NULL | | Column Name: | tbl_grant_id | NULL | +-------------------------------+----------------------------------------------------+----------------------------------------------------+ 50 rows selected (0.702 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120> show create table sys.TBL_PRIVS; INFO : Compiling command(queryId=hive_20231207221835_a68d6c55-7231-49db-af34-b53988d37fc7): show create table sys.TBL_PRIVS INFO : Semantic Analysis Completed (retrial = false) INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=hive_20231207221835_a68d6c55-7231-49db-af34-b53988d37fc7); Time taken: 0.02 seconds INFO : Executing command(queryId=hive_20231207221835_a68d6c55-7231-49db-af34-b53988d37fc7): show create table sys.TBL_PRIVS INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20231207221835_a68d6c55-7231-49db-af34-b53988d37fc7); Time taken: 0.144 seconds INFO : OK +----------------------------------------------------+ | createtab_stmt | +----------------------------------------------------+ | CREATE EXTERNAL TABLE `sys`.`tbl_privs`( | | `tbl_grant_id` bigint COMMENT 'from deserializer', | | `create_time` int COMMENT 'from deserializer', | | `grant_option` int COMMENT 'from deserializer', | | `grantor` string COMMENT 'from deserializer', | | `grantor_type` string COMMENT 'from deserializer', | | `principal_name` string COMMENT 'from deserializer', | | `principal_type` string COMMENT 'from deserializer', | | `tbl_priv` string COMMENT 'from deserializer', | | `tbl_id` bigint COMMENT 'from deserializer', | | `authorizer` string COMMENT 'from deserializer') | | ROW FORMAT SERDE | | 'org.apache.hive.storage.jdbc.JdbcSerDe' | | STORED BY | | 'org.apache.hive.storage.jdbc.JdbcStorageHandler' | | WITH SERDEPROPERTIES ( | | 'serialization.format'='1') | | TBLPROPERTIES ( | | 'bucketing_version'='2', | | 'hive.sql.database.type'='METASTORE', | | 'hive.sql.query'='SELECT "TBL_GRANT_ID", "CREATE_TIME", "GRANT_OPTION", "GRANTOR", "GRANTOR_TYPE", "PRINCIPAL_NAME", "PRINCIPAL_TYPE", "TBL_PRIV", "TBL_ID", "AUTHORIZER" FROM "TBL_PRIVS"', | | 'transient_lastDdlTime'='1701797114') | +----------------------------------------------------+ 22 rows selected (0.709 seconds) 0: jdbc:hive2://hs2-yctest-hive.dw-yctest-120>