hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject hive git commit: HIVE-11026 : Make vector_outer_join* test more robust (Ashutosh Chauhan via Hari Sankar)
Date Wed, 17 Jun 2015 07:43:39 GMT
Repository: hive
Updated Branches:
  refs/heads/master b86f10d0f -> a3792b7b7


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/a3792b7b
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/a3792b7b
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/a3792b7b

Branch: refs/heads/master
Commit: a3792b7b785f0b8db3d557db31cd1f9b2cd0acdc
Parents: b86f10d
Author: Ashutosh Chauhan <hashutosh@apache.org>
Authored: Wed Jun 17 00:42:21 2015 -0700
Committer: Ashutosh Chauhan <hashutosh@apache.org>
Committed: Wed Jun 17 00:42:21 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/a3792b7b/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/a3792b7b/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/a3792b7b/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/a3792b7b/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/a3792b7b/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/a3792b7b/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/a3792b7b/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/a3792b7b/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/a3792b7b/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


Mime
View raw message