select "DB_ID", "NAME", "DB_LOCATION_URI", "DESC", "OWNER_NAME", "OWNER_TYPE", "CTLG_NAME" , "CREATE_TIME", "DB_MANAGED_LOCATION_URI", "TYPE", "DATACONNECTOR_NAME", "REMOTE_DBNAME"FROM "DBS" where "NAME" = <'default'> and "CTLG_NAME" = <'hive'> select "PARAM_KEY", "PARAM_VALUE" from "DATABASE_PARAMS" WHERE "DB_ID" = <1> AND "PARAM_KEY" IS NOT NULL select "DB_ID", "NAME", "DB_LOCATION_URI", "DESC", "OWNER_NAME", "OWNER_TYPE", "CTLG_NAME" , "CREATE_TIME", "DB_MANAGED_LOCATION_URI", "TYPE", "DATACONNECTOR_NAME", "REMOTE_DBNAME"FROM "DBS" where "NAME" = <'default'> and "CTLG_NAME" = <'hive'> select "PARAM_KEY", "PARAM_VALUE" from "DATABASE_PARAMS" WHERE "DB_ID" = <1> AND "PARAM_KEY" IS NOT NULL SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS DN_TYPE,A0.CREATE_TIME,A0.TBL_ID,A0.LAST_ACCESS_TIME,A0.OWNER,A0.OWNER_TYPE,A0.RETENTION,A0.IS_REWRITE_ENABLED,A0.TBL_NAME,A0.TBL_TYPE,A0.WRITE_ID FROM TBLS A0 LEFT OUTER JOIN DBS B0 ON A0.DB_ID = B0.DB_ID WHERE A0.TBL_NAME = <'student'> AND B0."NAME" = <'default'> AND B0.CTLG_NAME = <'hive'> SELECT B0.CTLG_NAME,B0.DATACONNECTOR_NAME,B0.CREATE_TIME,B0."DESC",B0.DB_LOCATION_URI,B0.DB_MANAGED_LOCATION_URI,B0."NAME",B0.OWNER_NAME,B0.OWNER_TYPE,B0.REMOTE_DBNAME,B0."TYPE",B0.DB_ID,C0.INPUT_FORMAT,C0.IS_COMPRESSED,C0.IS_STOREDASSUBDIRECTORIES,C0.LOCATION,C0.NUM_BUCKETS,C0.OUTPUT_FORMAT,C0.SD_ID,A0.VIEW_EXPANDED_TEXT,A0.VIEW_ORIGINAL_TEXT FROM TBLS A0 LEFT OUTER JOIN DBS B0 ON A0.DB_ID = B0.DB_ID LEFT OUTER JOIN SDS C0 ON A0.SD_ID = C0.SD_ID WHERE A0.TBL_ID = <1> SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM TABLE_PARAMS A0 WHERE A0.TBL_ID = <1> AND A0.PARAM_KEY IS NOT NULL SELECT A0.PKEY_COMMENT,A0.PKEY_NAME,A0.PKEY_TYPE,A0.INTEGER_IDX AS NUCORDER0 FROM PARTITION_KEYS A0 WHERE A0.TBL_ID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT B0.CD_ID FROM SDS A0 LEFT OUTER JOIN CDS B0 ON A0.CD_ID = B0.CD_ID WHERE A0.SD_ID = <1> SELECT A0."COLUMN_NAME",A0."ORDER",A0.INTEGER_IDX AS NUCORDER0 FROM SORT_COLS A0 WHERE A0.SD_ID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT A0.BUCKET_COL_NAME,A0.INTEGER_IDX AS NUCORDER0 FROM BUCKETING_COLS A0 WHERE A0.SD_ID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM SD_PARAMS A0 WHERE A0.SD_ID = <1> AND A0.PARAM_KEY IS NOT NULL SELECT A0.COMMENT,A0."COLUMN_NAME",A0.TYPE_NAME,A0.INTEGER_IDX AS NUCORDER0 FROM COLUMNS_V2 A0 WHERE A0.CD_ID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT B0.DESCRIPTION,B0.DESERIALIZER_CLASS,B0."NAME",B0.SERDE_TYPE,B0.SLIB,B0.SERIALIZER_CLASS,B0.SERDE_ID FROM SDS A0 LEFT OUTER JOIN SERDES B0 ON A0.SERDE_ID = B0.SERDE_ID WHERE A0.SD_ID = <1> SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM SERDE_PARAMS A0 WHERE A0.SERDE_ID = <1> AND A0.PARAM_KEY IS NOT NULL SELECT A0.SKEWED_COL_NAME,A0.INTEGER_IDX AS NUCORDER0 FROM SKEWED_COL_NAMES A0 WHERE A0.SD_ID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT 'org.apache.hadoop.hive.metastore.model.MStringList' AS DN_TYPE,A1.STRING_LIST_ID,A0.INTEGER_IDX AS NUCORDER0 FROM SKEWED_VALUES A0 INNER JOIN SKEWED_STRING_LIST A1 ON A0.STRING_LIST_ID_EID = A1.STRING_LIST_ID WHERE A0.SD_ID_OID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT 'org.apache.hadoop.hive.metastore.model.MStringList' AS DN_TYPE,A0.STRING_LIST_ID FROM SKEWED_STRING_LIST A0 INNER JOIN SKEWED_COL_VALUE_LOC_MAP B0 ON A0.STRING_LIST_ID = B0.STRING_LIST_ID_KID WHERE B0.SD_ID = <1> SELECT A0.STRING_LIST_ID_KID,A0.LOCATION FROM SKEWED_COL_VALUE_LOC_MAP A0 WHERE A0.SD_ID = <1> AND NOT (A0.STRING_LIST_ID_KID IS NULL) select "DB_ID", "NAME", "DB_LOCATION_URI", "DESC", "OWNER_NAME", "OWNER_TYPE", "CTLG_NAME" , "CREATE_TIME", "DB_MANAGED_LOCATION_URI", "TYPE", "DATACONNECTOR_NAME", "REMOTE_DBNAME"FROM "DBS" where "NAME" = <'default'> and "CTLG_NAME" = <'hive'> select "PARAM_KEY", "PARAM_VALUE" from "DATABASE_PARAMS" WHERE "DB_ID" = <1> AND "PARAM_KEY" IS NOT NULL SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS DN_TYPE,A0.CREATE_TIME,A0.TBL_ID,A0.LAST_ACCESS_TIME,A0.OWNER,A0.OWNER_TYPE,A0.RETENTION,A0.IS_REWRITE_ENABLED,A0.TBL_NAME,A0.TBL_TYPE,A0.WRITE_ID FROM TBLS A0 LEFT OUTER JOIN DBS B0 ON A0.DB_ID = B0.DB_ID WHERE A0.TBL_NAME = <'student'> AND B0."NAME" = <'default'> AND B0.CTLG_NAME = <'hive'> SELECT B0.CTLG_NAME,B0.DATACONNECTOR_NAME,B0.CREATE_TIME,B0."DESC",B0.DB_LOCATION_URI,B0.DB_MANAGED_LOCATION_URI,B0."NAME",B0.OWNER_NAME,B0.OWNER_TYPE,B0.REMOTE_DBNAME,B0."TYPE",B0.DB_ID,C0.INPUT_FORMAT,C0.IS_COMPRESSED,C0.IS_STOREDASSUBDIRECTORIES,C0.LOCATION,C0.NUM_BUCKETS,C0.OUTPUT_FORMAT,C0.SD_ID,A0.VIEW_EXPANDED_TEXT,A0.VIEW_ORIGINAL_TEXT FROM TBLS A0 LEFT OUTER JOIN DBS B0 ON A0.DB_ID = B0.DB_ID LEFT OUTER JOIN SDS C0 ON A0.SD_ID = C0.SD_ID WHERE A0.TBL_ID = <1> SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM TABLE_PARAMS A0 WHERE A0.TBL_ID = <1> AND A0.PARAM_KEY IS NOT NULL SELECT A0.PKEY_COMMENT,A0.PKEY_NAME,A0.PKEY_TYPE,A0.INTEGER_IDX AS NUCORDER0 FROM PARTITION_KEYS A0 WHERE A0.TBL_ID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT B0.CD_ID FROM SDS A0 LEFT OUTER JOIN CDS B0 ON A0.CD_ID = B0.CD_ID WHERE A0.SD_ID = <1> SELECT A0."COLUMN_NAME",A0."ORDER",A0.INTEGER_IDX AS NUCORDER0 FROM SORT_COLS A0 WHERE A0.SD_ID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT A0.BUCKET_COL_NAME,A0.INTEGER_IDX AS NUCORDER0 FROM BUCKETING_COLS A0 WHERE A0.SD_ID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM SD_PARAMS A0 WHERE A0.SD_ID = <1> AND A0.PARAM_KEY IS NOT NULL SELECT A0.COMMENT,A0."COLUMN_NAME",A0.TYPE_NAME,A0.INTEGER_IDX AS NUCORDER0 FROM COLUMNS_V2 A0 WHERE A0.CD_ID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT B0.DESCRIPTION,B0.DESERIALIZER_CLASS,B0."NAME",B0.SERDE_TYPE,B0.SLIB,B0.SERIALIZER_CLASS,B0.SERDE_ID FROM SDS A0 LEFT OUTER JOIN SERDES B0 ON A0.SERDE_ID = B0.SERDE_ID WHERE A0.SD_ID = <1> SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM SERDE_PARAMS A0 WHERE A0.SERDE_ID = <1> AND A0.PARAM_KEY IS NOT NULL SELECT A0.SKEWED_COL_NAME,A0.INTEGER_IDX AS NUCORDER0 FROM SKEWED_COL_NAMES A0 WHERE A0.SD_ID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT 'org.apache.hadoop.hive.metastore.model.MStringList' AS DN_TYPE,A1.STRING_LIST_ID,A0.INTEGER_IDX AS NUCORDER0 FROM SKEWED_VALUES A0 INNER JOIN SKEWED_STRING_LIST A1 ON A0.STRING_LIST_ID_EID = A1.STRING_LIST_ID WHERE A0.SD_ID_OID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT 'org.apache.hadoop.hive.metastore.model.MStringList' AS DN_TYPE,A0.STRING_LIST_ID FROM SKEWED_STRING_LIST A0 INNER JOIN SKEWED_COL_VALUE_LOC_MAP B0 ON A0.STRING_LIST_ID = B0.STRING_LIST_ID_KID WHERE B0.SD_ID = <1> SELECT A0.STRING_LIST_ID_KID,A0.LOCATION FROM SKEWED_COL_VALUE_LOC_MAP A0 WHERE A0.SD_ID = <1> AND NOT (A0.STRING_LIST_ID_KID IS NULL) select "DB_ID", "NAME", "DB_LOCATION_URI", "DESC", "OWNER_NAME", "OWNER_TYPE", "CTLG_NAME" , "CREATE_TIME", "DB_MANAGED_LOCATION_URI", "TYPE", "DATACONNECTOR_NAME", "REMOTE_DBNAME"FROM "DBS" where "NAME" = <'default'> and "CTLG_NAME" = <'hive'> select "PARAM_KEY", "PARAM_VALUE" from "DATABASE_PARAMS" WHERE "DB_ID" = <1> AND "PARAM_KEY" IS NOT NULL select "PARTITIONS"."PART_ID" from "PARTITIONS" inner join "TBLS" on "PARTITIONS"."TBL_ID" = "TBLS"."TBL_ID" and "TBLS"."TBL_NAME" = <'student'> inner join "DBS" on "TBLS"."DB_ID" = "DBS"."DB_ID" and "DBS"."NAME" = <'default'> where "DBS"."CTLG_NAME" = <'hive'> order by "PART_NAME" asc select "PARTITIONS"."PART_ID", "SDS"."SD_ID", "SDS"."CD_ID", "SERDES"."SERDE_ID", "PARTITIONS"."CREATE_TIME", "PARTITIONS"."LAST_ACCESS_TIME", "SDS"."INPUT_FORMAT", "SDS"."IS_COMPRESSED", "SDS"."IS_STOREDASSUBDIRECTORIES", "SDS"."LOCATION", "SDS"."NUM_BUCKETS", "SDS"."OUTPUT_FORMAT", "SERDES"."NAME", "SERDES"."SLIB", "PARTITIONS"."WRITE_ID" from "PARTITIONS" left outer join "SDS" on "PARTITIONS"."SD_ID" = "SDS"."SD_ID" left outer join "SERDES" on "SDS"."SERDE_ID" = "SERDES"."SERDE_ID" where "PART_ID" in (1,2) order by "PART_NAME" asc select "PART_ID", "PARAM_KEY", "PARAM_VALUE" from "PARTITION_PARAMS" where "PART_ID" in (1,2) and "PARAM_KEY" is not null order by "PART_ID" asc select "PART_ID", "PART_KEY_VAL" from "PARTITION_KEY_VALS" where "PART_ID" in (1,2) order by "PART_ID" asc, "INTEGER_IDX" asc select "SD_ID", "PARAM_KEY", "PARAM_VALUE" from "SD_PARAMS" where "SD_ID" in (2,3) and "PARAM_KEY" is not null order by "SD_ID" asc select "SD_ID", "COLUMN_NAME", "SORT_COLS"."ORDER" from "SORT_COLS" where "SD_ID" in (2,3) order by "SD_ID" asc, "INTEGER_IDX" asc select "SD_ID", "BUCKET_COL_NAME" from "BUCKETING_COLS" where "SD_ID" in (2,3) order by "SD_ID" asc, "INTEGER_IDX" asc select "SD_ID", "SKEWED_COL_NAME" from "SKEWED_COL_NAMES" where "SD_ID" in (2,3) order by "SD_ID" asc, "INTEGER_IDX" asc select "CD_ID", "COMMENT", "COLUMN_NAME", "TYPE_NAME" from "COLUMNS_V2" where "CD_ID" in (1) order by "CD_ID" asc, "INTEGER_IDX" asc select "SERDE_ID", "PARAM_KEY", "PARAM_VALUE" from "SERDE_PARAMS" where "SERDE_ID" in (2,3) and "PARAM_KEY" is not null order by "SERDE_ID" asc SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MPartition' AS DN_TYPE,A0.CREATE_TIME,A0.LAST_ACCESS_TIME,A0.PART_NAME AS NUCORDER0,A0.WRITE_ID,A0.PART_ID FROM PARTITIONS A0 LEFT OUTER JOIN TBLS B0 ON A0.TBL_ID = B0.TBL_ID LEFT OUTER JOIN DBS C0 ON B0.DB_ID = C0.DB_ID WHERE B0.TBL_NAME = <'student'> AND C0."NAME" = <'default'> AND C0.CTLG_NAME = <'hive'> ORDER BY NUCORDER0 SELECT B0.INPUT_FORMAT,B0.IS_COMPRESSED,B0.IS_STOREDASSUBDIRECTORIES,B0.LOCATION,B0.NUM_BUCKETS,B0.OUTPUT_FORMAT,B0.SD_ID,C0.CREATE_TIME,C0.TBL_ID,C0.LAST_ACCESS_TIME,C0.OWNER,C0.OWNER_TYPE,C0.RETENTION,C0.IS_REWRITE_ENABLED,C0.TBL_NAME,C0.TBL_TYPE,C0.WRITE_ID FROM PARTITIONS A0 LEFT OUTER JOIN SDS B0 ON A0.SD_ID = B0.SD_ID LEFT OUTER JOIN TBLS C0 ON A0.TBL_ID = C0.TBL_ID WHERE A0.PART_ID = <1> SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM PARTITION_PARAMS A0 WHERE A0.PART_ID = <1> AND A0.PARAM_KEY IS NOT NULL SELECT A0.PART_KEY_VAL,A0.INTEGER_IDX AS NUCORDER0 FROM PARTITION_KEY_VALS A0 WHERE A0.PART_ID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT B0.INPUT_FORMAT,B0.IS_COMPRESSED,B0.IS_STOREDASSUBDIRECTORIES,B0.LOCATION,B0.NUM_BUCKETS,B0.OUTPUT_FORMAT,B0.SD_ID,C0.CREATE_TIME,C0.TBL_ID,C0.LAST_ACCESS_TIME,C0.OWNER,C0.OWNER_TYPE,C0.RETENTION,C0.IS_REWRITE_ENABLED,C0.TBL_NAME,C0.TBL_TYPE,C0.WRITE_ID FROM PARTITIONS A0 LEFT OUTER JOIN SDS B0 ON A0.SD_ID = B0.SD_ID LEFT OUTER JOIN TBLS C0 ON A0.TBL_ID = C0.TBL_ID WHERE A0.PART_ID = <2> SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM PARTITION_PARAMS A0 WHERE A0.PART_ID = <2> AND A0.PARAM_KEY IS NOT NULL SELECT A0.PART_KEY_VAL,A0.INTEGER_IDX AS NUCORDER0 FROM PARTITION_KEY_VALS A0 WHERE A0.PART_ID = <2> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT B0.CD_ID FROM SDS A0 LEFT OUTER JOIN CDS B0 ON A0.CD_ID = B0.CD_ID WHERE A0.SD_ID = <2> SELECT A0."COLUMN_NAME",A0."ORDER",A0.INTEGER_IDX AS NUCORDER0 FROM SORT_COLS A0 WHERE A0.SD_ID = <2> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT A0.BUCKET_COL_NAME,A0.INTEGER_IDX AS NUCORDER0 FROM BUCKETING_COLS A0 WHERE A0.SD_ID = <2> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM SD_PARAMS A0 WHERE A0.SD_ID = <2> AND A0.PARAM_KEY IS NOT NULL SELECT B0.DESCRIPTION,B0.DESERIALIZER_CLASS,B0."NAME",B0.SERDE_TYPE,B0.SLIB,B0.SERIALIZER_CLASS,B0.SERDE_ID FROM SDS A0 LEFT OUTER JOIN SERDES B0 ON A0.SERDE_ID = B0.SERDE_ID WHERE A0.SD_ID = <2> SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM SERDE_PARAMS A0 WHERE A0.SERDE_ID = <2> AND A0.PARAM_KEY IS NOT NULL SELECT A0.SKEWED_COL_NAME,A0.INTEGER_IDX AS NUCORDER0 FROM SKEWED_COL_NAMES A0 WHERE A0.SD_ID = <2> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT 'org.apache.hadoop.hive.metastore.model.MStringList' AS DN_TYPE,A1.STRING_LIST_ID,A0.INTEGER_IDX AS NUCORDER0 FROM SKEWED_VALUES A0 INNER JOIN SKEWED_STRING_LIST A1 ON A0.STRING_LIST_ID_EID = A1.STRING_LIST_ID WHERE A0.SD_ID_OID = <2> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT 'org.apache.hadoop.hive.metastore.model.MStringList' AS DN_TYPE,A0.STRING_LIST_ID FROM SKEWED_STRING_LIST A0 INNER JOIN SKEWED_COL_VALUE_LOC_MAP B0 ON A0.STRING_LIST_ID = B0.STRING_LIST_ID_KID WHERE B0.SD_ID = <2> SELECT A0.STRING_LIST_ID_KID,A0.LOCATION FROM SKEWED_COL_VALUE_LOC_MAP A0 WHERE A0.SD_ID = <2> AND NOT (A0.STRING_LIST_ID_KID IS NULL) SELECT B0.CD_ID FROM SDS A0 LEFT OUTER JOIN CDS B0 ON A0.CD_ID = B0.CD_ID WHERE A0.SD_ID = <3> SELECT A0."COLUMN_NAME",A0."ORDER",A0.INTEGER_IDX AS NUCORDER0 FROM SORT_COLS A0 WHERE A0.SD_ID = <3> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT A0.BUCKET_COL_NAME,A0.INTEGER_IDX AS NUCORDER0 FROM BUCKETING_COLS A0 WHERE A0.SD_ID = <3> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM SD_PARAMS A0 WHERE A0.SD_ID = <3> AND A0.PARAM_KEY IS NOT NULL SELECT B0.DESCRIPTION,B0.DESERIALIZER_CLASS,B0."NAME",B0.SERDE_TYPE,B0.SLIB,B0.SERIALIZER_CLASS,B0.SERDE_ID FROM SDS A0 LEFT OUTER JOIN SERDES B0 ON A0.SERDE_ID = B0.SERDE_ID WHERE A0.SD_ID = <3> SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM SERDE_PARAMS A0 WHERE A0.SERDE_ID = <3> AND A0.PARAM_KEY IS NOT NULL SELECT A0.SKEWED_COL_NAME,A0.INTEGER_IDX AS NUCORDER0 FROM SKEWED_COL_NAMES A0 WHERE A0.SD_ID = <3> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT 'org.apache.hadoop.hive.metastore.model.MStringList' AS DN_TYPE,A1.STRING_LIST_ID,A0.INTEGER_IDX AS NUCORDER0 FROM SKEWED_VALUES A0 INNER JOIN SKEWED_STRING_LIST A1 ON A0.STRING_LIST_ID_EID = A1.STRING_LIST_ID WHERE A0.SD_ID_OID = <3> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT 'org.apache.hadoop.hive.metastore.model.MStringList' AS DN_TYPE,A0.STRING_LIST_ID FROM SKEWED_STRING_LIST A0 INNER JOIN SKEWED_COL_VALUE_LOC_MAP B0 ON A0.STRING_LIST_ID = B0.STRING_LIST_ID_KID WHERE B0.SD_ID = <3> SELECT A0.STRING_LIST_ID_KID,A0.LOCATION FROM SKEWED_COL_VALUE_LOC_MAP A0 WHERE A0.SD_ID = <3> AND NOT (A0.STRING_LIST_ID_KID IS NULL) SELECT DISTINCT A0.ENGINE FROM PART_COL_STATS A0 WHERE A0."TABLE_NAME" = <'student'> AND A0.DB_NAME = <'default'> AND A0.CAT_NAME = <'hive'> SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS DN_TYPE,A0.CREATE_TIME,A0.TBL_ID,A0.LAST_ACCESS_TIME,A0.OWNER,A0.OWNER_TYPE,A0.RETENTION,A0.IS_REWRITE_ENABLED,A0.TBL_NAME,A0.TBL_TYPE,A0.WRITE_ID FROM TBLS A0 LEFT OUTER JOIN DBS B0 ON A0.DB_ID = B0.DB_ID WHERE A0.TBL_NAME = <'student'> AND B0."NAME" = <'default'> AND B0.CTLG_NAME = <'hive'> select "PARTITION_NAME", "COLUMN_NAME", "COLUMN_TYPE", "LONG_LOW_VALUE", "LONG_HIGH_VALUE", "DOUBLE_LOW_VALUE", "DOUBLE_HIGH_VALUE", "BIG_DECIMAL_LOW_VALUE", "BIG_DECIMAL_HIGH_VALUE", "NUM_NULLS", "NUM_DISTINCTS", "BIT_VECTOR", "AVG_COL_LEN", "MAX_COL_LEN", "NUM_TRUES", "NUM_FALSES", "LAST_ANALYZED" from "PART_COL_STATS" where "CAT_NAME" = <'hive'> and "DB_NAME" = <'default'> and "TABLE_NAME" = <'student'> and "COLUMN_NAME" in (<'fname'>,<'lname'>) AND "PARTITION_NAME" in (<'department=Computer Science'>) and "ENGINE" = <'hive'> order by "PARTITION_NAME" SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS DN_TYPE,A0.CREATE_TIME,A0.TBL_ID,A0.LAST_ACCESS_TIME,A0.OWNER,A0.OWNER_TYPE,A0.RETENTION,A0.IS_REWRITE_ENABLED,A0.TBL_NAME,A0.TBL_TYPE,A0.WRITE_ID FROM TBLS A0 LEFT OUTER JOIN DBS B0 ON A0.DB_ID = B0.DB_ID WHERE A0.TBL_NAME = <'student'> AND B0."NAME" = <'default'> AND B0.CTLG_NAME = <'hive'> SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MPartition' AS DN_TYPE,A0.CREATE_TIME,A0.LAST_ACCESS_TIME,A0.PART_NAME,A0.WRITE_ID,A0.PART_ID FROM PARTITIONS A0 LEFT OUTER JOIN TBLS B0 ON A0.TBL_ID = B0.TBL_ID LEFT OUTER JOIN DBS C0 ON B0.DB_ID = C0.DB_ID WHERE B0.TBL_NAME = <'student'> AND C0."NAME" = <'default'> AND A0.PART_NAME = <'department=Computer Science'> AND C0.CTLG_NAME = <'hive'> SELECT B0.INPUT_FORMAT,B0.IS_COMPRESSED,B0.IS_STOREDASSUBDIRECTORIES,B0.LOCATION,B0.NUM_BUCKETS,B0.OUTPUT_FORMAT,B0.SD_ID,C0.CREATE_TIME,C0.TBL_ID,C0.LAST_ACCESS_TIME,C0.OWNER,C0.OWNER_TYPE,C0.RETENTION,C0.IS_REWRITE_ENABLED,C0.TBL_NAME,C0.TBL_TYPE,C0.WRITE_ID FROM PARTITIONS A0 LEFT OUTER JOIN SDS B0 ON A0.SD_ID = B0.SD_ID LEFT OUTER JOIN TBLS C0 ON A0.TBL_ID = C0.TBL_ID WHERE A0.PART_ID = <1> SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM PARTITION_PARAMS A0 WHERE A0.PART_ID = <1> AND A0.PARAM_KEY IS NOT NULL SELECT A0.PART_KEY_VAL,A0.INTEGER_IDX AS NUCORDER0 FROM PARTITION_KEY_VALS A0 WHERE A0.PART_ID = <1> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MPartitionColumnStatistics' AS DN_TYPE,A0.AVG_COL_LEN,A0.CAT_NAME,A0."COLUMN_NAME",A0.COLUMN_TYPE,A0.DB_NAME,A0.BIG_DECIMAL_HIGH_VALUE,A0.BIG_DECIMAL_LOW_VALUE,A0.DOUBLE_HIGH_VALUE,A0.DOUBLE_LOW_VALUE,A0.ENGINE,A0.LAST_ANALYZED,A0.LONG_HIGH_VALUE,A0.LONG_LOW_VALUE,A0.MAX_COL_LEN,A0.NUM_DISTINCTS,A0.NUM_FALSES,A0.NUM_NULLS,A0.NUM_TRUES,A0.PARTITION_NAME,A0."TABLE_NAME",A0.CS_ID FROM PART_COL_STATS A0 LEFT OUTER JOIN PARTITIONS B0 ON A0.PART_ID = B0.PART_ID WHERE B0.PART_NAME = <'department=Computer Science'> AND A0.DB_NAME = <'default'> AND A0."TABLE_NAME" = <'student'> AND A0."COLUMN_NAME" = <'lname'> AND A0.CAT_NAME = <'hive'> AND A0.ENGINE = <'hive'> SELECT A0.BIT_VECTOR,B0.CREATE_TIME,B0.LAST_ACCESS_TIME,B0.PART_NAME,B0.WRITE_ID,B0.PART_ID FROM PART_COL_STATS A0 LEFT OUTER JOIN PARTITIONS B0 ON A0.PART_ID = B0.PART_ID WHERE A0.CS_ID = <2> SELECT B0.CREATE_TIME,B0.LAST_ACCESS_TIME,B0.PART_NAME,B0.WRITE_ID,B0.PART_ID FROM PART_COL_STATS A0 LEFT OUTER JOIN PARTITIONS B0 ON A0.PART_ID = B0.PART_ID WHERE A0.CS_ID = <2> BATCH [DELETE FROM PART_COL_STATS WHERE CS_ID=<2>] SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS DN_TYPE,A0.CREATE_TIME,A0.TBL_ID,A0.LAST_ACCESS_TIME,A0.OWNER,A0.OWNER_TYPE,A0.RETENTION,A0.IS_REWRITE_ENABLED,A0.TBL_NAME,A0.TBL_TYPE,A0.WRITE_ID FROM TBLS A0 LEFT OUTER JOIN DBS B0 ON A0.DB_ID = B0.DB_ID WHERE A0.TBL_NAME = <'student'> AND B0."NAME" = <'default'> AND B0.CTLG_NAME = <'hive'> SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MPartition' AS DN_TYPE,A0.CREATE_TIME,A0.LAST_ACCESS_TIME,A0.PART_NAME,A0.WRITE_ID,A0.PART_ID FROM PARTITIONS A0 LEFT OUTER JOIN TBLS B0 ON A0.TBL_ID = B0.TBL_ID LEFT OUTER JOIN DBS C0 ON B0.DB_ID = C0.DB_ID WHERE B0.TBL_NAME = <'student'> AND C0."NAME" = <'default'> AND A0.PART_NAME = <'department=Computer Science'> AND C0.CTLG_NAME = <'hive'> SELECT A0.PARAM_VALUE FROM PARTITION_PARAMS A0 WHERE A0.PART_ID = <1> AND A0.PARAM_KEY = <'COLUMN_STATS_ACCURATE'> UPDATE PARTITION_PARAMS SET PARAM_VALUE = <'{"BASIC_STATS":"true","COLUMN_STATS":{"fname":"true"}}'> WHERE PART_ID=<1> AND PARAM_KEY=<'COLUMN_STATS_ACCURATE'> SELECT 'org.apache.hadoop.hive.metastore.model.MConstraint' AS DN_TYPE,A0.CHILD_INTEGER_IDX,A0."CONSTRAINT_NAME",A0.CONSTRAINT_TYPE,A0.DEFAULT_VALUE,A0.DELETE_RULE,A0.ENABLE_VALIDATE_RELY,A0.PARENT_INTEGER_IDX,B0.CREATE_TIME,B0.TBL_ID,B0.LAST_ACCESS_TIME,B0.OWNER,B0.OWNER_TYPE,B0.RETENTION,B0.IS_REWRITE_ENABLED,B0.TBL_NAME,B0.TBL_TYPE,B0.WRITE_ID,A0."POSITION",A0.UPDATE_RULE FROM KEY_CONSTRAINTS A0 INNER JOIN TBLS B0 ON A0.PARENT_TBL_ID = B0.TBL_ID WHERE (A0.PARENT_CD_ID = <1>) OR (A0.CHILD_CD_ID = <1>) INSERT INTO CDS (CD_ID) VALUES (<2>) BATCH [INSERT INTO COLUMNS_V2 (CD_ID,COMMENT,"COLUMN_NAME",TYPE_NAME,INTEGER_IDX) VALUES (<2>,,<'fname'>,<'string'>,<0>) ; INSERT INTO COLUMNS_V2 (CD_ID,COMMENT,"COLUMN_NAME",TYPE_NAME,INTEGER_IDX) VALUES (<2>,,<'lastname'>,<'string'>,<1>) ] UPDATE SDS SET CD_ID=<2> WHERE SD_ID=<2> SELECT COUNT(1) FROM SDS A0 WHERE A0.CD_ID = <1> SELECT DISTINCT A0.ENGINE FROM PART_COL_STATS A0 WHERE A0."TABLE_NAME" = <'student'> AND A0.DB_NAME = <'default'> AND A0.CAT_NAME = <'hive'> SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS DN_TYPE,A0.CREATE_TIME,A0.TBL_ID,A0.LAST_ACCESS_TIME,A0.OWNER,A0.OWNER_TYPE,A0.RETENTION,A0.IS_REWRITE_ENABLED,A0.TBL_NAME,A0.TBL_TYPE,A0.WRITE_ID FROM TBLS A0 LEFT OUTER JOIN DBS B0 ON A0.DB_ID = B0.DB_ID WHERE A0.TBL_NAME = <'student'> AND B0."NAME" = <'default'> AND B0.CTLG_NAME = <'hive'> select "PARTITION_NAME", "COLUMN_NAME", "COLUMN_TYPE", "LONG_LOW_VALUE", "LONG_HIGH_VALUE", "DOUBLE_LOW_VALUE", "DOUBLE_HIGH_VALUE", "BIG_DECIMAL_LOW_VALUE", "BIG_DECIMAL_HIGH_VALUE", "NUM_NULLS", "NUM_DISTINCTS", "BIT_VECTOR", "AVG_COL_LEN", "MAX_COL_LEN", "NUM_TRUES", "NUM_FALSES", "LAST_ANALYZED" from "PART_COL_STATS" where "CAT_NAME" = <'hive'> and "DB_NAME" = <'default'> and "TABLE_NAME" = <'student'> and "COLUMN_NAME" in (<'fname'>,<'lname'>) AND "PARTITION_NAME" in (<'department=Physics'>) and "ENGINE" = <'hive'> order by "PARTITION_NAME" SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS DN_TYPE,A0.CREATE_TIME,A0.TBL_ID,A0.LAST_ACCESS_TIME,A0.OWNER,A0.OWNER_TYPE,A0.RETENTION,A0.IS_REWRITE_ENABLED,A0.TBL_NAME,A0.TBL_TYPE,A0.WRITE_ID FROM TBLS A0 LEFT OUTER JOIN DBS B0 ON A0.DB_ID = B0.DB_ID WHERE A0.TBL_NAME = <'student'> AND B0."NAME" = <'default'> AND B0.CTLG_NAME = <'hive'> SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MPartition' AS DN_TYPE,A0.CREATE_TIME,A0.LAST_ACCESS_TIME,A0.PART_NAME,A0.WRITE_ID,A0.PART_ID FROM PARTITIONS A0 LEFT OUTER JOIN TBLS B0 ON A0.TBL_ID = B0.TBL_ID LEFT OUTER JOIN DBS C0 ON B0.DB_ID = C0.DB_ID WHERE B0.TBL_NAME = <'student'> AND C0."NAME" = <'default'> AND A0.PART_NAME = <'department=Physics'> AND C0.CTLG_NAME = <'hive'> SELECT B0.INPUT_FORMAT,B0.IS_COMPRESSED,B0.IS_STOREDASSUBDIRECTORIES,B0.LOCATION,B0.NUM_BUCKETS,B0.OUTPUT_FORMAT,B0.SD_ID,C0.CREATE_TIME,C0.TBL_ID,C0.LAST_ACCESS_TIME,C0.OWNER,C0.OWNER_TYPE,C0.RETENTION,C0.IS_REWRITE_ENABLED,C0.TBL_NAME,C0.TBL_TYPE,C0.WRITE_ID FROM PARTITIONS A0 LEFT OUTER JOIN SDS B0 ON A0.SD_ID = B0.SD_ID LEFT OUTER JOIN TBLS C0 ON A0.TBL_ID = C0.TBL_ID WHERE A0.PART_ID = <2> SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM PARTITION_PARAMS A0 WHERE A0.PART_ID = <2> AND A0.PARAM_KEY IS NOT NULL SELECT A0.PART_KEY_VAL,A0.INTEGER_IDX AS NUCORDER0 FROM PARTITION_KEY_VALS A0 WHERE A0.PART_ID = <2> AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0 SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MPartitionColumnStatistics' AS DN_TYPE,A0.AVG_COL_LEN,A0.CAT_NAME,A0."COLUMN_NAME",A0.COLUMN_TYPE,A0.DB_NAME,A0.BIG_DECIMAL_HIGH_VALUE,A0.BIG_DECIMAL_LOW_VALUE,A0.DOUBLE_HIGH_VALUE,A0.DOUBLE_LOW_VALUE,A0.ENGINE,A0.LAST_ANALYZED,A0.LONG_HIGH_VALUE,A0.LONG_LOW_VALUE,A0.MAX_COL_LEN,A0.NUM_DISTINCTS,A0.NUM_FALSES,A0.NUM_NULLS,A0.NUM_TRUES,A0.PARTITION_NAME,A0."TABLE_NAME",A0.CS_ID FROM PART_COL_STATS A0 LEFT OUTER JOIN PARTITIONS B0 ON A0.PART_ID = B0.PART_ID WHERE B0.PART_NAME = <'department=Physics'> AND A0.DB_NAME = <'default'> AND A0."TABLE_NAME" = <'student'> AND A0."COLUMN_NAME" = <'lname'> AND A0.CAT_NAME = <'hive'> AND A0.ENGINE = <'hive'> SELECT A0.BIT_VECTOR,B0.CREATE_TIME,B0.LAST_ACCESS_TIME,B0.PART_NAME,B0.WRITE_ID,B0.PART_ID FROM PART_COL_STATS A0 LEFT OUTER JOIN PARTITIONS B0 ON A0.PART_ID = B0.PART_ID WHERE A0.CS_ID = <5> SELECT B0.CREATE_TIME,B0.LAST_ACCESS_TIME,B0.PART_NAME,B0.WRITE_ID,B0.PART_ID FROM PART_COL_STATS A0 LEFT OUTER JOIN PARTITIONS B0 ON A0.PART_ID = B0.PART_ID WHERE A0.CS_ID = <5> BATCH [DELETE FROM PART_COL_STATS WHERE CS_ID=<5>] SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS DN_TYPE,A0.CREATE_TIME,A0.TBL_ID,A0.LAST_ACCESS_TIME,A0.OWNER,A0.OWNER_TYPE,A0.RETENTION,A0.IS_REWRITE_ENABLED,A0.TBL_NAME,A0.TBL_TYPE,A0.WRITE_ID FROM TBLS A0 LEFT OUTER JOIN DBS B0 ON A0.DB_ID = B0.DB_ID WHERE A0.TBL_NAME = <'student'> AND B0."NAME" = <'default'> AND B0.CTLG_NAME = <'hive'> SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MPartition' AS DN_TYPE,A0.CREATE_TIME,A0.LAST_ACCESS_TIME,A0.PART_NAME,A0.WRITE_ID,A0.PART_ID FROM PARTITIONS A0 LEFT OUTER JOIN TBLS B0 ON A0.TBL_ID = B0.TBL_ID LEFT OUTER JOIN DBS C0 ON B0.DB_ID = C0.DB_ID WHERE B0.TBL_NAME = <'student'> AND C0."NAME" = <'default'> AND A0.PART_NAME = <'department=Physics'> AND C0.CTLG_NAME = <'hive'> SELECT A0.PARAM_VALUE FROM PARTITION_PARAMS A0 WHERE A0.PART_ID = <2> AND A0.PARAM_KEY = <'COLUMN_STATS_ACCURATE'> UPDATE PARTITION_PARAMS SET PARAM_VALUE = <'{"BASIC_STATS":"true","COLUMN_STATS":{"fname":"true"}}'> WHERE PART_ID=<2> AND PARAM_KEY=<'COLUMN_STATS_ACCURATE'> SELECT 'org.apache.hadoop.hive.metastore.model.MConstraint' AS DN_TYPE,A0.CHILD_INTEGER_IDX,A0."CONSTRAINT_NAME",A0.CONSTRAINT_TYPE,A0.DEFAULT_VALUE,A0.DELETE_RULE,A0.ENABLE_VALIDATE_RELY,A0.PARENT_INTEGER_IDX,B0.CREATE_TIME,B0.TBL_ID,B0.LAST_ACCESS_TIME,B0.OWNER,B0.OWNER_TYPE,B0.RETENTION,B0.IS_REWRITE_ENABLED,B0.TBL_NAME,B0.TBL_TYPE,B0.WRITE_ID,A0."POSITION",A0.UPDATE_RULE FROM KEY_CONSTRAINTS A0 INNER JOIN TBLS B0 ON A0.PARENT_TBL_ID = B0.TBL_ID WHERE (A0.PARENT_CD_ID = <1>) OR (A0.CHILD_CD_ID = <1>) INSERT INTO CDS (CD_ID) VALUES (<3>) BATCH [INSERT INTO COLUMNS_V2 (CD_ID,COMMENT,"COLUMN_NAME",TYPE_NAME,INTEGER_IDX) VALUES (<3>,,<'fname'>,<'string'>,<0>) ; INSERT INTO COLUMNS_V2 (CD_ID,COMMENT,"COLUMN_NAME",TYPE_NAME,INTEGER_IDX) VALUES (<3>,,<'lastname'>,<'string'>,<1>) ] UPDATE SDS SET CD_ID=<3> WHERE SD_ID=<3> SELECT COUNT(1) FROM SDS A0 WHERE A0.CD_ID = <1> SELECT 'org.apache.hadoop.hive.metastore.model.MDatabase' AS DN_TYPE,A0.CTLG_NAME,A0.DATACONNECTOR_NAME,A0.CREATE_TIME,A0."DESC",A0.DB_LOCATION_URI,A0.DB_MANAGED_LOCATION_URI,A0."NAME",A0.OWNER_NAME,A0.OWNER_TYPE,A0.REMOTE_DBNAME,A0."TYPE",A0.DB_ID FROM DBS A0 WHERE A0."NAME" = <'default'> AND A0.CTLG_NAME = <'hive'> SELECT A0.PARAM_KEY,A0.PARAM_VALUE FROM DATABASE_PARAMS A0 WHERE A0.DB_ID = <1> AND A0.PARAM_KEY IS NOT NULL SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MTable' AS DN_TYPE,A0.CREATE_TIME,A0.TBL_ID,A0.LAST_ACCESS_TIME,A0.OWNER,A0.OWNER_TYPE,A0.RETENTION,A0.IS_REWRITE_ENABLED,A0.TBL_NAME,A0.TBL_TYPE,A0.WRITE_ID FROM TBLS A0 LEFT OUTER JOIN DBS B0 ON A0.DB_ID = B0.DB_ID WHERE A0.TBL_NAME = <'student'> AND B0."NAME" = <'default'> AND B0.CTLG_NAME = <'hive'> SELECT A0.PARAM_VALUE FROM TABLE_PARAMS A0 WHERE A0.TBL_ID = <1> AND A0.PARAM_KEY = <'transient_lastDdlTime'> UPDATE TABLE_PARAMS SET PARAM_VALUE = <'1657726135'> WHERE TBL_ID=<1> AND PARAM_KEY=<'transient_lastDdlTime'> SELECT A0.PARAM_VALUE FROM TABLE_PARAMS A0 WHERE A0.TBL_ID = <1> AND A0.PARAM_KEY = <'last_modified_by'> INSERT INTO TABLE_PARAMS (PARAM_VALUE,TBL_ID,PARAM_KEY) VALUES (<'hive_test_user'>,<1>,<'last_modified_by'>) SELECT A0.PARAM_VALUE FROM TABLE_PARAMS A0 WHERE A0.TBL_ID = <1> AND A0.PARAM_KEY = <'last_modified_time'> INSERT INTO TABLE_PARAMS (PARAM_VALUE,TBL_ID,PARAM_KEY) VALUES (<'1657726135'>,<1>,<'last_modified_time'>) SELECT 'org.apache.hadoop.hive.metastore.model.MConstraint' AS DN_TYPE,A0.CHILD_INTEGER_IDX,A0."CONSTRAINT_NAME",A0.CONSTRAINT_TYPE,A0.DEFAULT_VALUE,A0.DELETE_RULE,A0.ENABLE_VALIDATE_RELY,A0.PARENT_INTEGER_IDX,B0.CREATE_TIME,B0.TBL_ID,B0.LAST_ACCESS_TIME,B0.OWNER,B0.OWNER_TYPE,B0.RETENTION,B0.IS_REWRITE_ENABLED,B0.TBL_NAME,B0.TBL_TYPE,B0.WRITE_ID,A0."POSITION",A0.UPDATE_RULE FROM KEY_CONSTRAINTS A0 INNER JOIN TBLS B0 ON A0.PARENT_TBL_ID = B0.TBL_ID WHERE (A0.PARENT_CD_ID = <1>) OR (A0.CHILD_CD_ID = <1>) INSERT INTO CDS (CD_ID) VALUES (<4>) BATCH [INSERT INTO COLUMNS_V2 (CD_ID,COMMENT,"COLUMN_NAME",TYPE_NAME,INTEGER_IDX) VALUES (<4>,,<'fname'>,<'string'>,<0>) ; INSERT INTO COLUMNS_V2 (CD_ID,COMMENT,"COLUMN_NAME",TYPE_NAME,INTEGER_IDX) VALUES (<4>,,<'lastname'>,<'string'>,<1>) ] UPDATE SDS SET CD_ID=<4> WHERE SD_ID=<1> SELECT COUNT(1) FROM SDS A0 WHERE A0.CD_ID = <1> SELECT 'org.apache.hadoop.hive.metastore.model.MConstraint' AS DN_TYPE,A0.CHILD_INTEGER_IDX,A0."CONSTRAINT_NAME",A0.CONSTRAINT_TYPE,A0.DEFAULT_VALUE,A0.DELETE_RULE,A0.ENABLE_VALIDATE_RELY,A0.PARENT_INTEGER_IDX,B0.CREATE_TIME,B0.TBL_ID,B0.LAST_ACCESS_TIME,B0.OWNER,B0.OWNER_TYPE,B0.RETENTION,B0.IS_REWRITE_ENABLED,B0.TBL_NAME,B0.TBL_TYPE,B0.WRITE_ID,A0."POSITION",A0.UPDATE_RULE FROM KEY_CONSTRAINTS A0 INNER JOIN TBLS B0 ON A0.PARENT_TBL_ID = B0.TBL_ID WHERE (A0.PARENT_CD_ID = <1>) OR (A0.CHILD_CD_ID = <1>) DELETE FROM COLUMNS_V2 WHERE CD_ID=<1> BATCH [DELETE FROM CDS WHERE CD_ID=<1>] DELETE FROM PARTITION_KEYS WHERE TBL_ID=<1> INSERT INTO PARTITION_KEYS (TBL_ID,PKEY_COMMENT,PKEY_NAME,PKEY_TYPE,INTEGER_IDX) VALUES (<1>,,<'department'>,<'string'>,<0>)