PREHOOK: query: explain select s1.key as key, s1.value as value from src s1 join src s3 on s1.key=s3.key UNION ALL select s2.key as key, s2.value as value from src s2 PREHOOK: type: QUERY POSTHOOK: query: explain select s1.key as key, s1.value as value from src s1 join src s3 on s1.key=s3.key UNION ALL select s2.key as key, s2.value as value from src s2 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Tez Edges: Map 1 <- Union 2 (CONTAINS), Map 3 (BROADCAST_EDGE) Map 4 <- Union 2 (CONTAINS) #### A masked pattern was here #### Vertices: Map 1 Map Operator Tree: TableScan alias: s1 Map Join Operator condition map: Inner Join 0 to 1 condition expressions: 0 {key} {value} 1 keys: 0 key (type: string) 1 key (type: string) outputColumnNames: _col0, _col1 Select Operator expressions: _col0 (type: string), _col1 (type: string) outputColumnNames: _col0, _col1 Select Operator expressions: _col0 (type: string), _col1 (type: string) outputColumnNames: _col0, _col1 File Output Operator compressed: false table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Map 3 Map Operator Tree: TableScan alias: s3 Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Map 4 Map Operator Tree: TableScan alias: s2 Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Select Operator expressions: _col0 (type: string), _col1 (type: string) outputColumnNames: _col0, _col1 File Output Operator compressed: false table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Union 2 Vertex: Union 2 Stage: Stage-0 Fetch Operator limit: -1 PREHOOK: query: create table ut as select s1.key as key, s1.value as value from src s1 join src s3 on s1.key=s3.key UNION ALL select s2.key as key, s2.value as value from src s2 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src POSTHOOK: query: create table ut as select s1.key as key, s1.value as value from src s1 join src s3 on s1.key=s3.key UNION ALL select s2.key as key, s2.value as value from src s2 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src POSTHOOK: Output: default@ut PREHOOK: query: select * from ut order by key, value limit 20 PREHOOK: type: QUERY PREHOOK: Input: default@ut #### A masked pattern was here #### POSTHOOK: query: select * from ut order by key, value limit 20 POSTHOOK: type: QUERY POSTHOOK: Input: default@ut #### A masked pattern was here #### 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 10 val_10 10 val_10 100 val_100 100 val_100 100 val_100 100 val_100 100 val_100 100 val_100 PREHOOK: query: drop table ut PREHOOK: type: DROPTABLE PREHOOK: Input: default@ut PREHOOK: Output: default@ut POSTHOOK: query: drop table ut POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@ut POSTHOOK: Output: default@ut PREHOOK: query: explain with u as (select * from src union all select * from src) select count(*) from (select u1.key as k1, u2.key as k2 from u as u1 join u as u2 on (u1.key = u2.key)) a PREHOOK: type: QUERY POSTHOOK: query: explain with u as (select * from src union all select * from src) select count(*) from (select u1.key as k1, u2.key as k2 from u as u1 join u as u2 on (u1.key = u2.key)) a POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Tez Edges: Map 1 <- Union 2 (CONTAINS) Map 5 <- Union 6 (CONTAINS) Map 7 <- Union 2 (CONTAINS) Map 8 <- Union 6 (CONTAINS) Reducer 3 <- Union 2 (SIMPLE_EDGE), Union 6 (SIMPLE_EDGE) Reducer 4 <- Reducer 3 (SIMPLE_EDGE) #### A masked pattern was here #### Vertices: Map 1 Map Operator Tree: TableScan alias: src Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) Map 5 Map Operator Tree: TableScan alias: src Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) Map 7 Map Operator Tree: TableScan alias: src Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) Map 8 Map Operator Tree: TableScan alias: src Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) Reducer 3 Reduce Operator Tree: Join Operator condition map: Inner Join 0 to 1 condition expressions: 0 1 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator Statistics: Num rows: 63 Data size: 12786 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 4 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 Select Operator expressions: _col0 (type: bigint) 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.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Union 2 Vertex: Union 2 Union 6 Vertex: Union 6 Stage: Stage-0 Fetch Operator limit: -1 PREHOOK: query: create table ut as with u as (select * from src union all select * from src) select count(*) as cnt from (select u1.key as k1, u2.key as k2 from u as u1 join u as u2 on (u1.key = u2.key)) a PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src POSTHOOK: query: create table ut as with u as (select * from src union all select * from src) select count(*) as cnt from (select u1.key as k1, u2.key as k2 from u as u1 join u as u2 on (u1.key = u2.key)) a POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src POSTHOOK: Output: default@ut PREHOOK: query: select * from ut order by cnt limit 20 PREHOOK: type: QUERY PREHOOK: Input: default@ut #### A masked pattern was here #### POSTHOOK: query: select * from ut order by cnt limit 20 POSTHOOK: type: QUERY POSTHOOK: Input: default@ut #### A masked pattern was here #### 4112 PREHOOK: query: drop table ut PREHOOK: type: DROPTABLE PREHOOK: Input: default@ut PREHOOK: Output: default@ut POSTHOOK: query: drop table ut POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@ut POSTHOOK: Output: default@ut PREHOOK: query: explain select s1.key as skey, u1.key as ukey from src s1 join (select * from src union all select * from src) u1 on s1.key = u1.key PREHOOK: type: QUERY POSTHOOK: query: explain select s1.key as skey, u1.key as ukey from src s1 join (select * from src union all select * from src) u1 on s1.key = u1.key POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Tez Edges: Map 2 <- Map 1 (BROADCAST_EDGE), Union 3 (CONTAINS) Map 4 <- Map 1 (BROADCAST_EDGE), Union 3 (CONTAINS) #### A masked pattern was here #### Vertices: Map 1 Map Operator Tree: TableScan alias: s1 Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE value expressions: key (type: string) Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE value expressions: key (type: string) Map 2 Map Operator Tree: TableScan alias: src Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Map Join Operator condition map: Inner Join 0 to 1 condition expressions: 0 {key} 1 {_col0} keys: 0 key (type: string) 1 _col0 (type: string) outputColumnNames: _col0, _col4 Select Operator expressions: _col0 (type: string), _col4 (type: string) outputColumnNames: _col0, _col1 File Output Operator compressed: false table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Map 4 Map Operator Tree: TableScan alias: src Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Map Join Operator condition map: Inner Join 0 to 1 condition expressions: 0 {key} 1 {_col0} keys: 0 key (type: string) 1 _col0 (type: string) outputColumnNames: _col0, _col4 Select Operator expressions: _col0 (type: string), _col4 (type: string) outputColumnNames: _col0, _col1 File Output Operator compressed: false table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Union 3 Vertex: Union 3 Stage: Stage-0 Fetch Operator limit: -1 PREHOOK: query: create table ut as select s1.key as skey, u1.key as ukey from src s1 join (select * from src union all select * from src) u1 on s1.key = u1.key PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src POSTHOOK: query: create table ut as select s1.key as skey, u1.key as ukey from src s1 join (select * from src union all select * from src) u1 on s1.key = u1.key POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src POSTHOOK: Output: default@ut PREHOOK: query: select * from ut order by skey, ukey limit 20 PREHOOK: type: QUERY PREHOOK: Input: default@ut #### A masked pattern was here #### POSTHOOK: query: select * from ut order by skey, ukey limit 20 POSTHOOK: type: QUERY POSTHOOK: Input: default@ut #### A masked pattern was here #### 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 10 10 10 PREHOOK: query: drop table ut PREHOOK: type: DROPTABLE PREHOOK: Input: default@ut PREHOOK: Output: default@ut POSTHOOK: query: drop table ut POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@ut POSTHOOK: Output: default@ut PREHOOK: query: explain select s1.key as skey, u1.key as ukey, s8.key as lkey from src s1 join (select s2.key as key from src s2 join src s3 on s2.key = s3.key union all select s4.key from src s4 join src s5 on s4.key = s5.key union all select s6.key from src s6 join src s7 on s6.key = s7.key) u1 on (s1.key = u1.key) join src s8 on (u1.key = s8.key) order by lkey PREHOOK: type: QUERY POSTHOOK: query: explain select s1.key as skey, u1.key as ukey, s8.key as lkey from src s1 join (select s2.key as key from src s2 join src s3 on s2.key = s3.key union all select s4.key from src s4 join src s5 on s4.key = s5.key union all select s6.key from src s6 join src s7 on s6.key = s7.key) u1 on (s1.key = u1.key) join src s8 on (u1.key = s8.key) order by lkey POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Tez Edges: Map 2 <- Map 1 (BROADCAST_EDGE), Union 3 (CONTAINS), Map 5 (BROADCAST_EDGE), Map 8 (BROADCAST_EDGE) Map 7 <- Map 1 (BROADCAST_EDGE), Map 6 (BROADCAST_EDGE), Union 3 (CONTAINS), Map 8 (BROADCAST_EDGE) Map 9 <- Map 1 (BROADCAST_EDGE), Map 8 (BROADCAST_EDGE), Union 3 (CONTAINS), Map 10 (BROADCAST_EDGE) Reducer 4 <- Union 3 (SIMPLE_EDGE) #### A masked pattern was here #### Vertices: Map 1 Map Operator Tree: TableScan alias: s1 Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE value expressions: key (type: string) Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE value expressions: key (type: string) Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE value expressions: key (type: string) Map 10 Map Operator Tree: TableScan alias: s5 Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Map 2 Map Operator Tree: TableScan alias: s2 Map Join Operator condition map: Inner Join 0 to 1 condition expressions: 0 {key} 1 keys: 0 key (type: string) 1 key (type: string) outputColumnNames: _col0 Select Operator expressions: _col0 (type: string) outputColumnNames: _col0 Map Join Operator condition map: Inner Join 0 to 1 Inner Join 1 to 2 condition expressions: 0 {key} 1 {_col0} 2 {key} keys: 0 key (type: string) 1 _col0 (type: string) 2 key (type: string) outputColumnNames: _col0, _col4, _col5 Select Operator expressions: _col0 (type: string), _col4 (type: string), _col5 (type: string) outputColumnNames: _col0, _col1, _col2 Reduce Output Operator key expressions: _col2 (type: string) sort order: + value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) Map 5 Map Operator Tree: TableScan alias: s3 Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Map 6 Map Operator Tree: TableScan alias: s7 Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Map 7 Map Operator Tree: TableScan alias: s6 Map Join Operator condition map: Inner Join 0 to 1 condition expressions: 0 {key} 1 keys: 0 key (type: string) 1 key (type: string) outputColumnNames: _col0 Select Operator expressions: _col0 (type: string) outputColumnNames: _col0 Map Join Operator condition map: Inner Join 0 to 1 Inner Join 1 to 2 condition expressions: 0 {key} 1 {_col0} 2 {key} keys: 0 key (type: string) 1 _col0 (type: string) 2 key (type: string) outputColumnNames: _col0, _col4, _col5 Select Operator expressions: _col0 (type: string), _col4 (type: string), _col5 (type: string) outputColumnNames: _col0, _col1, _col2 Reduce Output Operator key expressions: _col2 (type: string) sort order: + value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) Map 8 Map Operator Tree: TableScan alias: s8 Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE value expressions: key (type: string) Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE value expressions: key (type: string) Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE value expressions: key (type: string) Map 9 Map Operator Tree: TableScan alias: s4 Map Join Operator condition map: Inner Join 0 to 1 condition expressions: 0 {key} 1 keys: 0 key (type: string) 1 key (type: string) outputColumnNames: _col0 Select Operator expressions: _col0 (type: string) outputColumnNames: _col0 Map Join Operator condition map: Inner Join 0 to 1 Inner Join 1 to 2 condition expressions: 0 {key} 1 {_col0} 2 {key} keys: 0 key (type: string) 1 _col0 (type: string) 2 key (type: string) outputColumnNames: _col0, _col4, _col5 Select Operator expressions: _col0 (type: string), _col4 (type: string), _col5 (type: string) outputColumnNames: _col0, _col1, _col2 Reduce Output Operator key expressions: _col2 (type: string) sort order: + value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) Reducer 4 Reduce Operator Tree: Extract Statistics: Num rows: 415 Data size: 42193 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 415 Data size: 42193 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Union 3 Vertex: Union 3 Stage: Stage-0 Fetch Operator limit: -1 PREHOOK: query: create table ut as select s1.key as skey, u1.key as ukey, s8.key as lkey from src s1 join (select s2.key as key from src s2 join src s3 on s2.key = s3.key union all select s4.key from src s4 join src s5 on s4.key = s5.key union all select s6.key from src s6 join src s7 on s6.key = s7.key) u1 on (s1.key = u1.key) join src s8 on (u1.key = s8.key) order by lkey PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src POSTHOOK: query: create table ut as select s1.key as skey, u1.key as ukey, s8.key as lkey from src s1 join (select s2.key as key from src s2 join src s3 on s2.key = s3.key union all select s4.key from src s4 join src s5 on s4.key = s5.key union all select s6.key from src s6 join src s7 on s6.key = s7.key) u1 on (s1.key = u1.key) join src s8 on (u1.key = s8.key) order by lkey POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src POSTHOOK: Output: default@ut PREHOOK: query: select * from ut order by skey, ukey, lkey limit 100 PREHOOK: type: QUERY PREHOOK: Input: default@ut #### A masked pattern was here #### POSTHOOK: query: select * from ut order by skey, ukey, lkey limit 100 POSTHOOK: type: QUERY POSTHOOK: Input: default@ut #### A masked pattern was here #### 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 PREHOOK: query: drop table ut PREHOOK: type: DROPTABLE PREHOOK: Input: default@ut PREHOOK: Output: default@ut POSTHOOK: query: drop table ut POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@ut POSTHOOK: Output: default@ut PREHOOK: query: explain select s2.key as key from src s2 join src s3 on s2.key = s3.key union all select s4.key from src s4 join src s5 on s4.key = s5.key PREHOOK: type: QUERY POSTHOOK: query: explain select s2.key as key from src s2 join src s3 on s2.key = s3.key union all select s4.key from src s4 join src s5 on s4.key = s5.key POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Tez Edges: Map 1 <- Union 2 (CONTAINS), Map 3 (BROADCAST_EDGE) Map 4 <- Union 2 (CONTAINS), Map 5 (BROADCAST_EDGE) #### A masked pattern was here #### Vertices: Map 1 Map Operator Tree: TableScan alias: s2 Map Join Operator condition map: Inner Join 0 to 1 condition expressions: 0 {key} 1 keys: 0 key (type: string) 1 key (type: string) outputColumnNames: _col0 Select Operator expressions: _col0 (type: string) outputColumnNames: _col0 Select Operator expressions: _col0 (type: string) outputColumnNames: _col0 File Output Operator compressed: false table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Map 3 Map Operator Tree: TableScan alias: s3 Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Map 4 Map Operator Tree: TableScan alias: s4 Map Join Operator condition map: Inner Join 0 to 1 condition expressions: 0 {key} 1 keys: 0 key (type: string) 1 key (type: string) outputColumnNames: _col0 Select Operator expressions: _col0 (type: string) outputColumnNames: _col0 Select Operator expressions: _col0 (type: string) outputColumnNames: _col0 File Output Operator compressed: false table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Map 5 Map Operator Tree: TableScan alias: s5 Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Union 2 Vertex: Union 2 Stage: Stage-0 Fetch Operator limit: -1 PREHOOK: query: create table ut as select s2.key as key from src s2 join src s3 on s2.key = s3.key union all select s4.key from src s4 join src s5 on s4.key = s5.key PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src POSTHOOK: query: create table ut as select s2.key as key from src s2 join src s3 on s2.key = s3.key union all select s4.key from src s4 join src s5 on s4.key = s5.key POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src POSTHOOK: Output: default@ut PREHOOK: query: select * from ut order by key limit 30 PREHOOK: type: QUERY PREHOOK: Input: default@ut #### A masked pattern was here #### POSTHOOK: query: select * from ut order by key limit 30 POSTHOOK: type: QUERY POSTHOOK: Input: default@ut #### A masked pattern was here #### 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 10 100 100 100 100 100 100 100 100 103 103 PREHOOK: query: drop table ut PREHOOK: type: DROPTABLE PREHOOK: Input: default@ut PREHOOK: Output: default@ut POSTHOOK: query: drop table ut POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@ut POSTHOOK: Output: default@ut PREHOOK: query: explain select * from (select * from src union all select * from src) u left outer join src s on u.key = s.key PREHOOK: type: QUERY POSTHOOK: query: explain select * from (select * from src union all select * from src) u left outer join src s on u.key = s.key POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Tez Edges: Map 1 <- Union 2 (CONTAINS), Map 3 (BROADCAST_EDGE) Map 4 <- Map 3 (BROADCAST_EDGE), Union 2 (CONTAINS) #### A masked pattern was here #### Vertices: Map 1 Map Operator Tree: TableScan alias: src Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Map Join Operator condition map: Left Outer Join0 to 1 condition expressions: 0 {_col0} {_col1} 1 {key} {value} keys: 0 _col0 (type: string) 1 key (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Select Operator expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 File Output Operator compressed: false table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Map 3 Map Operator Tree: TableScan alias: s Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE value expressions: key (type: string), value (type: string) Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE value expressions: key (type: string), value (type: string) Map 4 Map Operator Tree: TableScan alias: src Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Map Join Operator condition map: Left Outer Join0 to 1 condition expressions: 0 {_col0} {_col1} 1 {key} {value} keys: 0 _col0 (type: string) 1 key (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Select Operator expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 File Output Operator compressed: false table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Union 2 Vertex: Union 2 Stage: Stage-0 Fetch Operator limit: -1 PREHOOK: query: explain select u.key as ukey, s.key as skey from (select * from src union all select * from src) u right outer join src s on u.key = s.key PREHOOK: type: QUERY POSTHOOK: query: explain select u.key as ukey, s.key as skey from (select * from src union all select * from src) u right outer join src s on u.key = s.key POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Tez Edges: Map 1 <- Union 2 (CONTAINS) Map 3 <- Union 2 (BROADCAST_EDGE) Map 4 <- Union 2 (CONTAINS) #### A masked pattern was here #### Vertices: Map 1 Map Operator Tree: TableScan alias: src Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) value expressions: _col0 (type: string) Map 3 Map Operator Tree: TableScan alias: s Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Right Outer Join0 to 1 condition expressions: 0 {_col0} 1 {key} keys: 0 _col0 (type: string) 1 key (type: string) outputColumnNames: _col0, _col2 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Map 4 Map Operator Tree: TableScan alias: src Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) value expressions: _col0 (type: string) Union 2 Vertex: Union 2 Stage: Stage-0 Fetch Operator limit: -1 PREHOOK: query: create table ut as select u.key as ukey, s.key as skey from (select * from src union all select * from src) u right outer join src s on u.key = s.key PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src POSTHOOK: query: create table ut as select u.key as ukey, s.key as skey from (select * from src union all select * from src) u right outer join src s on u.key = s.key POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src POSTHOOK: Output: default@ut PREHOOK: query: select * from ut order by ukey, skey limit 20 PREHOOK: type: QUERY PREHOOK: Input: default@ut #### A masked pattern was here #### POSTHOOK: query: select * from ut order by ukey, skey limit 20 POSTHOOK: type: QUERY POSTHOOK: Input: default@ut #### A masked pattern was here #### 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 10 10 10 PREHOOK: query: drop table ut PREHOOK: type: DROPTABLE PREHOOK: Input: default@ut PREHOOK: Output: default@ut POSTHOOK: query: drop table ut POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@ut POSTHOOK: Output: default@ut