You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by su...@apache.org on 2017/05/18 05:39:34 UTC

[3/7] hive git commit: HIVE-16696: Fix JoinCondDesc explain string (Chao Sun, reviewed by Xuefu Zhang)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out b/ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out
index 28a2e00..43ed467 100644
--- a/ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out
+++ b/ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out
@@ -303,7 +303,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 6 Data size: 26 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
@@ -317,7 +317,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
@@ -594,7 +594,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                 Statistics: Num rows: 6 Data size: 26 Basic stats: COMPLETE Column stats: NONE
                 Group By Operator
                   aggregations: count(1)
@@ -623,7 +623,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                 Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                 Group By Operator
                   aggregations: count(1)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out b/ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out
index 3646478..3c46e95 100644
--- a/ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out
+++ b/ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out
@@ -260,7 +260,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 1 Data size: 33 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
@@ -274,7 +274,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 1 Data size: 33 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
@@ -560,7 +560,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 outputColumnNames: _col0
                 Statistics: Num rows: 1 Data size: 33 Basic stats: COMPLETE Column stats: NONE
                 Group By Operator
@@ -594,7 +594,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 outputColumnNames: _col0
                 Statistics: Num rows: 1 Data size: 33 Basic stats: COMPLETE Column stats: NONE
                 Group By Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/smb_mapjoin_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/smb_mapjoin_1.q.out b/ql/src/test/results/clientpositive/spark/smb_mapjoin_1.q.out
index 5de1ea4..df29e99 100644
--- a/ql/src/test/results/clientpositive/spark/smb_mapjoin_1.q.out
+++ b/ql/src/test/results/clientpositive/spark/smb_mapjoin_1.q.out
@@ -127,7 +127,7 @@ STAGE PLANS:
                   Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
-                         Left Outer Join0 to 1
+                         Left Outer Join 0 to 1
                     keys:
                       0 key (type: int)
                       1 key (type: int)
@@ -188,7 +188,7 @@ STAGE PLANS:
                   Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
-                         Right Outer Join0 to 1
+                         Right Outer Join 0 to 1
                     keys:
                       0 key (type: int)
                       1 key (type: int)
@@ -372,7 +372,7 @@ STAGE PLANS:
                   Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
-                         Left Outer Join0 to 1
+                         Left Outer Join 0 to 1
                     keys:
                       0 key (type: int)
                       1 key (type: int)
@@ -433,7 +433,7 @@ STAGE PLANS:
                   Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
-                         Right Outer Join0 to 1
+                         Right Outer Join 0 to 1
                     keys:
                       0 key (type: int)
                       1 key (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/smb_mapjoin_17.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/smb_mapjoin_17.q.out b/ql/src/test/results/clientpositive/spark/smb_mapjoin_17.q.out
index 18e6e85..c9422ea 100644
--- a/ql/src/test/results/clientpositive/spark/smb_mapjoin_17.q.out
+++ b/ql/src/test/results/clientpositive/spark/smb_mapjoin_17.q.out
@@ -429,12 +429,12 @@ STAGE PLANS:
                     Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
                     Sorted Merge Bucket Map Join Operator
                       condition map:
-                           Left Outer Join0 to 1
-                           Left Outer Join0 to 2
-                           Left Outer Join0 to 3
-                           Left Outer Join0 to 4
-                           Left Outer Join0 to 5
-                           Left Outer Join0 to 6
+                           Left Outer Join 0 to 1
+                           Left Outer Join 0 to 2
+                           Left Outer Join 0 to 3
+                           Left Outer Join 0 to 4
+                           Left Outer Join 0 to 5
+                           Left Outer Join 0 to 6
                       keys:
                         0 _col0 (type: int)
                         1 _col0 (type: int)
@@ -549,13 +549,13 @@ STAGE PLANS:
                     Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
                     Sorted Merge Bucket Map Join Operator
                       condition map:
-                           Left Outer Join0 to 1
-                           Left Outer Join0 to 2
-                           Left Outer Join0 to 3
-                           Left Outer Join0 to 4
-                           Left Outer Join0 to 5
-                           Left Outer Join0 to 6
-                           Left Outer Join0 to 7
+                           Left Outer Join 0 to 1
+                           Left Outer Join 0 to 2
+                           Left Outer Join 0 to 3
+                           Left Outer Join 0 to 4
+                           Left Outer Join 0 to 5
+                           Left Outer Join 0 to 6
+                           Left Outer Join 0 to 7
                       keys:
                         0 _col0 (type: int)
                         1 _col0 (type: int)
@@ -777,21 +777,21 @@ STAGE PLANS:
                     Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
                     Sorted Merge Bucket Map Join Operator
                       condition map:
-                           Left Outer Join0 to 1
-                           Left Outer Join0 to 2
-                           Left Outer Join0 to 3
-                           Left Outer Join0 to 4
-                           Left Outer Join0 to 5
-                           Left Outer Join0 to 6
-                           Left Outer Join0 to 7
-                           Left Outer Join0 to 8
-                           Left Outer Join0 to 9
-                           Left Outer Join0 to 10
-                           Left Outer Join0 to 11
-                           Left Outer Join0 to 12
-                           Left Outer Join0 to 13
-                           Left Outer Join0 to 14
-                           Left Outer Join0 to 15
+                           Left Outer Join 0 to 1
+                           Left Outer Join 0 to 2
+                           Left Outer Join 0 to 3
+                           Left Outer Join 0 to 4
+                           Left Outer Join 0 to 5
+                           Left Outer Join 0 to 6
+                           Left Outer Join 0 to 7
+                           Left Outer Join 0 to 8
+                           Left Outer Join 0 to 9
+                           Left Outer Join 0 to 10
+                           Left Outer Join 0 to 11
+                           Left Outer Join 0 to 12
+                           Left Outer Join 0 to 13
+                           Left Outer Join 0 to 14
+                           Left Outer Join 0 to 15
                       keys:
                         0 _col0 (type: int)
                         1 _col0 (type: int)
@@ -813,10 +813,10 @@ STAGE PLANS:
                       Statistics: Num rows: 165 Data size: 1155 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
-                             Left Outer Join0 to 1
-                             Left Outer Join0 to 2
-                             Left Outer Join0 to 3
-                             Left Outer Join0 to 4
+                             Left Outer Join 0 to 1
+                             Left Outer Join 0 to 2
+                             Left Outer Join 0 to 3
+                             Left Outer Join 0 to 4
                         keys:
                           0 _col0 (type: int)
                           1 _col0 (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/smb_mapjoin_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/smb_mapjoin_2.q.out b/ql/src/test/results/clientpositive/spark/smb_mapjoin_2.q.out
index be4abc6..f6294b5 100644
--- a/ql/src/test/results/clientpositive/spark/smb_mapjoin_2.q.out
+++ b/ql/src/test/results/clientpositive/spark/smb_mapjoin_2.q.out
@@ -129,7 +129,7 @@ STAGE PLANS:
                   Statistics: Num rows: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
-                         Left Outer Join0 to 1
+                         Left Outer Join 0 to 1
                     keys:
                       0 key (type: int)
                       1 key (type: int)
@@ -190,7 +190,7 @@ STAGE PLANS:
                   Statistics: Num rows: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
-                         Right Outer Join0 to 1
+                         Right Outer Join 0 to 1
                     keys:
                       0 key (type: int)
                       1 key (type: int)
@@ -378,7 +378,7 @@ STAGE PLANS:
                   Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
-                         Left Outer Join0 to 1
+                         Left Outer Join 0 to 1
                     keys:
                       0 key (type: int)
                       1 key (type: int)
@@ -439,7 +439,7 @@ STAGE PLANS:
                   Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
-                         Right Outer Join0 to 1
+                         Right Outer Join 0 to 1
                     keys:
                       0 key (type: int)
                       1 key (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/smb_mapjoin_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/smb_mapjoin_3.q.out b/ql/src/test/results/clientpositive/spark/smb_mapjoin_3.q.out
index d7e5d40..4f13539 100644
--- a/ql/src/test/results/clientpositive/spark/smb_mapjoin_3.q.out
+++ b/ql/src/test/results/clientpositive/spark/smb_mapjoin_3.q.out
@@ -129,7 +129,7 @@ STAGE PLANS:
                   Statistics: Num rows: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
-                         Left Outer Join0 to 1
+                         Left Outer Join 0 to 1
                     keys:
                       0 key (type: int)
                       1 key (type: int)
@@ -189,7 +189,7 @@ STAGE PLANS:
                   Statistics: Num rows: 2 Data size: 222 Basic stats: COMPLETE Column stats: NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
-                         Right Outer Join0 to 1
+                         Right Outer Join 0 to 1
                     keys:
                       0 key (type: int)
                       1 key (type: int)
@@ -376,7 +376,7 @@ STAGE PLANS:
                   Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
-                         Left Outer Join0 to 1
+                         Left Outer Join 0 to 1
                     keys:
                       0 key (type: int)
                       1 key (type: int)
@@ -436,7 +436,7 @@ STAGE PLANS:
                   Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats: NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
-                         Right Outer Join0 to 1
+                         Right Outer Join 0 to 1
                     keys:
                       0 key (type: int)
                       1 key (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/smb_mapjoin_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/smb_mapjoin_4.q.out b/ql/src/test/results/clientpositive/spark/smb_mapjoin_4.q.out
index 0efc8ab..432d4bc 100644
--- a/ql/src/test/results/clientpositive/spark/smb_mapjoin_4.q.out
+++ b/ql/src/test/results/clientpositive/spark/smb_mapjoin_4.q.out
@@ -330,8 +330,8 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
-                     Left Outer Join1 to 2
+                     Left Outer Join 0 to 1
+                     Left Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
@@ -435,8 +435,8 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
-                     Right Outer Join1 to 2
+                     Left Outer Join 0 to 1
+                     Right Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
@@ -541,7 +541,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                      Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
@@ -661,7 +661,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                      Inner Join 1 to 2
                 keys:
                   0 _col0 (type: int)
@@ -763,8 +763,8 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
-                     Left Outer Join1 to 2
+                     Right Outer Join 0 to 1
+                     Left Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
@@ -867,8 +867,8 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
-                     Right Outer Join1 to 2
+                     Right Outer Join 0 to 1
+                     Right Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
@@ -973,7 +973,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                      Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
@@ -1090,7 +1090,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                      Inner Join 1 to 2
                 keys:
                   0 _col0 (type: int)
@@ -1193,7 +1193,7 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Outer Join 0 to 1
-                     Left Outer Join1 to 2
+                     Left Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
@@ -1302,7 +1302,7 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Outer Join 0 to 1
-                     Right Outer Join1 to 2
+                     Right Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out b/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out
index 9f50e9f..d001d6d 100644
--- a/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out
+++ b/ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out
@@ -330,8 +330,8 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
-                     Left Outer Join1 to 2
+                     Left Outer Join 0 to 1
+                     Left Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
@@ -435,8 +435,8 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
-                     Right Outer Join1 to 2
+                     Left Outer Join 0 to 1
+                     Right Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
@@ -541,7 +541,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                      Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
@@ -661,7 +661,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                      Inner Join 1 to 2
                 keys:
                   0 _col0 (type: int)
@@ -763,8 +763,8 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
-                     Left Outer Join1 to 2
+                     Right Outer Join 0 to 1
+                     Left Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
@@ -867,8 +867,8 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
-                     Right Outer Join1 to 2
+                     Right Outer Join 0 to 1
+                     Right Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
@@ -973,7 +973,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                      Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
@@ -1090,7 +1090,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                      Inner Join 1 to 2
                 keys:
                   0 _col0 (type: int)
@@ -1193,7 +1193,7 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Outer Join 0 to 1
-                     Left Outer Join1 to 2
+                     Left Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
@@ -1302,7 +1302,7 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Outer Join 0 to 1
-                     Right Outer Join1 to 2
+                     Right Outer Join 1 to 2
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/subquery_in.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/subquery_in.q.out b/ql/src/test/results/clientpositive/spark/subquery_in.q.out
index fa184d8..5e38938 100644
--- a/ql/src/test/results/clientpositive/spark/subquery_in.q.out
+++ b/ql/src/test/results/clientpositive/spark/subquery_in.q.out
@@ -3831,7 +3831,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col4 (type: string)
                   1 _col0 (type: string)
@@ -4308,7 +4308,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col4 (type: string)
                   1 _col0 (type: string)
@@ -4331,7 +4331,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col4 (type: string)
                   1 _col0 (type: string)
@@ -4347,7 +4347,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col4 (type: string), UDFToLong(_col5) (type: bigint)
                   1 _col1 (type: string), _col0 (type: bigint)
@@ -4546,7 +4546,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
@@ -4569,7 +4569,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
@@ -4585,7 +4585,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col0 (type: int), UDFToDouble(_col5) (type: double)
                   1 _col1 (type: int), _col0 (type: double)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.out b/ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.out
index 3807511..a0adcae 100644
--- a/ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.out
+++ b/ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.out
@@ -175,7 +175,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col0 (type: string)
                   1 _col0 (type: string)
@@ -632,7 +632,7 @@ STAGE PLANS:
                     Statistics: Num rows: 500 Data size: 9812 Basic stats: COMPLETE Column stats: NONE
                     Map Join Operator
                       condition map:
-                           Left Outer Join0 to 1
+                           Left Outer Join 0 to 1
                       keys:
                         0 _col0 (type: string)
                         1 _col0 (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/tez_join_tests.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/tez_join_tests.q.out b/ql/src/test/results/clientpositive/spark/tez_join_tests.q.out
index 5818191..2c95e12 100644
--- a/ql/src/test/results/clientpositive/spark/tez_join_tests.q.out
+++ b/ql/src/test/results/clientpositive/spark/tez_join_tests.q.out
@@ -66,7 +66,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                 keys:
                   0 _col0 (type: string)
                   1 _col0 (type: string)
@@ -93,7 +93,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                 keys:
                   0 _col1 (type: string)
                   1 _col1 (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/tez_joins_explain.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/tez_joins_explain.q.out b/ql/src/test/results/clientpositive/spark/tez_joins_explain.q.out
index 7082df0..24c7b40 100644
--- a/ql/src/test/results/clientpositive/spark/tez_joins_explain.q.out
+++ b/ql/src/test/results/clientpositive/spark/tez_joins_explain.q.out
@@ -66,7 +66,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                 keys:
                   0 _col0 (type: string)
                   1 _col0 (type: string)
@@ -93,7 +93,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                 keys:
                   0 _col1 (type: string)
                   1 _col1 (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/union22.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union22.q.out b/ql/src/test/results/clientpositive/spark/union22.q.out
index 5aa5358..0aaf475 100644
--- a/ql/src/test/results/clientpositive/spark/union22.q.out
+++ b/ql/src/test/results/clientpositive/spark/union22.q.out
@@ -276,7 +276,7 @@ STAGE PLANS:
                       Statistics: Num rows: 166 Data size: 3693 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
-                             Left Outer Join0 to 1
+                             Left Outer Join 0 to 1
                         filter mappings:
                           0 [1, 1]
                         filter predicates:

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/union_lateralview.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_lateralview.q.out b/ql/src/test/results/clientpositive/spark/union_lateralview.q.out
index c223ac6..fe9afb8 100644
--- a/ql/src/test/results/clientpositive/spark/union_lateralview.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_lateralview.q.out
@@ -166,7 +166,7 @@ STAGE PLANS:
             Reduce Operator Tree:
               Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col1 (type: string)
                   1 key (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/vector_left_outer_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vector_left_outer_join.q.out b/ql/src/test/results/clientpositive/spark/vector_left_outer_join.q.out
index 91af229..1e93de9 100644
--- a/ql/src/test/results/clientpositive/spark/vector_left_outer_join.q.out
+++ b/ql/src/test/results/clientpositive/spark/vector_left_outer_join.q.out
@@ -96,7 +96,7 @@ STAGE PLANS:
                     Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                     Map Join Operator
                       condition map:
-                           Left Outer Join0 to 1
+                           Left Outer Join 0 to 1
                       keys:
                         0 _col1 (type: int)
                         1 _col0 (type: int)
@@ -106,7 +106,7 @@ STAGE PLANS:
                       Statistics: Num rows: 13516 Data size: 414960 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
-                             Left Outer Join0 to 1
+                             Left Outer Join 0 to 1
                         keys:
                           0 _col0 (type: tinyint)
                           1 _col0 (type: tinyint)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/vector_outer_join0.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vector_outer_join0.q.out b/ql/src/test/results/clientpositive/spark/vector_outer_join0.q.out
index c664e8f..b99b96f 100644
--- a/ql/src/test/results/clientpositive/spark/vector_outer_join0.q.out
+++ b/ql/src/test/results/clientpositive/spark/vector_outer_join0.q.out
@@ -140,7 +140,7 @@ STAGE PLANS:
                     Statistics: Num rows: 6 Data size: 544 Basic stats: COMPLETE Column stats: NONE
                     Map Join Operator
                       condition map:
-                           Left Outer Join0 to 1
+                           Left Outer Join 0 to 1
                       keys:
                         0 _col1 (type: int)
                         1 _col0 (type: int)
@@ -290,7 +290,7 @@ STAGE PLANS:
                     Statistics: Num rows: 6 Data size: 550 Basic stats: COMPLETE Column stats: NONE
                     Map Join Operator
                       condition map:
-                           Right Outer Join0 to 1
+                           Right Outer Join 0 to 1
                       keys:
                         0 _col1 (type: int)
                         1 _col0 (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/vector_outer_join1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vector_outer_join1.q.out b/ql/src/test/results/clientpositive/spark/vector_outer_join1.q.out
index 88f7796..03e3a47 100644
--- a/ql/src/test/results/clientpositive/spark/vector_outer_join1.q.out
+++ b/ql/src/test/results/clientpositive/spark/vector_outer_join1.q.out
@@ -302,7 +302,7 @@ STAGE PLANS:
                     Statistics: Num rows: 15 Data size: 4033 Basic stats: COMPLETE Column stats: NONE
                     Map Join Operator
                       condition map:
-                           Left Outer Join0 to 1
+                           Left Outer Join 0 to 1
                       keys:
                         0 _col2 (type: int)
                         1 _col2 (type: int)
@@ -475,7 +475,7 @@ STAGE PLANS:
                     Statistics: Num rows: 15 Data size: 4033 Basic stats: COMPLETE Column stats: NONE
                     Map Join Operator
                       condition map:
-                           Left Outer Join0 to 1
+                           Left Outer Join 0 to 1
                       keys:
                         0 _col0 (type: tinyint)
                         1 _col0 (type: tinyint)
@@ -778,7 +778,7 @@ STAGE PLANS:
                     Statistics: Num rows: 15 Data size: 4033 Basic stats: COMPLETE Column stats: NONE
                     Map Join Operator
                       condition map:
-                           Left Outer Join0 to 1
+                           Left Outer Join 0 to 1
                       keys:
                         0 _col1 (type: int)
                         1 _col0 (type: int)
@@ -796,7 +796,7 @@ STAGE PLANS:
                       Statistics: Num rows: 16 Data size: 4436 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
-                             Left Outer Join0 to 1
+                             Left Outer Join 0 to 1
                         keys:
                           0 _col0 (type: tinyint)
                           1 _col0 (type: tinyint)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/spark/vector_outer_join2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vector_outer_join2.q.out b/ql/src/test/results/clientpositive/spark/vector_outer_join2.q.out
index 66ef406..c91f175 100644
--- a/ql/src/test/results/clientpositive/spark/vector_outer_join2.q.out
+++ b/ql/src/test/results/clientpositive/spark/vector_outer_join2.q.out
@@ -359,7 +359,7 @@ STAGE PLANS:
                     Statistics: Num rows: 20 Data size: 5277 Basic stats: COMPLETE Column stats: NONE
                     Map Join Operator
                       condition map:
-                           Left Outer Join0 to 1
+                           Left Outer Join 0 to 1
                       keys:
                         0 _col0 (type: int)
                         1 _col0 (type: int)
@@ -377,7 +377,7 @@ STAGE PLANS:
                       Statistics: Num rows: 22 Data size: 5804 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
-                             Left Outer Join0 to 1
+                             Left Outer Join 0 to 1
                         keys:
                           0 _col1 (type: bigint)
                           1 _col0 (type: bigint)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/subquery_in_having.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/subquery_in_having.q.out b/ql/src/test/results/clientpositive/subquery_in_having.q.out
index 2b3af79..c4569ba 100644
--- a/ql/src/test/results/clientpositive/subquery_in_having.q.out
+++ b/ql/src/test/results/clientpositive/subquery_in_having.q.out
@@ -2002,7 +2002,7 @@ STAGE PLANS:
             Statistics: Num rows: 2566 Data size: 517492 Basic stats: COMPLETE Column stats: NONE
             Join Operator
               condition map:
-                   Left Outer Join0 to 1
+                   Left Outer Join 0 to 1
               keys:
                 0 _col1 (type: string)
                 1 _col0 (type: string)
@@ -2040,7 +2040,7 @@ STAGE PLANS:
                 Statistics: Num rows: 2566 Data size: 517492 Basic stats: COMPLETE Column stats: NONE
                 Join Operator
                   condition map:
-                       Left Outer Join0 to 1
+                       Left Outer Join 0 to 1
                   keys:
                     0 _col1 (type: string)
                     1 _col0 (type: string)
@@ -2117,7 +2117,7 @@ STAGE PLANS:
           TableScan
             Map Join Operator
               condition map:
-                   Left Outer Join0 to 1
+                   Left Outer Join 0 to 1
               keys:
                 0 _col1 (type: string)
                 1 _col0 (type: string)
@@ -2155,7 +2155,7 @@ STAGE PLANS:
             Statistics: Num rows: 9 Data size: 1873 Basic stats: COMPLETE Column stats: NONE
             Join Operator
               condition map:
-                   Left Outer Join0 to 1
+                   Left Outer Join 0 to 1
               keys:
                 0 _col1 (type: string), _col2 (type: bigint)
                 1 _col1 (type: string), _col0 (type: bigint)
@@ -2195,7 +2195,7 @@ STAGE PLANS:
                     Statistics: Num rows: 9 Data size: 1873 Basic stats: COMPLETE Column stats: NONE
                     Join Operator
                       condition map:
-                           Left Outer Join0 to 1
+                           Left Outer Join 0 to 1
                       keys:
                         0 _col1 (type: string), _col2 (type: bigint)
                         1 _col1 (type: string), _col0 (type: bigint)
@@ -2236,7 +2236,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col1 (type: string)
             1 _col0 (type: string)
@@ -2353,7 +2353,7 @@ STAGE PLANS:
             Statistics: Num rows: 2566 Data size: 517492 Basic stats: COMPLETE Column stats: NONE
             Join Operator
               condition map:
-                   Left Outer Join0 to 1
+                   Left Outer Join 0 to 1
               keys:
                 0 _col1 (type: string)
                 1 _col0 (type: string)
@@ -2390,7 +2390,7 @@ STAGE PLANS:
                 Statistics: Num rows: 2566 Data size: 517492 Basic stats: COMPLETE Column stats: NONE
                 Join Operator
                   condition map:
-                       Left Outer Join0 to 1
+                       Left Outer Join 0 to 1
                   keys:
                     0 _col1 (type: string)
                     1 _col0 (type: string)
@@ -2630,7 +2630,7 @@ STAGE PLANS:
             Statistics: Num rows: 2566 Data size: 517492 Basic stats: COMPLETE Column stats: NONE
             Join Operator
               condition map:
-                   Left Outer Join0 to 1
+                   Left Outer Join 0 to 1
               keys:
                 0 _col1 (type: string)
                 1 _col0 (type: string)
@@ -2667,7 +2667,7 @@ STAGE PLANS:
                 Statistics: Num rows: 2566 Data size: 517492 Basic stats: COMPLETE Column stats: NONE
                 Join Operator
                   condition map:
-                       Left Outer Join0 to 1
+                       Left Outer Join 0 to 1
                   keys:
                     0 _col1 (type: string)
                     1 _col0 (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/subquery_multiinsert.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/subquery_multiinsert.q.out b/ql/src/test/results/clientpositive/subquery_multiinsert.q.out
index b8923d8..28c82b8 100644
--- a/ql/src/test/results/clientpositive/subquery_multiinsert.q.out
+++ b/ql/src/test/results/clientpositive/subquery_multiinsert.q.out
@@ -179,7 +179,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col0 (type: string)
             1 _col0 (type: string)
@@ -654,7 +654,7 @@ STAGE PLANS:
           TableScan
             Map Join Operator
               condition map:
-                   Left Outer Join0 to 1
+                   Left Outer Join 0 to 1
               keys:
                 0 _col0 (type: string)
                 1 _col0 (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/subquery_notexists.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/subquery_notexists.q.out b/ql/src/test/results/clientpositive/subquery_notexists.q.out
index 827b53b..039df03 100644
--- a/ql/src/test/results/clientpositive/subquery_notexists.q.out
+++ b/ql/src/test/results/clientpositive/subquery_notexists.q.out
@@ -83,7 +83,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col0 (type: string), _col1 (type: string)
             1 _col0 (type: string), _col1 (type: string)
@@ -344,7 +344,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col1 (type: string)
             1 _col0 (type: string)
@@ -671,7 +671,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col0 (type: string), _col1 (type: string)
             1 _col0 (type: string), _col1 (type: string)
@@ -767,7 +767,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 
             1 
@@ -800,7 +800,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col1 (type: string)
             1 _col0 (type: string)
@@ -846,7 +846,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 
             1 

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/subquery_notexists_having.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/subquery_notexists_having.q.out b/ql/src/test/results/clientpositive/subquery_notexists_having.q.out
index 29b1308..fda801d 100644
--- a/ql/src/test/results/clientpositive/subquery_notexists_having.q.out
+++ b/ql/src/test/results/clientpositive/subquery_notexists_having.q.out
@@ -77,7 +77,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col0 (type: string), _col1 (type: string)
             1 _col0 (type: string), _col1 (type: string)
@@ -260,7 +260,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col1 (type: string)
             1 _col0 (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/subquery_notin_having.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/subquery_notin_having.q.out b/ql/src/test/results/clientpositive/subquery_notin_having.q.out
index 6d4608d..462dda5 100644
--- a/ql/src/test/results/clientpositive/subquery_notin_having.q.out
+++ b/ql/src/test/results/clientpositive/subquery_notin_having.q.out
@@ -111,7 +111,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col0 (type: string)
             1 _col0 (type: string)
@@ -291,7 +291,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col1 (type: double)
             1 _col0 (type: double)
@@ -324,7 +324,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col0 (type: string), _col1 (type: double)
             1 _col0 (type: string), _col1 (type: double)
@@ -616,7 +616,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col0 (type: string)
             1 _col0 (type: string)
@@ -909,7 +909,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col0 (type: int)
             1 _col0 (type: int)
@@ -1089,8 +1089,8 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
-               Left Outer Join0 to 2
+               Left Outer Join 0 to 1
+               Left Outer Join 0 to 2
           keys:
             0 _col0 (type: int)
             1 _col0 (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out b/ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out
index 126f265..2507d52 100644
--- a/ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out
+++ b/ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out
@@ -199,7 +199,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 concat(_col0, _col1) (type: string)
             1 _col0 (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out b/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out
index 0a7a36f..03eb4b6 100644
--- a/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out
+++ b/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out
@@ -389,7 +389,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col1 (type: string)
             1 _col0 (type: string)
@@ -422,7 +422,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col0 (type: string), _col1 (type: string)
             1 _col0 (type: string), _col1 (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_1.q.out b/ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_1.q.out
index f3a5dc3..0a1e039 100644
--- a/ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_1.q.out
+++ b/ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_1.q.out
@@ -503,7 +503,7 @@ STAGE PLANS:
                     Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
                     Map Join Operator
                       condition map:
-                           Left Outer Join0 to 1
+                           Left Outer Join 0 to 1
                       keys:
                         0 _col0 (type: int)
                         1 _col0 (type: int)
@@ -609,7 +609,7 @@ STAGE PLANS:
                     Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
                     Map Join Operator
                       condition map:
-                           Left Outer Join0 to 1
+                           Left Outer Join 0 to 1
                       keys:
                         0 _col0 (type: int)
                         1 _col0 (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/union22.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union22.q.out b/ql/src/test/results/clientpositive/union22.q.out
index f60dbf6..9134bdf 100644
--- a/ql/src/test/results/clientpositive/union22.q.out
+++ b/ql/src/test/results/clientpositive/union22.q.out
@@ -178,7 +178,7 @@ STAGE PLANS:
                 Statistics: Num rows: 166 Data size: 3693 Basic stats: COMPLETE Column stats: NONE
                 Map Join Operator
                   condition map:
-                       Left Outer Join0 to 1
+                       Left Outer Join 0 to 1
                   filter mappings:
                     0 [1, 1]
                   filter predicates:
@@ -651,7 +651,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           filter mappings:
             0 [1, 1]
           filter predicates:

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/union_lateralview.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_lateralview.q.out b/ql/src/test/results/clientpositive/union_lateralview.q.out
index 7b89e50..f563476 100644
--- a/ql/src/test/results/clientpositive/union_lateralview.q.out
+++ b/ql/src/test/results/clientpositive/union_lateralview.q.out
@@ -160,7 +160,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col1 (type: string)
             1 key (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/union_offcbo.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_offcbo.q.out b/ql/src/test/results/clientpositive/union_offcbo.q.out
index cb6a4a5..df56539 100644
--- a/ql/src/test/results/clientpositive/union_offcbo.q.out
+++ b/ql/src/test/results/clientpositive/union_offcbo.q.out
@@ -622,7 +622,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Right Outer Join0 to 1
+               Right Outer Join 0 to 1
           keys:
             0 _col0 (type: string)
             1 _col5 (type: string)
@@ -712,7 +712,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col3 (type: string)
             1 _col1 (type: string)
@@ -1661,7 +1661,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Right Outer Join0 to 1
+               Right Outer Join 0 to 1
           keys:
             0 _col0 (type: string)
             1 _col5 (type: string)
@@ -1751,7 +1751,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col3 (type: string)
             1 _col1 (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/vector_coalesce_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_coalesce_3.q.out b/ql/src/test/results/clientpositive/vector_coalesce_3.q.out
index 1d3e57e..0e75593 100644
--- a/ql/src/test/results/clientpositive/vector_coalesce_3.q.out
+++ b/ql/src/test/results/clientpositive/vector_coalesce_3.q.out
@@ -75,7 +75,7 @@ STAGE PLANS:
               Statistics: Num rows: 4 Data size: 32 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col0 (type: bigint)
                   1 _col0 (type: bigint)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out b/ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out
index addbdeb..f0c87c4 100644
--- a/ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out
+++ b/ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out
@@ -184,7 +184,7 @@ STAGE PLANS:
                 projectedOutputColumns: [0, 1, 2, 3]
             Map Join Operator
               condition map:
-                   Left Outer Join0 to 1
+                   Left Outer Join 0 to 1
               keys:
                 0 _col0 (type: string)
                 1 _col0 (type: string)
@@ -294,7 +294,7 @@ STAGE PLANS:
       Reduce Operator Tree:
         Join Operator
           condition map:
-               Left Outer Join0 to 1
+               Left Outer Join 0 to 1
           keys:
             0 _col0 (type: string)
             1 _col0 (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/vector_left_outer_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_left_outer_join.q.out b/ql/src/test/results/clientpositive/vector_left_outer_join.q.out
index 5e88346..5fe3569 100644
--- a/ql/src/test/results/clientpositive/vector_left_outer_join.q.out
+++ b/ql/src/test/results/clientpositive/vector_left_outer_join.q.out
@@ -73,7 +73,7 @@ STAGE PLANS:
               Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col1 (type: int)
                   1 _col0 (type: int)
@@ -81,7 +81,7 @@ STAGE PLANS:
                 Statistics: Num rows: 13516 Data size: 2906160 Basic stats: COMPLETE Column stats: NONE
                 Map Join Operator
                   condition map:
-                       Left Outer Join0 to 1
+                       Left Outer Join 0 to 1
                   keys:
                     0 _col0 (type: tinyint)
                     1 _col0 (type: tinyint)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/vector_left_outer_join2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_left_outer_join2.q.out b/ql/src/test/results/clientpositive/vector_left_outer_join2.q.out
index 2b62ff5..6f57872 100644
--- a/ql/src/test/results/clientpositive/vector_left_outer_join2.q.out
+++ b/ql/src/test/results/clientpositive/vector_left_outer_join2.q.out
@@ -127,7 +127,7 @@ STAGE PLANS:
               Statistics: Num rows: 3 Data size: 32 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 filter predicates:
                   0 {(_col2 > 15)}
                   1 
@@ -220,7 +220,7 @@ STAGE PLANS:
               Statistics: Num rows: 3 Data size: 32 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 filter predicates:
                   0 {(_col2 > 15)}
                   1 
@@ -320,7 +320,7 @@ STAGE PLANS:
               Statistics: Num rows: 3 Data size: 32 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 filter predicates:
                   0 {(_col2 > 15)}
                   1 
@@ -441,7 +441,7 @@ STAGE PLANS:
               Statistics: Num rows: 3 Data size: 32 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 filter predicates:
                   0 {(_col2 > 15)}
                   1 
@@ -562,7 +562,7 @@ STAGE PLANS:
               Statistics: Num rows: 3 Data size: 32 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 filter predicates:
                   0 {(_col2 > 15)}
                   1 
@@ -683,7 +683,7 @@ STAGE PLANS:
               Statistics: Num rows: 3 Data size: 32 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 filter predicates:
                   0 {(_col2 > 15)}
                   1 

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/ql/src/test/results/clientpositive/vector_outer_join0.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_outer_join0.q.out b/ql/src/test/results/clientpositive/vector_outer_join0.q.out
index 38772cb..ebfac76 100644
--- a/ql/src/test/results/clientpositive/vector_outer_join0.q.out
+++ b/ql/src/test/results/clientpositive/vector_outer_join0.q.out
@@ -113,7 +113,7 @@ STAGE PLANS:
               Statistics: Num rows: 6 Data size: 544 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col1 (type: int)
                   1 _col0 (type: int)
@@ -229,7 +229,7 @@ STAGE PLANS:
               Statistics: Num rows: 6 Data size: 550 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Right Outer Join0 to 1
+                     Right Outer Join 0 to 1
                 keys:
                   0 _col1 (type: int)
                   1 _col0 (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/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 dc2010d..7a92bef 100644
--- a/ql/src/test/results/clientpositive/vector_outer_join1.q.out
+++ b/ql/src/test/results/clientpositive/vector_outer_join1.q.out
@@ -275,7 +275,7 @@ STAGE PLANS:
               Statistics: Num rows: 15 Data size: 3320 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col2 (type: int)
                   1 _col2 (type: int)
@@ -414,7 +414,7 @@ STAGE PLANS:
               Statistics: Num rows: 15 Data size: 3320 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col0 (type: tinyint)
                   1 _col0 (type: tinyint)
@@ -659,7 +659,7 @@ STAGE PLANS:
               Statistics: Num rows: 15 Data size: 3320 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col1 (type: int)
                   1 _col0 (type: int)
@@ -672,7 +672,7 @@ STAGE PLANS:
                 Statistics: Num rows: 16 Data size: 3652 Basic stats: COMPLETE Column stats: NONE
                 Map Join Operator
                   condition map:
-                       Left Outer Join0 to 1
+                       Left Outer Join 0 to 1
                   keys:
                     0 _col0 (type: tinyint)
                     1 _col0 (type: tinyint)

http://git-wip-us.apache.org/repos/asf/hive/blob/92983158/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 2d2c2b5..6b51489 100644
--- a/ql/src/test/results/clientpositive/vector_outer_join2.q.out
+++ b/ql/src/test/results/clientpositive/vector_outer_join2.q.out
@@ -306,7 +306,7 @@ STAGE PLANS:
               Statistics: Num rows: 20 Data size: 4182 Basic stats: COMPLETE Column stats: NONE
               Map Join Operator
                 condition map:
-                     Left Outer Join0 to 1
+                     Left Outer Join 0 to 1
                 keys:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
@@ -319,7 +319,7 @@ STAGE PLANS:
                 Statistics: Num rows: 22 Data size: 4600 Basic stats: COMPLETE Column stats: NONE
                 Map Join Operator
                   condition map:
-                       Left Outer Join0 to 1
+                       Left Outer Join 0 to 1
                   keys:
                     0 _col1 (type: bigint)
                     1 _col0 (type: bigint)