http://git-wip-us.apache.org/repos/asf/hive/blob/4d592303/ql/src/test/results/clientpositive/tez/vector_multi_insert.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_multi_insert.q.out b/ql/src/test/results/clientpositive/tez/vector_multi_insert.q.out index b54f496..1080bf4 100644 --- a/ql/src/test/results/clientpositive/tez/vector_multi_insert.q.out +++ b/ql/src/test/results/clientpositive/tez/vector_multi_insert.q.out @@ -85,17 +85,17 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a - Statistics: Num rows: 154 Data size: 616 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (rn < 100) (type: boolean) - Statistics: Num rows: 51 Data size: 204 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: rn (type: int) outputColumnNames: _col0 - Statistics: Num rows: 51 Data size: 204 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 51 Data size: 204 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -103,14 +103,14 @@ STAGE PLANS: name: default.orc_rn1 Filter Operator predicate: ((rn >= 100) and (rn < 1000)) (type: boolean) - Statistics: Num rows: 17 Data size: 68 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: rn (type: int) outputColumnNames: _col0 - Statistics: Num rows: 17 Data size: 68 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 17 Data size: 68 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -118,14 +118,14 @@ STAGE PLANS: name: default.orc_rn2 Filter Operator predicate: (rn >= 1000) (type: boolean) - Statistics: Num rows: 51 Data size: 204 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: rn (type: int) outputColumnNames: _col0 - Statistics: Num rows: 51 Data size: 204 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 51 Data size: 204 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/4d592303/ql/src/test/results/clientpositive/tez/vector_outer_join1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_outer_join1.q.out b/ql/src/test/results/clientpositive/tez/vector_outer_join1.q.out index a2f4458..4101c35 100644 --- a/ql/src/test/results/clientpositive/tez/vector_outer_join1.q.out +++ b/ql/src/test/results/clientpositive/tez/vector_outer_join1.q.out @@ -111,11 +111,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 13 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint), csmallint (type: smallint), cint (type: int), cbigint (type: bigint), cfloat (type: float), cdouble (type: double), cstring1 (type: string), cstring2 (type: string), ctimestamp1 (type: timestamp), ctimestamp2 (type: timestamp), cboolean1 (type: boolean), cboolean2 (type: boolean) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11 - Statistics: Num rows: 13 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -125,11 +125,11 @@ STAGE PLANS: outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23 input vertices: 1 Map 2 - Statistics: Num rows: 14 Data size: 4601 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true File Output Operator compressed: false - Statistics: Num rows: 14 Data size: 4601 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -139,16 +139,16 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 13 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint), csmallint (type: smallint), cint (type: int), cbigint (type: bigint), cfloat (type: float), cdouble (type: double), cstring1 (type: string), cstring2 (type: string), ctimestamp1 (type: timestamp), ctimestamp2 (type: timestamp), cboolean1 (type: boolean), cboolean2 (type: boolean) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11 - Statistics: Num rows: 13 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col2 (type: int) sort order: + Map-reduce partition columns: _col2 (type: int) - Statistics: Num rows: 13 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col3 (type: bigint), _col4 (type: float), _col5 (type: double), _col6 (type: string), _col7 (type: string), _col8 (type: timestamp), _col9 (type: timestamp), _col10 (type: boolean), _col11 (type: boolean) Execution mode: vectorized @@ -218,11 +218,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint) outputColumnNames: _col0 - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -232,11 +232,11 @@ STAGE PLANS: outputColumnNames: _col0 input vertices: 1 Map 2 - Statistics: Num rows: 1149 Data size: 4601 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true File Output Operator compressed: false - Statistics: Num rows: 1149 Data size: 4601 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -246,16 +246,16 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint) outputColumnNames: _col0 - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: tinyint) sort order: + Map-reduce partition columns: _col0 (type: tinyint) - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Stage: Stage-0 @@ -357,11 +357,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 522 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint), cint (type: int) outputColumnNames: _col0, _col1 - Statistics: Num rows: 522 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -371,7 +371,7 @@ STAGE PLANS: outputColumnNames: _col0 input vertices: 1 Map 3 - Statistics: Num rows: 1149 Data size: 4601 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Map Join Operator condition map: @@ -382,7 +382,7 @@ STAGE PLANS: outputColumnNames: _col0 input vertices: 1 Map 4 - Statistics: Num rows: 1263 Data size: 5061 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 17 Data size: 4578 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Group By Operator aggregations: count(), sum(_col0) @@ -398,31 +398,31 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map 4 Map Operator Tree: TableScan alias: c - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint) outputColumnNames: _col0 - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: tinyint) sort order: + Map-reduce partition columns: _col0 (type: tinyint) - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Reducer 2 Reduce Operator Tree: http://git-wip-us.apache.org/repos/asf/hive/blob/4d592303/ql/src/test/results/clientpositive/tez/vector_outer_join2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_outer_join2.q.out b/ql/src/test/results/clientpositive/tez/vector_outer_join2.q.out index 8c8f54e..b8e18e0 100644 --- a/ql/src/test/results/clientpositive/tez/vector_outer_join2.q.out +++ b/ql/src/test/results/clientpositive/tez/vector_outer_join2.q.out @@ -118,11 +118,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 348 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int), cbigint (type: bigint) outputColumnNames: _col0, _col1 - Statistics: Num rows: 348 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -132,7 +132,7 @@ STAGE PLANS: outputColumnNames: _col1 input vertices: 1 Map 3 - Statistics: Num rows: 1149 Data size: 4601 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Map Join Operator condition map: @@ -143,12 +143,12 @@ STAGE PLANS: outputColumnNames: _col1 input vertices: 1 Map 4 - Statistics: Num rows: 1263 Data size: 5061 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 17 Data size: 4578 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Select Operator expressions: _col1 (type: bigint) outputColumnNames: _col0 - Statistics: Num rows: 1263 Data size: 5061 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 17 Data size: 4578 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(), sum(_col0) mode: hash @@ -163,31 +163,31 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map 4 Map Operator Tree: TableScan alias: c - Statistics: Num rows: 522 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cbigint (type: bigint) outputColumnNames: _col0 - Statistics: Num rows: 522 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: bigint) sort order: + Map-reduce partition columns: _col0 (type: bigint) - Statistics: Num rows: 522 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Reducer 2 Reduce Operator Tree: http://git-wip-us.apache.org/repos/asf/hive/blob/4d592303/ql/src/test/results/clientpositive/tez/vector_outer_join3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_outer_join3.q.out b/ql/src/test/results/clientpositive/tez/vector_outer_join3.q.out index fa47a03..b5619a0 100644 --- a/ql/src/test/results/clientpositive/tez/vector_outer_join3.q.out +++ b/ql/src/test/results/clientpositive/tez/vector_outer_join3.q.out @@ -118,11 +118,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 40 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int), cstring1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 40 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -132,7 +132,7 @@ STAGE PLANS: outputColumnNames: _col1 input vertices: 1 Map 3 - Statistics: Num rows: 1149 Data size: 4601 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Map Join Operator condition map: @@ -142,7 +142,7 @@ STAGE PLANS: 1 _col0 (type: string) input vertices: 1 Map 4 - Statistics: Num rows: 1263 Data size: 5061 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 17 Data size: 4578 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Group By Operator aggregations: count() @@ -158,31 +158,31 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1045 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map 4 Map Operator Tree: TableScan alias: c - Statistics: Num rows: 41 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cstring1 (type: string) outputColumnNames: _col0 - Statistics: Num rows: 41 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 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: 41 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Reducer 2 Reduce Operator Tree: @@ -265,11 +265,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 20 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cstring1 (type: string), cstring2 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 20 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -279,7 +279,7 @@ STAGE PLANS: outputColumnNames: _col0 input vertices: 1 Map 3 - Statistics: Num rows: 45 Data size: 4601 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Map Join Operator condition map: @@ -289,7 +289,7 @@ STAGE PLANS: 1 _col0 (type: string) input vertices: 1 Map 4 - Statistics: Num rows: 49 Data size: 5061 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 17 Data size: 4578 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Group By Operator aggregations: count() @@ -305,31 +305,31 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 41 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cstring2 (type: string) outputColumnNames: _col0 - Statistics: Num rows: 41 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 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: 41 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map 4 Map Operator Tree: TableScan alias: c - Statistics: Num rows: 41 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cstring1 (type: string) outputColumnNames: _col0 - Statistics: Num rows: 41 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 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: 41 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Reducer 2 Reduce Operator Tree: @@ -412,11 +412,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 19 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int), cbigint (type: bigint), cstring1 (type: string), cstring2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 19 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -426,7 +426,7 @@ STAGE PLANS: outputColumnNames: _col0, _col2 input vertices: 1 Map 3 - Statistics: Num rows: 41 Data size: 4601 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Map Join Operator condition map: @@ -436,7 +436,7 @@ STAGE PLANS: 1 _col1 (type: string), _col0 (type: int) input vertices: 1 Map 4 - Statistics: Num rows: 45 Data size: 5061 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 17 Data size: 4578 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Group By Operator aggregations: count() @@ -452,31 +452,31 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 38 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cbigint (type: bigint), cstring2 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 38 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col1 (type: string), _col0 (type: bigint) sort order: ++ Map-reduce partition columns: _col1 (type: string), _col0 (type: bigint) - Statistics: Num rows: 38 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map 4 Map Operator Tree: TableScan alias: c - Statistics: Num rows: 40 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int), cstring1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 40 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col1 (type: string), _col0 (type: int) sort order: ++ Map-reduce partition columns: _col1 (type: string), _col0 (type: int) - Statistics: Num rows: 40 Data size: 4183 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Reducer 2 Reduce Operator Tree: http://git-wip-us.apache.org/repos/asf/hive/blob/4d592303/ql/src/test/results/clientpositive/tez/vector_outer_join4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_outer_join4.q.out b/ql/src/test/results/clientpositive/tez/vector_outer_join4.q.out index a73cd06..2c9a9cd 100644 --- a/ql/src/test/results/clientpositive/tez/vector_outer_join4.q.out +++ b/ql/src/test/results/clientpositive/tez/vector_outer_join4.q.out @@ -111,11 +111,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 12 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint), csmallint (type: smallint), cint (type: int), cbigint (type: bigint), cfloat (type: float), cdouble (type: double), cstring1 (type: string), cstring2 (type: string), ctimestamp1 (type: timestamp), ctimestamp2 (type: timestamp), cboolean1 (type: boolean), cboolean2 (type: boolean) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11 - Statistics: Num rows: 12 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -125,11 +125,11 @@ STAGE PLANS: outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23 input vertices: 1 Map 2 - Statistics: Num rows: 13 Data size: 4385 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 33 Data size: 6514 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true File Output Operator compressed: false - Statistics: Num rows: 13 Data size: 4385 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 33 Data size: 6514 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -139,16 +139,16 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 12 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint), csmallint (type: smallint), cint (type: int), cbigint (type: bigint), cfloat (type: float), cdouble (type: double), cstring1 (type: string), cstring2 (type: string), ctimestamp1 (type: timestamp), ctimestamp2 (type: timestamp), cboolean1 (type: boolean), cboolean2 (type: boolean) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11 - Statistics: Num rows: 12 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col2 (type: int) sort order: + Map-reduce partition columns: _col2 (type: int) - Statistics: Num rows: 12 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col3 (type: bigint), _col4 (type: float), _col5 (type: double), _col6 (type: string), _col7 (type: string), _col8 (type: timestamp), _col9 (type: timestamp), _col10 (type: boolean), _col11 (type: boolean) Execution mode: vectorized @@ -613,11 +613,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 996 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint) outputColumnNames: _col0 - Statistics: Num rows: 996 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -627,11 +627,11 @@ STAGE PLANS: outputColumnNames: _col0 input vertices: 1 Map 2 - Statistics: Num rows: 1095 Data size: 4385 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 33 Data size: 6514 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true File Output Operator compressed: false - Statistics: Num rows: 1095 Data size: 4385 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 33 Data size: 6514 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -641,16 +641,16 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 996 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint) outputColumnNames: _col0 - Statistics: Num rows: 996 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: tinyint) sort order: + Map-reduce partition columns: _col0 (type: tinyint) - Statistics: Num rows: 996 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Stage: Stage-0 @@ -749,11 +749,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 498 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint), cint (type: int) outputColumnNames: _col0, _col1 - Statistics: Num rows: 498 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -763,7 +763,7 @@ STAGE PLANS: outputColumnNames: _col0 input vertices: 1 Map 3 - Statistics: Num rows: 1095 Data size: 4385 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 33 Data size: 6514 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Map Join Operator condition map: @@ -773,7 +773,7 @@ STAGE PLANS: 1 _col0 (type: tinyint) input vertices: 1 Map 4 - Statistics: Num rows: 1204 Data size: 4823 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 36 Data size: 7165 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Group By Operator aggregations: count() @@ -789,31 +789,31 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 996 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int) outputColumnNames: _col0 - Statistics: Num rows: 996 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 996 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map 4 Map Operator Tree: TableScan alias: c - Statistics: Num rows: 996 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint) outputColumnNames: _col0 - Statistics: Num rows: 996 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: tinyint) sort order: + Map-reduce partition columns: _col0 (type: tinyint) - Statistics: Num rows: 996 Data size: 3987 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 30 Data size: 5922 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Reducer 2 Reduce Operator Tree: