http://git-wip-us.apache.org/repos/asf/hive/blob/62a3778e/ql/src/test/results/clientpositive/llap/cross_prod_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/cross_prod_1.q.out b/ql/src/test/results/clientpositive/llap/cross_prod_1.q.out deleted file mode 100644 index 969f4c6..0000000 --- a/ql/src/test/results/clientpositive/llap/cross_prod_1.q.out +++ /dev/null @@ -1,2208 +0,0 @@ -PREHOOK: query: create table X as -select distinct * from src order by key limit 10 -PREHOOK: type: CREATETABLE_AS_SELECT -PREHOOK: Input: default@src -PREHOOK: Output: database:default -PREHOOK: Output: default@X -POSTHOOK: query: create table X as -select distinct * from src order by key limit 10 -POSTHOOK: type: CREATETABLE_AS_SELECT -POSTHOOK: Input: default@src -POSTHOOK: Output: database:default -POSTHOOK: Output: default@X -POSTHOOK: Lineage: x.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: x.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -Warning: Shuffle Join MERGEJOIN[9][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: explain select * from X as A, X as B -PREHOOK: type: QUERY -POSTHOOK: query: explain select * from X as A, X as B -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: - Reducer 2 <- Map 1 (XPROD_EDGE), Map 3 (XPROD_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Map 3 - Map Operator Tree: - TableScan - alias: b - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Merge Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 - 1 - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 100 Data size: 2140 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 100 Data size: 2140 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 - -Warning: Shuffle Join MERGEJOIN[9][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: select * from X as A, X as B -PREHOOK: type: QUERY -PREHOOK: Input: default@x -#### A masked pattern was here #### -POSTHOOK: query: select * from X as A, X as B -POSTHOOK: type: QUERY -POSTHOOK: Input: default@x -#### A masked pattern was here #### -0 val_0 0 val_0 -0 val_0 10 val_10 -0 val_0 100 val_100 -0 val_0 103 val_103 -0 val_0 104 val_104 -0 val_0 105 val_105 -0 val_0 11 val_11 -0 val_0 111 val_111 -0 val_0 113 val_113 -0 val_0 114 val_114 -10 val_10 0 val_0 -10 val_10 10 val_10 -10 val_10 100 val_100 -10 val_10 103 val_103 -10 val_10 104 val_104 -10 val_10 105 val_105 -10 val_10 11 val_11 -10 val_10 111 val_111 -10 val_10 113 val_113 -10 val_10 114 val_114 -100 val_100 0 val_0 -100 val_100 10 val_10 -100 val_100 100 val_100 -100 val_100 103 val_103 -100 val_100 104 val_104 -100 val_100 105 val_105 -100 val_100 11 val_11 -100 val_100 111 val_111 -100 val_100 113 val_113 -100 val_100 114 val_114 -103 val_103 0 val_0 -103 val_103 10 val_10 -103 val_103 100 val_100 -103 val_103 103 val_103 -103 val_103 104 val_104 -103 val_103 105 val_105 -103 val_103 11 val_11 -103 val_103 111 val_111 -103 val_103 113 val_113 -103 val_103 114 val_114 -104 val_104 0 val_0 -104 val_104 10 val_10 -104 val_104 100 val_100 -104 val_104 103 val_103 -104 val_104 104 val_104 -104 val_104 105 val_105 -104 val_104 11 val_11 -104 val_104 111 val_111 -104 val_104 113 val_113 -104 val_104 114 val_114 -105 val_105 0 val_0 -105 val_105 10 val_10 -105 val_105 100 val_100 -105 val_105 103 val_103 -105 val_105 104 val_104 -105 val_105 105 val_105 -105 val_105 11 val_11 -105 val_105 111 val_111 -105 val_105 113 val_113 -105 val_105 114 val_114 -11 val_11 0 val_0 -11 val_11 10 val_10 -11 val_11 100 val_100 -11 val_11 103 val_103 -11 val_11 104 val_104 -11 val_11 105 val_105 -11 val_11 11 val_11 -11 val_11 111 val_111 -11 val_11 113 val_113 -11 val_11 114 val_114 -111 val_111 0 val_0 -111 val_111 10 val_10 -111 val_111 100 val_100 -111 val_111 103 val_103 -111 val_111 104 val_104 -111 val_111 105 val_105 -111 val_111 11 val_11 -111 val_111 111 val_111 -111 val_111 113 val_113 -111 val_111 114 val_114 -113 val_113 0 val_0 -113 val_113 10 val_10 -113 val_113 100 val_100 -113 val_113 103 val_103 -113 val_113 104 val_104 -113 val_113 105 val_105 -113 val_113 11 val_11 -113 val_113 111 val_111 -113 val_113 113 val_113 -113 val_113 114 val_114 -114 val_114 0 val_0 -114 val_114 10 val_10 -114 val_114 100 val_100 -114 val_114 103 val_103 -114 val_114 104 val_104 -114 val_114 105 val_105 -114 val_114 11 val_11 -114 val_114 111 val_111 -114 val_114 113 val_113 -114 val_114 114 val_114 -Warning: Shuffle Join MERGEJOIN[10][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: explain select * from X as A join X as B on A.key<B.key -PREHOOK: type: QUERY -POSTHOOK: query: explain select * from X as A join X as B on A.key<B.key -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: - Reducer 2 <- Map 1 (XPROD_EDGE), Map 3 (XPROD_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Map 3 - Map Operator Tree: - TableScan - alias: b - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Merge Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 - 1 - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 100 Data size: 2140 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (_col0 < _col2) (type: boolean) - Statistics: Num rows: 33 Data size: 706 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 33 Data size: 706 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 - -Warning: Shuffle Join MERGEJOIN[10][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: select * from X as A join X as B on A.key<B.key -PREHOOK: type: QUERY -PREHOOK: Input: default@x -#### A masked pattern was here #### -POSTHOOK: query: select * from X as A join X as B on A.key<B.key -POSTHOOK: type: QUERY -POSTHOOK: Input: default@x -#### A masked pattern was here #### -0 val_0 10 val_10 -0 val_0 100 val_100 -0 val_0 103 val_103 -0 val_0 104 val_104 -0 val_0 105 val_105 -0 val_0 11 val_11 -0 val_0 111 val_111 -0 val_0 113 val_113 -0 val_0 114 val_114 -10 val_10 100 val_100 -10 val_10 103 val_103 -10 val_10 104 val_104 -10 val_10 105 val_105 -10 val_10 11 val_11 -10 val_10 111 val_111 -10 val_10 113 val_113 -10 val_10 114 val_114 -100 val_100 103 val_103 -100 val_100 104 val_104 -100 val_100 105 val_105 -100 val_100 11 val_11 -100 val_100 111 val_111 -100 val_100 113 val_113 -100 val_100 114 val_114 -103 val_103 104 val_104 -103 val_103 105 val_105 -103 val_103 11 val_11 -103 val_103 111 val_111 -103 val_103 113 val_113 -103 val_103 114 val_114 -104 val_104 105 val_105 -104 val_104 11 val_11 -104 val_104 111 val_111 -104 val_104 113 val_113 -104 val_104 114 val_114 -105 val_105 11 val_11 -105 val_105 111 val_111 -105 val_105 113 val_113 -105 val_105 114 val_114 -11 val_11 111 val_111 -11 val_11 113 val_113 -11 val_11 114 val_114 -111 val_111 113 val_113 -111 val_111 114 val_114 -113 val_113 114 val_114 -Warning: Shuffle Join MERGEJOIN[10][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: explain select * from X as A join X as B on A.key between "103" and "105" -PREHOOK: type: QUERY -POSTHOOK: query: explain select * from X as A join X as B on A.key between "103" and "105" -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: - Reducer 2 <- Map 1 (XPROD_EDGE), Map 3 (XPROD_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: _col0 BETWEEN '103' AND '105' (type: boolean) - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Map 3 - Map Operator Tree: - TableScan - alias: b - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Merge Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 - 1 - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 10 Data size: 212 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 212 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 - -Warning: Shuffle Join MERGEJOIN[10][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: select * from X as A join X as B on A.key between "103" and "105" -PREHOOK: type: QUERY -PREHOOK: Input: default@x -#### A masked pattern was here #### -POSTHOOK: query: select * from X as A join X as B on A.key between "103" and "105" -POSTHOOK: type: QUERY -POSTHOOK: Input: default@x -#### A masked pattern was here #### -103 val_103 0 val_0 -103 val_103 10 val_10 -103 val_103 100 val_100 -103 val_103 103 val_103 -103 val_103 104 val_104 -103 val_103 105 val_105 -103 val_103 11 val_11 -103 val_103 111 val_111 -103 val_103 113 val_113 -103 val_103 114 val_114 -104 val_104 0 val_0 -104 val_104 10 val_10 -104 val_104 100 val_100 -104 val_104 103 val_103 -104 val_104 104 val_104 -104 val_104 105 val_105 -104 val_104 11 val_11 -104 val_104 111 val_111 -104 val_104 113 val_113 -104 val_104 114 val_114 -105 val_105 0 val_0 -105 val_105 10 val_10 -105 val_105 100 val_100 -105 val_105 103 val_103 -105 val_105 104 val_104 -105 val_105 105 val_105 -105 val_105 11 val_11 -105 val_105 111 val_111 -105 val_105 113 val_113 -105 val_105 114 val_114 -Warning: Shuffle Join MERGEJOIN[12][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: explain select * from X as A, X as B, X as C -PREHOOK: type: QUERY -POSTHOOK: query: explain select * from X as A, X as B, X as C -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: - Reducer 2 <- Map 1 (XPROD_EDGE), Map 3 (XPROD_EDGE), Map 4 (XPROD_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Map 3 - Map Operator Tree: - TableScan - alias: c - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Map 4 - Map Operator Tree: - TableScan - alias: b - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Merge Join Operator - condition map: - Inner Join 0 to 1 - Inner Join 0 to 2 - keys: - 0 - 1 - 2 - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 1000 Data size: 31600 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col2 (type: string), _col3 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 1000 Data size: 31600 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1000 Data size: 31600 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 - -Warning: Shuffle Join MERGEJOIN[12][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: select * from X as A, X as B, X as C -PREHOOK: type: QUERY -PREHOOK: Input: default@x -#### A masked pattern was here #### -POSTHOOK: query: select * from X as A, X as B, X as C -POSTHOOK: type: QUERY -POSTHOOK: Input: default@x -#### A masked pattern was here #### -0 val_0 0 val_0 0 val_0 -0 val_0 10 val_10 0 val_0 -0 val_0 100 val_100 0 val_0 -0 val_0 103 val_103 0 val_0 -0 val_0 104 val_104 0 val_0 -0 val_0 105 val_105 0 val_0 -0 val_0 11 val_11 0 val_0 -0 val_0 111 val_111 0 val_0 -0 val_0 113 val_113 0 val_0 -0 val_0 114 val_114 0 val_0 -0 val_0 0 val_0 10 val_10 -0 val_0 10 val_10 10 val_10 -0 val_0 100 val_100 10 val_10 -0 val_0 103 val_103 10 val_10 -0 val_0 104 val_104 10 val_10 -0 val_0 105 val_105 10 val_10 -0 val_0 11 val_11 10 val_10 -0 val_0 111 val_111 10 val_10 -0 val_0 113 val_113 10 val_10 -0 val_0 114 val_114 10 val_10 -0 val_0 0 val_0 100 val_100 -0 val_0 10 val_10 100 val_100 -0 val_0 100 val_100 100 val_100 -0 val_0 103 val_103 100 val_100 -0 val_0 104 val_104 100 val_100 -0 val_0 105 val_105 100 val_100 -0 val_0 11 val_11 100 val_100 -0 val_0 111 val_111 100 val_100 -0 val_0 113 val_113 100 val_100 -0 val_0 114 val_114 100 val_100 -0 val_0 0 val_0 103 val_103 -0 val_0 10 val_10 103 val_103 -0 val_0 100 val_100 103 val_103 -0 val_0 103 val_103 103 val_103 -0 val_0 104 val_104 103 val_103 -0 val_0 105 val_105 103 val_103 -0 val_0 11 val_11 103 val_103 -0 val_0 111 val_111 103 val_103 -0 val_0 113 val_113 103 val_103 -0 val_0 114 val_114 103 val_103 -0 val_0 0 val_0 104 val_104 -0 val_0 10 val_10 104 val_104 -0 val_0 100 val_100 104 val_104 -0 val_0 103 val_103 104 val_104 -0 val_0 104 val_104 104 val_104 -0 val_0 105 val_105 104 val_104 -0 val_0 11 val_11 104 val_104 -0 val_0 111 val_111 104 val_104 -0 val_0 113 val_113 104 val_104 -0 val_0 114 val_114 104 val_104 -0 val_0 0 val_0 105 val_105 -0 val_0 10 val_10 105 val_105 -0 val_0 100 val_100 105 val_105 -0 val_0 103 val_103 105 val_105 -0 val_0 104 val_104 105 val_105 -0 val_0 105 val_105 105 val_105 -0 val_0 11 val_11 105 val_105 -0 val_0 111 val_111 105 val_105 -0 val_0 113 val_113 105 val_105 -0 val_0 114 val_114 105 val_105 -0 val_0 0 val_0 11 val_11 -0 val_0 10 val_10 11 val_11 -0 val_0 100 val_100 11 val_11 -0 val_0 103 val_103 11 val_11 -0 val_0 104 val_104 11 val_11 -0 val_0 105 val_105 11 val_11 -0 val_0 11 val_11 11 val_11 -0 val_0 111 val_111 11 val_11 -0 val_0 113 val_113 11 val_11 -0 val_0 114 val_114 11 val_11 -0 val_0 0 val_0 111 val_111 -0 val_0 10 val_10 111 val_111 -0 val_0 100 val_100 111 val_111 -0 val_0 103 val_103 111 val_111 -0 val_0 104 val_104 111 val_111 -0 val_0 105 val_105 111 val_111 -0 val_0 11 val_11 111 val_111 -0 val_0 111 val_111 111 val_111 -0 val_0 113 val_113 111 val_111 -0 val_0 114 val_114 111 val_111 -0 val_0 0 val_0 113 val_113 -0 val_0 10 val_10 113 val_113 -0 val_0 100 val_100 113 val_113 -0 val_0 103 val_103 113 val_113 -0 val_0 104 val_104 113 val_113 -0 val_0 105 val_105 113 val_113 -0 val_0 11 val_11 113 val_113 -0 val_0 111 val_111 113 val_113 -0 val_0 113 val_113 113 val_113 -0 val_0 114 val_114 113 val_113 -0 val_0 0 val_0 114 val_114 -0 val_0 10 val_10 114 val_114 -0 val_0 100 val_100 114 val_114 -0 val_0 103 val_103 114 val_114 -0 val_0 104 val_104 114 val_114 -0 val_0 105 val_105 114 val_114 -0 val_0 11 val_11 114 val_114 -0 val_0 111 val_111 114 val_114 -0 val_0 113 val_113 114 val_114 -0 val_0 114 val_114 114 val_114 -10 val_10 0 val_0 0 val_0 -10 val_10 10 val_10 0 val_0 -10 val_10 100 val_100 0 val_0 -10 val_10 103 val_103 0 val_0 -10 val_10 104 val_104 0 val_0 -10 val_10 105 val_105 0 val_0 -10 val_10 11 val_11 0 val_0 -10 val_10 111 val_111 0 val_0 -10 val_10 113 val_113 0 val_0 -10 val_10 114 val_114 0 val_0 -10 val_10 0 val_0 10 val_10 -10 val_10 10 val_10 10 val_10 -10 val_10 100 val_100 10 val_10 -10 val_10 103 val_103 10 val_10 -10 val_10 104 val_104 10 val_10 -10 val_10 105 val_105 10 val_10 -10 val_10 11 val_11 10 val_10 -10 val_10 111 val_111 10 val_10 -10 val_10 113 val_113 10 val_10 -10 val_10 114 val_114 10 val_10 -10 val_10 0 val_0 100 val_100 -10 val_10 10 val_10 100 val_100 -10 val_10 100 val_100 100 val_100 -10 val_10 103 val_103 100 val_100 -10 val_10 104 val_104 100 val_100 -10 val_10 105 val_105 100 val_100 -10 val_10 11 val_11 100 val_100 -10 val_10 111 val_111 100 val_100 -10 val_10 113 val_113 100 val_100 -10 val_10 114 val_114 100 val_100 -10 val_10 0 val_0 103 val_103 -10 val_10 10 val_10 103 val_103 -10 val_10 100 val_100 103 val_103 -10 val_10 103 val_103 103 val_103 -10 val_10 104 val_104 103 val_103 -10 val_10 105 val_105 103 val_103 -10 val_10 11 val_11 103 val_103 -10 val_10 111 val_111 103 val_103 -10 val_10 113 val_113 103 val_103 -10 val_10 114 val_114 103 val_103 -10 val_10 0 val_0 104 val_104 -10 val_10 10 val_10 104 val_104 -10 val_10 100 val_100 104 val_104 -10 val_10 103 val_103 104 val_104 -10 val_10 104 val_104 104 val_104 -10 val_10 105 val_105 104 val_104 -10 val_10 11 val_11 104 val_104 -10 val_10 111 val_111 104 val_104 -10 val_10 113 val_113 104 val_104 -10 val_10 114 val_114 104 val_104 -10 val_10 0 val_0 105 val_105 -10 val_10 10 val_10 105 val_105 -10 val_10 100 val_100 105 val_105 -10 val_10 103 val_103 105 val_105 -10 val_10 104 val_104 105 val_105 -10 val_10 105 val_105 105 val_105 -10 val_10 11 val_11 105 val_105 -10 val_10 111 val_111 105 val_105 -10 val_10 113 val_113 105 val_105 -10 val_10 114 val_114 105 val_105 -10 val_10 0 val_0 11 val_11 -10 val_10 10 val_10 11 val_11 -10 val_10 100 val_100 11 val_11 -10 val_10 103 val_103 11 val_11 -10 val_10 104 val_104 11 val_11 -10 val_10 105 val_105 11 val_11 -10 val_10 11 val_11 11 val_11 -10 val_10 111 val_111 11 val_11 -10 val_10 113 val_113 11 val_11 -10 val_10 114 val_114 11 val_11 -10 val_10 0 val_0 111 val_111 -10 val_10 10 val_10 111 val_111 -10 val_10 100 val_100 111 val_111 -10 val_10 103 val_103 111 val_111 -10 val_10 104 val_104 111 val_111 -10 val_10 105 val_105 111 val_111 -10 val_10 11 val_11 111 val_111 -10 val_10 111 val_111 111 val_111 -10 val_10 113 val_113 111 val_111 -10 val_10 114 val_114 111 val_111 -10 val_10 0 val_0 113 val_113 -10 val_10 10 val_10 113 val_113 -10 val_10 100 val_100 113 val_113 -10 val_10 103 val_103 113 val_113 -10 val_10 104 val_104 113 val_113 -10 val_10 105 val_105 113 val_113 -10 val_10 11 val_11 113 val_113 -10 val_10 111 val_111 113 val_113 -10 val_10 113 val_113 113 val_113 -10 val_10 114 val_114 113 val_113 -10 val_10 0 val_0 114 val_114 -10 val_10 10 val_10 114 val_114 -10 val_10 100 val_100 114 val_114 -10 val_10 103 val_103 114 val_114 -10 val_10 104 val_104 114 val_114 -10 val_10 105 val_105 114 val_114 -10 val_10 11 val_11 114 val_114 -10 val_10 111 val_111 114 val_114 -10 val_10 113 val_113 114 val_114 -10 val_10 114 val_114 114 val_114 -100 val_100 0 val_0 0 val_0 -100 val_100 10 val_10 0 val_0 -100 val_100 100 val_100 0 val_0 -100 val_100 103 val_103 0 val_0 -100 val_100 104 val_104 0 val_0 -100 val_100 105 val_105 0 val_0 -100 val_100 11 val_11 0 val_0 -100 val_100 111 val_111 0 val_0 -100 val_100 113 val_113 0 val_0 -100 val_100 114 val_114 0 val_0 -100 val_100 0 val_0 10 val_10 -100 val_100 10 val_10 10 val_10 -100 val_100 100 val_100 10 val_10 -100 val_100 103 val_103 10 val_10 -100 val_100 104 val_104 10 val_10 -100 val_100 105 val_105 10 val_10 -100 val_100 11 val_11 10 val_10 -100 val_100 111 val_111 10 val_10 -100 val_100 113 val_113 10 val_10 -100 val_100 114 val_114 10 val_10 -100 val_100 0 val_0 100 val_100 -100 val_100 10 val_10 100 val_100 -100 val_100 100 val_100 100 val_100 -100 val_100 103 val_103 100 val_100 -100 val_100 104 val_104 100 val_100 -100 val_100 105 val_105 100 val_100 -100 val_100 11 val_11 100 val_100 -100 val_100 111 val_111 100 val_100 -100 val_100 113 val_113 100 val_100 -100 val_100 114 val_114 100 val_100 -100 val_100 0 val_0 103 val_103 -100 val_100 10 val_10 103 val_103 -100 val_100 100 val_100 103 val_103 -100 val_100 103 val_103 103 val_103 -100 val_100 104 val_104 103 val_103 -100 val_100 105 val_105 103 val_103 -100 val_100 11 val_11 103 val_103 -100 val_100 111 val_111 103 val_103 -100 val_100 113 val_113 103 val_103 -100 val_100 114 val_114 103 val_103 -100 val_100 0 val_0 104 val_104 -100 val_100 10 val_10 104 val_104 -100 val_100 100 val_100 104 val_104 -100 val_100 103 val_103 104 val_104 -100 val_100 104 val_104 104 val_104 -100 val_100 105 val_105 104 val_104 -100 val_100 11 val_11 104 val_104 -100 val_100 111 val_111 104 val_104 -100 val_100 113 val_113 104 val_104 -100 val_100 114 val_114 104 val_104 -100 val_100 0 val_0 105 val_105 -100 val_100 10 val_10 105 val_105 -100 val_100 100 val_100 105 val_105 -100 val_100 103 val_103 105 val_105 -100 val_100 104 val_104 105 val_105 -100 val_100 105 val_105 105 val_105 -100 val_100 11 val_11 105 val_105 -100 val_100 111 val_111 105 val_105 -100 val_100 113 val_113 105 val_105 -100 val_100 114 val_114 105 val_105 -100 val_100 0 val_0 11 val_11 -100 val_100 10 val_10 11 val_11 -100 val_100 100 val_100 11 val_11 -100 val_100 103 val_103 11 val_11 -100 val_100 104 val_104 11 val_11 -100 val_100 105 val_105 11 val_11 -100 val_100 11 val_11 11 val_11 -100 val_100 111 val_111 11 val_11 -100 val_100 113 val_113 11 val_11 -100 val_100 114 val_114 11 val_11 -100 val_100 0 val_0 111 val_111 -100 val_100 10 val_10 111 val_111 -100 val_100 100 val_100 111 val_111 -100 val_100 103 val_103 111 val_111 -100 val_100 104 val_104 111 val_111 -100 val_100 105 val_105 111 val_111 -100 val_100 11 val_11 111 val_111 -100 val_100 111 val_111 111 val_111 -100 val_100 113 val_113 111 val_111 -100 val_100 114 val_114 111 val_111 -100 val_100 0 val_0 113 val_113 -100 val_100 10 val_10 113 val_113 -100 val_100 100 val_100 113 val_113 -100 val_100 103 val_103 113 val_113 -100 val_100 104 val_104 113 val_113 -100 val_100 105 val_105 113 val_113 -100 val_100 11 val_11 113 val_113 -100 val_100 111 val_111 113 val_113 -100 val_100 113 val_113 113 val_113 -100 val_100 114 val_114 113 val_113 -100 val_100 0 val_0 114 val_114 -100 val_100 10 val_10 114 val_114 -100 val_100 100 val_100 114 val_114 -100 val_100 103 val_103 114 val_114 -100 val_100 104 val_104 114 val_114 -100 val_100 105 val_105 114 val_114 -100 val_100 11 val_11 114 val_114 -100 val_100 111 val_111 114 val_114 -100 val_100 113 val_113 114 val_114 -100 val_100 114 val_114 114 val_114 -103 val_103 0 val_0 0 val_0 -103 val_103 10 val_10 0 val_0 -103 val_103 100 val_100 0 val_0 -103 val_103 103 val_103 0 val_0 -103 val_103 104 val_104 0 val_0 -103 val_103 105 val_105 0 val_0 -103 val_103 11 val_11 0 val_0 -103 val_103 111 val_111 0 val_0 -103 val_103 113 val_113 0 val_0 -103 val_103 114 val_114 0 val_0 -103 val_103 0 val_0 10 val_10 -103 val_103 10 val_10 10 val_10 -103 val_103 100 val_100 10 val_10 -103 val_103 103 val_103 10 val_10 -103 val_103 104 val_104 10 val_10 -103 val_103 105 val_105 10 val_10 -103 val_103 11 val_11 10 val_10 -103 val_103 111 val_111 10 val_10 -103 val_103 113 val_113 10 val_10 -103 val_103 114 val_114 10 val_10 -103 val_103 0 val_0 100 val_100 -103 val_103 10 val_10 100 val_100 -103 val_103 100 val_100 100 val_100 -103 val_103 103 val_103 100 val_100 -103 val_103 104 val_104 100 val_100 -103 val_103 105 val_105 100 val_100 -103 val_103 11 val_11 100 val_100 -103 val_103 111 val_111 100 val_100 -103 val_103 113 val_113 100 val_100 -103 val_103 114 val_114 100 val_100 -103 val_103 0 val_0 103 val_103 -103 val_103 10 val_10 103 val_103 -103 val_103 100 val_100 103 val_103 -103 val_103 103 val_103 103 val_103 -103 val_103 104 val_104 103 val_103 -103 val_103 105 val_105 103 val_103 -103 val_103 11 val_11 103 val_103 -103 val_103 111 val_111 103 val_103 -103 val_103 113 val_113 103 val_103 -103 val_103 114 val_114 103 val_103 -103 val_103 0 val_0 104 val_104 -103 val_103 10 val_10 104 val_104 -103 val_103 100 val_100 104 val_104 -103 val_103 103 val_103 104 val_104 -103 val_103 104 val_104 104 val_104 -103 val_103 105 val_105 104 val_104 -103 val_103 11 val_11 104 val_104 -103 val_103 111 val_111 104 val_104 -103 val_103 113 val_113 104 val_104 -103 val_103 114 val_114 104 val_104 -103 val_103 0 val_0 105 val_105 -103 val_103 10 val_10 105 val_105 -103 val_103 100 val_100 105 val_105 -103 val_103 103 val_103 105 val_105 -103 val_103 104 val_104 105 val_105 -103 val_103 105 val_105 105 val_105 -103 val_103 11 val_11 105 val_105 -103 val_103 111 val_111 105 val_105 -103 val_103 113 val_113 105 val_105 -103 val_103 114 val_114 105 val_105 -103 val_103 0 val_0 11 val_11 -103 val_103 10 val_10 11 val_11 -103 val_103 100 val_100 11 val_11 -103 val_103 103 val_103 11 val_11 -103 val_103 104 val_104 11 val_11 -103 val_103 105 val_105 11 val_11 -103 val_103 11 val_11 11 val_11 -103 val_103 111 val_111 11 val_11 -103 val_103 113 val_113 11 val_11 -103 val_103 114 val_114 11 val_11 -103 val_103 0 val_0 111 val_111 -103 val_103 10 val_10 111 val_111 -103 val_103 100 val_100 111 val_111 -103 val_103 103 val_103 111 val_111 -103 val_103 104 val_104 111 val_111 -103 val_103 105 val_105 111 val_111 -103 val_103 11 val_11 111 val_111 -103 val_103 111 val_111 111 val_111 -103 val_103 113 val_113 111 val_111 -103 val_103 114 val_114 111 val_111 -103 val_103 0 val_0 113 val_113 -103 val_103 10 val_10 113 val_113 -103 val_103 100 val_100 113 val_113 -103 val_103 103 val_103 113 val_113 -103 val_103 104 val_104 113 val_113 -103 val_103 105 val_105 113 val_113 -103 val_103 11 val_11 113 val_113 -103 val_103 111 val_111 113 val_113 -103 val_103 113 val_113 113 val_113 -103 val_103 114 val_114 113 val_113 -103 val_103 0 val_0 114 val_114 -103 val_103 10 val_10 114 val_114 -103 val_103 100 val_100 114 val_114 -103 val_103 103 val_103 114 val_114 -103 val_103 104 val_104 114 val_114 -103 val_103 105 val_105 114 val_114 -103 val_103 11 val_11 114 val_114 -103 val_103 111 val_111 114 val_114 -103 val_103 113 val_113 114 val_114 -103 val_103 114 val_114 114 val_114 -104 val_104 0 val_0 0 val_0 -104 val_104 10 val_10 0 val_0 -104 val_104 100 val_100 0 val_0 -104 val_104 103 val_103 0 val_0 -104 val_104 104 val_104 0 val_0 -104 val_104 105 val_105 0 val_0 -104 val_104 11 val_11 0 val_0 -104 val_104 111 val_111 0 val_0 -104 val_104 113 val_113 0 val_0 -104 val_104 114 val_114 0 val_0 -104 val_104 0 val_0 10 val_10 -104 val_104 10 val_10 10 val_10 -104 val_104 100 val_100 10 val_10 -104 val_104 103 val_103 10 val_10 -104 val_104 104 val_104 10 val_10 -104 val_104 105 val_105 10 val_10 -104 val_104 11 val_11 10 val_10 -104 val_104 111 val_111 10 val_10 -104 val_104 113 val_113 10 val_10 -104 val_104 114 val_114 10 val_10 -104 val_104 0 val_0 100 val_100 -104 val_104 10 val_10 100 val_100 -104 val_104 100 val_100 100 val_100 -104 val_104 103 val_103 100 val_100 -104 val_104 104 val_104 100 val_100 -104 val_104 105 val_105 100 val_100 -104 val_104 11 val_11 100 val_100 -104 val_104 111 val_111 100 val_100 -104 val_104 113 val_113 100 val_100 -104 val_104 114 val_114 100 val_100 -104 val_104 0 val_0 103 val_103 -104 val_104 10 val_10 103 val_103 -104 val_104 100 val_100 103 val_103 -104 val_104 103 val_103 103 val_103 -104 val_104 104 val_104 103 val_103 -104 val_104 105 val_105 103 val_103 -104 val_104 11 val_11 103 val_103 -104 val_104 111 val_111 103 val_103 -104 val_104 113 val_113 103 val_103 -104 val_104 114 val_114 103 val_103 -104 val_104 0 val_0 104 val_104 -104 val_104 10 val_10 104 val_104 -104 val_104 100 val_100 104 val_104 -104 val_104 103 val_103 104 val_104 -104 val_104 104 val_104 104 val_104 -104 val_104 105 val_105 104 val_104 -104 val_104 11 val_11 104 val_104 -104 val_104 111 val_111 104 val_104 -104 val_104 113 val_113 104 val_104 -104 val_104 114 val_114 104 val_104 -104 val_104 0 val_0 105 val_105 -104 val_104 10 val_10 105 val_105 -104 val_104 100 val_100 105 val_105 -104 val_104 103 val_103 105 val_105 -104 val_104 104 val_104 105 val_105 -104 val_104 105 val_105 105 val_105 -104 val_104 11 val_11 105 val_105 -104 val_104 111 val_111 105 val_105 -104 val_104 113 val_113 105 val_105 -104 val_104 114 val_114 105 val_105 -104 val_104 0 val_0 11 val_11 -104 val_104 10 val_10 11 val_11 -104 val_104 100 val_100 11 val_11 -104 val_104 103 val_103 11 val_11 -104 val_104 104 val_104 11 val_11 -104 val_104 105 val_105 11 val_11 -104 val_104 11 val_11 11 val_11 -104 val_104 111 val_111 11 val_11 -104 val_104 113 val_113 11 val_11 -104 val_104 114 val_114 11 val_11 -104 val_104 0 val_0 111 val_111 -104 val_104 10 val_10 111 val_111 -104 val_104 100 val_100 111 val_111 -104 val_104 103 val_103 111 val_111 -104 val_104 104 val_104 111 val_111 -104 val_104 105 val_105 111 val_111 -104 val_104 11 val_11 111 val_111 -104 val_104 111 val_111 111 val_111 -104 val_104 113 val_113 111 val_111 -104 val_104 114 val_114 111 val_111 -104 val_104 0 val_0 113 val_113 -104 val_104 10 val_10 113 val_113 -104 val_104 100 val_100 113 val_113 -104 val_104 103 val_103 113 val_113 -104 val_104 104 val_104 113 val_113 -104 val_104 105 val_105 113 val_113 -104 val_104 11 val_11 113 val_113 -104 val_104 111 val_111 113 val_113 -104 val_104 113 val_113 113 val_113 -104 val_104 114 val_114 113 val_113 -104 val_104 0 val_0 114 val_114 -104 val_104 10 val_10 114 val_114 -104 val_104 100 val_100 114 val_114 -104 val_104 103 val_103 114 val_114 -104 val_104 104 val_104 114 val_114 -104 val_104 105 val_105 114 val_114 -104 val_104 11 val_11 114 val_114 -104 val_104 111 val_111 114 val_114 -104 val_104 113 val_113 114 val_114 -104 val_104 114 val_114 114 val_114 -105 val_105 0 val_0 0 val_0 -105 val_105 10 val_10 0 val_0 -105 val_105 100 val_100 0 val_0 -105 val_105 103 val_103 0 val_0 -105 val_105 104 val_104 0 val_0 -105 val_105 105 val_105 0 val_0 -105 val_105 11 val_11 0 val_0 -105 val_105 111 val_111 0 val_0 -105 val_105 113 val_113 0 val_0 -105 val_105 114 val_114 0 val_0 -105 val_105 0 val_0 10 val_10 -105 val_105 10 val_10 10 val_10 -105 val_105 100 val_100 10 val_10 -105 val_105 103 val_103 10 val_10 -105 val_105 104 val_104 10 val_10 -105 val_105 105 val_105 10 val_10 -105 val_105 11 val_11 10 val_10 -105 val_105 111 val_111 10 val_10 -105 val_105 113 val_113 10 val_10 -105 val_105 114 val_114 10 val_10 -105 val_105 0 val_0 100 val_100 -105 val_105 10 val_10 100 val_100 -105 val_105 100 val_100 100 val_100 -105 val_105 103 val_103 100 val_100 -105 val_105 104 val_104 100 val_100 -105 val_105 105 val_105 100 val_100 -105 val_105 11 val_11 100 val_100 -105 val_105 111 val_111 100 val_100 -105 val_105 113 val_113 100 val_100 -105 val_105 114 val_114 100 val_100 -105 val_105 0 val_0 103 val_103 -105 val_105 10 val_10 103 val_103 -105 val_105 100 val_100 103 val_103 -105 val_105 103 val_103 103 val_103 -105 val_105 104 val_104 103 val_103 -105 val_105 105 val_105 103 val_103 -105 val_105 11 val_11 103 val_103 -105 val_105 111 val_111 103 val_103 -105 val_105 113 val_113 103 val_103 -105 val_105 114 val_114 103 val_103 -105 val_105 0 val_0 104 val_104 -105 val_105 10 val_10 104 val_104 -105 val_105 100 val_100 104 val_104 -105 val_105 103 val_103 104 val_104 -105 val_105 104 val_104 104 val_104 -105 val_105 105 val_105 104 val_104 -105 val_105 11 val_11 104 val_104 -105 val_105 111 val_111 104 val_104 -105 val_105 113 val_113 104 val_104 -105 val_105 114 val_114 104 val_104 -105 val_105 0 val_0 105 val_105 -105 val_105 10 val_10 105 val_105 -105 val_105 100 val_100 105 val_105 -105 val_105 103 val_103 105 val_105 -105 val_105 104 val_104 105 val_105 -105 val_105 105 val_105 105 val_105 -105 val_105 11 val_11 105 val_105 -105 val_105 111 val_111 105 val_105 -105 val_105 113 val_113 105 val_105 -105 val_105 114 val_114 105 val_105 -105 val_105 0 val_0 11 val_11 -105 val_105 10 val_10 11 val_11 -105 val_105 100 val_100 11 val_11 -105 val_105 103 val_103 11 val_11 -105 val_105 104 val_104 11 val_11 -105 val_105 105 val_105 11 val_11 -105 val_105 11 val_11 11 val_11 -105 val_105 111 val_111 11 val_11 -105 val_105 113 val_113 11 val_11 -105 val_105 114 val_114 11 val_11 -105 val_105 0 val_0 111 val_111 -105 val_105 10 val_10 111 val_111 -105 val_105 100 val_100 111 val_111 -105 val_105 103 val_103 111 val_111 -105 val_105 104 val_104 111 val_111 -105 val_105 105 val_105 111 val_111 -105 val_105 11 val_11 111 val_111 -105 val_105 111 val_111 111 val_111 -105 val_105 113 val_113 111 val_111 -105 val_105 114 val_114 111 val_111 -105 val_105 0 val_0 113 val_113 -105 val_105 10 val_10 113 val_113 -105 val_105 100 val_100 113 val_113 -105 val_105 103 val_103 113 val_113 -105 val_105 104 val_104 113 val_113 -105 val_105 105 val_105 113 val_113 -105 val_105 11 val_11 113 val_113 -105 val_105 111 val_111 113 val_113 -105 val_105 113 val_113 113 val_113 -105 val_105 114 val_114 113 val_113 -105 val_105 0 val_0 114 val_114 -105 val_105 10 val_10 114 val_114 -105 val_105 100 val_100 114 val_114 -105 val_105 103 val_103 114 val_114 -105 val_105 104 val_104 114 val_114 -105 val_105 105 val_105 114 val_114 -105 val_105 11 val_11 114 val_114 -105 val_105 111 val_111 114 val_114 -105 val_105 113 val_113 114 val_114 -105 val_105 114 val_114 114 val_114 -11 val_11 0 val_0 0 val_0 -11 val_11 10 val_10 0 val_0 -11 val_11 100 val_100 0 val_0 -11 val_11 103 val_103 0 val_0 -11 val_11 104 val_104 0 val_0 -11 val_11 105 val_105 0 val_0 -11 val_11 11 val_11 0 val_0 -11 val_11 111 val_111 0 val_0 -11 val_11 113 val_113 0 val_0 -11 val_11 114 val_114 0 val_0 -11 val_11 0 val_0 10 val_10 -11 val_11 10 val_10 10 val_10 -11 val_11 100 val_100 10 val_10 -11 val_11 103 val_103 10 val_10 -11 val_11 104 val_104 10 val_10 -11 val_11 105 val_105 10 val_10 -11 val_11 11 val_11 10 val_10 -11 val_11 111 val_111 10 val_10 -11 val_11 113 val_113 10 val_10 -11 val_11 114 val_114 10 val_10 -11 val_11 0 val_0 100 val_100 -11 val_11 10 val_10 100 val_100 -11 val_11 100 val_100 100 val_100 -11 val_11 103 val_103 100 val_100 -11 val_11 104 val_104 100 val_100 -11 val_11 105 val_105 100 val_100 -11 val_11 11 val_11 100 val_100 -11 val_11 111 val_111 100 val_100 -11 val_11 113 val_113 100 val_100 -11 val_11 114 val_114 100 val_100 -11 val_11 0 val_0 103 val_103 -11 val_11 10 val_10 103 val_103 -11 val_11 100 val_100 103 val_103 -11 val_11 103 val_103 103 val_103 -11 val_11 104 val_104 103 val_103 -11 val_11 105 val_105 103 val_103 -11 val_11 11 val_11 103 val_103 -11 val_11 111 val_111 103 val_103 -11 val_11 113 val_113 103 val_103 -11 val_11 114 val_114 103 val_103 -11 val_11 0 val_0 104 val_104 -11 val_11 10 val_10 104 val_104 -11 val_11 100 val_100 104 val_104 -11 val_11 103 val_103 104 val_104 -11 val_11 104 val_104 104 val_104 -11 val_11 105 val_105 104 val_104 -11 val_11 11 val_11 104 val_104 -11 val_11 111 val_111 104 val_104 -11 val_11 113 val_113 104 val_104 -11 val_11 114 val_114 104 val_104 -11 val_11 0 val_0 105 val_105 -11 val_11 10 val_10 105 val_105 -11 val_11 100 val_100 105 val_105 -11 val_11 103 val_103 105 val_105 -11 val_11 104 val_104 105 val_105 -11 val_11 105 val_105 105 val_105 -11 val_11 11 val_11 105 val_105 -11 val_11 111 val_111 105 val_105 -11 val_11 113 val_113 105 val_105 -11 val_11 114 val_114 105 val_105 -11 val_11 0 val_0 11 val_11 -11 val_11 10 val_10 11 val_11 -11 val_11 100 val_100 11 val_11 -11 val_11 103 val_103 11 val_11 -11 val_11 104 val_104 11 val_11 -11 val_11 105 val_105 11 val_11 -11 val_11 11 val_11 11 val_11 -11 val_11 111 val_111 11 val_11 -11 val_11 113 val_113 11 val_11 -11 val_11 114 val_114 11 val_11 -11 val_11 0 val_0 111 val_111 -11 val_11 10 val_10 111 val_111 -11 val_11 100 val_100 111 val_111 -11 val_11 103 val_103 111 val_111 -11 val_11 104 val_104 111 val_111 -11 val_11 105 val_105 111 val_111 -11 val_11 11 val_11 111 val_111 -11 val_11 111 val_111 111 val_111 -11 val_11 113 val_113 111 val_111 -11 val_11 114 val_114 111 val_111 -11 val_11 0 val_0 113 val_113 -11 val_11 10 val_10 113 val_113 -11 val_11 100 val_100 113 val_113 -11 val_11 103 val_103 113 val_113 -11 val_11 104 val_104 113 val_113 -11 val_11 105 val_105 113 val_113 -11 val_11 11 val_11 113 val_113 -11 val_11 111 val_111 113 val_113 -11 val_11 113 val_113 113 val_113 -11 val_11 114 val_114 113 val_113 -11 val_11 0 val_0 114 val_114 -11 val_11 10 val_10 114 val_114 -11 val_11 100 val_100 114 val_114 -11 val_11 103 val_103 114 val_114 -11 val_11 104 val_104 114 val_114 -11 val_11 105 val_105 114 val_114 -11 val_11 11 val_11 114 val_114 -11 val_11 111 val_111 114 val_114 -11 val_11 113 val_113 114 val_114 -11 val_11 114 val_114 114 val_114 -111 val_111 0 val_0 0 val_0 -111 val_111 10 val_10 0 val_0 -111 val_111 100 val_100 0 val_0 -111 val_111 103 val_103 0 val_0 -111 val_111 104 val_104 0 val_0 -111 val_111 105 val_105 0 val_0 -111 val_111 11 val_11 0 val_0 -111 val_111 111 val_111 0 val_0 -111 val_111 113 val_113 0 val_0 -111 val_111 114 val_114 0 val_0 -111 val_111 0 val_0 10 val_10 -111 val_111 10 val_10 10 val_10 -111 val_111 100 val_100 10 val_10 -111 val_111 103 val_103 10 val_10 -111 val_111 104 val_104 10 val_10 -111 val_111 105 val_105 10 val_10 -111 val_111 11 val_11 10 val_10 -111 val_111 111 val_111 10 val_10 -111 val_111 113 val_113 10 val_10 -111 val_111 114 val_114 10 val_10 -111 val_111 0 val_0 100 val_100 -111 val_111 10 val_10 100 val_100 -111 val_111 100 val_100 100 val_100 -111 val_111 103 val_103 100 val_100 -111 val_111 104 val_104 100 val_100 -111 val_111 105 val_105 100 val_100 -111 val_111 11 val_11 100 val_100 -111 val_111 111 val_111 100 val_100 -111 val_111 113 val_113 100 val_100 -111 val_111 114 val_114 100 val_100 -111 val_111 0 val_0 103 val_103 -111 val_111 10 val_10 103 val_103 -111 val_111 100 val_100 103 val_103 -111 val_111 103 val_103 103 val_103 -111 val_111 104 val_104 103 val_103 -111 val_111 105 val_105 103 val_103 -111 val_111 11 val_11 103 val_103 -111 val_111 111 val_111 103 val_103 -111 val_111 113 val_113 103 val_103 -111 val_111 114 val_114 103 val_103 -111 val_111 0 val_0 104 val_104 -111 val_111 10 val_10 104 val_104 -111 val_111 100 val_100 104 val_104 -111 val_111 103 val_103 104 val_104 -111 val_111 104 val_104 104 val_104 -111 val_111 105 val_105 104 val_104 -111 val_111 11 val_11 104 val_104 -111 val_111 111 val_111 104 val_104 -111 val_111 113 val_113 104 val_104 -111 val_111 114 val_114 104 val_104 -111 val_111 0 val_0 105 val_105 -111 val_111 10 val_10 105 val_105 -111 val_111 100 val_100 105 val_105 -111 val_111 103 val_103 105 val_105 -111 val_111 104 val_104 105 val_105 -111 val_111 105 val_105 105 val_105 -111 val_111 11 val_11 105 val_105 -111 val_111 111 val_111 105 val_105 -111 val_111 113 val_113 105 val_105 -111 val_111 114 val_114 105 val_105 -111 val_111 0 val_0 11 val_11 -111 val_111 10 val_10 11 val_11 -111 val_111 100 val_100 11 val_11 -111 val_111 103 val_103 11 val_11 -111 val_111 104 val_104 11 val_11 -111 val_111 105 val_105 11 val_11 -111 val_111 11 val_11 11 val_11 -111 val_111 111 val_111 11 val_11 -111 val_111 113 val_113 11 val_11 -111 val_111 114 val_114 11 val_11 -111 val_111 0 val_0 111 val_111 -111 val_111 10 val_10 111 val_111 -111 val_111 100 val_100 111 val_111 -111 val_111 103 val_103 111 val_111 -111 val_111 104 val_104 111 val_111 -111 val_111 105 val_105 111 val_111 -111 val_111 11 val_11 111 val_111 -111 val_111 111 val_111 111 val_111 -111 val_111 113 val_113 111 val_111 -111 val_111 114 val_114 111 val_111 -111 val_111 0 val_0 113 val_113 -111 val_111 10 val_10 113 val_113 -111 val_111 100 val_100 113 val_113 -111 val_111 103 val_103 113 val_113 -111 val_111 104 val_104 113 val_113 -111 val_111 105 val_105 113 val_113 -111 val_111 11 val_11 113 val_113 -111 val_111 111 val_111 113 val_113 -111 val_111 113 val_113 113 val_113 -111 val_111 114 val_114 113 val_113 -111 val_111 0 val_0 114 val_114 -111 val_111 10 val_10 114 val_114 -111 val_111 100 val_100 114 val_114 -111 val_111 103 val_103 114 val_114 -111 val_111 104 val_104 114 val_114 -111 val_111 105 val_105 114 val_114 -111 val_111 11 val_11 114 val_114 -111 val_111 111 val_111 114 val_114 -111 val_111 113 val_113 114 val_114 -111 val_111 114 val_114 114 val_114 -113 val_113 0 val_0 0 val_0 -113 val_113 10 val_10 0 val_0 -113 val_113 100 val_100 0 val_0 -113 val_113 103 val_103 0 val_0 -113 val_113 104 val_104 0 val_0 -113 val_113 105 val_105 0 val_0 -113 val_113 11 val_11 0 val_0 -113 val_113 111 val_111 0 val_0 -113 val_113 113 val_113 0 val_0 -113 val_113 114 val_114 0 val_0 -113 val_113 0 val_0 10 val_10 -113 val_113 10 val_10 10 val_10 -113 val_113 100 val_100 10 val_10 -113 val_113 103 val_103 10 val_10 -113 val_113 104 val_104 10 val_10 -113 val_113 105 val_105 10 val_10 -113 val_113 11 val_11 10 val_10 -113 val_113 111 val_111 10 val_10 -113 val_113 113 val_113 10 val_10 -113 val_113 114 val_114 10 val_10 -113 val_113 0 val_0 100 val_100 -113 val_113 10 val_10 100 val_100 -113 val_113 100 val_100 100 val_100 -113 val_113 103 val_103 100 val_100 -113 val_113 104 val_104 100 val_100 -113 val_113 105 val_105 100 val_100 -113 val_113 11 val_11 100 val_100 -113 val_113 111 val_111 100 val_100 -113 val_113 113 val_113 100 val_100 -113 val_113 114 val_114 100 val_100 -113 val_113 0 val_0 103 val_103 -113 val_113 10 val_10 103 val_103 -113 val_113 100 val_100 103 val_103 -113 val_113 103 val_103 103 val_103 -113 val_113 104 val_104 103 val_103 -113 val_113 105 val_105 103 val_103 -113 val_113 11 val_11 103 val_103 -113 val_113 111 val_111 103 val_103 -113 val_113 113 val_113 103 val_103 -113 val_113 114 val_114 103 val_103 -113 val_113 0 val_0 104 val_104 -113 val_113 10 val_10 104 val_104 -113 val_113 100 val_100 104 val_104 -113 val_113 103 val_103 104 val_104 -113 val_113 104 val_104 104 val_104 -113 val_113 105 val_105 104 val_104 -113 val_113 11 val_11 104 val_104 -113 val_113 111 val_111 104 val_104 -113 val_113 113 val_113 104 val_104 -113 val_113 114 val_114 104 val_104 -113 val_113 0 val_0 105 val_105 -113 val_113 10 val_10 105 val_105 -113 val_113 100 val_100 105 val_105 -113 val_113 103 val_103 105 val_105 -113 val_113 104 val_104 105 val_105 -113 val_113 105 val_105 105 val_105 -113 val_113 11 val_11 105 val_105 -113 val_113 111 val_111 105 val_105 -113 val_113 113 val_113 105 val_105 -113 val_113 114 val_114 105 val_105 -113 val_113 0 val_0 11 val_11 -113 val_113 10 val_10 11 val_11 -113 val_113 100 val_100 11 val_11 -113 val_113 103 val_103 11 val_11 -113 val_113 104 val_104 11 val_11 -113 val_113 105 val_105 11 val_11 -113 val_113 11 val_11 11 val_11 -113 val_113 111 val_111 11 val_11 -113 val_113 113 val_113 11 val_11 -113 val_113 114 val_114 11 val_11 -113 val_113 0 val_0 111 val_111 -113 val_113 10 val_10 111 val_111 -113 val_113 100 val_100 111 val_111 -113 val_113 103 val_103 111 val_111 -113 val_113 104 val_104 111 val_111 -113 val_113 105 val_105 111 val_111 -113 val_113 11 val_11 111 val_111 -113 val_113 111 val_111 111 val_111 -113 val_113 113 val_113 111 val_111 -113 val_113 114 val_114 111 val_111 -113 val_113 0 val_0 113 val_113 -113 val_113 10 val_10 113 val_113 -113 val_113 100 val_100 113 val_113 -113 val_113 103 val_103 113 val_113 -113 val_113 104 val_104 113 val_113 -113 val_113 105 val_105 113 val_113 -113 val_113 11 val_11 113 val_113 -113 val_113 111 val_111 113 val_113 -113 val_113 113 val_113 113 val_113 -113 val_113 114 val_114 113 val_113 -113 val_113 0 val_0 114 val_114 -113 val_113 10 val_10 114 val_114 -113 val_113 100 val_100 114 val_114 -113 val_113 103 val_103 114 val_114 -113 val_113 104 val_104 114 val_114 -113 val_113 105 val_105 114 val_114 -113 val_113 11 val_11 114 val_114 -113 val_113 111 val_111 114 val_114 -113 val_113 113 val_113 114 val_114 -113 val_113 114 val_114 114 val_114 -114 val_114 0 val_0 0 val_0 -114 val_114 10 val_10 0 val_0 -114 val_114 100 val_100 0 val_0 -114 val_114 103 val_103 0 val_0 -114 val_114 104 val_104 0 val_0 -114 val_114 105 val_105 0 val_0 -114 val_114 11 val_11 0 val_0 -114 val_114 111 val_111 0 val_0 -114 val_114 113 val_113 0 val_0 -114 val_114 114 val_114 0 val_0 -114 val_114 0 val_0 10 val_10 -114 val_114 10 val_10 10 val_10 -114 val_114 100 val_100 10 val_10 -114 val_114 103 val_103 10 val_10 -114 val_114 104 val_104 10 val_10 -114 val_114 105 val_105 10 val_10 -114 val_114 11 val_11 10 val_10 -114 val_114 111 val_111 10 val_10 -114 val_114 113 val_113 10 val_10 -114 val_114 114 val_114 10 val_10 -114 val_114 0 val_0 100 val_100 -114 val_114 10 val_10 100 val_100 -114 val_114 100 val_100 100 val_100 -114 val_114 103 val_103 100 val_100 -114 val_114 104 val_104 100 val_100 -114 val_114 105 val_105 100 val_100 -114 val_114 11 val_11 100 val_100 -114 val_114 111 val_111 100 val_100 -114 val_114 113 val_113 100 val_100 -114 val_114 114 val_114 100 val_100 -114 val_114 0 val_0 103 val_103 -114 val_114 10 val_10 103 val_103 -114 val_114 100 val_100 103 val_103 -114 val_114 103 val_103 103 val_103 -114 val_114 104 val_104 103 val_103 -114 val_114 105 val_105 103 val_103 -114 val_114 11 val_11 103 val_103 -114 val_114 111 val_111 103 val_103 -114 val_114 113 val_113 103 val_103 -114 val_114 114 val_114 103 val_103 -114 val_114 0 val_0 104 val_104 -114 val_114 10 val_10 104 val_104 -114 val_114 100 val_100 104 val_104 -114 val_114 103 val_103 104 val_104 -114 val_114 104 val_104 104 val_104 -114 val_114 105 val_105 104 val_104 -114 val_114 11 val_11 104 val_104 -114 val_114 111 val_111 104 val_104 -114 val_114 113 val_113 104 val_104 -114 val_114 114 val_114 104 val_104 -114 val_114 0 val_0 105 val_105 -114 val_114 10 val_10 105 val_105 -114 val_114 100 val_100 105 val_105 -114 val_114 103 val_103 105 val_105 -114 val_114 104 val_104 105 val_105 -114 val_114 105 val_105 105 val_105 -114 val_114 11 val_11 105 val_105 -114 val_114 111 val_111 105 val_105 -114 val_114 113 val_113 105 val_105 -114 val_114 114 val_114 105 val_105 -114 val_114 0 val_0 11 val_11 -114 val_114 10 val_10 11 val_11 -114 val_114 100 val_100 11 val_11 -114 val_114 103 val_103 11 val_11 -114 val_114 104 val_104 11 val_11 -114 val_114 105 val_105 11 val_11 -114 val_114 11 val_11 11 val_11 -114 val_114 111 val_111 11 val_11 -114 val_114 113 val_113 11 val_11 -114 val_114 114 val_114 11 val_11 -114 val_114 0 val_0 111 val_111 -114 val_114 10 val_10 111 val_111 -114 val_114 100 val_100 111 val_111 -114 val_114 103 val_103 111 val_111 -114 val_114 104 val_104 111 val_111 -114 val_114 105 val_105 111 val_111 -114 val_114 11 val_11 111 val_111 -114 val_114 111 val_111 111 val_111 -114 val_114 113 val_113 111 val_111 -114 val_114 114 val_114 111 val_111 -114 val_114 0 val_0 113 val_113 -114 val_114 10 val_10 113 val_113 -114 val_114 100 val_100 113 val_113 -114 val_114 103 val_103 113 val_113 -114 val_114 104 val_104 113 val_113 -114 val_114 105 val_105 113 val_113 -114 val_114 11 val_11 113 val_113 -114 val_114 111 val_111 113 val_113 -114 val_114 113 val_113 113 val_113 -114 val_114 114 val_114 113 val_113 -114 val_114 0 val_0 114 val_114 -114 val_114 10 val_10 114 val_114 -114 val_114 100 val_100 114 val_114 -114 val_114 103 val_103 114 val_114 -114 val_114 104 val_104 114 val_114 -114 val_114 105 val_105 114 val_114 -114 val_114 11 val_11 114 val_114 -114 val_114 111 val_111 114 val_114 -114 val_114 113 val_113 114 val_114 -114 val_114 114 val_114 114 val_114 -Warning: Shuffle Join MERGEJOIN[10][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: explain select * from X as A join X as B on A.key in ("103", "104", "105") -PREHOOK: type: QUERY -POSTHOOK: query: explain select * from X as A join X as B on A.key in ("103", "104", "105") -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: - Reducer 2 <- Map 1 (XPROD_EDGE), Map 3 (XPROD_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (_col0) IN ('103', '104', '105') (type: boolean) - Statistics: Num rows: 5 Data size: 51 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 5 Data size: 51 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Map 3 - Map Operator Tree: - TableScan - alias: b - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Merge Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 - 1 - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 50 Data size: 1070 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 50 Data size: 1070 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 - -Warning: Shuffle Join MERGEJOIN[10][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: select * from X as A join X as B on A.key in ("103", "104", "105") -PREHOOK: type: QUERY -PREHOOK: Input: default@x -#### A masked pattern was here #### -POSTHOOK: query: select * from X as A join X as B on A.key in ("103", "104", "105") -POSTHOOK: type: QUERY -POSTHOOK: Input: default@x -#### A masked pattern was here #### -103 val_103 0 val_0 -103 val_103 10 val_10 -103 val_103 100 val_100 -103 val_103 103 val_103 -103 val_103 104 val_104 -103 val_103 105 val_105 -103 val_103 11 val_11 -103 val_103 111 val_111 -103 val_103 113 val_113 -103 val_103 114 val_114 -104 val_104 0 val_0 -104 val_104 10 val_10 -104 val_104 100 val_100 -104 val_104 103 val_103 -104 val_104 104 val_104 -104 val_104 105 val_105 -104 val_104 11 val_11 -104 val_104 111 val_111 -104 val_104 113 val_113 -104 val_104 114 val_114 -105 val_105 0 val_0 -105 val_105 10 val_10 -105 val_105 100 val_100 -105 val_105 103 val_103 -105 val_105 104 val_104 -105 val_105 105 val_105 -105 val_105 11 val_11 -105 val_105 111 val_111 -105 val_105 113 val_113 -105 val_105 114 val_114 -Warning: Shuffle Join MERGEJOIN[13][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: explain select A.key, count(*) from X as A, X as B group by A.key -PREHOOK: type: QUERY -POSTHOOK: query: explain select A.key, count(*) from X as A, X as B group by A.key -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: - Reducer 2 <- Map 1 (XPROD_EDGE), Map 4 (XPROD_EDGE) - Reducer 3 <- Reducer 2 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string) - outputColumnNames: _col0 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string) - Execution mode: llap - LLAP IO: no inputs - Map 4 - Map Operator Tree: - TableScan - alias: b - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Merge Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 - 1 - outputColumnNames: _col0 - Statistics: Num rows: 100 Data size: 1520 Basic stats: COMPLETE Column stats: NONE - Group By Operator - aggregations: count() - keys: _col0 (type: string) - mode: hash - outputColumnNames: _col0, _col1 - Statistics: Num rows: 100 Data size: 1520 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 100 Data size: 1520 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: bigint) - Reducer 3 - Execution mode: llap - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - keys: KEY._col0 (type: string) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 50 Data size: 760 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 50 Data size: 760 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 - -Warning: Shuffle Join MERGEJOIN[13][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: select A.key, count(*) from X as A, X as B group by A.key -PREHOOK: type: QUERY -PREHOOK: Input: default@x -#### A masked pattern was here #### -POSTHOOK: query: select A.key, count(*) from X as A, X as B group by A.key -POSTHOOK: type: QUERY -POSTHOOK: Input: default@x -#### A masked pattern was here #### -0 10 -10 10 -100 10 -103 10 -104 10 -105 10 -11 10 -111 10 -113 10 -114 10 -Warning: Shuffle Join MERGEJOIN[9][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: explain select * from X as A left outer join X as B on (A.key = B.key or A.value between "val_103" and "val_105") -PREHOOK: type: QUERY -POSTHOOK: query: explain select * from X as A left outer join X as B on (A.key = B.key or A.value between "val_103" and "val_105") -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: - Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Map 3 - Map Operator Tree: - TableScan - alias: b - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Merge Join Operator - condition map: - Left Outer Join0 to 1 - keys: - 0 - 1 - outputColumnNames: _col0, _col1, _col2, _col3 - residual filter predicates: {((_col0 = _col2) or _col1 BETWEEN 'val_103' AND 'val_105')} - Statistics: Num rows: 100 Data size: 2140 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 100 Data size: 2140 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 - -Warning: Shuffle Join MERGEJOIN[9][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: explain select * from X as A right outer join X as B on (A.key = B.key or A.value between "val_103" and "val_105") -PREHOOK: type: QUERY -POSTHOOK: query: explain select * from X as A right outer join X as B on (A.key = B.key or A.value between "val_103" and "val_105") -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: - Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Map 3 - Map Operator Tree: - TableScan - alias: b - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Merge Join Operator - condition map: - Right Outer Join0 to 1 - keys: - 0 - 1 - outputColumnNames: _col0, _col1, _col2, _col3 - residual filter predicates: {((_col0 = _col2) or _col1 BETWEEN 'val_103' AND 'val_105')} - Statistics: Num rows: 100 Data size: 2140 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 100 Data size: 2140 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 - -Warning: Shuffle Join MERGEJOIN[9][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product -PREHOOK: query: explain select * from X as A full outer join X as B on (A.key = B.key or A.value between "val_103" and "val_105") -PREHOOK: type: QUERY -POSTHOOK: query: explain select * from X as A full outer join X as B on (A.key = B.key or A.value between "val_103" and "val_105") -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: - Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Map 3 - Map Operator Tree: - TableScan - alias: b - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Merge Join Operator - condition map: - Outer Join 0 to 1 - keys: - 0 - 1 - outputColumnNames: _col0, _col1, _col2, _col3 - residual filter predicates: {((_col0 = _col2) or _col1 BETWEEN 'val_103' AND 'val_105')} - Statistics: Num rows: 100 Data size: 2140 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 100 Data size: 2140 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 - -Warning: Shuffle Join MERGEJOIN[17][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 3' is a cross product -PREHOOK: query: explain select * from (select X.key, count(*) from X group by X.key) as A, (select X.key, count(*) from X group by X.key) as B -PREHOOK: type: QUERY -POSTHOOK: query: explain select * from (select X.key, count(*) from X group by X.key) as A, (select X.key, count(*) from X group by X.key) as B -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: - Reducer 2 <- Map 1 (SIMPLE_EDGE) - Reducer 3 <- Reducer 2 (XPROD_EDGE), Reducer 5 (XPROD_EDGE) - Reducer 5 <- Map 4 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: x - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string) - outputColumnNames: key - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Group By Operator - aggregations: count() - keys: key (type: string) - mode: hash - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: bigint) - Execution mode: llap - LLAP IO: no inputs - Map 4 - Map Operator Tree: - TableScan - alias: x - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string) - outputColumnNames: key - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Group By Operator - aggregations: count() - keys: key (type: string) - mode: hash - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 10 Data size: 102 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: bigint) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - keys: KEY._col0 (type: string) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 5 Data size: 51 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 5 Data size: 51 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: bigint) - Reducer 3 - Execution mode: llap - Reduce Operator Tree: - Merge Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 - 1 - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 25 Data size: 535 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 25 Data size: 535 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 - Reducer 5 - Execution mode: llap - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - keys: KEY._col0 (type: string) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 5 Data size: 51 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 5 Data size: 51 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: bigint) - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -Warning: Shuffle Join MERGEJOIN[17][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 3' is a cross product -PREHOOK: query: select * from (select X.key, count(*) from X group by X.key) as A, (select X.key, count(*) from X group by X.key) as B -PREHOOK: type: QUERY -PREHOOK: Input: default@x -#### A masked pattern was here #### -POSTHOOK: query: select * from (select X.key, count(*) from X group by X.key) as A, (select X.key, count(*) from X group by X.key) as B -POSTHOOK: type: QUERY -POSTHOOK: Input: default@x -#### A masked pattern was here #### -0 1 0 1 -0 1 10 1 -0 1 100 1 -0 1 103 1 -0 1 104 1 -0 1 105 1 -0 1 11 1 -0 1 111 1 -0 1 113 1 -0 1 114 1 -10 1 0 1 -10 1 10 1 -10 1 100 1 -10 1 103 1 -10 1 104 1 -10 1 105 1 -10 1 11 1 -10 1 111 1 -10 1 113 1 -10 1 114 1 -100 1 0 1 -100 1 10 1 -100 1 100 1 -100 1 103 1 -100 1 104 1 -100 1 105 1 -100 1 11 1 -100 1 111 1 -100 1 113 1 -100 1 114 1 -103 1 0 1 -103 1 10 1 -103 1 100 1 -103 1 103 1 -103 1 104 1 -103 1 105 1 -103 1 11 1 -103 1 111 1 -103 1 113 1 -103 1 114 1 -104 1 0 1 -104 1 10 1 -104 1 100 1 -104 1 103 1 -104 1 104 1 -104 1 105 1 -104 1 11 1 -104 1 111 1 -104 1 113 1 -104 1 114 1 -105 1 0 1 -105 1 10 1 -105 1 100 1 -105 1 103 1 -105 1 104 1 -105 1 105 1 -105 1 11 1 -105 1 111 1 -105 1 113 1 -105 1 114 1 -11 1 0 1 -11 1 10 1 -11 1 100 1 -11 1 103 1 -11 1 104 1 -11 1 105 1 -11 1 11 1 -11 1 111 1 -11 1 113 1 -11 1 114 1 -111 1 0 1 -111 1 10 1 -111 1 100 1 -111 1 103 1 -111 1 104 1 -111 1 105 1 -111 1 11 1 -111 1 111 1 -111 1 113 1 -111 1 114 1 -113 1 0 1 -113 1 10 1 -113 1 100 1 -113 1 103 1 -113 1 104 1 -113 1 105 1 -113 1 11 1 -113 1 111 1 -113 1 113 1 -113 1 114 1 -114 1 0 1 -114 1 10 1 -114 1 100 1 -114 1 103 1 -114 1 104 1 -114 1 105 1 -114 1 11 1 -114 1 111 1 -114 1 113 1 -114 1 114 1
http://git-wip-us.apache.org/repos/asf/hive/blob/62a3778e/ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out b/ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out index d28bafb..8e3ad89 100644 --- a/ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out +++ b/ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out @@ -2228,7 +2228,7 @@ STAGE PLANS: Tez #### A masked pattern was here #### Edges: - Reducer 2 <- Map 1 (XPROD_EDGE), Reducer 5 (XPROD_EDGE) + Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 5 (SIMPLE_EDGE) Reducer 3 <- Reducer 2 (SIMPLE_EDGE) Reducer 5 <- Map 4 (SIMPLE_EDGE) #### A masked pattern was here #### @@ -2361,7 +2361,7 @@ STAGE PLANS: Tez #### A masked pattern was here #### Edges: - Reducer 2 <- Map 1 (XPROD_EDGE), Map 4 (XPROD_EDGE) + Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) Reducer 3 <- Reducer 2 (SIMPLE_EDGE) #### A masked pattern was here #### Vertices: http://git-wip-us.apache.org/repos/asf/hive/blob/62a3778e/ql/src/test/results/clientpositive/llap/orc_llap_counters.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_llap_counters.q.out b/ql/src/test/results/clientpositive/llap/orc_llap_counters.q.out index 8ba49f6..7000727 100644 --- a/ql/src/test/results/clientpositive/llap/orc_llap_counters.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_llap_counters.q.out @@ -134,9 +134,9 @@ POSTHOOK: Lineage: orc_ppd_staging.b SIMPLE [] POSTHOOK: Lineage: orc_ppd_staging.bin EXPRESSION [] POSTHOOK: Lineage: orc_ppd_staging.bo SIMPLE [] POSTHOOK: Lineage: orc_ppd_staging.c EXPRESSION [] -POSTHOOK: Lineage: orc_ppd_staging.d EXPRESSION [] +POSTHOOK: Lineage: orc_ppd_staging.d SIMPLE [] POSTHOOK: Lineage: orc_ppd_staging.da EXPRESSION [] -POSTHOOK: Lineage: orc_ppd_staging.dec SIMPLE [] +POSTHOOK: Lineage: orc_ppd_staging.dec EXPRESSION [] POSTHOOK: Lineage: orc_ppd_staging.f EXPRESSION [] POSTHOOK: Lineage: orc_ppd_staging.i SIMPLE [] POSTHOOK: Lineage: orc_ppd_staging.s SIMPLE [] @@ -1089,7 +1089,7 @@ Stage-1 HIVE COUNTERS: DESERIALIZE_ERRORS: 0 RECORDS_IN_Map_1: 0 RECORDS_OUT_0: 1 - RECORDS_OUT_INTERMEDIATE_Map_1: 1 + RECORDS_OUT_INTERMEDIATE_Map_1: 0 Stage-1 LLAP IO COUNTERS: METADATA_CACHE_HIT: 2 SELECTED_ROWGROUPS: 0 http://git-wip-us.apache.org/repos/asf/hive/blob/62a3778e/ql/src/test/results/clientpositive/llap/orc_llap_counters1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_llap_counters1.q.out b/ql/src/test/results/clientpositive/llap/orc_llap_counters1.q.out index 5c54622..63dc834 100644 --- a/ql/src/test/results/clientpositive/llap/orc_llap_counters1.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_llap_counters1.q.out @@ -134,9 +134,9 @@ POSTHOOK: Lineage: orc_ppd_staging.b SIMPLE [] POSTHOOK: Lineage: orc_ppd_staging.bin EXPRESSION [] POSTHOOK: Lineage: orc_ppd_staging.bo SIMPLE [] POSTHOOK: Lineage: orc_ppd_staging.c EXPRESSION [] -POSTHOOK: Lineage: orc_ppd_staging.d EXPRESSION [] +POSTHOOK: Lineage: orc_ppd_staging.d SIMPLE [] POSTHOOK: Lineage: orc_ppd_staging.da EXPRESSION [] -POSTHOOK: Lineage: orc_ppd_staging.dec SIMPLE [] +POSTHOOK: Lineage: orc_ppd_staging.dec EXPRESSION [] POSTHOOK: Lineage: orc_ppd_staging.f EXPRESSION [] POSTHOOK: Lineage: orc_ppd_staging.i SIMPLE [] POSTHOOK: Lineage: orc_ppd_staging.s SIMPLE []
