PREHOOK: query: create table if not exists ext_loc ( state string, locid int, 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 if not exists ext_loc ( state string, locid int, 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.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.txt' OVERWRITE INTO TABLE ext_loc POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@ext_loc PREHOOK: query: create table if not exists loc_orc_1d ( state string, locid int, 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 if not exists loc_orc_1d ( state string, locid int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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 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 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 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 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.state PARTITION(year='2001') PREHOOK: type: DESCTABLE PREHOOK: Input: default@loc_orc_1d POSTHOOK: query: describe formatted loc_orc_1d.state PARTITION(year='2001') 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.state PARTITION(year='2002') PREHOOK: type: DESCTABLE PREHOOK: Input: default@loc_orc_1d POSTHOOK: query: describe formatted loc_orc_1d.state PARTITION(year='2002') 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: -- basicStatState: COMPLETE colStatState: PARTIAL explain extended select state from loc_orc_1d PREHOOK: type: QUERY POSTHOOK: query: -- basicStatState: COMPLETE colStatState: PARTIAL explain extended select state from loc_orc_1d POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: TOK_QUERY TOK_FROM TOK_TABREF TOK_TABNAME loc_orc_1d TOK_INSERT TOK_DESTINATION TOK_DIR TOK_TMP_FILE TOK_SELECT TOK_SELEXPR TOK_TABLE_OR_COL state 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 2 partition_columns year partition_columns.types string rawDataSize 184 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 362 #### 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,zip columns.comments columns.types string:int: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, i32 locid, 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 4 partition_columns year partition_columns.types string rawDataSize 368 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} 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,zip columns.comments columns.types string:int: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, i32 locid, 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 6 partition_columns year partition_columns.types string rawDataSize 570 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 404 #### 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,zip columns.comments columns.types string:int: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, i32 locid, 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 8 partition_columns year partition_columns.types string rawDataSize 744 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} 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,zip columns.comments columns.types string:int: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, i32 locid, 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: 1866 Basic stats: COMPLETE Column stats: PARTIAL GatherStats: false Select Operator expressions: state (type: string) outputColumnNames: _col0 Statistics: Num rows: 20 Data size: 1780 Basic stats: COMPLETE Column stats: PARTIAL ListSink PREHOOK: query: -- column statistics for __HIVE_DEFAULT_PARTITION__ is not supported yet. Hence colStatState reports PARTIAL -- basicStatState: COMPLETE colStatState: PARTIAL explain extended select state,locid from loc_orc_1d PREHOOK: type: QUERY POSTHOOK: query: -- column statistics for __HIVE_DEFAULT_PARTITION__ is not supported yet. Hence colStatState reports PARTIAL -- basicStatState: COMPLETE colStatState: PARTIAL explain extended select state,locid from loc_orc_1d POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: TOK_QUERY TOK_FROM TOK_TABREF TOK_TABNAME loc_orc_1d TOK_INSERT TOK_DESTINATION TOK_DIR TOK_TMP_FILE TOK_SELECT TOK_SELEXPR TOK_TABLE_OR_COL state TOK_SELEXPR TOK_TABLE_OR_COL locid 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 2 partition_columns year partition_columns.types string rawDataSize 184 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 362 #### 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,zip columns.comments columns.types string:int: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, i32 locid, 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 4 partition_columns year partition_columns.types string rawDataSize 368 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} 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,zip columns.comments columns.types string:int: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, i32 locid, 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 6 partition_columns year partition_columns.types string rawDataSize 570 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 404 #### 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,zip columns.comments columns.types string:int: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, i32 locid, 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 8 partition_columns year partition_columns.types string rawDataSize 744 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} 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,zip columns.comments columns.types string:int: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, i32 locid, 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: 1866 Basic stats: COMPLETE Column stats: PARTIAL GatherStats: false Select Operator expressions: state (type: string), locid (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 20 Data size: 1860 Basic stats: COMPLETE Column stats: PARTIAL ListSink PREHOOK: query: analyze table loc_orc_1d partition(year='2000') compute statistics for columns state 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 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 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 POSTHOOK: type: QUERY POSTHOOK: Input: default@loc_orc_1d POSTHOOK: Input: default@loc_orc_1d@year=2003 #### A masked pattern was here #### PREHOOK: query: explain extended select state from loc_orc_1d PREHOOK: type: QUERY POSTHOOK: query: explain extended select state from loc_orc_1d POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: TOK_QUERY TOK_FROM TOK_TABREF TOK_TABNAME loc_orc_1d TOK_INSERT TOK_DESTINATION TOK_DIR TOK_TMP_FILE TOK_SELECT TOK_SELEXPR TOK_TABLE_OR_COL state 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 2 partition_columns year partition_columns.types string rawDataSize 184 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 362 #### 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,zip columns.comments columns.types string:int: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, i32 locid, 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 4 partition_columns year partition_columns.types string rawDataSize 368 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} 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,zip columns.comments columns.types string:int: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, i32 locid, 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 6 partition_columns year partition_columns.types string rawDataSize 570 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 404 #### 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,zip columns.comments columns.types string:int: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, i32 locid, 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 8 partition_columns year partition_columns.types string rawDataSize 744 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} 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,zip columns.comments columns.types string:int: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, i32 locid, 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: 1866 Basic stats: COMPLETE Column stats: COMPLETE GatherStats: false Select Operator expressions: state (type: string) outputColumnNames: _col0 Statistics: Num rows: 20 Data size: 1740 Basic stats: COMPLETE Column stats: COMPLETE ListSink PREHOOK: query: explain extended select state,locid from loc_orc_1d PREHOOK: type: QUERY POSTHOOK: query: explain extended select state,locid from loc_orc_1d POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: TOK_QUERY TOK_FROM TOK_TABREF TOK_TABNAME loc_orc_1d TOK_INSERT TOK_DESTINATION TOK_DIR TOK_TMP_FILE TOK_SELECT TOK_SELEXPR TOK_TABLE_OR_COL state TOK_SELEXPR TOK_TABLE_OR_COL locid 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 2 partition_columns year partition_columns.types string rawDataSize 184 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 362 #### 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,zip columns.comments columns.types string:int: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, i32 locid, 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 4 partition_columns year partition_columns.types string rawDataSize 368 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} 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,zip columns.comments columns.types string:int: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, i32 locid, 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 6 partition_columns year partition_columns.types string rawDataSize 570 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 404 #### 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,zip columns.comments columns.types string:int: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, i32 locid, 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 true bucket_count -1 columns state,locid,zip columns.comments columns.types string:int:int #### A masked pattern was here #### name default.loc_orc_1d numFiles 1 numRows 8 partition_columns year partition_columns.types string rawDataSize 744 serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip} 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,zip columns.comments columns.types string:int: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, i32 locid, 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: 1866 Basic stats: COMPLETE Column stats: PARTIAL GatherStats: false Select Operator expressions: state (type: string), locid (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 20 Data size: 1820 Basic stats: COMPLETE Column stats: PARTIAL ListSink PREHOOK: query: create table if not exists loc_orc_2d ( state string, locid int ) 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 if not exists loc_orc_2d ( state string, locid int ) 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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).locid SIMPLE [(ext_loc)ext_loc.FieldSchema(name:locid, type:int, 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 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 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 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 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: explain extended select state from loc_orc_2d PREHOOK: type: QUERY POSTHOOK: query: explain extended select state from loc_orc_2d POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: TOK_QUERY TOK_FROM TOK_TABREF TOK_TABNAME loc_orc_2d TOK_INSERT TOK_DESTINATION TOK_DIR TOK_TMP_FILE TOK_SELECT TOK_SELEXPR TOK_TABLE_OR_COL state 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 1 partition_columns zip/year partition_columns.types int:string rawDataSize 90 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 281 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 2 partition_columns zip/year partition_columns.types int:string rawDataSize 182 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 291 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 3 partition_columns zip/year partition_columns.types int:string rawDataSize 267 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 298 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 1 partition_columns zip/year partition_columns.types int:string rawDataSize 89 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 277 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 2 partition_columns zip/year partition_columns.types int:string rawDataSize 176 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 272 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 1 partition_columns zip/year partition_columns.types int:string rawDataSize 91 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 283 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 2 partition_columns zip/year partition_columns.types int:string rawDataSize 180 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 292 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 1 partition_columns zip/year partition_columns.types int:string rawDataSize 88 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 261 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 1 partition_columns zip/year partition_columns.types int:string rawDataSize 88 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 261 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 3 partition_columns zip/year partition_columns.types int:string rawDataSize 273 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 294 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 3 partition_columns zip/year partition_columns.types int:string rawDataSize 264 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 291 #### 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 columns.comments columns.types string:int #### 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} 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: 1788 Basic stats: COMPLETE Column stats: PARTIAL GatherStats: false Select Operator expressions: state (type: string) outputColumnNames: _col0 Statistics: Num rows: 20 Data size: 1760 Basic stats: COMPLETE Column stats: PARTIAL ListSink PREHOOK: query: explain extended select state,locid from loc_orc_2d PREHOOK: type: QUERY POSTHOOK: query: explain extended select state,locid from loc_orc_2d POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: TOK_QUERY TOK_FROM TOK_TABREF TOK_TABNAME loc_orc_2d TOK_INSERT TOK_DESTINATION TOK_DIR TOK_TMP_FILE TOK_SELECT TOK_SELEXPR TOK_TABLE_OR_COL state TOK_SELEXPR TOK_TABLE_OR_COL locid 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 1 partition_columns zip/year partition_columns.types int:string rawDataSize 90 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 281 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 2 partition_columns zip/year partition_columns.types int:string rawDataSize 182 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 291 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 3 partition_columns zip/year partition_columns.types int:string rawDataSize 267 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 298 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 1 partition_columns zip/year partition_columns.types int:string rawDataSize 89 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 277 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 2 partition_columns zip/year partition_columns.types int:string rawDataSize 176 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 272 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 1 partition_columns zip/year partition_columns.types int:string rawDataSize 91 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 283 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 2 partition_columns zip/year partition_columns.types int:string rawDataSize 180 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 292 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 1 partition_columns zip/year partition_columns.types int:string rawDataSize 88 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 261 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 1 partition_columns zip/year partition_columns.types int:string rawDataSize 88 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 261 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 3 partition_columns zip/year partition_columns.types int:string rawDataSize 273 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 294 #### 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 columns.comments columns.types string:int #### 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} 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 true bucket_count -1 columns state,locid columns.comments columns.types string:int #### A masked pattern was here #### name default.loc_orc_2d numFiles 1 numRows 3 partition_columns zip/year partition_columns.types int:string rawDataSize 264 serialization.ddl struct loc_orc_2d { string state, i32 locid} serialization.format 1 serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde totalSize 291 #### 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 columns.comments columns.types string:int #### 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} 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: 1788 Basic stats: COMPLETE Column stats: PARTIAL GatherStats: false Select Operator expressions: state (type: string), locid (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 20 Data size: 1840 Basic stats: COMPLETE Column stats: PARTIAL ListSink