CREATE TABLE `default`.`orders`( `id` int, `cid` int, `d` date, `amount` double) ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' LOCATION 'hdfs://harshitguptahive-2.harshitguptahive.root.hwx.site:8020/warehouse/tablespace/managed/hive/orders' TBLPROPERTIES ( 'bucketing_version'='2', 'transactional'='true', 'transactional_properties'='default', 'transient_lastDdlTime'='1615088565'); CREATE TABLE `default`.`customers`( `id` int, `name` varchar(10), `age` int) ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' LOCATION 'hdfs://harshitguptahive-2.harshitguptahive.root.hwx.site:8020/warehouse/tablespace/managed/hive/customers' TBLPROPERTIES ( 'bucketing_version'='2', 'transactional'='true', 'transactional_properties'='default', 'transient_lastDdlTime'='1615088562'); ALTER TABLE default.orders UPDATE STATISTICS SET('numRows'='8','rawDataSize'='0' ); ALTER TABLE default.customers UPDATE STATISTICS SET('numRows'='3','rawDataSize'='0' ); ALTER TABLE default.orders UPDATE STATISTICS FOR COLUMN id SET('lowValue'='1','highValue'='8','numNulls'='0','numDVs'='8' ); ALTER TABLE default.orders UPDATE STATISTICS FOR COLUMN cid SET('lowValue'='1','highValue'='3','numNulls'='0','numDVs'='3' ); ALTER TABLE default.orders UPDATE STATISTICS FOR COLUMN d SET('lowValue'='15877','highValue'='16450','numNulls'='0','numDVs'='7' ); ALTER TABLE default.orders UPDATE STATISTICS FOR COLUMN amount SET('numNulls'='0','numDVs'='7','highValue'='210.03','lowValue'='3.65' ); ALTER TABLE default.customers UPDATE STATISTICS FOR COLUMN id SET('lowValue'='1','highValue'='3','numNulls'='0','numDVs'='3' ); ALTER TABLE default.customers UPDATE STATISTICS FOR COLUMN name SET('avgColLen'='5.0','maxColLen'='6','numNulls'='0','numDVs'='3' ); ALTER TABLE default.customers UPDATE STATISTICS FOR COLUMN age SET('lowValue'='20','highValue'='30','numNulls'='0','numDVs'='3' );