PREHOOK: query: DROP TABLE IF EXISTS test1 PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS test1 POSTHOOK: type: DROPTABLE PREHOOK: query: DROP TABLE IF EXISTS test2 PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS test2 POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE test1(name string, age int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@test1 POSTHOOK: query: CREATE TABLE test1(name string, age int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@test1 PREHOOK: query: CREATE TABLE test2(name string) PARTITIONED by (age int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@test2 POSTHOOK: query: CREATE TABLE test2(name string) PARTITIONED by (age int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@test2 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/test1.txt' INTO TABLE test1 PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@test1 POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/test1.txt' INTO TABLE test1 POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@test1 PREHOOK: query: FROM test1 INSERT OVERWRITE TABLE test2 PARTITION(age) SELECT test1.name, test1.age PREHOOK: type: QUERY PREHOOK: Input: default@test1 PREHOOK: Output: default@test2 POSTHOOK: query: FROM test1 INSERT OVERWRITE TABLE test2 PARTITION(age) SELECT test1.name, test1.age POSTHOOK: type: QUERY POSTHOOK: Input: default@test1 POSTHOOK: Output: default@test2@age=15 POSTHOOK: Output: default@test2@age=30 POSTHOOK: Output: default@test2@age=40 POSTHOOK: Output: default@test2@age=__HIVE_DEFAULT_PARTITION__ POSTHOOK: Lineage: test2 PARTITION(age=15).name SIMPLE [(test1)test1.FieldSchema(name:name, type:string, comment:null), ] POSTHOOK: Lineage: test2 PARTITION(age=30).name SIMPLE [(test1)test1.FieldSchema(name:name, type:string, comment:null), ] POSTHOOK: Lineage: test2 PARTITION(age=40).name SIMPLE [(test1)test1.FieldSchema(name:name, type:string, comment:null), ] POSTHOOK: Lineage: test2 PARTITION(age=__HIVE_DEFAULT_PARTITION__).name SIMPLE [(test1)test1.FieldSchema(name:name, type:string, comment:null), ] PREHOOK: query: ANALYZE TABLE test2 PARTITION(age) COMPUTE STATISTICS PREHOOK: type: QUERY PREHOOK: Input: default@test2 PREHOOK: Input: default@test2@age=15 PREHOOK: Input: default@test2@age=30 PREHOOK: Input: default@test2@age=40 PREHOOK: Input: default@test2@age=__HIVE_DEFAULT_PARTITION__ PREHOOK: Output: default@test2 PREHOOK: Output: default@test2@age=15 PREHOOK: Output: default@test2@age=30 PREHOOK: Output: default@test2@age=40 PREHOOK: Output: default@test2@age=__HIVE_DEFAULT_PARTITION__ POSTHOOK: query: ANALYZE TABLE test2 PARTITION(age) COMPUTE STATISTICS POSTHOOK: type: QUERY POSTHOOK: Input: default@test2 POSTHOOK: Input: default@test2@age=15 POSTHOOK: Input: default@test2@age=30 POSTHOOK: Input: default@test2@age=40 POSTHOOK: Input: default@test2@age=__HIVE_DEFAULT_PARTITION__ POSTHOOK: Output: default@test2 POSTHOOK: Output: default@test2@age=15 POSTHOOK: Output: default@test2@age=30 POSTHOOK: Output: default@test2@age=40 POSTHOOK: Output: default@test2@age=__HIVE_DEFAULT_PARTITION__ PREHOOK: query: -- To show stats. It doesn't show due to a bug. DESC EXTENDED test2 PREHOOK: type: DESCTABLE PREHOOK: Input: default@test2 POSTHOOK: query: -- To show stats. It doesn't show due to a bug. DESC EXTENDED test2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@test2 name string age int # Partition Information # col_name data_type comment age int #### A masked pattern was here #### PREHOOK: query: -- Another way to show stats. EXPLAIN EXTENDED select * from test2 PREHOOK: type: QUERY POSTHOOK: query: -- Another way to show stats. EXPLAIN EXTENDED select * from test2 POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: TOK_QUERY TOK_FROM TOK_TABREF TOK_TABNAME test2 TOK_INSERT TOK_DESTINATION TOK_DIR TOK_TMP_FILE TOK_SELECT TOK_SELEXPR TOK_ALLCOLREF STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Fetch Operator limit: -1 Partition Description: Partition input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat partition values: age 15 properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns name columns.comments columns.types string #### A masked pattern was here #### name default.test2 numFiles 1 numRows 1 partition_columns age partition_columns.types int rawDataSize 3 serialization.ddl struct test2 { string name} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 4 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 columns name columns.comments columns.types string #### A masked pattern was here #### name default.test2 partition_columns age partition_columns.types int serialization.ddl struct test2 { string name} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.test2 name: default.test2 Partition input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat partition values: age 30 properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns name columns.comments columns.types string #### A masked pattern was here #### name default.test2 numFiles 1 numRows 1 partition_columns age partition_columns.types int rawDataSize 0 serialization.ddl struct test2 { string name} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 1 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 columns name columns.comments columns.types string #### A masked pattern was here #### name default.test2 partition_columns age partition_columns.types int serialization.ddl struct test2 { string name} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.test2 name: default.test2 Partition input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat partition values: age 40 properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns name columns.comments columns.types string #### A masked pattern was here #### name default.test2 numFiles 1 numRows 1 partition_columns age partition_columns.types int rawDataSize 4 serialization.ddl struct test2 { string name} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 5 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 columns name columns.comments columns.types string #### A masked pattern was here #### name default.test2 partition_columns age partition_columns.types int serialization.ddl struct test2 { string name} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.test2 name: default.test2 Partition input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat partition values: age __HIVE_DEFAULT_PARTITION__ properties: COLUMN_STATS_ACCURATE true bucket_count -1 columns name columns.comments columns.types string #### A masked pattern was here #### name default.test2 numFiles 1 numRows 2 partition_columns age partition_columns.types int rawDataSize 4 serialization.ddl struct test2 { string name} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe totalSize 6 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 columns name columns.comments columns.types string #### A masked pattern was here #### name default.test2 partition_columns age partition_columns.types int serialization.ddl struct test2 { string name} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.test2 name: default.test2 Processor Tree: TableScan alias: test2 Statistics: Num rows: 5 Data size: 111 Basic stats: COMPLETE Column stats: NONE GatherStats: false Select Operator expressions: name (type: string), age (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 5 Data size: 111 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: DROP TABLE test1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@test1 PREHOOK: Output: default@test1 POSTHOOK: query: DROP TABLE test1 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@test1 POSTHOOK: Output: default@test1 PREHOOK: query: DROP TABLE test2 PREHOOK: type: DROPTABLE PREHOOK: Input: default@test2 PREHOOK: Output: default@test2 POSTHOOK: query: DROP TABLE test2 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@test2 POSTHOOK: Output: default@test2