http://git-wip-us.apache.org/repos/asf/hive/blob/62a3778e/ql/src/test/results/clientpositive/tez/vector_outer_join5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_outer_join5.q.out b/ql/src/test/results/clientpositive/tez/vector_outer_join5.q.out deleted file mode 100644 index fdd4d6a..0000000 --- a/ql/src/test/results/clientpositive/tez/vector_outer_join5.q.out +++ /dev/null @@ -1,1346 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS - -create table sorted_mod_4 stored as orc -as select ctinyint, pmod(cint, 4) as cmodint from alltypesorc -where cint is not null and ctinyint is not null -order by ctinyint -PREHOOK: type: CREATETABLE_AS_SELECT -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: database:default -PREHOOK: Output: default@sorted_mod_4 -POSTHOOK: query: -- SORT_QUERY_RESULTS - -create table sorted_mod_4 stored as orc -as select ctinyint, pmod(cint, 4) as cmodint from alltypesorc -where cint is not null and ctinyint is not null -order by ctinyint -POSTHOOK: type: CREATETABLE_AS_SELECT -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: database:default -POSTHOOK: Output: default@sorted_mod_4 -POSTHOOK: Lineage: sorted_mod_4.cmodint EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: sorted_mod_4.ctinyint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctinyint, type:tinyint, comment:null), ] -PREHOOK: query: ANALYZE TABLE sorted_mod_4 COMPUTE STATISTICS -PREHOOK: type: QUERY -PREHOOK: Input: default@sorted_mod_4 -PREHOOK: Output: default@sorted_mod_4 -POSTHOOK: query: ANALYZE TABLE sorted_mod_4 COMPUTE STATISTICS -POSTHOOK: type: QUERY -POSTHOOK: Input: default@sorted_mod_4 -POSTHOOK: Output: default@sorted_mod_4 -PREHOOK: query: ANALYZE TABLE sorted_mod_4 COMPUTE STATISTICS FOR COLUMNS -PREHOOK: type: QUERY -PREHOOK: Input: default@sorted_mod_4 -#### A masked pattern was here #### -POSTHOOK: query: ANALYZE TABLE sorted_mod_4 COMPUTE STATISTICS FOR COLUMNS -POSTHOOK: type: QUERY -POSTHOOK: Input: default@sorted_mod_4 -#### A masked pattern was here #### -PREHOOK: query: create table small_table stored -as orc as select ctinyint, cbigint from alltypesorc limit 100 -PREHOOK: type: CREATETABLE_AS_SELECT -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: database:default -PREHOOK: Output: default@small_table -POSTHOOK: query: create table small_table stored -as orc as select ctinyint, cbigint from alltypesorc limit 100 -POSTHOOK: type: CREATETABLE_AS_SELECT -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: database:default -POSTHOOK: Output: default@small_table -POSTHOOK: Lineage: small_table.cbigint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cbigint, type:bigint, comment:null), ] -POSTHOOK: Lineage: small_table.ctinyint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctinyint, type:tinyint, comment:null), ] -PREHOOK: query: ANALYZE TABLE small_table COMPUTE STATISTICS -PREHOOK: type: QUERY -PREHOOK: Input: default@small_table -PREHOOK: Output: default@small_table -POSTHOOK: query: ANALYZE TABLE small_table COMPUTE STATISTICS -POSTHOOK: type: QUERY -POSTHOOK: Input: default@small_table -POSTHOOK: Output: default@small_table -PREHOOK: query: ANALYZE TABLE small_table COMPUTE STATISTICS FOR COLUMNS -PREHOOK: type: QUERY -PREHOOK: Input: default@small_table -#### A masked pattern was here #### -POSTHOOK: query: ANALYZE TABLE small_table COMPUTE STATISTICS FOR COLUMNS -POSTHOOK: type: QUERY -POSTHOOK: Input: default@small_table -#### A masked pattern was here #### -PREHOOK: query: explain -select count(*) from (select s.*, st.* -from sorted_mod_4 s -left outer join small_table st -on s.ctinyint = st.ctinyint -) t1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select count(*) from (select s.*, st.* -from sorted_mod_4 s -left outer join small_table st -on s.ctinyint = st.ctinyint -) t1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 1 <- Map 3 (BROADCAST_EDGE) - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: s - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: ctinyint (type: tinyint) - outputColumnNames: _col0 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - keys: - 0 _col0 (type: tinyint) - 1 _col0 (type: tinyint) - input vertices: - 1 Map 3 - Statistics: Num rows: 6663 Data size: 53310 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: bigint) - Execution mode: vectorized - Map 3 - Map Operator Tree: - TableScan - alias: st - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: ctinyint (type: tinyint) - outputColumnNames: _col0 - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: tinyint) - sort order: + - Map-reduce partition columns: _col0 (type: tinyint) - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Reducer 2 - Execution mode: vectorized - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from (select s.*, st.* -from sorted_mod_4 s -left outer join small_table st -on s.ctinyint = st.ctinyint -) t1 -PREHOOK: type: QUERY -PREHOOK: Input: default@small_table -PREHOOK: Input: default@sorted_mod_4 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from (select s.*, st.* -from sorted_mod_4 s -left outer join small_table st -on s.ctinyint = st.ctinyint -) t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@small_table -POSTHOOK: Input: default@sorted_mod_4 -#### A masked pattern was here #### -6876 -PREHOOK: query: explain -select count(*) from (select s.ctinyint, s.cmodint, sm.cbigint -from sorted_mod_4 s -left outer join small_table sm -on s.ctinyint = sm.ctinyint and s.cmodint = 2 -) t1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select count(*) from (select s.ctinyint, s.cmodint, sm.cbigint -from sorted_mod_4 s -left outer join small_table sm -on s.ctinyint = sm.ctinyint and s.cmodint = 2 -) t1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 1 <- Map 3 (BROADCAST_EDGE) - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: s - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: ctinyint (type: tinyint), cmodint (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - filter predicates: - 0 {(_col1 = 2)} - 1 - keys: - 0 _col0 (type: tinyint) - 1 _col0 (type: tinyint) - input vertices: - 1 Map 3 - Statistics: Num rows: 6663 Data size: 53310 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: bigint) - Execution mode: vectorized - Map 3 - Map Operator Tree: - TableScan - alias: sm - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: ctinyint (type: tinyint) - outputColumnNames: _col0 - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: tinyint) - sort order: + - Map-reduce partition columns: _col0 (type: tinyint) - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Reducer 2 - Execution mode: vectorized - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from (select s.ctinyint, s.cmodint, sm.cbigint -from sorted_mod_4 s -left outer join small_table sm -on s.ctinyint = sm.ctinyint and s.cmodint = 2 -) t1 -PREHOOK: type: QUERY -PREHOOK: Input: default@small_table -PREHOOK: Input: default@sorted_mod_4 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from (select s.ctinyint, s.cmodint, sm.cbigint -from sorted_mod_4 s -left outer join small_table sm -on s.ctinyint = sm.ctinyint and s.cmodint = 2 -) t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@small_table -POSTHOOK: Input: default@sorted_mod_4 -#### A masked pattern was here #### -6058 -PREHOOK: query: explain -select count(*) from (select s.ctinyint, s.cmodint, sm.cbigint -from sorted_mod_4 s -left outer join small_table sm -on s.ctinyint = sm.ctinyint and pmod(s.ctinyint, 4) = s.cmodint -) t1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select count(*) from (select s.ctinyint, s.cmodint, sm.cbigint -from sorted_mod_4 s -left outer join small_table sm -on s.ctinyint = sm.ctinyint and pmod(s.ctinyint, 4) = s.cmodint -) t1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 1 <- Map 3 (BROADCAST_EDGE) - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: s - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: ctinyint (type: tinyint), cmodint (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - filter predicates: - 0 {((UDFToInteger(_col0) pmod 4) = _col1)} - 1 - keys: - 0 _col0 (type: tinyint) - 1 _col0 (type: tinyint) - input vertices: - 1 Map 3 - Statistics: Num rows: 6663 Data size: 53310 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: bigint) - Execution mode: vectorized - Map 3 - Map Operator Tree: - TableScan - alias: sm - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: ctinyint (type: tinyint) - outputColumnNames: _col0 - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: tinyint) - sort order: + - Map-reduce partition columns: _col0 (type: tinyint) - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Reducer 2 - Execution mode: vectorized - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from (select s.ctinyint, s.cmodint, sm.cbigint -from sorted_mod_4 s -left outer join small_table sm -on s.ctinyint = sm.ctinyint and pmod(s.ctinyint, 4) = s.cmodint -) t1 -PREHOOK: type: QUERY -PREHOOK: Input: default@small_table -PREHOOK: Input: default@sorted_mod_4 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from (select s.ctinyint, s.cmodint, sm.cbigint -from sorted_mod_4 s -left outer join small_table sm -on s.ctinyint = sm.ctinyint and pmod(s.ctinyint, 4) = s.cmodint -) t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@small_table -POSTHOOK: Input: default@sorted_mod_4 -#### A masked pattern was here #### -6248 -PREHOOK: query: explain -select count(*) from (select s.ctinyint, s.cmodint, sm.cbigint -from sorted_mod_4 s -left outer join small_table sm -on s.ctinyint = sm.ctinyint and s.ctinyint < 100 -) t1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select count(*) from (select s.ctinyint, s.cmodint, sm.cbigint -from sorted_mod_4 s -left outer join small_table sm -on s.ctinyint = sm.ctinyint and s.ctinyint < 100 -) t1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 1 <- Map 3 (BROADCAST_EDGE) - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: s - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: ctinyint (type: tinyint) - outputColumnNames: _col0 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - filter predicates: - 0 {(_col0 < 100)} - 1 - keys: - 0 _col0 (type: tinyint) - 1 _col0 (type: tinyint) - input vertices: - 1 Map 3 - Statistics: Num rows: 6663 Data size: 53310 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: bigint) - Execution mode: vectorized - Map 3 - Map Operator Tree: - TableScan - alias: sm - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: ctinyint (type: tinyint) - outputColumnNames: _col0 - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: tinyint) - sort order: + - Map-reduce partition columns: _col0 (type: tinyint) - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Reducer 2 - Execution mode: vectorized - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from (select s.ctinyint, s.cmodint, sm.cbigint -from sorted_mod_4 s -left outer join small_table sm -on s.ctinyint = sm.ctinyint and s.ctinyint < 100 -) t1 -PREHOOK: type: QUERY -PREHOOK: Input: default@small_table -PREHOOK: Input: default@sorted_mod_4 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from (select s.ctinyint, s.cmodint, sm.cbigint -from sorted_mod_4 s -left outer join small_table sm -on s.ctinyint = sm.ctinyint and s.ctinyint < 100 -) t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@small_table -POSTHOOK: Input: default@sorted_mod_4 -#### A masked pattern was here #### -6876 -PREHOOK: query: explain -select count(*) from (select s.*, sm.*, s2.* -from sorted_mod_4 s -left outer join small_table sm - on pmod(sm.cbigint, 8) = s.cmodint -left outer join sorted_mod_4 s2 - on s2.ctinyint = s.ctinyint -) t1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select count(*) from (select s.*, sm.*, s2.* -from sorted_mod_4 s -left outer join small_table sm - on pmod(sm.cbigint, 8) = s.cmodint -left outer join sorted_mod_4 s2 - on s2.ctinyint = s.ctinyint -) t1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 1 <- Map 4 (BROADCAST_EDGE) - Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 5 (SIMPLE_EDGE) - Reducer 3 <- Reducer 2 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: s - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: ctinyint (type: tinyint), cmodint (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - keys: - 0 UDFToLong(_col1) (type: bigint) - 1 (_col0 pmod 8) (type: bigint) - outputColumnNames: _col0 - input vertices: - 1 Map 4 - Statistics: Num rows: 6663 Data size: 53310 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Reduce Output Operator - key expressions: _col0 (type: tinyint) - sort order: + - Map-reduce partition columns: _col0 (type: tinyint) - Statistics: Num rows: 6663 Data size: 53310 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Map 4 - Map Operator Tree: - TableScan - alias: sm - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: cbigint (type: bigint) - outputColumnNames: _col0 - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: (_col0 pmod 8) (type: bigint) - sort order: + - Map-reduce partition columns: (_col0 pmod 8) (type: bigint) - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Map 5 - Map Operator Tree: - TableScan - alias: s2 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: ctinyint (type: tinyint) - outputColumnNames: _col0 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: tinyint) - sort order: + - Map-reduce partition columns: _col0 (type: tinyint) - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Reducer 2 - Reduce Operator Tree: - Merge Join Operator - condition map: - Left Outer Join0 to 1 - keys: - 0 _col0 (type: tinyint) - 1 _col0 (type: tinyint) - Statistics: Num rows: 7329 Data size: 58641 Basic stats: COMPLETE Column stats: NONE - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: bigint) - Reducer 3 - Execution mode: vectorized - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from (select s.*, sm.*, s2.* -from sorted_mod_4 s -left outer join small_table sm - on pmod(sm.cbigint, 8) = s.cmodint -left outer join sorted_mod_4 s2 - on s2.ctinyint = s.ctinyint -) t1 -PREHOOK: type: QUERY -PREHOOK: Input: default@small_table -PREHOOK: Input: default@sorted_mod_4 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from (select s.*, sm.*, s2.* -from sorted_mod_4 s -left outer join small_table sm - on pmod(sm.cbigint, 8) = s.cmodint -left outer join sorted_mod_4 s2 - on s2.ctinyint = s.ctinyint -) t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@small_table -POSTHOOK: Input: default@sorted_mod_4 -#### A masked pattern was here #### -3268334 -PREHOOK: query: create table mod_8_mod_4 stored as orc -as select pmod(ctinyint, 8) as cmodtinyint, pmod(cint, 4) as cmodint from alltypesorc -where cint is not null and ctinyint is not null -PREHOOK: type: CREATETABLE_AS_SELECT -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: database:default -PREHOOK: Output: default@mod_8_mod_4 -POSTHOOK: query: create table mod_8_mod_4 stored as orc -as select pmod(ctinyint, 8) as cmodtinyint, pmod(cint, 4) as cmodint from alltypesorc -where cint is not null and ctinyint is not null -POSTHOOK: type: CREATETABLE_AS_SELECT -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: database:default -POSTHOOK: Output: default@mod_8_mod_4 -POSTHOOK: Lineage: mod_8_mod_4.cmodint EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: mod_8_mod_4.cmodtinyint EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctinyint, type:tinyint, comment:null), ] -PREHOOK: query: ANALYZE TABLE mod_8_mod_4 COMPUTE STATISTICS -PREHOOK: type: QUERY -PREHOOK: Input: default@mod_8_mod_4 -PREHOOK: Output: default@mod_8_mod_4 -POSTHOOK: query: ANALYZE TABLE mod_8_mod_4 COMPUTE STATISTICS -POSTHOOK: type: QUERY -POSTHOOK: Input: default@mod_8_mod_4 -POSTHOOK: Output: default@mod_8_mod_4 -PREHOOK: query: ANALYZE TABLE mod_8_mod_4 COMPUTE STATISTICS FOR COLUMNS -PREHOOK: type: QUERY -PREHOOK: Input: default@mod_8_mod_4 -#### A masked pattern was here #### -POSTHOOK: query: ANALYZE TABLE mod_8_mod_4 COMPUTE STATISTICS FOR COLUMNS -POSTHOOK: type: QUERY -POSTHOOK: Input: default@mod_8_mod_4 -#### A masked pattern was here #### -PREHOOK: query: create table small_table2 stored -as orc as select pmod(ctinyint, 16) as cmodtinyint, cbigint from alltypesorc limit 100 -PREHOOK: type: CREATETABLE_AS_SELECT -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: database:default -PREHOOK: Output: default@small_table2 -POSTHOOK: query: create table small_table2 stored -as orc as select pmod(ctinyint, 16) as cmodtinyint, cbigint from alltypesorc limit 100 -POSTHOOK: type: CREATETABLE_AS_SELECT -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: database:default -POSTHOOK: Output: default@small_table2 -POSTHOOK: Lineage: small_table2.cbigint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cbigint, type:bigint, comment:null), ] -POSTHOOK: Lineage: small_table2.cmodtinyint EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctinyint, type:tinyint, comment:null), ] -PREHOOK: query: ANALYZE TABLE small_table2 COMPUTE STATISTICS -PREHOOK: type: QUERY -PREHOOK: Input: default@small_table2 -PREHOOK: Output: default@small_table2 -POSTHOOK: query: ANALYZE TABLE small_table2 COMPUTE STATISTICS -POSTHOOK: type: QUERY -POSTHOOK: Input: default@small_table2 -POSTHOOK: Output: default@small_table2 -PREHOOK: query: ANALYZE TABLE small_table2 COMPUTE STATISTICS FOR COLUMNS -PREHOOK: type: QUERY -PREHOOK: Input: default@small_table2 -#### A masked pattern was here #### -POSTHOOK: query: ANALYZE TABLE small_table2 COMPUTE STATISTICS FOR COLUMNS -POSTHOOK: type: QUERY -POSTHOOK: Input: default@small_table2 -#### A masked pattern was here #### -PREHOOK: query: explain -select count(*) from (select s.*, st.* -from mod_8_mod_4 s -left outer join small_table2 st -on s.cmodtinyint = st.cmodtinyint -) t1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select count(*) from (select s.*, st.* -from mod_8_mod_4 s -left outer join small_table2 st -on s.cmodtinyint = st.cmodtinyint -) t1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 1 <- Map 3 (BROADCAST_EDGE) - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: s - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: cmodtinyint (type: int) - outputColumnNames: _col0 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - keys: - 0 _col0 (type: int) - 1 _col0 (type: int) - input vertices: - 1 Map 3 - Statistics: Num rows: 6663 Data size: 53310 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: bigint) - Execution mode: vectorized - Map 3 - Map Operator Tree: - TableScan - alias: st - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: cmodtinyint (type: int) - outputColumnNames: _col0 - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Reducer 2 - Execution mode: vectorized - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from (select s.*, st.* -from mod_8_mod_4 s -left outer join small_table2 st -on s.cmodtinyint = st.cmodtinyint -) t1 -PREHOOK: type: QUERY -PREHOOK: Input: default@mod_8_mod_4 -PREHOOK: Input: default@small_table2 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from (select s.*, st.* -from mod_8_mod_4 s -left outer join small_table2 st -on s.cmodtinyint = st.cmodtinyint -) t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@mod_8_mod_4 -POSTHOOK: Input: default@small_table2 -#### A masked pattern was here #### -39112 -PREHOOK: query: explain -select count(*) from (select s.cmodtinyint, s.cmodint, sm.cbigint -from mod_8_mod_4 s -left outer join small_table2 sm -on s.cmodtinyint = sm.cmodtinyint and s.cmodint = 2 -) t1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select count(*) from (select s.cmodtinyint, s.cmodint, sm.cbigint -from mod_8_mod_4 s -left outer join small_table2 sm -on s.cmodtinyint = sm.cmodtinyint and s.cmodint = 2 -) t1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 1 <- Map 3 (BROADCAST_EDGE) - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: s - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: cmodtinyint (type: int), cmodint (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - filter predicates: - 0 {(_col1 = 2)} - 1 - keys: - 0 _col0 (type: int) - 1 _col0 (type: int) - input vertices: - 1 Map 3 - Statistics: Num rows: 6663 Data size: 53310 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: bigint) - Execution mode: vectorized - Map 3 - Map Operator Tree: - TableScan - alias: sm - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: cmodtinyint (type: int) - outputColumnNames: _col0 - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Reducer 2 - Execution mode: vectorized - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from (select s.cmodtinyint, s.cmodint, sm.cbigint -from mod_8_mod_4 s -left outer join small_table2 sm -on s.cmodtinyint = sm.cmodtinyint and s.cmodint = 2 -) t1 -PREHOOK: type: QUERY -PREHOOK: Input: default@mod_8_mod_4 -PREHOOK: Input: default@small_table2 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from (select s.cmodtinyint, s.cmodint, sm.cbigint -from mod_8_mod_4 s -left outer join small_table2 sm -on s.cmodtinyint = sm.cmodtinyint and s.cmodint = 2 -) t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@mod_8_mod_4 -POSTHOOK: Input: default@small_table2 -#### A masked pattern was here #### -11171 -PREHOOK: query: explain -select count(*) from (select s.cmodtinyint, s.cmodint, sm.cbigint -from mod_8_mod_4 s -left outer join small_table2 sm -on s.cmodtinyint = sm.cmodtinyint and pmod(s.cmodtinyint, 4) = s.cmodint -) t1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select count(*) from (select s.cmodtinyint, s.cmodint, sm.cbigint -from mod_8_mod_4 s -left outer join small_table2 sm -on s.cmodtinyint = sm.cmodtinyint and pmod(s.cmodtinyint, 4) = s.cmodint -) t1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 1 <- Map 3 (BROADCAST_EDGE) - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: s - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: cmodtinyint (type: int), cmodint (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - filter predicates: - 0 {((_col0 pmod 4) = _col1)} - 1 - keys: - 0 _col0 (type: int) - 1 _col0 (type: int) - input vertices: - 1 Map 3 - Statistics: Num rows: 6663 Data size: 53310 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: bigint) - Execution mode: vectorized - Map 3 - Map Operator Tree: - TableScan - alias: sm - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: cmodtinyint (type: int) - outputColumnNames: _col0 - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Reducer 2 - Execution mode: vectorized - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from (select s.cmodtinyint, s.cmodint, sm.cbigint -from mod_8_mod_4 s -left outer join small_table2 sm -on s.cmodtinyint = sm.cmodtinyint and pmod(s.cmodtinyint, 4) = s.cmodint -) t1 -PREHOOK: type: QUERY -PREHOOK: Input: default@mod_8_mod_4 -PREHOOK: Input: default@small_table2 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from (select s.cmodtinyint, s.cmodint, sm.cbigint -from mod_8_mod_4 s -left outer join small_table2 sm -on s.cmodtinyint = sm.cmodtinyint and pmod(s.cmodtinyint, 4) = s.cmodint -) t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@mod_8_mod_4 -POSTHOOK: Input: default@small_table2 -#### A masked pattern was here #### -14371 -PREHOOK: query: explain -select count(*) from (select s.cmodtinyint, s.cmodint, sm.cbigint -from mod_8_mod_4 s -left outer join small_table2 sm -on s.cmodtinyint = sm.cmodtinyint and s.cmodtinyint < 3 -) t1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select count(*) from (select s.cmodtinyint, s.cmodint, sm.cbigint -from mod_8_mod_4 s -left outer join small_table2 sm -on s.cmodtinyint = sm.cmodtinyint and s.cmodtinyint < 3 -) t1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 1 <- Map 3 (BROADCAST_EDGE) - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: s - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: cmodtinyint (type: int) - outputColumnNames: _col0 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - filter predicates: - 0 {(_col0 < 3)} - 1 - keys: - 0 _col0 (type: int) - 1 _col0 (type: int) - input vertices: - 1 Map 3 - Statistics: Num rows: 6663 Data size: 53310 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: bigint) - Execution mode: vectorized - Map 3 - Map Operator Tree: - TableScan - alias: sm - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: cmodtinyint (type: int) - outputColumnNames: _col0 - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Reducer 2 - Execution mode: vectorized - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from (select s.cmodtinyint, s.cmodint, sm.cbigint -from mod_8_mod_4 s -left outer join small_table2 sm -on s.cmodtinyint = sm.cmodtinyint and s.cmodtinyint < 3 -) t1 -PREHOOK: type: QUERY -PREHOOK: Input: default@mod_8_mod_4 -PREHOOK: Input: default@small_table2 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from (select s.cmodtinyint, s.cmodint, sm.cbigint -from mod_8_mod_4 s -left outer join small_table2 sm -on s.cmodtinyint = sm.cmodtinyint and s.cmodtinyint < 3 -) t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@mod_8_mod_4 -POSTHOOK: Input: default@small_table2 -#### A masked pattern was here #### -17792 -PREHOOK: query: explain -select count(*) from (select s.*, sm.*, s2.* -from mod_8_mod_4 s -left outer join small_table2 sm - on pmod(sm.cbigint, 8) = s.cmodint -left outer join mod_8_mod_4 s2 - on s2.cmodtinyint = s.cmodtinyint -) t1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select count(*) from (select s.*, sm.*, s2.* -from mod_8_mod_4 s -left outer join small_table2 sm - on pmod(sm.cbigint, 8) = s.cmodint -left outer join mod_8_mod_4 s2 - on s2.cmodtinyint = s.cmodtinyint -) t1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 1 <- Map 4 (BROADCAST_EDGE) - Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 5 (SIMPLE_EDGE) - Reducer 3 <- Reducer 2 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: s - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: cmodtinyint (type: int), cmodint (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - keys: - 0 UDFToLong(_col1) (type: bigint) - 1 (_col0 pmod 8) (type: bigint) - outputColumnNames: _col0 - input vertices: - 1 Map 4 - Statistics: Num rows: 6663 Data size: 53310 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 6663 Data size: 53310 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Map 4 - Map Operator Tree: - TableScan - alias: sm - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: cbigint (type: bigint) - outputColumnNames: _col0 - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: (_col0 pmod 8) (type: bigint) - sort order: + - Map-reduce partition columns: (_col0 pmod 8) (type: bigint) - Statistics: Num rows: 100 Data size: 392 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Map 5 - Map Operator Tree: - TableScan - alias: s2 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: cmodtinyint (type: int) - outputColumnNames: _col0 - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 6058 Data size: 48464 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - Reducer 2 - Reduce Operator Tree: - Merge Join Operator - condition map: - Left Outer Join0 to 1 - keys: - 0 _col0 (type: int) - 1 _col0 (type: int) - Statistics: Num rows: 7329 Data size: 58641 Basic stats: COMPLETE Column stats: NONE - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: bigint) - Reducer 3 - Execution mode: vectorized - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from (select s.*, sm.*, s2.* -from mod_8_mod_4 s -left outer join small_table2 sm - on pmod(sm.cbigint, 8) = s.cmodint -left outer join mod_8_mod_4 s2 - on s2.cmodtinyint = s.cmodtinyint -) t1 -PREHOOK: type: QUERY -PREHOOK: Input: default@mod_8_mod_4 -PREHOOK: Input: default@small_table2 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from (select s.*, sm.*, s2.* -from mod_8_mod_4 s -left outer join small_table2 sm - on pmod(sm.cbigint, 8) = s.cmodint -left outer join mod_8_mod_4 s2 - on s2.cmodtinyint = s.cmodtinyint -) t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@mod_8_mod_4 -POSTHOOK: Input: default@small_table2 -#### A masked pattern was here #### -6524438
http://git-wip-us.apache.org/repos/asf/hive/blob/62a3778e/ql/src/test/results/clientpositive/tez/vector_outer_join6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_outer_join6.q.out b/ql/src/test/results/clientpositive/tez/vector_outer_join6.q.out deleted file mode 100644 index 517de4e..0000000 --- a/ql/src/test/results/clientpositive/tez/vector_outer_join6.q.out +++ /dev/null @@ -1,367 +0,0 @@ -PREHOOK: query: create table TJOIN1_txt (RNUM int , C1 int, C2 int) -ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@TJOIN1_txt -POSTHOOK: query: create table TJOIN1_txt (RNUM int , C1 int, C2 int) -ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@TJOIN1_txt -PREHOOK: query: create table TJOIN2_txt (RNUM int , C1 int, C2 char(2)) -ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@TJOIN2_txt -POSTHOOK: query: create table TJOIN2_txt (RNUM int , C1 int, C2 char(2)) -ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@TJOIN2_txt -PREHOOK: query: create table if not exists TJOIN3_txt (RNUM int , C1 int, C2 char(2)) -ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@TJOIN3_txt -POSTHOOK: query: create table if not exists TJOIN3_txt (RNUM int , C1 int, C2 char(2)) -ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@TJOIN3_txt -PREHOOK: query: create table TJOIN4_txt (RNUM int , C1 int, C2 char(2)) -ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@TJOIN4_txt -POSTHOOK: query: create table TJOIN4_txt (RNUM int , C1 int, C2 char(2)) -ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@TJOIN4_txt -PREHOOK: query: load data local inpath '../../data/files/TJOIN1' into table TJOIN1_txt -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@tjoin1_txt -POSTHOOK: query: load data local inpath '../../data/files/TJOIN1' into table TJOIN1_txt -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@tjoin1_txt -PREHOOK: query: load data local inpath '../../data/files/TJOIN2' into table TJOIN2_txt -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@tjoin2_txt -POSTHOOK: query: load data local inpath '../../data/files/TJOIN2' into table TJOIN2_txt -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@tjoin2_txt -PREHOOK: query: load data local inpath '../../data/files/TJOIN3' into table TJOIN3_txt -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@tjoin3_txt -POSTHOOK: query: load data local inpath '../../data/files/TJOIN3' into table TJOIN3_txt -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@tjoin3_txt -PREHOOK: query: load data local inpath '../../data/files/TJOIN4' into table TJOIN4_txt -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@tjoin4_txt -POSTHOOK: query: load data local inpath '../../data/files/TJOIN4' into table TJOIN4_txt -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@tjoin4_txt -PREHOOK: query: create table TJOIN1 stored as orc AS SELECT * FROM TJOIN1_txt -PREHOOK: type: CREATETABLE_AS_SELECT -PREHOOK: Input: default@tjoin1_txt -PREHOOK: Output: database:default -PREHOOK: Output: default@TJOIN1 -POSTHOOK: query: create table TJOIN1 stored as orc AS SELECT * FROM TJOIN1_txt -POSTHOOK: type: CREATETABLE_AS_SELECT -POSTHOOK: Input: default@tjoin1_txt -POSTHOOK: Output: database:default -POSTHOOK: Output: default@TJOIN1 -POSTHOOK: Lineage: tjoin1.c1 SIMPLE [(tjoin1_txt)tjoin1_txt.FieldSchema(name:c1, type:int, comment:null), ] -POSTHOOK: Lineage: tjoin1.c2 SIMPLE [(tjoin1_txt)tjoin1_txt.FieldSchema(name:c2, type:int, comment:null), ] -POSTHOOK: Lineage: tjoin1.rnum SIMPLE [(tjoin1_txt)tjoin1_txt.FieldSchema(name:rnum, type:int, comment:null), ] -PREHOOK: query: create table TJOIN2 stored as orc AS SELECT * FROM TJOIN2_txt -PREHOOK: type: CREATETABLE_AS_SELECT -PREHOOK: Input: default@tjoin2_txt -PREHOOK: Output: database:default -PREHOOK: Output: default@TJOIN2 -POSTHOOK: query: create table TJOIN2 stored as orc AS SELECT * FROM TJOIN2_txt -POSTHOOK: type: CREATETABLE_AS_SELECT -POSTHOOK: Input: default@tjoin2_txt -POSTHOOK: Output: database:default -POSTHOOK: Output: default@TJOIN2 -POSTHOOK: Lineage: tjoin2.c1 SIMPLE [(tjoin2_txt)tjoin2_txt.FieldSchema(name:c1, type:int, comment:null), ] -POSTHOOK: Lineage: tjoin2.c2 SIMPLE [(tjoin2_txt)tjoin2_txt.FieldSchema(name:c2, type:char(2), comment:null), ] -POSTHOOK: Lineage: tjoin2.rnum SIMPLE [(tjoin2_txt)tjoin2_txt.FieldSchema(name:rnum, type:int, comment:null), ] -PREHOOK: query: create table TJOIN3 stored as orc AS SELECT * FROM TJOIN3_txt -PREHOOK: type: CREATETABLE_AS_SELECT -PREHOOK: Input: default@tjoin3_txt -PREHOOK: Output: database:default -PREHOOK: Output: default@TJOIN3 -POSTHOOK: query: create table TJOIN3 stored as orc AS SELECT * FROM TJOIN3_txt -POSTHOOK: type: CREATETABLE_AS_SELECT -POSTHOOK: Input: default@tjoin3_txt -POSTHOOK: Output: database:default -POSTHOOK: Output: default@TJOIN3 -POSTHOOK: Lineage: tjoin3.c1 SIMPLE [(tjoin3_txt)tjoin3_txt.FieldSchema(name:c1, type:int, comment:null), ] -POSTHOOK: Lineage: tjoin3.c2 SIMPLE [(tjoin3_txt)tjoin3_txt.FieldSchema(name:c2, type:char(2), comment:null), ] -POSTHOOK: Lineage: tjoin3.rnum SIMPLE [(tjoin3_txt)tjoin3_txt.FieldSchema(name:rnum, type:int, comment:null), ] -PREHOOK: query: create table TJOIN4 stored as orc AS SELECT * FROM TJOIN4_txt -PREHOOK: type: CREATETABLE_AS_SELECT -PREHOOK: Input: default@tjoin4_txt -PREHOOK: Output: database:default -PREHOOK: Output: default@TJOIN4 -POSTHOOK: query: create table TJOIN4 stored as orc AS SELECT * FROM TJOIN4_txt -POSTHOOK: type: CREATETABLE_AS_SELECT -POSTHOOK: Input: default@tjoin4_txt -POSTHOOK: Output: database:default -POSTHOOK: Output: default@TJOIN4 -POSTHOOK: Lineage: tjoin4.c1 SIMPLE [(tjoin4_txt)tjoin4_txt.FieldSchema(name:c1, type:int, comment:null), ] -POSTHOOK: Lineage: tjoin4.c2 SIMPLE [(tjoin4_txt)tjoin4_txt.FieldSchema(name:c2, type:char(2), comment:null), ] -POSTHOOK: Lineage: tjoin4.rnum SIMPLE [(tjoin4_txt)tjoin4_txt.FieldSchema(name:rnum, type:int, comment:null), ] -PREHOOK: query: explain -select tj1rnum, tj2rnum, tjoin3.rnum as rnumt3 from - (select tjoin1.rnum tj1rnum, tjoin2.rnum tj2rnum, tjoin2.c1 tj2c1 from tjoin1 left outer join tjoin2 on tjoin1.c1 = tjoin2.c1 ) tj left outer join tjoin3 on tj2c1 = tjoin3.c1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select tj1rnum, tj2rnum, tjoin3.rnum as rnumt3 from - (select tjoin1.rnum tj1rnum, tjoin2.rnum tj2rnum, tjoin2.c1 tj2c1 from tjoin1 left outer join tjoin2 on tjoin1.c1 = tjoin2.c1 ) tj left outer join tjoin3 on tj2c1 = tjoin3.c1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 1 <- Map 2 (BROADCAST_EDGE), Map 3 (BROADCAST_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: tjoin1 - Statistics: Num rows: 3 Data size: 32 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: rnum (type: int), c1 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 32 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - keys: - 0 _col1 (type: int) - 1 _col1 (type: int) - outputColumnNames: _col0, _col2, _col3 - input vertices: - 1 Map 2 - Statistics: Num rows: 4 Data size: 409 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Select Operator - expressions: _col0 (type: int), _col2 (type: int), _col3 (type: int) - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 4 Data size: 409 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - keys: - 0 _col2 (type: int) - 1 _col1 (type: int) - outputColumnNames: _col0, _col1, _col3 - input vertices: - 1 Map 3 - Statistics: Num rows: 4 Data size: 449 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Select Operator - expressions: _col0 (type: int), _col1 (type: int), _col3 (type: int) - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 4 Data size: 449 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 4 Data size: 449 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - Execution mode: vectorized - Map 2 - Map Operator Tree: - TableScan - alias: tjoin2 - Statistics: Num rows: 4 Data size: 372 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: rnum (type: int), c1 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 4 Data size: 372 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col1 (type: int) - sort order: + - Map-reduce partition columns: _col1 (type: int) - Statistics: Num rows: 4 Data size: 372 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: int) - Execution mode: vectorized - Map 3 - Map Operator Tree: - TableScan - alias: tjoin3 - Statistics: Num rows: 2 Data size: 188 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: rnum (type: int), c1 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 2 Data size: 188 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col1 (type: int) - sort order: + - Map-reduce partition columns: _col1 (type: int) - Statistics: Num rows: 2 Data size: 188 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: int) - Execution mode: vectorized - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select tj1rnum, tj2rnum, tjoin3.rnum as rnumt3 from - (select tjoin1.rnum tj1rnum, tjoin2.rnum tj2rnum, tjoin2.c1 tj2c1 from tjoin1 left outer join tjoin2 on tjoin1.c1 = tjoin2.c1 ) tj left outer join tjoin3 on tj2c1 = tjoin3.c1 -PREHOOK: type: QUERY -PREHOOK: Input: default@tjoin1 -PREHOOK: Input: default@tjoin2 -PREHOOK: Input: default@tjoin3 -#### A masked pattern was here #### -POSTHOOK: query: select tj1rnum, tj2rnum, tjoin3.rnum as rnumt3 from - (select tjoin1.rnum tj1rnum, tjoin2.rnum tj2rnum, tjoin2.c1 tj2c1 from tjoin1 left outer join tjoin2 on tjoin1.c1 = tjoin2.c1 ) tj left outer join tjoin3 on tj2c1 = tjoin3.c1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@tjoin1 -POSTHOOK: Input: default@tjoin2 -POSTHOOK: Input: default@tjoin3 -#### A masked pattern was here #### -0 0 0 -0 3 0 -1 NULL NULL -2 NULL NULL -PREHOOK: query: explain -select tj1rnum, tj2rnum as rnumt3 from - (select tjoin1.rnum tj1rnum, tjoin2.rnum tj2rnum, tjoin2.c1 tj2c1 from tjoin1 left outer join tjoin2 on tjoin1.c1 = tjoin2.c1 ) tj left outer join tjoin3 on tj2c1 = tjoin3.c1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select tj1rnum, tj2rnum as rnumt3 from - (select tjoin1.rnum tj1rnum, tjoin2.rnum tj2rnum, tjoin2.c1 tj2c1 from tjoin1 left outer join tjoin2 on tjoin1.c1 = tjoin2.c1 ) tj left outer join tjoin3 on tj2c1 = tjoin3.c1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 1 <- Map 2 (BROADCAST_EDGE), Map 3 (BROADCAST_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: tjoin1 - Statistics: Num rows: 3 Data size: 32 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: rnum (type: int), c1 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 32 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - keys: - 0 _col1 (type: int) - 1 _col1 (type: int) - outputColumnNames: _col0, _col2, _col3 - input vertices: - 1 Map 2 - Statistics: Num rows: 4 Data size: 409 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Select Operator - expressions: _col0 (type: int), _col2 (type: int), _col3 (type: int) - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 4 Data size: 409 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Left Outer Join0 to 1 - keys: - 0 _col2 (type: int) - 1 _col0 (type: int) - outputColumnNames: _col0, _col1 - input vertices: - 1 Map 3 - Statistics: Num rows: 4 Data size: 449 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - File Output Operator - compressed: false - Statistics: Num rows: 4 Data size: 449 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - Execution mode: vectorized - Map 2 - Map Operator Tree: - TableScan - alias: tjoin2 - Statistics: Num rows: 4 Data size: 372 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: rnum (type: int), c1 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 4 Data size: 372 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col1 (type: int) - sort order: + - Map-reduce partition columns: _col1 (type: int) - Statistics: Num rows: 4 Data size: 372 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: int) - Execution mode: vectorized - Map 3 - Map Operator Tree: - TableScan - alias: tjoin3 - Statistics: Num rows: 2 Data size: 188 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: c1 (type: int) - outputColumnNames: _col0 - Statistics: Num rows: 2 Data size: 188 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 2 Data size: 188 Basic stats: COMPLETE Column stats: NONE - Execution mode: vectorized - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select tj1rnum, tj2rnum as rnumt3 from - (select tjoin1.rnum tj1rnum, tjoin2.rnum tj2rnum, tjoin2.c1 tj2c1 from tjoin1 left outer join tjoin2 on tjoin1.c1 = tjoin2.c1 ) tj left outer join tjoin3 on tj2c1 = tjoin3.c1 -PREHOOK: type: QUERY -PREHOOK: Input: default@tjoin1 -PREHOOK: Input: default@tjoin2 -PREHOOK: Input: default@tjoin3 -#### A masked pattern was here #### -POSTHOOK: query: select tj1rnum, tj2rnum as rnumt3 from - (select tjoin1.rnum tj1rnum, tjoin2.rnum tj2rnum, tjoin2.c1 tj2c1 from tjoin1 left outer join tjoin2 on tjoin1.c1 = tjoin2.c1 ) tj left outer join tjoin3 on tj2c1 = tjoin3.c1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@tjoin1 -POSTHOOK: Input: default@tjoin2 -POSTHOOK: Input: default@tjoin3 -#### A masked pattern was here #### -0 0 -0 3 -1 NULL -2 NULL
