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_full.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_full.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: 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), ]
PREHOOK: query: analyze table loc_orc_1d partition(year='2000') compute statistics for columns state,locid
PREHOOK: type: QUERY
PREHOOK: Input: default@loc_orc_1d
PREHOOK: Input: default@loc_orc_1d@year=2000
#### A masked pattern was here ####
POSTHOOK: query: analyze table loc_orc_1d partition(year='2000') compute statistics for columns state,locid
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='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: 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: -- 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 375
#### 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 397
#### 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: 6 Data size: 552 Basic stats: COMPLETE Column stats: COMPLETE
          GatherStats: false
          Select Operator
            expressions: state (type: string)
            outputColumnNames: _col0
            Statistics: Num rows: 6 Data size: 510 Basic stats: COMPLETE Column stats: COMPLETE
            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 375
#### 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 397
#### 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: 6 Data size: 552 Basic stats: COMPLETE Column stats: COMPLETE
          GatherStats: false
          Select Operator
            expressions: state (type: string), locid (type: int)
            outputColumnNames: _col0, _col1
            Statistics: Num rows: 6 Data size: 534 Basic stats: COMPLETE Column stats: COMPLETE
            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=94086/year=2000
POSTHOOK: Output: default@loc_orc_2d@zip=94086/year=2001
POSTHOOK: Output: default@loc_orc_2d@zip=94087/year=2000
POSTHOOK: Output: default@loc_orc_2d@zip=94087/year=2001
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=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), ]
PREHOOK: query: analyze table loc_orc_2d partition(zip=94086, year='2000') compute statistics for columns state,locid
PREHOOK: type: QUERY
PREHOOK: Input: default@loc_orc_2d
PREHOOK: Input: default@loc_orc_2d@zip=94086/year=2000
#### A masked pattern was here ####
POSTHOOK: query: analyze table loc_orc_2d partition(zip=94086, year='2000') compute statistics for columns state,locid
POSTHOOK: type: QUERY
POSTHOOK: Input: default@loc_orc_2d
POSTHOOK: Input: default@loc_orc_2d@zip=94086/year=2000
#### A masked pattern was here ####
PREHOOK: query: analyze table loc_orc_2d partition(zip=94087, year='2000') compute statistics for columns state,locid
PREHOOK: type: QUERY
PREHOOK: Input: default@loc_orc_2d
PREHOOK: Input: default@loc_orc_2d@zip=94087/year=2000
#### A masked pattern was here ####
POSTHOOK: query: analyze table loc_orc_2d partition(zip=94087, year='2000') compute statistics for columns state,locid
POSTHOOK: type: QUERY
POSTHOOK: Input: default@loc_orc_2d
POSTHOOK: Input: default@loc_orc_2d@zip=94087/year=2000
#### A masked pattern was here ####
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='2001') compute statistics for columns state,locid
PREHOOK: type: QUERY
PREHOOK: Input: default@loc_orc_2d
PREHOOK: Input: default@loc_orc_2d@zip=94087/year=2001
#### A masked pattern was here ####
POSTHOOK: query: analyze table loc_orc_2d partition(zip=94087, year='2001') compute statistics for columns state,locid
POSTHOOK: type: QUERY
POSTHOOK: Input: default@loc_orc_2d
POSTHOOK: Input: default@loc_orc_2d@zip=94087/year=2001
#### 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 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 290
#### 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 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 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 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 274
#### 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 274
#### 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: 6 Data size: 532 Basic stats: COMPLETE Column stats: COMPLETE
          GatherStats: false
          Select Operator
            expressions: state (type: string)
            outputColumnNames: _col0
            Statistics: Num rows: 6 Data size: 510 Basic stats: COMPLETE Column stats: COMPLETE
            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 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 290
#### 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 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 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 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 274
#### 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 274
#### 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: 6 Data size: 532 Basic stats: COMPLETE Column stats: COMPLETE
          GatherStats: false
          Select Operator
            expressions: state (type: string), locid (type: int)
            outputColumnNames: _col0, _col1
            Statistics: Num rows: 6 Data size: 534 Basic stats: COMPLETE Column stats: COMPLETE
            ListSink