2023-09-28T11:26:47.348072Z 20 Connect hiveuser@172.80.0.1 on hivedb using TCP/IP 2023-09-28T11:26:47.348413Z 20 Query set autocommit=1, session_track_schema=1, sql_mode = concat(@@sql_mode,',STRICT_TRANS_TABLES') 2023-09-28T11:26:47.348504Z 20 Query SELECT @@max_allowed_packet,@@system_time_zone,@@time_zone,@@auto_increment_increment 2023-09-28T11:26:47.349650Z 21 Connect hiveuser@172.80.0.1 on hivedb using TCP/IP 2023-09-28T11:26:47.349964Z 21 Query set autocommit=1, session_track_schema=1, sql_mode = concat(@@sql_mode,',STRICT_TRANS_TABLES') 2023-09-28T11:26:47.350045Z 21 Query SELECT @@max_allowed_packet,@@system_time_zone,@@time_zone,@@auto_increment_increment 2023-09-28T11:26:47.350357Z 21 Query SELECT t.`SCHEMA_VERSION` from `VERSION` t 2023-09-28T11:26:47.350684Z 21 Quit 2023-09-28T11:26:47.355262Z 20 Query select max(`DB_ID`) from `DBS` 2023-09-28T11:26:47.355686Z 20 Query select max(`ROLE_ID`) from `ROLES` 2023-09-28T11:26:47.356145Z 20 Query select max(`USER_GRANT_ID`) from `GLOBAL_PRIVS` 2023-09-28T11:26:47.356367Z 20 Query select max(`TBL_ID`) from `TBLS` 2023-09-28T11:26:47.356588Z 20 Query select max(`SD_ID`) from `SDS` 2023-09-28T11:26:47.356833Z 20 Query select max(`SERDE_ID`) from `SERDES` 2023-09-28T11:26:47.357071Z 20 Query select max(`CD_ID`) from `CDS` 2023-09-28T11:26:47.357388Z 20 Query select max(`TBL_GRANT_ID`) from `TBL_PRIVS` 2023-09-28T11:26:47.357621Z 20 Query select max(`CS_ID`) from `TAB_COL_STATS` 2023-09-28T11:26:47.357813Z 20 Query select max(`PART_ID`) from `PARTITIONS` 2023-09-28T11:26:47.358112Z 20 Query select max(`CS_ID`) from `PART_COL_STATS` 2023-09-28T11:26:47.358337Z 20 Query select max(`FUNC_ID`) from `FUNCS` 2023-09-28T11:26:47.358650Z 20 Query select max(`INDEX_ID`) from `IDXS` 2023-09-28T11:26:47.358968Z 20 Query select max(`STRING_LIST_ID`) from `SKEWED_STRING_LIST` 2023-09-28T11:26:47.359981Z 22 Connect hiveuser@172.80.0.1 on hivedb using TCP/IP 2023-09-28T11:26:47.360146Z 22 Query set autocommit=1, session_track_schema=1, sql_mode = concat(@@sql_mode,',STRICT_TRANS_TABLES') 2023-09-28T11:26:47.360208Z 22 Query SELECT @@max_allowed_packet,@@system_time_zone,@@time_zone,@@auto_increment_increment 2023-09-28T11:26:47.360446Z 22 Query SELECT t.`SCHEMA_VERSION` from `VERSION` t 2023-09-28T11:26:47.360605Z 22 Quit 2023-09-28T11:26:47.361375Z 23 Connect hiveuser@172.80.0.1 on hivedb using TCP/IP 2023-09-28T11:26:47.361564Z 23 Query set autocommit=1, session_track_schema=1, sql_mode = concat(@@sql_mode,',STRICT_TRANS_TABLES') 2023-09-28T11:26:47.361627Z 23 Query SELECT @@max_allowed_packet,@@system_time_zone,@@time_zone,@@auto_increment_increment 2023-09-28T11:26:47.362101Z 20 Query SELECT TABLE_SCHEMA TABLE_CAT, NULL TABLE_SCHEM, TABLE_NAME, IF(TABLE_TYPE='BASE TABLE', 'TABLE', TABLE_TYPE) as TABLE_TYPE, TABLE_COMMENT REMARKS, NULL TYPE_CAT, NULL TYPE_SCHEM, NULL TYPE_NAME, NULL SELF_REFERENCING_COL_NAME, NULL REF_GENERATION FROM INFORMATION_SCHEMA.TABLES WHERE (ISNULL(database()) OR (TABLE_SCHEMA = database())) AND (TABLE_NAME LIKE '%') AND TABLE_TYPE IN ('BASE TABLE') ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME 2023-09-28T11:26:47.384059Z 20 Query select dbt.`DB_ID`, dbt.`NAME`, dbt.`DB_LOCATION_URI` from `DBS` dbt order by dbt.`DB_ID` 2023-09-28T11:26:47.384356Z 20 Query select max(`TBL_ID`), min(`TBL_ID`) from `TBLS` 2023-09-28T11:26:47.388569Z 20 Query select tbl.`TBL_ID`, tbl.`TBL_NAME`, sd.`LOCATION`, dbt.`DB_ID`, dbt.`NAME` from `TBLS` tbl inner join `SDS` sd on sd.`SD_ID` = tbl.`SD_ID` inner join `DBS` dbt on tbl.`DB_ID` = dbt.`DB_ID` where tbl.`TBL_TYPE` != 'VIRTUAL_VIEW' and tbl.`TBL_ID` >= 0 and tbl.`TBL_ID` <= 2000 order by tbl.`TBL_ID` 2023-09-28T11:26:47.389027Z 20 Query select max(`PART_ID`), min(`PART_ID`) from `PARTITIONS` 2023-09-28T11:26:47.389323Z 20 Query select pt.`PART_ID`, pt.`PART_NAME`, sd.`LOCATION`, tbl.`TBL_ID`, tbl.`TBL_NAME`, dbt.`DB_ID`, dbt.`NAME` from `PARTITIONS` pt inner join `SDS` sd on sd.`SD_ID` = pt.`SD_ID` inner join `TBLS` tbl on tbl.`TBL_ID` = pt.`TBL_ID` inner join `DBS` dbt on dbt.`DB_ID` = tbl.`DB_ID` where pt.`PART_ID` >= 0 and pt.`PART_ID` <= 2000 order by tbl.`TBL_ID` 2023-09-28T11:26:47.389692Z 20 Query select max(`STRING_LIST_ID_KID`), min(`STRING_LIST_ID_KID`) from `SKEWED_COL_VALUE_LOC_MAP` 2023-09-28T11:26:47.390004Z 20 Query select t.`TBL_NAME`, t.`TBL_ID`, sk.`STRING_LIST_ID_KID`, sk.`LOCATION`, db.`NAME`, db.`DB_ID` from `TBLS` t join `SDS` s on s.`SD_ID` = t.`SD_ID` join `DBS` db on db.`DB_ID` = t.`DB_ID` join `SKEWED_COL_VALUE_LOC_MAP` sk on sk.`SD_ID` = s.`SD_ID` where sk.`STRING_LIST_ID_KID` >= 0 and sk.`STRING_LIST_ID_KID` <= 2000 order by t.`TBL_ID` 2023-09-28T11:26:47.390283Z 20 Query select t.* from `TBLS` t where t.`SD_ID` IS NULL and (t.`TBL_TYPE` = 'EXTERNAL_TABLE' or t.`TBL_TYPE` = 'MANAGED_TABLE') order by t.`TBL_ID` 2023-09-28T11:26:47.390759Z 20 Quit