Repository: hive Updated Branches: refs/heads/branch-1.2 bc3249948 -> 70108e115
HIVE-11026 : Make vector_outer_join* test more robust (Ashutosh Chauhan via Hari Sankar) Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/70108e11 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/70108e11 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/70108e11 Branch: refs/heads/branch-1.2 Commit: 70108e115875797d6476d7c7d5f6ec07f312dcb9 Parents: bc32499 Author: Ashutosh Chauhan <hashut...@apache.org> Authored: Wed Jun 17 00:42:21 2015 -0700 Committer: Ashutosh Chauhan <hashut...@apache.org> Committed: Wed Jun 17 00:44:27 2015 -0700 ---------------------------------------------------------------------- .../queries/clientpositive/vector_outer_join1.q | 5 +- .../queries/clientpositive/vector_outer_join2.q | 5 +- .../queries/clientpositive/vector_outer_join3.q | 6 +- .../clientpositive/tez/vector_outer_join1.q.out | 50 ++++++++-------- .../clientpositive/tez/vector_outer_join2.q.out | 24 ++++---- .../clientpositive/tez/vector_outer_join3.q.out | 62 ++++++++++---------- .../clientpositive/vector_outer_join1.q.out | 2 + .../clientpositive/vector_outer_join2.q.out | 2 + .../clientpositive/vector_outer_join3.q.out | 2 + 9 files changed, 87 insertions(+), 71 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/70108e11/ql/src/test/queries/clientpositive/vector_outer_join1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/vector_outer_join1.q b/ql/src/test/queries/clientpositive/vector_outer_join1.q index 5a1aa0b..b695b08 100644 --- a/ql/src/test/queries/clientpositive/vector_outer_join1.q +++ b/ql/src/test/queries/clientpositive/vector_outer_join1.q @@ -13,7 +13,8 @@ create table small_alltypesorc_a stored as orc as select * from union all select * from (select * from small_alltypesorc3a) sq3 union all - select * from (select * from small_alltypesorc4a) sq4) q; + select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1; ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS; ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS FOR COLUMNS; @@ -61,4 +62,4 @@ left outer join small_alltypesorc_a cd on cd.cint = c.cint left outer join small_alltypesorc_a hd on hd.ctinyint = c.ctinyint -) t1; \ No newline at end of file +) t1; http://git-wip-us.apache.org/repos/asf/hive/blob/70108e11/ql/src/test/queries/clientpositive/vector_outer_join2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/vector_outer_join2.q b/ql/src/test/queries/clientpositive/vector_outer_join2.q index b3503fd..d7abb21 100644 --- a/ql/src/test/queries/clientpositive/vector_outer_join2.q +++ b/ql/src/test/queries/clientpositive/vector_outer_join2.q @@ -14,7 +14,8 @@ create table small_alltypesorc_a stored as orc as select * from union all select * from (select * from small_alltypesorc3a) sq3 union all - select * from (select * from small_alltypesorc4a) sq4) q; + select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1; ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS; ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS FOR COLUMNS; @@ -36,4 +37,4 @@ left outer join small_alltypesorc_a cd on cd.cint = c.cint left outer join small_alltypesorc_a hd on hd.cbigint = c.cbigint -) t1; \ No newline at end of file +) t1; http://git-wip-us.apache.org/repos/asf/hive/blob/70108e11/ql/src/test/queries/clientpositive/vector_outer_join3.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/vector_outer_join3.q b/ql/src/test/queries/clientpositive/vector_outer_join3.q index a612ab0..f256e39 100644 --- a/ql/src/test/queries/clientpositive/vector_outer_join3.q +++ b/ql/src/test/queries/clientpositive/vector_outer_join3.q @@ -14,7 +14,9 @@ create table small_alltypesorc_a stored as orc as select * from union all select * from (select * from small_alltypesorc3a) sq3 union all - select * from (select * from small_alltypesorc4a) sq4) q; + select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1; + ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS; ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS FOR COLUMNS; @@ -77,4 +79,4 @@ left outer join small_alltypesorc_a cd on cd.cstring2 = c.cstring2 and cd.cbigint = c.cbigint left outer join small_alltypesorc_a hd on hd.cstring1 = c.cstring1 and hd.cint = c.cint -) t1; \ No newline at end of file +) t1; http://git-wip-us.apache.org/repos/asf/hive/blob/70108e11/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 4101c35..95ed151 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 @@ -46,6 +46,7 @@ PREHOOK: query: create table small_alltypesorc_a stored as orc as select * from select * from (select * from small_alltypesorc3a) sq3 union all select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@small_alltypesorc1a PREHOOK: Input: default@small_alltypesorc2a @@ -61,6 +62,7 @@ POSTHOOK: query: create table small_alltypesorc_a stored as orc as select * from select * from (select * from small_alltypesorc3a) sq3 union all select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@small_alltypesorc1a POSTHOOK: Input: default@small_alltypesorc2a @@ -111,11 +113,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -125,11 +127,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: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4070 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true File Output Operator compressed: false - Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4070 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 +141,16 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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 +220,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint) outputColumnNames: _col0 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -232,11 +234,11 @@ STAGE PLANS: outputColumnNames: _col0 input vertices: 1 Map 2 - Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4070 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true File Output Operator compressed: false - Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4070 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 +248,16 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint) outputColumnNames: _col0 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Stage: Stage-0 @@ -357,11 +359,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint), cint (type: int) outputColumnNames: _col0, _col1 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -371,7 +373,7 @@ STAGE PLANS: outputColumnNames: _col0 input vertices: 1 Map 3 - Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4070 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Map Join Operator condition map: @@ -382,7 +384,7 @@ STAGE PLANS: outputColumnNames: _col0 input vertices: 1 Map 4 - Statistics: Num rows: 17 Data size: 4578 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 17 Data size: 4477 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Group By Operator aggregations: count(), sum(_col0) @@ -398,31 +400,31 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int) outputColumnNames: _col0 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map 4 Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ctinyint (type: tinyint) outputColumnNames: _col0 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Reducer 2 Reduce Operator Tree: http://git-wip-us.apache.org/repos/asf/hive/blob/70108e11/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 b8e18e0..31ef469 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 @@ -46,6 +46,7 @@ PREHOOK: query: create table small_alltypesorc_a stored as orc as select * from select * from (select * from small_alltypesorc3a) sq3 union all select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@small_alltypesorc1a PREHOOK: Input: default@small_alltypesorc2a @@ -61,6 +62,7 @@ POSTHOOK: query: create table small_alltypesorc_a stored as orc as select * from select * from (select * from small_alltypesorc3a) sq3 union all select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@small_alltypesorc1a POSTHOOK: Input: default@small_alltypesorc2a @@ -118,11 +120,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int), cbigint (type: bigint) outputColumnNames: _col0, _col1 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -132,7 +134,7 @@ STAGE PLANS: outputColumnNames: _col1 input vertices: 1 Map 3 - Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4070 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Map Join Operator condition map: @@ -143,12 +145,12 @@ STAGE PLANS: outputColumnNames: _col1 input vertices: 1 Map 4 - Statistics: Num rows: 17 Data size: 4578 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 17 Data size: 4477 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Select Operator expressions: _col1 (type: bigint) outputColumnNames: _col0 - Statistics: Num rows: 17 Data size: 4578 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 17 Data size: 4477 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(), sum(_col0) mode: hash @@ -163,31 +165,31 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int) outputColumnNames: _col0 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map 4 Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cbigint (type: bigint) outputColumnNames: _col0 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Reducer 2 Reduce Operator Tree: http://git-wip-us.apache.org/repos/asf/hive/blob/70108e11/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 b5619a0..75c4215 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 @@ -46,6 +46,7 @@ PREHOOK: query: create table small_alltypesorc_a stored as orc as select * from select * from (select * from small_alltypesorc3a) sq3 union all select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@small_alltypesorc1a PREHOOK: Input: default@small_alltypesorc2a @@ -61,6 +62,7 @@ POSTHOOK: query: create table small_alltypesorc_a stored as orc as select * from select * from (select * from small_alltypesorc3a) sq3 union all select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@small_alltypesorc1a POSTHOOK: Input: default@small_alltypesorc2a @@ -118,11 +120,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int), cstring1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -132,7 +134,7 @@ STAGE PLANS: outputColumnNames: _col1 input vertices: 1 Map 3 - Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4070 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Map Join Operator condition map: @@ -142,7 +144,7 @@ STAGE PLANS: 1 _col0 (type: string) input vertices: 1 Map 4 - Statistics: Num rows: 17 Data size: 4578 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 17 Data size: 4477 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Group By Operator aggregations: count() @@ -158,31 +160,31 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int) outputColumnNames: _col0 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map 4 Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cstring1 (type: string) outputColumnNames: _col0 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Reducer 2 Reduce Operator Tree: @@ -265,11 +267,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cstring1 (type: string), cstring2 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -279,7 +281,7 @@ STAGE PLANS: outputColumnNames: _col0 input vertices: 1 Map 3 - Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4070 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Map Join Operator condition map: @@ -289,7 +291,7 @@ STAGE PLANS: 1 _col0 (type: string) input vertices: 1 Map 4 - Statistics: Num rows: 17 Data size: 4578 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 17 Data size: 4477 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Group By Operator aggregations: count() @@ -305,31 +307,31 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cstring2 (type: string) outputColumnNames: _col0 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map 4 Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cstring1 (type: string) outputColumnNames: _col0 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Reducer 2 Reduce Operator Tree: @@ -412,11 +414,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join0 to 1 @@ -426,7 +428,7 @@ STAGE PLANS: outputColumnNames: _col0, _col2 input vertices: 1 Map 3 - Statistics: Num rows: 16 Data size: 4162 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 16 Data size: 4070 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Map Join Operator condition map: @@ -436,7 +438,7 @@ STAGE PLANS: 1 _col1 (type: string), _col0 (type: int) input vertices: 1 Map 4 - Statistics: Num rows: 17 Data size: 4578 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 17 Data size: 4477 Basic stats: COMPLETE Column stats: NONE HybridGraceHashJoin: true Group By Operator aggregations: count() @@ -452,31 +454,31 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cbigint (type: bigint), cstring2 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map 4 Map Operator Tree: TableScan alias: c - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: cint (type: int), cstring1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 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: 15 Data size: 3784 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 3700 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Reducer 2 Reduce Operator Tree: http://git-wip-us.apache.org/repos/asf/hive/blob/70108e11/ql/src/test/results/clientpositive/vector_outer_join1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_outer_join1.q.out b/ql/src/test/results/clientpositive/vector_outer_join1.q.out index c7c89ba..2d3f2d8 100644 --- a/ql/src/test/results/clientpositive/vector_outer_join1.q.out +++ b/ql/src/test/results/clientpositive/vector_outer_join1.q.out @@ -46,6 +46,7 @@ PREHOOK: query: create table small_alltypesorc_a stored as orc as select * from select * from (select * from small_alltypesorc3a) sq3 union all select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@small_alltypesorc1a PREHOOK: Input: default@small_alltypesorc2a @@ -61,6 +62,7 @@ POSTHOOK: query: create table small_alltypesorc_a stored as orc as select * from select * from (select * from small_alltypesorc3a) sq3 union all select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@small_alltypesorc1a POSTHOOK: Input: default@small_alltypesorc2a http://git-wip-us.apache.org/repos/asf/hive/blob/70108e11/ql/src/test/results/clientpositive/vector_outer_join2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_outer_join2.q.out b/ql/src/test/results/clientpositive/vector_outer_join2.q.out index ff2e52a..096ce7b 100644 --- a/ql/src/test/results/clientpositive/vector_outer_join2.q.out +++ b/ql/src/test/results/clientpositive/vector_outer_join2.q.out @@ -46,6 +46,7 @@ PREHOOK: query: create table small_alltypesorc_a stored as orc as select * from select * from (select * from small_alltypesorc3a) sq3 union all select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@small_alltypesorc1a PREHOOK: Input: default@small_alltypesorc2a @@ -61,6 +62,7 @@ POSTHOOK: query: create table small_alltypesorc_a stored as orc as select * from select * from (select * from small_alltypesorc3a) sq3 union all select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@small_alltypesorc1a POSTHOOK: Input: default@small_alltypesorc2a http://git-wip-us.apache.org/repos/asf/hive/blob/70108e11/ql/src/test/results/clientpositive/vector_outer_join3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_outer_join3.q.out b/ql/src/test/results/clientpositive/vector_outer_join3.q.out index 901808c..6eca0b5 100644 --- a/ql/src/test/results/clientpositive/vector_outer_join3.q.out +++ b/ql/src/test/results/clientpositive/vector_outer_join3.q.out @@ -46,6 +46,7 @@ PREHOOK: query: create table small_alltypesorc_a stored as orc as select * from select * from (select * from small_alltypesorc3a) sq3 union all select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@small_alltypesorc1a PREHOOK: Input: default@small_alltypesorc2a @@ -61,6 +62,7 @@ POSTHOOK: query: create table small_alltypesorc_a stored as orc as select * from select * from (select * from small_alltypesorc3a) sq3 union all select * from (select * from small_alltypesorc4a) sq4) q +order by cint, ctinyint, cstring1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@small_alltypesorc1a POSTHOOK: Input: default@small_alltypesorc2a
