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>