http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/extrapolate_part_stats_partial_ndv.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/extrapolate_part_stats_partial_ndv.q.out b/ql/src/test/results/clientpositive/extrapolate_part_stats_partial_ndv.q.out deleted file mode 100644 index 96ff748..0000000 --- a/ql/src/test/results/clientpositive/extrapolate_part_stats_partial_ndv.q.out +++ /dev/null @@ -1,1307 +0,0 @@ -PREHOOK: query: drop table if exists ext_loc -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table if exists ext_loc -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table ext_loc ( - state string, - locid double, - cnt decimal, - zip int, - year string -) row format delimited fields terminated by '|' stored as textfile -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@ext_loc -POSTHOOK: query: create table ext_loc ( - state string, - locid double, - cnt decimal, - zip int, - year string -) row format delimited fields terminated by '|' stored as textfile -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@ext_loc -PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/extrapolate_stats_partial_ndv.txt' OVERWRITE INTO TABLE ext_loc -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@ext_loc -POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/extrapolate_stats_partial_ndv.txt' OVERWRITE INTO TABLE ext_loc -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@ext_loc -PREHOOK: query: drop table if exists loc_orc_1d -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table if exists loc_orc_1d -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table loc_orc_1d ( - state string, - locid double, - cnt decimal, - zip int -) partitioned by(year string) stored as orc -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@loc_orc_1d -POSTHOOK: query: create table loc_orc_1d ( - state string, - locid double, - cnt decimal, - zip int -) partitioned by(year string) stored as orc -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@loc_orc_1d -PREHOOK: query: insert overwrite table loc_orc_1d partition(year) select * from ext_loc -PREHOOK: type: QUERY -PREHOOK: Input: default@ext_loc -PREHOOK: Output: default@loc_orc_1d -POSTHOOK: query: insert overwrite table loc_orc_1d partition(year) select * from ext_loc -POSTHOOK: type: QUERY -POSTHOOK: Input: default@ext_loc -POSTHOOK: Output: default@loc_orc_1d@year=2000 -POSTHOOK: Output: default@loc_orc_1d@year=2001 -POSTHOOK: Output: default@loc_orc_1d@year=2002 -POSTHOOK: Output: default@loc_orc_1d@year=2003 -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2000).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2000).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2000).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2000).zip SIMPLE [(ext_loc)ext_loc.FieldSchema(name:zip, type:int, comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2001).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2001).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2001).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2001).zip SIMPLE [(ext_loc)ext_loc.FieldSchema(name:zip, type:int, comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2002).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2002).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2002).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2002).zip SIMPLE [(ext_loc)ext_loc.FieldSchema(name:zip, type:int, comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2003).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2003).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2003).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_1d PARTITION(year=2003).zip SIMPLE [(ext_loc)ext_loc.FieldSchema(name:zip, type:int, comment:null), ] -PREHOOK: query: analyze table loc_orc_1d partition(year='2001') compute statistics for columns state,locid,cnt,zip -PREHOOK: type: QUERY -PREHOOK: Input: default@loc_orc_1d -PREHOOK: Input: default@loc_orc_1d@year=2001 -#### A masked pattern was here #### -POSTHOOK: query: analyze table loc_orc_1d partition(year='2001') compute statistics for columns state,locid,cnt,zip -POSTHOOK: type: QUERY -POSTHOOK: Input: default@loc_orc_1d -POSTHOOK: Input: default@loc_orc_1d@year=2001 -#### A masked pattern was here #### -PREHOOK: query: analyze table loc_orc_1d partition(year='2002') compute statistics for columns state,locid,cnt,zip -PREHOOK: type: QUERY -PREHOOK: Input: default@loc_orc_1d -PREHOOK: Input: default@loc_orc_1d@year=2002 -#### A masked pattern was here #### -POSTHOOK: query: analyze table loc_orc_1d partition(year='2002') compute statistics for columns state,locid,cnt,zip -POSTHOOK: type: QUERY -POSTHOOK: Input: default@loc_orc_1d -POSTHOOK: Input: default@loc_orc_1d@year=2002 -#### A masked pattern was here #### -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2001') state -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2001') state -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -state string 0 3 0.75 2 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2002') state -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2002') state -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -state string 0 6 3.0 3 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2001') locid -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2001') locid -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -locid double 1.0 4.0 0 5 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2002') locid -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2002') locid -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -locid double 1.0 5.0 0 6 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2001') cnt -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2001') cnt -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -cnt decimal(10,0) 10 2000 0 5 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2002') cnt -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2002') cnt -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -cnt decimal(10,0) 10 910 0 4 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2001') zip -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2001') zip -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -zip int 43201 94087 0 4 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2002') zip -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2002') zip -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -zip int 43201 94087 0 4 from deserializer -PREHOOK: query: explain extended select state,locid,cnt,zip from loc_orc_1d -PREHOOK: type: QUERY -POSTHOOK: query: explain extended select state,locid,cnt,zip from loc_orc_1d -POSTHOOK: type: QUERY -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.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2000 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - numFiles 1 - numRows 2 - partition_columns year - partition_columns.types string - rawDataSize 416 - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 531 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - partition_columns year - partition_columns.types string - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_1d - name: default.loc_orc_1d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2001 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"cnt":"true","locid":"true","state":"true","zip":"true"}} - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - numFiles 1 - numRows 4 - partition_columns year - partition_columns.types string - rawDataSize 832 - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 562 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - partition_columns year - partition_columns.types string - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_1d - name: default.loc_orc_1d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2002 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"cnt":"true","locid":"true","state":"true","zip":"true"}} - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - numFiles 1 - numRows 6 - partition_columns year - partition_columns.types string - rawDataSize 1266 - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 580 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - partition_columns year - partition_columns.types string - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_1d - name: default.loc_orc_1d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2003 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - numFiles 1 - numRows 8 - partition_columns year - partition_columns.types string - rawDataSize 1672 - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 602 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - partition_columns year - partition_columns.types string - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_1d - name: default.loc_orc_1d - Processor Tree: - TableScan - alias: loc_orc_1d - Statistics: Num rows: 20 Data size: 4260 Basic stats: COMPLETE Column stats: PARTIAL - GatherStats: false - Select Operator - expressions: state (type: string), locid (type: double), cnt (type: decimal(10,0)), zip (type: int) - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 20 Data size: 4260 Basic stats: COMPLETE Column stats: PARTIAL - ListSink - -PREHOOK: query: analyze table loc_orc_1d partition(year='2000') compute statistics for columns state,locid,cnt,zip -PREHOOK: type: QUERY -PREHOOK: Input: default@loc_orc_1d -PREHOOK: Input: default@loc_orc_1d@year=2000 -#### A masked pattern was here #### -POSTHOOK: query: analyze table loc_orc_1d partition(year='2000') compute statistics for columns state,locid,cnt,zip -POSTHOOK: type: QUERY -POSTHOOK: Input: default@loc_orc_1d -POSTHOOK: Input: default@loc_orc_1d@year=2000 -#### A masked pattern was here #### -PREHOOK: query: analyze table loc_orc_1d partition(year='2003') compute statistics for columns state,locid,cnt,zip -PREHOOK: type: QUERY -PREHOOK: Input: default@loc_orc_1d -PREHOOK: Input: default@loc_orc_1d@year=2003 -#### A masked pattern was here #### -POSTHOOK: query: analyze table loc_orc_1d partition(year='2003') compute statistics for columns state,locid,cnt,zip -POSTHOOK: type: QUERY -POSTHOOK: Input: default@loc_orc_1d -POSTHOOK: Input: default@loc_orc_1d@year=2003 -#### A masked pattern was here #### -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2000') state -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2000') state -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -state string 0 2 0.5 1 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2003') state -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2003') state -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -state string 0 4 1.25 4 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2000') locid -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2000') locid -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -locid double 1.0 2.0 0 2 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2003') locid -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2003') locid -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -locid double 1.0 31.0 0 6 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2000') cnt -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2000') cnt -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -cnt decimal(10,0) 1000 1010 0 3 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2003') cnt -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2003') cnt -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -cnt decimal(10,0) 1000 2000 0 3 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2000') zip -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2000') zip -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -zip int 94086 94087 0 2 from deserializer -PREHOOK: query: describe formatted loc_orc_1d PARTITION(year='2003') zip -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_1d -POSTHOOK: query: describe formatted loc_orc_1d PARTITION(year='2003') zip -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_1d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -zip int 43201 94087 0 4 from deserializer -PREHOOK: query: explain extended select state,locid,cnt,zip from loc_orc_1d -PREHOOK: type: QUERY -POSTHOOK: query: explain extended select state,locid,cnt,zip from loc_orc_1d -POSTHOOK: type: QUERY -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.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2000 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"cnt":"true","locid":"true","state":"true","zip":"true"}} - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - numFiles 1 - numRows 2 - partition_columns year - partition_columns.types string - rawDataSize 416 - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 531 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - partition_columns year - partition_columns.types string - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_1d - name: default.loc_orc_1d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2001 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"cnt":"true","locid":"true","state":"true","zip":"true"}} - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - numFiles 1 - numRows 4 - partition_columns year - partition_columns.types string - rawDataSize 832 - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 562 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - partition_columns year - partition_columns.types string - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_1d - name: default.loc_orc_1d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2002 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"cnt":"true","locid":"true","state":"true","zip":"true"}} - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - numFiles 1 - numRows 6 - partition_columns year - partition_columns.types string - rawDataSize 1266 - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 580 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - partition_columns year - partition_columns.types string - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_1d - name: default.loc_orc_1d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2003 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"cnt":"true","locid":"true","state":"true","zip":"true"}} - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - numFiles 1 - numRows 8 - partition_columns year - partition_columns.types string - rawDataSize 1672 - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 602 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt,zip - columns.comments - columns.types string:double:decimal(10,0):int -#### A masked pattern was here #### - name default.loc_orc_1d - partition_columns year - partition_columns.types string - serialization.ddl struct loc_orc_1d { string state, double locid, decimal(10,0) cnt, i32 zip} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_1d - name: default.loc_orc_1d - Processor Tree: - TableScan - alias: loc_orc_1d - Statistics: Num rows: 20 Data size: 4220 Basic stats: COMPLETE Column stats: COMPLETE - GatherStats: false - Select Operator - expressions: state (type: string), locid (type: double), cnt (type: decimal(10,0)), zip (type: int) - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 20 Data size: 4220 Basic stats: COMPLETE Column stats: COMPLETE - ListSink - -PREHOOK: query: drop table if exists loc_orc_2d -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table if exists loc_orc_2d -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table loc_orc_2d ( - state string, - locid int, - cnt decimal -) partitioned by(zip int, year string) stored as orc -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@loc_orc_2d -POSTHOOK: query: create table loc_orc_2d ( - state string, - locid int, - cnt decimal -) partitioned by(zip int, year string) stored as orc -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@loc_orc_2d -PREHOOK: query: insert overwrite table loc_orc_2d partition(zip, year) select * from ext_loc -PREHOOK: type: QUERY -PREHOOK: Input: default@ext_loc -PREHOOK: Output: default@loc_orc_2d -POSTHOOK: query: insert overwrite table loc_orc_2d partition(zip, year) select * from ext_loc -POSTHOOK: type: QUERY -POSTHOOK: Input: default@ext_loc -POSTHOOK: Output: default@loc_orc_2d@zip=43201/year=2001 -POSTHOOK: Output: default@loc_orc_2d@zip=43201/year=2002 -POSTHOOK: Output: default@loc_orc_2d@zip=43201/year=2003 -POSTHOOK: Output: default@loc_orc_2d@zip=94086/year=2000 -POSTHOOK: Output: default@loc_orc_2d@zip=94086/year=2001 -POSTHOOK: Output: default@loc_orc_2d@zip=94086/year=2002 -POSTHOOK: Output: default@loc_orc_2d@zip=94086/year=2003 -POSTHOOK: Output: default@loc_orc_2d@zip=94087/year=2000 -POSTHOOK: Output: default@loc_orc_2d@zip=94087/year=2001 -POSTHOOK: Output: default@loc_orc_2d@zip=94087/year=2002 -POSTHOOK: Output: default@loc_orc_2d@zip=94087/year=2003 -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=43201,year=2001).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=43201,year=2001).locid EXPRESSION [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=43201,year=2001).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=43201,year=2002).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=43201,year=2002).locid EXPRESSION [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=43201,year=2002).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=43201,year=2003).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=43201,year=2003).locid EXPRESSION [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=43201,year=2003).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94086,year=2000).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94086,year=2000).locid EXPRESSION [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94086,year=2000).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94086,year=2001).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94086,year=2001).locid EXPRESSION [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94086,year=2001).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94086,year=2002).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94086,year=2002).locid EXPRESSION [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94086,year=2002).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94086,year=2003).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94086,year=2003).locid EXPRESSION [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94086,year=2003).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94087,year=2000).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94087,year=2000).locid EXPRESSION [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94087,year=2000).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94087,year=2001).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94087,year=2001).locid EXPRESSION [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94087,year=2001).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94087,year=2002).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94087,year=2002).locid EXPRESSION [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94087,year=2002).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94087,year=2003).cnt SIMPLE [(ext_loc)ext_loc.FieldSchema(name:cnt, type:decimal(10,0), comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94087,year=2003).locid EXPRESSION [(ext_loc)ext_loc.FieldSchema(name:locid, type:double, comment:null), ] -POSTHOOK: Lineage: loc_orc_2d PARTITION(zip=94087,year=2003).state SIMPLE [(ext_loc)ext_loc.FieldSchema(name:state, type:string, comment:null), ] -PREHOOK: query: analyze table loc_orc_2d partition(zip=94086, year='2001') compute statistics for columns state,locid,cnt -PREHOOK: type: QUERY -PREHOOK: Input: default@loc_orc_2d -PREHOOK: Input: default@loc_orc_2d@zip=94086/year=2001 -#### A masked pattern was here #### -POSTHOOK: query: analyze table loc_orc_2d partition(zip=94086, year='2001') compute statistics for columns state,locid,cnt -POSTHOOK: type: QUERY -POSTHOOK: Input: default@loc_orc_2d -POSTHOOK: Input: default@loc_orc_2d@zip=94086/year=2001 -#### A masked pattern was here #### -PREHOOK: query: analyze table loc_orc_2d partition(zip=94087, year='2002') compute statistics for columns state,locid,cnt -PREHOOK: type: QUERY -PREHOOK: Input: default@loc_orc_2d -PREHOOK: Input: default@loc_orc_2d@zip=94087/year=2002 -#### A masked pattern was here #### -POSTHOOK: query: analyze table loc_orc_2d partition(zip=94087, year='2002') compute statistics for columns state,locid,cnt -POSTHOOK: type: QUERY -POSTHOOK: Input: default@loc_orc_2d -POSTHOOK: Input: default@loc_orc_2d@zip=94087/year=2002 -#### A masked pattern was here #### -PREHOOK: query: describe formatted loc_orc_2d partition(zip=94086, year='2001') state -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_2d -POSTHOOK: query: describe formatted loc_orc_2d partition(zip=94086, year='2001') state -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_2d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -state string 0 2 0.5 1 from deserializer -PREHOOK: query: describe formatted loc_orc_2d partition(zip=94087, year='2002') state -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_2d -POSTHOOK: query: describe formatted loc_orc_2d partition(zip=94087, year='2002') state -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_2d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -state string 0 4 3.0 3 from deserializer -PREHOOK: query: describe formatted loc_orc_2d partition(zip=94086, year='2001') locid -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_2d -POSTHOOK: query: describe formatted loc_orc_2d partition(zip=94086, year='2001') locid -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_2d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -locid int 2 3 0 2 from deserializer -PREHOOK: query: describe formatted loc_orc_2d partition(zip=94087, year='2002') locid -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_2d -POSTHOOK: query: describe formatted loc_orc_2d partition(zip=94087, year='2002') locid -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_2d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -locid int 1 5 0 3 from deserializer -PREHOOK: query: describe formatted loc_orc_2d partition(zip=94086, year='2001') cnt -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_2d -POSTHOOK: query: describe formatted loc_orc_2d partition(zip=94086, year='2001') cnt -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_2d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -cnt decimal(10,0) 1000 2000 0 2 from deserializer -PREHOOK: query: describe formatted loc_orc_2d partition(zip=94087, year='2002') cnt -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@loc_orc_2d -POSTHOOK: query: describe formatted loc_orc_2d partition(zip=94087, year='2002') cnt -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@loc_orc_2d -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -cnt decimal(10,0) 10 100 0 2 from deserializer -PREHOOK: query: explain extended select state,locid,cnt,zip from loc_orc_2d -PREHOOK: type: QUERY -POSTHOOK: query: explain extended select state,locid,cnt,zip from loc_orc_2d -POSTHOOK: type: QUERY -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.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2001 - zip 43201 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - numFiles 1 - numRows 1 - partition_columns zip/year - partition_columns.types int:string - rawDataSize 202 - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 386 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - partition_columns zip/year - partition_columns.types int:string - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_2d - name: default.loc_orc_2d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2002 - zip 43201 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - numFiles 1 - numRows 2 - partition_columns zip/year - partition_columns.types int:string - rawDataSize 406 - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 409 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - partition_columns zip/year - partition_columns.types int:string - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_2d - name: default.loc_orc_2d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2003 - zip 43201 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - numFiles 1 - numRows 3 - partition_columns zip/year - partition_columns.types int:string - rawDataSize 603 - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 423 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - partition_columns zip/year - partition_columns.types int:string - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_2d - name: default.loc_orc_2d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2000 - zip 94086 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - numFiles 1 - numRows 1 - partition_columns zip/year - partition_columns.types int:string - rawDataSize 201 - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 383 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - partition_columns zip/year - partition_columns.types int:string - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_2d - name: default.loc_orc_2d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2001 - zip 94086 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"cnt":"true","locid":"true","state":"true"}} - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - numFiles 1 - numRows 2 - partition_columns zip/year - partition_columns.types int:string - rawDataSize 400 - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 394 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - partition_columns zip/year - partition_columns.types int:string - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_2d - name: default.loc_orc_2d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2002 - zip 94086 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - numFiles 1 - numRows 1 - partition_columns zip/year - partition_columns.types int:string - rawDataSize 203 - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 387 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - partition_columns zip/year - partition_columns.types int:string - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_2d - name: default.loc_orc_2d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2003 - zip 94086 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - numFiles 1 - numRows 2 - partition_columns zip/year - partition_columns.types int:string - rawDataSize 404 - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 409 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - partition_columns zip/year - partition_columns.types int:string - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_2d - name: default.loc_orc_2d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2000 - zip 94087 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - numFiles 1 - numRows 1 - partition_columns zip/year - partition_columns.types int:string - rawDataSize 200 - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 366 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - partition_columns zip/year - partition_columns.types int:string - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_2d - name: default.loc_orc_2d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2001 - zip 94087 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - numFiles 1 - numRows 1 - partition_columns zip/year - partition_columns.types int:string - rawDataSize 200 - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 361 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - partition_columns zip/year - partition_columns.types int:string - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_2d - name: default.loc_orc_2d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2002 - zip 94087 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"cnt":"true","locid":"true","state":"true"}} - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - numFiles 1 - numRows 3 - partition_columns zip/year - partition_columns.types int:string - rawDataSize 609 - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 412 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - partition_columns zip/year - partition_columns.types int:string - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_2d - name: default.loc_orc_2d - Partition - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - partition values: - year 2003 - zip 94087 - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - numFiles 1 - numRows 3 - partition_columns zip/year - partition_columns.types int:string - rawDataSize 600 - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 412 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count -1 - columns state,locid,cnt - columns.comments - columns.types string:int:decimal(10,0) -#### A masked pattern was here #### - name default.loc_orc_2d - partition_columns zip/year - partition_columns.types int:string - serialization.ddl struct loc_orc_2d { string state, i32 locid, decimal(10,0) cnt} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.loc_orc_2d - name: default.loc_orc_2d - Processor Tree: - TableScan - alias: loc_orc_2d - Statistics: Num rows: 20 Data size: 4160 Basic stats: COMPLETE Column stats: PARTIAL - GatherStats: false - Select Operator - expressions: state (type: string), locid (type: int), cnt (type: decimal(10,0)), zip (type: int) - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 20 Data size: 4160 Basic stats: COMPLETE Column stats: PARTIAL - ListSink -
http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/file_with_header_footer.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/file_with_header_footer.q.out b/ql/src/test/results/clientpositive/file_with_header_footer.q.out deleted file mode 100644 index ca3dadb..0000000 --- a/ql/src/test/results/clientpositive/file_with_header_footer.q.out +++ /dev/null @@ -1,184 +0,0 @@ -#### A masked pattern was here #### -PREHOOK: type: CREATETABLE -#### A masked pattern was here #### -PREHOOK: Output: database:default -PREHOOK: Output: default@header_footer_table_1 -#### A masked pattern was here #### -POSTHOOK: type: CREATETABLE -#### A masked pattern was here #### -POSTHOOK: Output: database:default -POSTHOOK: Output: default@header_footer_table_1 -PREHOOK: query: SELECT * FROM header_footer_table_1 -PREHOOK: type: QUERY -PREHOOK: Input: default@header_footer_table_1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM header_footer_table_1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@header_footer_table_1 -#### A masked pattern was here #### -steven hive 1 -dave oozie 2 -xifa phd 3 -chuan hadoop 4 -shanyu senior 5 -steven2 hive 11 -dave2 oozie 12 -xifa2 phd 13 -chuan2 hadoop 14 -shanyu2 senior 15 -david3 oozie 22 -PREHOOK: query: SELECT * FROM header_footer_table_1 WHERE id < 50 -PREHOOK: type: QUERY -PREHOOK: Input: default@header_footer_table_1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM header_footer_table_1 WHERE id < 50 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@header_footer_table_1 -#### A masked pattern was here #### -steven hive 1 -dave oozie 2 -xifa phd 3 -chuan hadoop 4 -shanyu senior 5 -steven2 hive 11 -dave2 oozie 12 -xifa2 phd 13 -chuan2 hadoop 14 -shanyu2 senior 15 -david3 oozie 22 -PREHOOK: query: CREATE EXTERNAL TABLE header_footer_table_2 (name string, message string, id int) PARTITIONED BY (year int, month int, day int) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2") -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@header_footer_table_2 -POSTHOOK: query: CREATE EXTERNAL TABLE header_footer_table_2 (name string, message string, id int) PARTITIONED BY (year int, month int, day int) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2") -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@header_footer_table_2 -#### A masked pattern was here #### -PREHOOK: type: ALTERTABLE_ADDPARTS -#### A masked pattern was here #### -PREHOOK: Output: default@header_footer_table_2 -#### A masked pattern was here #### -POSTHOOK: type: ALTERTABLE_ADDPARTS -#### A masked pattern was here #### -POSTHOOK: Output: default@header_footer_table_2 -POSTHOOK: Output: default@header_footer_table_2@year=2012/month=1/day=1 -#### A masked pattern was here #### -PREHOOK: type: ALTERTABLE_ADDPARTS -#### A masked pattern was here #### -PREHOOK: Output: default@header_footer_table_2 -#### A masked pattern was here #### -POSTHOOK: type: ALTERTABLE_ADDPARTS -#### A masked pattern was here #### -POSTHOOK: Output: default@header_footer_table_2 -POSTHOOK: Output: default@header_footer_table_2@year=2012/month=1/day=2 -#### A masked pattern was here #### -PREHOOK: type: ALTERTABLE_ADDPARTS -#### A masked pattern was here #### -PREHOOK: Output: default@header_footer_table_2 -#### A masked pattern was here #### -POSTHOOK: type: ALTERTABLE_ADDPARTS -#### A masked pattern was here #### -POSTHOOK: Output: default@header_footer_table_2 -POSTHOOK: Output: default@header_footer_table_2@year=2012/month=1/day=3 -PREHOOK: query: SELECT * FROM header_footer_table_2 -PREHOOK: type: QUERY -PREHOOK: Input: default@header_footer_table_2 -PREHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=1 -PREHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=2 -PREHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=3 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM header_footer_table_2 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@header_footer_table_2 -POSTHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=1 -POSTHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=2 -POSTHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=3 -#### A masked pattern was here #### -steven hive 1 2012 1 1 -dave oozie 2 2012 1 1 -xifa phd 3 2012 1 1 -chuan hadoop 4 2012 1 1 -shanyu senior 5 2012 1 1 -steven2 hive 11 2012 1 2 -dave2 oozie 12 2012 1 2 -xifa2 phd 13 2012 1 2 -chuan2 hadoop 14 2012 1 2 -shanyu2 senior 15 2012 1 2 -david3 oozie 22 2012 1 3 -PREHOOK: query: SELECT * FROM header_footer_table_2 WHERE id < 50 -PREHOOK: type: QUERY -PREHOOK: Input: default@header_footer_table_2 -PREHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=1 -PREHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=2 -PREHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=3 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM header_footer_table_2 WHERE id < 50 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@header_footer_table_2 -POSTHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=1 -POSTHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=2 -POSTHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=3 -#### A masked pattern was here #### -steven hive 1 2012 1 1 -dave oozie 2 2012 1 1 -xifa phd 3 2012 1 1 -chuan hadoop 4 2012 1 1 -shanyu senior 5 2012 1 1 -steven2 hive 11 2012 1 2 -dave2 oozie 12 2012 1 2 -xifa2 phd 13 2012 1 2 -chuan2 hadoop 14 2012 1 2 -shanyu2 senior 15 2012 1 2 -david3 oozie 22 2012 1 3 -#### A masked pattern was here #### -PREHOOK: type: CREATETABLE -#### A masked pattern was here #### -PREHOOK: Output: database:default -PREHOOK: Output: default@emptytable -#### A masked pattern was here #### -POSTHOOK: type: CREATETABLE -#### A masked pattern was here #### -POSTHOOK: Output: database:default -POSTHOOK: Output: default@emptytable -PREHOOK: query: SELECT * FROM emptytable -PREHOOK: type: QUERY -PREHOOK: Input: default@emptytable -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM emptytable -POSTHOOK: type: QUERY -POSTHOOK: Input: default@emptytable -#### A masked pattern was here #### -PREHOOK: query: SELECT * FROM emptytable WHERE id < 50 -PREHOOK: type: QUERY -PREHOOK: Input: default@emptytable -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM emptytable WHERE id < 50 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@emptytable -#### A masked pattern was here #### -PREHOOK: query: DROP TABLE header_footer_table_1 -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@header_footer_table_1 -PREHOOK: Output: default@header_footer_table_1 -POSTHOOK: query: DROP TABLE header_footer_table_1 -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@header_footer_table_1 -POSTHOOK: Output: default@header_footer_table_1 -PREHOOK: query: DROP TABLE header_footer_table_2 -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@header_footer_table_2 -PREHOOK: Output: default@header_footer_table_2 -POSTHOOK: query: DROP TABLE header_footer_table_2 -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@header_footer_table_2 -POSTHOOK: Output: default@header_footer_table_2 -PREHOOK: query: DROP TABLE emptytable -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@emptytable -PREHOOK: Output: default@emptytable -POSTHOOK: query: DROP TABLE emptytable -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@emptytable -POSTHOOK: Output: default@emptytable -#### A masked pattern was here ####
