2023-09-28T10:09:15.248035Z 20 Connect hiveuser@172.80.0.1 on hivedb using TCP/IP 2023-09-28T10:09:15.248317Z 20 Query set autocommit=1, session_track_schema=1, sql_mode = concat(@@sql_mode,',STRICT_TRANS_TABLES') 2023-09-28T10:09:15.248411Z 20 Query SELECT @@max_allowed_packet,@@system_time_zone,@@time_zone,@@auto_increment_increment 2023-09-28T10:09:15.249461Z 21 Connect hiveuser@172.80.0.1 on hivedb using TCP/IP 2023-09-28T10:09:15.249787Z 21 Query set autocommit=1, session_track_schema=1, sql_mode = concat(@@sql_mode,',STRICT_TRANS_TABLES') 2023-09-28T10:09:15.249870Z 21 Query SELECT @@max_allowed_packet,@@system_time_zone,@@time_zone,@@auto_increment_increment 2023-09-28T10:09:15.250176Z 21 Query select t.SCHEMA_VERSION from VERSION t 2023-09-28T10:09:15.250485Z 21 Quit 2023-09-28T10:09:15.256232Z 20 Query select max(DB_ID) from DBS 2023-09-28T10:09:15.256657Z 20 Query select max(ROLE_ID) from ROLES 2023-09-28T10:09:15.257056Z 20 Query select max(USER_GRANT_ID) from GLOBAL_PRIVS 2023-09-28T10:09:15.257256Z 20 Query select max(TBL_ID) from TBLS 2023-09-28T10:09:15.257487Z 20 Query select max(SD_ID) from SDS 2023-09-28T10:09:15.257756Z 20 Query select max(SERDE_ID) from SERDES 2023-09-28T10:09:15.258020Z 20 Query select max(CD_ID) from CDS 2023-09-28T10:09:15.258495Z 20 Query select max(TBL_GRANT_ID) from TBL_PRIVS 2023-09-28T10:09:15.258787Z 20 Query select max(CS_ID) from TAB_COL_STATS 2023-09-28T10:09:15.259025Z 20 Query select max(PART_ID) from PARTITIONS 2023-09-28T10:09:15.259272Z 20 Query select max(CS_ID) from PART_COL_STATS 2023-09-28T10:09:15.259580Z 20 Query select max(FUNC_ID) from FUNCS 2023-09-28T10:09:15.259895Z 20 Query select max(INDEX_ID) from IDXS 2023-09-28T10:09:15.260295Z 20 Query select max(STRING_LIST_ID) from SKEWED_STRING_LIST 2023-09-28T10:09:15.261351Z 22 Connect hiveuser@172.80.0.1 on hivedb using TCP/IP 2023-09-28T10:09:15.261665Z 22 Query set autocommit=1, session_track_schema=1, sql_mode = concat(@@sql_mode,',STRICT_TRANS_TABLES') 2023-09-28T10:09:15.261733Z 22 Query SELECT @@max_allowed_packet,@@system_time_zone,@@time_zone,@@auto_increment_increment 2023-09-28T10:09:15.261987Z 22 Query select t.SCHEMA_VERSION from VERSION t 2023-09-28T10:09:15.262278Z 22 Quit 2023-09-28T10:09:15.262979Z 23 Connect hiveuser@172.80.0.1 on hivedb using TCP/IP 2023-09-28T10:09:15.263183Z 23 Query set autocommit=1, session_track_schema=1, sql_mode = concat(@@sql_mode,',STRICT_TRANS_TABLES') 2023-09-28T10:09:15.263242Z 23 Query SELECT @@max_allowed_packet,@@system_time_zone,@@time_zone,@@auto_increment_increment 2023-09-28T10:09:15.263670Z 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-28T10:09:15.292531Z 20 Query select dbt.DB_ID, dbt.NAME, dbt.DB_LOCATION_URI from DBS dbt order by dbt.DB_ID 2023-09-28T10:09:15.292971Z 20 Query select max(TBL_ID), min(TBL_ID) from TBLS 2023-09-28T10:09:15.298721Z 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-28T10:09:15.299246Z 20 Query select max(PART_ID), min(PART_ID) from PARTITIONS 2023-09-28T10:09:15.299601Z 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-28T10:09:15.299991Z 20 Query select max(STRING_LIST_ID_KID), min(STRING_LIST_ID_KID) from SKEWED_COL_VALUE_LOC_MAP 2023-09-28T10:09:15.300348Z 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-28T10:09:15.300768Z 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-28T10:09:15.301050Z 20 Quit