PREHOOK: query: DROP TABLE orcfile_merge2a
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE orcfile_merge2a
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE orcfile_merge2a (key INT, value STRING)
    PARTITIONED BY (one string, two string, three string)
    STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@orcfile_merge2a
POSTHOOK: query: CREATE TABLE orcfile_merge2a (key INT, value STRING)
    PARTITIONED BY (one string, two string, three string)
    STORED AS ORC
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@orcfile_merge2a
PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE orcfile_merge2a PARTITION (one='1', two, three)
    SELECT key, value, PMOD(HASH(key), 10) as two, 
        PMOD(HASH(value), 10) as three
    FROM src
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE orcfile_merge2a PARTITION (one='1', two, three)
    SELECT key, value, PMOD(HASH(key), 10) as two, 
        PMOD(HASH(value), 10) as three
    FROM src
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1
  Stage-2 depends on stages: Stage-0

STAGE PLANS:
  Stage: Stage-1
    Map Reduce
      Map Operator Tree:
          TableScan
            alias: src
            Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: UDFToInteger(key) (type: int), value (type: string), (hash(key) pmod 10) (type: int), (hash(value) pmod 10) (type: int)
              outputColumnNames: _col0, _col1, _col2, _col3
              Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
              Reduce Output Operator
                key expressions: _col2 (type: int), _col3 (type: int)
                sort order: ++
                Map-reduce partition columns: _col2 (type: int), _col3 (type: int)
                Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: int), _col3 (type: int)
      Reduce Operator Tree:
        Extract
          Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
          File Output Operator
            compressed: false
            Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
            table:
                input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
                output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
                serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
                name: default.orcfile_merge2a

  Stage: Stage-0
    Move Operator
      tables:
          partition:
            one 1
            three 
            two 
          replace: true
          table:
              input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
              output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
              serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
              name: default.orcfile_merge2a

  Stage: Stage-2
    Stats-Aggr Operator

PREHOOK: query: INSERT OVERWRITE TABLE orcfile_merge2a PARTITION (one='1', two, three)
    SELECT key, value, PMOD(HASH(key), 10) as two, 
        PMOD(HASH(value), 10) as three
    FROM src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@orcfile_merge2a@one=1
POSTHOOK: query: INSERT OVERWRITE TABLE orcfile_merge2a PARTITION (one='1', two, three)
    SELECT key, value, PMOD(HASH(key), 10) as two, 
        PMOD(HASH(value), 10) as three
    FROM src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=0/three=2
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=0/three=8
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=1/three=3
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=1/three=9
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=2/three=0
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=2/three=4
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=3/three=1
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=3/three=5
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=4/three=2
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=4/three=6
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=5/three=3
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=5/three=7
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=6/three=4
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=6/three=8
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=7/three=5
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=7/three=9
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=8/three=0
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=8/three=6
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=9/three=1
POSTHOOK: Output: default@orcfile_merge2a@one=1/two=9/three=7
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=0,three=2).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=0,three=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=0,three=8).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=0,three=8).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=1,three=3).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=1,three=3).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=1,three=9).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=1,three=9).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=2,three=0).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=2,three=0).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=2,three=4).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=2,three=4).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=3,three=1).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=3,three=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=3,three=5).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=3,three=5).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=4,three=2).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=4,three=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=4,three=6).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=4,three=6).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=5,three=3).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=5,three=3).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=5,three=7).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=5,three=7).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=6,three=4).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=6,three=4).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=6,three=8).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=6,three=8).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=7,three=5).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=7,three=5).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=7,three=9).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=7,three=9).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=8,three=0).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=8,three=0).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=8,three=6).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=8,three=6).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=9,three=1).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=9,three=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=9,three=7).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge2a PARTITION(one=1,two=9,three=7).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: DESC FORMATTED orcfile_merge2a partition (one='1', two='0', three='2')
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@orcfile_merge2a
POSTHOOK: query: DESC FORMATTED orcfile_merge2a partition (one='1', two='0', three='2')
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@orcfile_merge2a
# col_name            	data_type           	comment             
	 	 
key                 	int                 	                    
value               	string              	                    
	 	 
# Partition Information	 	 
# col_name            	data_type           	comment             
	 	 
one                 	string              	                    
two                 	string              	                    
three               	string              	                    
	 	 
# Detailed Partition Information	 	 
Partition Value:    	[1, 0, 2]           	 
Database:           	default             	 
Table:              	orcfile_merge2a     	 
#### A masked pattern was here ####
Protect Mode:       	None                	 
#### A masked pattern was here ####
Partition Parameters:	 	 
	COLUMN_STATS_ACCURATE	true                
	numFiles            	1                   
	numRows             	4                   
	rawDataSize         	376                 
	totalSize           	320                 
#### A masked pattern was here ####
	 	 
# Storage Information	 	 
SerDe Library:      	org.apache.hadoop.hive.ql.io.orc.OrcSerde	 
InputFormat:        	org.apache.hadoop.hive.ql.io.orc.OrcInputFormat	 
OutputFormat:       	org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat	 
Compressed:         	No                  	 
Num Buckets:        	-1                  	 
Bucket Columns:     	[]                  	 
Sort Columns:       	[]                  	 
Storage Desc Params:	 	 
	serialization.format	1                   
PREHOOK: query: SELECT SUM(HASH(c)) FROM (
    SELECT TRANSFORM(*) USING 'tr \t _' AS (c)
    FROM orcfile_merge2a
) t
PREHOOK: type: QUERY
PREHOOK: Input: default@orcfile_merge2a
PREHOOK: Input: default@orcfile_merge2a@one=1/two=0/three=2
PREHOOK: Input: default@orcfile_merge2a@one=1/two=0/three=8
PREHOOK: Input: default@orcfile_merge2a@one=1/two=1/three=3
PREHOOK: Input: default@orcfile_merge2a@one=1/two=1/three=9
PREHOOK: Input: default@orcfile_merge2a@one=1/two=2/three=0
PREHOOK: Input: default@orcfile_merge2a@one=1/two=2/three=4
PREHOOK: Input: default@orcfile_merge2a@one=1/two=3/three=1
PREHOOK: Input: default@orcfile_merge2a@one=1/two=3/three=5
PREHOOK: Input: default@orcfile_merge2a@one=1/two=4/three=2
PREHOOK: Input: default@orcfile_merge2a@one=1/two=4/three=6
PREHOOK: Input: default@orcfile_merge2a@one=1/two=5/three=3
PREHOOK: Input: default@orcfile_merge2a@one=1/two=5/three=7
PREHOOK: Input: default@orcfile_merge2a@one=1/two=6/three=4
PREHOOK: Input: default@orcfile_merge2a@one=1/two=6/three=8
PREHOOK: Input: default@orcfile_merge2a@one=1/two=7/three=5
PREHOOK: Input: default@orcfile_merge2a@one=1/two=7/three=9
PREHOOK: Input: default@orcfile_merge2a@one=1/two=8/three=0
PREHOOK: Input: default@orcfile_merge2a@one=1/two=8/three=6
PREHOOK: Input: default@orcfile_merge2a@one=1/two=9/three=1
PREHOOK: Input: default@orcfile_merge2a@one=1/two=9/three=7
#### A masked pattern was here ####
POSTHOOK: query: SELECT SUM(HASH(c)) FROM (
    SELECT TRANSFORM(*) USING 'tr \t _' AS (c)
    FROM orcfile_merge2a
) t
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orcfile_merge2a
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=0/three=2
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=0/three=8
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=1/three=3
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=1/three=9
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=2/three=0
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=2/three=4
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=3/three=1
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=3/three=5
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=4/three=2
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=4/three=6
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=5/three=3
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=5/three=7
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=6/three=4
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=6/three=8
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=7/three=5
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=7/three=9
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=8/three=0
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=8/three=6
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=9/three=1
POSTHOOK: Input: default@orcfile_merge2a@one=1/two=9/three=7
#### A masked pattern was here ####
-4209012844
PREHOOK: query: SELECT SUM(HASH(c)) FROM (
    SELECT TRANSFORM(key, value, '1', PMOD(HASH(key), 10), 
        PMOD(HASH(value), 10)) USING 'tr \t _' AS (c)
    FROM src
) t
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT SUM(HASH(c)) FROM (
    SELECT TRANSFORM(key, value, '1', PMOD(HASH(key), 10), 
        PMOD(HASH(value), 10)) USING 'tr \t _' AS (c)
    FROM src
) t
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-4209012844
PREHOOK: query: DROP TABLE orcfile_merge2a
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@orcfile_merge2a
PREHOOK: Output: default@orcfile_merge2a
POSTHOOK: query: DROP TABLE orcfile_merge2a
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@orcfile_merge2a
POSTHOOK: Output: default@orcfile_merge2a