| 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 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: -- 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 |
| 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,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 369 |
| #### 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 {"BASIC_STATS":"true","COLUMN_STATS":{"locid":"true","state":"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 390 |
| #### 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 {"BASIC_STATS":"true","COLUMN_STATS":{"locid":"true","state":"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 410 |
| #### 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 {"BASIC_STATS":"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 419 |
| #### 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: 1780 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 |
| 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,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 369 |
| #### 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 {"BASIC_STATS":"true","COLUMN_STATS":{"locid":"true","state":"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 390 |
| #### 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 {"BASIC_STATS":"true","COLUMN_STATS":{"locid":"true","state":"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 410 |
| #### 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 {"BASIC_STATS":"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 419 |
| #### 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: 1860 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 |
| 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":{"state":"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 369 |
| #### 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 {"BASIC_STATS":"true","COLUMN_STATS":{"locid":"true","state":"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 390 |
| #### 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 {"BASIC_STATS":"true","COLUMN_STATS":{"locid":"true","state":"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 410 |
| #### 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 {"BASIC_STATS":"true","COLUMN_STATS":{"state":"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 419 |
| #### 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: 1740 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 |
| 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":{"state":"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 369 |
| #### 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 {"BASIC_STATS":"true","COLUMN_STATS":{"locid":"true","state":"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 390 |
| #### 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 {"BASIC_STATS":"true","COLUMN_STATS":{"locid":"true","state":"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 410 |
| #### 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 {"BASIC_STATS":"true","COLUMN_STATS":{"state":"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 419 |
| #### 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: 1820 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 |
| 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 |
| 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 286 |
| #### 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 {"BASIC_STATS":"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 295 |
| #### 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 {"BASIC_STATS":"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 302 |
| #### 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 {"BASIC_STATS":"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 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 2001 |
| zip 94086 |
| properties: |
| COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"locid":"true","state":"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 276 |
| #### 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 {"BASIC_STATS":"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 288 |
| #### 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 {"BASIC_STATS":"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 297 |
| #### 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 {"BASIC_STATS":"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 265 |
| #### 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 {"BASIC_STATS":"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 265 |
| #### 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 {"BASIC_STATS":"true","COLUMN_STATS":{"locid":"true","state":"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 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 2003 |
| zip 94087 |
| properties: |
| COLUMN_STATS_ACCURATE {"BASIC_STATS":"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 295 |
| #### 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: 1760 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 |
| 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 |
| 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 286 |
| #### 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 {"BASIC_STATS":"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 295 |
| #### 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 {"BASIC_STATS":"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 302 |
| #### 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 {"BASIC_STATS":"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 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 2001 |
| zip 94086 |
| properties: |
| COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"locid":"true","state":"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 276 |
| #### 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 {"BASIC_STATS":"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 288 |
| #### 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 {"BASIC_STATS":"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 297 |
| #### 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 {"BASIC_STATS":"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 265 |
| #### 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 {"BASIC_STATS":"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 265 |
| #### 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 {"BASIC_STATS":"true","COLUMN_STATS":{"locid":"true","state":"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 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 2003 |
| zip 94087 |
| properties: |
| COLUMN_STATS_ACCURATE {"BASIC_STATS":"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 295 |
| #### 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: 1840 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 |
| |
