You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/12/29 03:14:00 UTC

svn commit: r1648280 [7/25] - in /hive/branches/spark: data/conf/spark/ ql/src/java/org/apache/hadoop/hive/ql/exec/spark/session/ ql/src/java/org/apache/hadoop/hive/ql/optimizer/optiq/ ql/src/test/results/clientpositive/spark/

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/column_access_stats.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/column_access_stats.q.out?rev=1648280&r1=1648279&r2=1648280&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/column_access_stats.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/column_access_stats.q.out Mon Dec 29 02:13:57 2014
@@ -405,9 +405,9 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {KEY.reducesinkkey0}
-                  1 
+                keys:
+                  0 key (type: string)
+                  1 key (type: string)
                 outputColumnNames: _col0
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Select Operator
@@ -528,9 +528,9 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {KEY.reducesinkkey0}
-                  1 {KEY.reducesinkkey0}
+                keys:
+                  0 key (type: string)
+                  1 key (type: string)
                 outputColumnNames: _col0, _col5
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Select Operator
@@ -626,9 +626,9 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {KEY.reducesinkkey0}
-                  1 
+                keys:
+                  0 _col0 (type: string)
+                  1 _col0 (type: string)
                 outputColumnNames: _col0
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Select Operator
@@ -753,9 +753,9 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {KEY.reducesinkkey0}
-                  1 
+                keys:
+                  0 _col0 (type: string)
+                  1 _col0 (type: string)
                 outputColumnNames: _col0
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Reduce Output Operator
@@ -768,9 +768,9 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {KEY.reducesinkkey0}
-                  1 {KEY.reducesinkkey0} {VALUE._col0}
+                keys:
+                  0 _col0 (type: string)
+                  1 key (type: string)
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Select Operator

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/cross_join.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/cross_join.q.out?rev=1648280&r1=1648279&r2=1648280&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/cross_join.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/cross_join.q.out Mon Dec 29 02:13:57 2014
@@ -38,8 +38,8 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {VALUE._col0}
+                keys:
+                  0 
                   1 
                 outputColumnNames: _col0
                 Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
@@ -101,8 +101,8 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {VALUE._col0}
+                keys:
+                  0 
                   1 
                 outputColumnNames: _col0
                 Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
@@ -172,9 +172,9 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {KEY.reducesinkkey0}
-                  1 
+                keys:
+                  0 key (type: string)
+                  1 key (type: string)
                 outputColumnNames: _col0
                 Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
                 Select Operator

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/cross_product_check_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/cross_product_check_1.q.out?rev=1648280&r1=1648279&r2=1648280&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/cross_product_check_1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/cross_product_check_1.q.out Mon Dec 29 02:13:57 2014
@@ -63,9 +63,9 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {VALUE._col0} {VALUE._col1}
-                  1 {VALUE._col0} {VALUE._col1}
+                keys:
+                  0 
+                  1 
                 outputColumnNames: _col0, _col1, _col5, _col6
                 Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
@@ -145,9 +145,9 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {KEY.reducesinkkey0} {VALUE._col0}
-                  1 {KEY.reducesinkkey0} {VALUE._col0}
+                keys:
+                  0 key (type: string)
+                  1 key (type: string)
                 outputColumnNames: _col0, _col1, _col5, _col6
                 Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
                 Reduce Output Operator
@@ -159,9 +159,9 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {VALUE._col6}
-                  1 {VALUE._col0} {VALUE._col1}
+                keys:
+                  0 
+                  1 
                 outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
                 Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
@@ -246,9 +246,9 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {KEY.reducesinkkey0}
-                  1 
+                keys:
+                  0 key (type: string)
+                  1 key (type: string)
                 outputColumnNames: _col0
                 Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
                 Group By Operator
@@ -267,19 +267,19 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0
-                Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 2 Data size: 22 Basic stats: COMPLETE Column stats: NONE
                 Reduce Output Operator
                   sort order: 
-                  Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 2 Data size: 22 Basic stats: COMPLETE Column stats: NONE
                   value expressions: _col0 (type: string)
         Reducer 4 
             Reduce Operator Tree:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {VALUE._col0} {VALUE._col1}
-                  1 {VALUE._col0}
+                keys:
+                  0 
+                  1 
                 outputColumnNames: _col0, _col1, _col5
                 Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
@@ -350,8 +350,8 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {VALUE._col0}
+                keys:
+                  0 
                   1 
                 outputColumnNames: _col0
                 Statistics: Num rows: 11 Data size: 114 Basic stats: COMPLETE Column stats: NONE
@@ -371,19 +371,19 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0
-                Statistics: Num rows: 11 Data size: 114 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 5 Data size: 51 Basic stats: COMPLETE Column stats: NONE
                 Reduce Output Operator
                   sort order: 
-                  Statistics: Num rows: 11 Data size: 114 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 5 Data size: 51 Basic stats: COMPLETE Column stats: NONE
                   value expressions: _col0 (type: string)
         Reducer 4 
             Reduce Operator Tree:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {VALUE._col0} {VALUE._col1}
-                  1 {VALUE._col0}
+                keys:
+                  0 
+                  1 
                 outputColumnNames: _col0, _col1, _col5
                 Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
@@ -478,28 +478,28 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0
-                Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                 Reduce Output Operator
                   sort order: 
-                  Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                   value expressions: _col0 (type: string)
         Reducer 3 
             Reduce Operator Tree:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {VALUE._col0}
-                  1 {VALUE._col0}
+                keys:
+                  0 
+                  1 
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
                   expressions: _col0 (type: string), _col1 (type: string)
                   outputColumnNames: _col0, _col1
-                  Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -509,9 +509,9 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {KEY.reducesinkkey0}
-                  1 
+                keys:
+                  0 key (type: string)
+                  1 key (type: string)
                 outputColumnNames: _col0
                 Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
                 Group By Operator
@@ -530,10 +530,10 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0
-                Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 2 Data size: 22 Basic stats: COMPLETE Column stats: NONE
                 Reduce Output Operator
                   sort order: 
-                  Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 2 Data size: 22 Basic stats: COMPLETE Column stats: NONE
                   value expressions: _col0 (type: string)
 
   Stage: Stage-0

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/cross_product_check_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/cross_product_check_2.q.out?rev=1648280&r1=1648279&r2=1648280&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/cross_product_check_2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/cross_product_check_2.q.out Mon Dec 29 02:13:57 2014
@@ -45,9 +45,6 @@ STAGE PLANS:
                   alias: b
                   Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                   Spark HashTable Sink Operator
-                    condition expressions:
-                      0 {key} {value}
-                      1 {key} {value}
                     keys:
                       0 
                       1 
@@ -66,9 +63,6 @@ STAGE PLANS:
                   Map Join Operator
                     condition map:
                          Inner Join 0 to 1
-                    condition expressions:
-                      0 {key} {value}
-                      1 {key} {value}
                     keys:
                       0 
                       1 
@@ -121,9 +115,6 @@ STAGE PLANS:
                     predicate: key is not null (type: boolean)
                     Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
                     Spark HashTable Sink Operator
-                      condition expressions:
-                        0 {key} {value}
-                        1 {value}
                       keys:
                         0 key (type: string)
                         1 key (type: string)
@@ -145,9 +136,6 @@ STAGE PLANS:
                     Map Join Operator
                       condition map:
                            Inner Join 0 to 1
-                      condition expressions:
-                        0 {key} {value}
-                        1 {key} {value}
                       keys:
                         0 key (type: string)
                         1 key (type: string)
@@ -156,9 +144,6 @@ STAGE PLANS:
                         1 Map 2
                       Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
                       Spark HashTable Sink Operator
-                        condition expressions:
-                          0 {_col0} {_col1} {_col5} {_col6}
-                          1 {key} {value}
                         keys:
                           0 
                           1 
@@ -177,9 +162,6 @@ STAGE PLANS:
                   Map Join Operator
                     condition map:
                          Inner Join 0 to 1
-                    condition expressions:
-                      0 {_col0} {_col1} {_col5} {_col6}
-                      1 {key} {value}
                     keys:
                       0 
                       1 
@@ -238,9 +220,6 @@ STAGE PLANS:
                     predicate: key is not null (type: boolean)
                     Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
                     Spark HashTable Sink Operator
-                      condition expressions:
-                        0 {key}
-                        1 
                       keys:
                         0 key (type: string)
                         1 key (type: string)
@@ -264,9 +243,6 @@ STAGE PLANS:
                     Map Join Operator
                       condition map:
                            Inner Join 0 to 1
-                      condition expressions:
-                        0 {key}
-                        1 
                       keys:
                         0 key (type: string)
                         1 key (type: string)
@@ -294,11 +270,8 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0
-                Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 2 Data size: 22 Basic stats: COMPLETE Column stats: NONE
                 Spark HashTable Sink Operator
-                  condition expressions:
-                    0 {key} {value}
-                    1 {_col0}
                   keys:
                     0 
                     1 
@@ -315,9 +288,6 @@ STAGE PLANS:
                   Map Join Operator
                     condition map:
                          Inner Join 0 to 1
-                    condition expressions:
-                      0 {key} {value}
-                      1 {_col0}
                     keys:
                       0 
                       1 
@@ -368,9 +338,6 @@ STAGE PLANS:
                   alias: d2
                   Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
                   Spark HashTable Sink Operator
-                    condition expressions:
-                      0 {key}
-                      1 
                     keys:
                       0 
                       1 
@@ -391,9 +358,6 @@ STAGE PLANS:
                   Map Join Operator
                     condition map:
                          Inner Join 0 to 1
-                    condition expressions:
-                      0 {key}
-                      1 
                     keys:
                       0 
                       1 
@@ -421,11 +385,8 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0
-                Statistics: Num rows: 11 Data size: 114 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 5 Data size: 51 Basic stats: COMPLETE Column stats: NONE
                 Spark HashTable Sink Operator
-                  condition expressions:
-                    0 {key} {value}
-                    1 {_col0}
                   keys:
                     0 
                     1 
@@ -442,9 +403,6 @@ STAGE PLANS:
                   Map Join Operator
                     condition map:
                          Inner Join 0 to 1
-                    condition expressions:
-                      0 {key} {value}
-                      1 {_col0}
                     keys:
                       0 
                       1 
@@ -501,9 +459,6 @@ STAGE PLANS:
                     predicate: key is not null (type: boolean)
                     Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
                     Spark HashTable Sink Operator
-                      condition expressions:
-                        0 {key}
-                        1 
                       keys:
                         0 key (type: string)
                         1 key (type: string)
@@ -527,9 +482,6 @@ STAGE PLANS:
                     Map Join Operator
                       condition map:
                            Inner Join 0 to 1
-                      condition expressions:
-                        0 {key}
-                        1 
                       keys:
                         0 key (type: string)
                         1 key (type: string)
@@ -557,11 +509,8 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0
-                Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 2 Data size: 22 Basic stats: COMPLETE Column stats: NONE
                 Spark HashTable Sink Operator
-                  condition expressions:
-                    0 {_col0}
-                    1 {_col0}
                   keys:
                     0 
                     1 
@@ -599,27 +548,24 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0
-                Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                 Map Join Operator
                   condition map:
                        Inner Join 0 to 1
-                  condition expressions:
-                    0 {_col0}
-                    1 {_col0}
                   keys:
                     0 
                     1 
                   outputColumnNames: _col0, _col1
                   input vertices:
                     1 Reducer 4
-                  Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
                     expressions: _col0 (type: string), _col1 (type: string)
                     outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/ctas.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/ctas.q.out?rev=1648280&r1=1648279&r2=1648280&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/ctas.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/ctas.q.out Mon Dec 29 02:13:57 2014
@@ -748,7 +748,7 @@ STAGE PLANS:
                     COLUMN_STATS_ACCURATE true
                     bucket_count -1
                     columns key,value
-                    columns.comments defaultdefault
+                    columns.comments 'default','default'
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.src
@@ -768,7 +768,7 @@ STAGE PLANS:
                       COLUMN_STATS_ACCURATE true
                       bucket_count -1
                       columns key,value
-                      columns.comments defaultdefault
+                      columns.comments 'default','default'
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.src

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/disable_merge_for_bucketing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/disable_merge_for_bucketing.q.out?rev=1648280&r1=1648279&r2=1648280&view=diff
==============================================================================
Binary files hive/branches/spark/ql/src/test/results/clientpositive/spark/disable_merge_for_bucketing.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/spark/disable_merge_for_bucketing.q.out Mon Dec 29 02:13:57 2014 differ

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out?rev=1648280&r1=1648279&r2=1648280&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out Mon Dec 29 02:13:57 2014
@@ -177,7 +177,7 @@ STAGE PLANS:
                     COLUMN_STATS_ACCURATE true
                     bucket_count -1
                     columns key,value
-                    columns.comments 
+                    columns.comments 
                     columns.types int:string
 #### A masked pattern was here ####
                     name default.filter_join_breaktask
@@ -198,7 +198,7 @@ STAGE PLANS:
                     properties:
                       bucket_count -1
                       columns key,value
-                      columns.comments 
+                      columns.comments 
                       columns.types int:string
 #### A masked pattern was here ####
                       name default.filter_join_breaktask
@@ -245,7 +245,7 @@ STAGE PLANS:
                     COLUMN_STATS_ACCURATE true
                     bucket_count -1
                     columns key,value
-                    columns.comments 
+                    columns.comments 
                     columns.types int:string
 #### A masked pattern was here ####
                     name default.filter_join_breaktask
@@ -266,7 +266,7 @@ STAGE PLANS:
                     properties:
                       bucket_count -1
                       columns key,value
-                      columns.comments 
+                      columns.comments 
                       columns.types int:string
 #### A masked pattern was here ####
                       name default.filter_join_breaktask
@@ -312,7 +312,7 @@ STAGE PLANS:
                     COLUMN_STATS_ACCURATE true
                     bucket_count -1
                     columns key,value
-                    columns.comments 
+                    columns.comments 
                     columns.types int:string
 #### A masked pattern was here ####
                     name default.filter_join_breaktask
@@ -333,7 +333,7 @@ STAGE PLANS:
                     properties:
                       bucket_count -1
                       columns key,value
-                      columns.comments 
+                      columns.comments 
                       columns.types int:string
 #### A masked pattern was here ####
                       name default.filter_join_breaktask
@@ -354,9 +354,9 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {KEY.reducesinkkey0}
-                  1 {VALUE._col0}
+                keys:
+                  0 key (type: int)
+                  1 key (type: int)
                 outputColumnNames: _col0, _col7
                 Statistics: Num rows: 14 Data size: 119 Basic stats: COMPLETE Column stats: NONE
                 Reduce Output Operator
@@ -373,9 +373,9 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {VALUE._col0}
-                  1 {KEY.reducesinkkey0}
+                keys:
+                  0 _col7 (type: string)
+                  1 value (type: string)
                 outputColumnNames: _col0, _col13
                 Statistics: Num rows: 15 Data size: 130 Basic stats: COMPLETE Column stats: NONE
                 Select Operator

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/filter_join_breaktask2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/filter_join_breaktask2.q.out?rev=1648280&r1=1648279&r2=1648280&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/filter_join_breaktask2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/filter_join_breaktask2.q.out Mon Dec 29 02:13:57 2014
@@ -230,6 +230,7 @@ POSTHOOK: Input: default@t4
 POSTHOOK: Input: default@t4@ds=2010-04-17
 #### A masked pattern was here ####
 4	1	1	8	4	5	1	0	9	U	2	2	0	2	1	1	J	C	A	U	2	s	2	NULL	NULL	NULL	NULL	NULL	NULL	1	j	S	6	NULL	1	2	J	g	1	e	2	1	2	U	P	p	3	0	0	0	1	1	1	0	0	0	6	2	j	NULL	NULL	NULL	NULL	NULL	NULL	5	NULL	NULL	j	2	2	1	2	2	1	1	1	1	1	1	1	1	32	NULL	2010-04-17
+WARNING: Comparing a bigint and a string may result in a loss of precision.
 PREHOOK: query: SELECT a.c1 as a_c1, b.c1 b_c1, d.c0 as d_c0
 FROM T1 a JOIN T2 b 
        ON (a.c1 = b.c1 AND a.ds='2010-04-17' AND b.ds='2010-04-17')

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_map_ppr.q.out?rev=1648280&r1=1648279&r2=1648280&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_map_ppr.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_map_ppr.q.out Mon Dec 29 02:13:57 2014
@@ -146,7 +146,7 @@ STAGE PLANS:
                     COLUMN_STATS_ACCURATE true
                     bucket_count -1
                     columns key,value
-                    columns.comments defaultdefault
+                    columns.comments 'default','default'
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.srcpart
@@ -167,7 +167,7 @@ STAGE PLANS:
                     properties:
                       bucket_count -1
                       columns key,value
-                      columns.comments defaultdefault
+                      columns.comments 'default','default'
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.srcpart
@@ -192,7 +192,7 @@ STAGE PLANS:
                     COLUMN_STATS_ACCURATE true
                     bucket_count -1
                     columns key,value
-                    columns.comments defaultdefault
+                    columns.comments 'default','default'
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.srcpart
@@ -213,7 +213,7 @@ STAGE PLANS:
                     properties:
                       bucket_count -1
                       columns key,value
-                      columns.comments defaultdefault
+                      columns.comments 'default','default'
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.srcpart
@@ -255,7 +255,7 @@ STAGE PLANS:
                         properties:
                           bucket_count -1
                           columns key,c1,c2
-                          columns.comments 
+                          columns.comments 
                           columns.types string:int:string
 #### A masked pattern was here ####
                           name default.dest1
@@ -280,7 +280,7 @@ STAGE PLANS:
               properties:
                 bucket_count -1
                 columns key,c1,c2
-                columns.comments 
+                columns.comments 
                 columns.types string:int:string
 #### A masked pattern was here ####
                 name default.dest1

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_map_ppr_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_map_ppr_multi_distinct.q.out?rev=1648280&r1=1648279&r2=1648280&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_map_ppr_multi_distinct.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_map_ppr_multi_distinct.q.out Mon Dec 29 02:13:57 2014
@@ -163,7 +163,7 @@ STAGE PLANS:
                     COLUMN_STATS_ACCURATE true
                     bucket_count -1
                     columns key,value
-                    columns.comments defaultdefault
+                    columns.comments 'default','default'
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.srcpart
@@ -184,7 +184,7 @@ STAGE PLANS:
                     properties:
                       bucket_count -1
                       columns key,value
-                      columns.comments defaultdefault
+                      columns.comments 'default','default'
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.srcpart
@@ -209,7 +209,7 @@ STAGE PLANS:
                     COLUMN_STATS_ACCURATE true
                     bucket_count -1
                     columns key,value
-                    columns.comments defaultdefault
+                    columns.comments 'default','default'
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.srcpart
@@ -230,7 +230,7 @@ STAGE PLANS:
                     properties:
                       bucket_count -1
                       columns key,value
-                      columns.comments defaultdefault
+                      columns.comments 'default','default'
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.srcpart
@@ -272,7 +272,7 @@ STAGE PLANS:
                         properties:
                           bucket_count -1
                           columns key,c1,c2,c3,c4
-                          columns.comments 
+                          columns.comments 
                           columns.types string:int:string:int:int
 #### A masked pattern was here ####
                           name default.dest1
@@ -297,7 +297,7 @@ STAGE PLANS:
               properties:
                 bucket_count -1
                 columns key,c1,c2,c3,c4
-                columns.comments 
+                columns.comments 
                 columns.types string:int:string:int:int
 #### A masked pattern was here ####
                 name default.dest1

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_position.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_position.q.out?rev=1648280&r1=1648279&r2=1648280&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_position.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_position.q.out Mon Dec 29 02:13:57 2014
@@ -457,20 +457,20 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col1 (type: bigint), _col0 (type: string)
                   sort order: -+
-                  Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
         Reducer 3 
             Reduce Operator Tree:
               Select Operator
                 expressions: KEY.reducesinkkey1 (type: string), KEY.reducesinkkey0 (type: bigint)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -614,28 +614,28 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {KEY.reducesinkkey0} {VALUE._col0}
-                  1 {KEY.reducesinkkey0} {VALUE._col0}
+                keys:
+                  0 _col0 (type: string)
+                  1 _col0 (type: string)
                 outputColumnNames: _col0, _col1, _col3, _col4
-                Statistics: Num rows: 30 Data size: 326 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 15 Data size: 162 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
                   expressions: _col0 (type: string), _col1 (type: string), _col3 (type: string), _col4 (type: string)
                   outputColumnNames: _col0, _col1, _col2, _col3
-                  Statistics: Num rows: 30 Data size: 326 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 15 Data size: 162 Basic stats: COMPLETE Column stats: NONE
                   Reduce Output Operator
                     key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
                     sort order: --++
-                    Statistics: Num rows: 30 Data size: 326 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 15 Data size: 162 Basic stats: COMPLETE Column stats: NONE
         Reducer 4 
             Reduce Operator Tree:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string)
                 outputColumnNames: _col0, _col1, _col2, _col3
-                Statistics: Num rows: 30 Data size: 326 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 15 Data size: 162 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 30 Data size: 326 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 15 Data size: 162 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -646,12 +646,12 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string), KEY._col1 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 14 Data size: 148 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: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 14 Data size: 148 Basic stats: COMPLETE Column stats: NONE
                   value expressions: _col1 (type: string)
 
   Stage: Stage-0

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_ppr.q.out?rev=1648280&r1=1648279&r2=1648280&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_ppr.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_ppr.q.out Mon Dec 29 02:13:57 2014
@@ -135,7 +135,7 @@ STAGE PLANS:
                     COLUMN_STATS_ACCURATE true
                     bucket_count -1
                     columns key,value
-                    columns.comments defaultdefault
+                    columns.comments 'default','default'
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.srcpart
@@ -156,7 +156,7 @@ STAGE PLANS:
                     properties:
                       bucket_count -1
                       columns key,value
-                      columns.comments defaultdefault
+                      columns.comments 'default','default'
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.srcpart
@@ -181,7 +181,7 @@ STAGE PLANS:
                     COLUMN_STATS_ACCURATE true
                     bucket_count -1
                     columns key,value
-                    columns.comments defaultdefault
+                    columns.comments 'default','default'
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.srcpart
@@ -202,7 +202,7 @@ STAGE PLANS:
                     properties:
                       bucket_count -1
                       columns key,value
-                      columns.comments defaultdefault
+                      columns.comments 'default','default'
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.srcpart
@@ -244,7 +244,7 @@ STAGE PLANS:
                         properties:
                           bucket_count -1
                           columns key,c1,c2
-                          columns.comments 
+                          columns.comments 
                           columns.types string:int:string
 #### A masked pattern was here ####
                           name default.dest1
@@ -269,7 +269,7 @@ STAGE PLANS:
               properties:
                 bucket_count -1
                 columns key,c1,c2
-                columns.comments 
+                columns.comments 
                 columns.types string:int:string
 #### A masked pattern was here ####
                 name default.dest1

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out?rev=1648280&r1=1648279&r2=1648280&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out Mon Dec 29 02:13:57 2014
@@ -122,7 +122,7 @@ STAGE PLANS:
                               properties:
                                 bucket_count -1
                                 columns key,cnt
-                                columns.comments 
+                                columns.comments 
                                 columns.types int:int
 #### A masked pattern was here ####
                                 name default.outputtbl1
@@ -149,7 +149,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -171,7 +171,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -200,7 +200,7 @@ STAGE PLANS:
               properties:
                 bucket_count -1
                 columns key,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int
 #### A masked pattern was here ####
                 name default.outputtbl1
@@ -338,7 +338,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -360,7 +360,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -403,7 +403,7 @@ STAGE PLANS:
                         properties:
                           bucket_count -1
                           columns key1,key2,cnt
-                          columns.comments 
+                          columns.comments 
                           columns.types int:string:int
 #### A masked pattern was here ####
                           name default.outputtbl2
@@ -428,7 +428,7 @@ STAGE PLANS:
               properties:
                 bucket_count -1
                 columns key1,key2,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:string:int
 #### A masked pattern was here ####
                 name default.outputtbl2
@@ -564,7 +564,7 @@ STAGE PLANS:
                                 COLUMN_STATS_ACCURATE true
                                 bucket_count -1
                                 columns key,cnt
-                                columns.comments 
+                                columns.comments 
                                 columns.types int:int
 #### A masked pattern was here ####
                                 name default.outputtbl1
@@ -595,7 +595,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -617,7 +617,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -647,7 +647,7 @@ STAGE PLANS:
                 COLUMN_STATS_ACCURATE true
                 bucket_count -1
                 columns key,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int
 #### A masked pattern was here ####
                 name default.outputtbl1
@@ -787,7 +787,7 @@ STAGE PLANS:
                                 COLUMN_STATS_ACCURATE true
                                 bucket_count -1
                                 columns key,cnt
-                                columns.comments 
+                                columns.comments 
                                 columns.types int:int
 #### A masked pattern was here ####
                                 name default.outputtbl1
@@ -818,7 +818,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -840,7 +840,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -870,7 +870,7 @@ STAGE PLANS:
                 COLUMN_STATS_ACCURATE true
                 bucket_count -1
                 columns key,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int
 #### A masked pattern was here ####
                 name default.outputtbl1
@@ -1005,7 +1005,7 @@ STAGE PLANS:
                               properties:
                                 bucket_count -1
                                 columns key1,key2,cnt
-                                columns.comments 
+                                columns.comments 
                                 columns.types int:int:int
 #### A masked pattern was here ####
                                 name default.outputtbl3
@@ -1032,7 +1032,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -1054,7 +1054,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -1083,7 +1083,7 @@ STAGE PLANS:
               properties:
                 bucket_count -1
                 columns key1,key2,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int:int
 #### A masked pattern was here ####
                 name default.outputtbl3
@@ -1225,7 +1225,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -1247,7 +1247,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -1290,7 +1290,7 @@ STAGE PLANS:
                         properties:
                           bucket_count -1
                           columns key1,key2,key3,cnt
-                          columns.comments 
+                          columns.comments 
                           columns.types int:int:string:int
 #### A masked pattern was here ####
                           name default.outputtbl4
@@ -1315,7 +1315,7 @@ STAGE PLANS:
               properties:
                 bucket_count -1
                 columns key1,key2,key3,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int:string:int
 #### A masked pattern was here ####
                 name default.outputtbl4
@@ -1452,7 +1452,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -1474,7 +1474,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -1518,7 +1518,7 @@ STAGE PLANS:
                           COLUMN_STATS_ACCURATE true
                           bucket_count -1
                           columns key1,key2,cnt
-                          columns.comments 
+                          columns.comments 
                           columns.types int:int:int
 #### A masked pattern was here ####
                           name default.outputtbl3
@@ -1548,7 +1548,7 @@ STAGE PLANS:
                 COLUMN_STATS_ACCURATE true
                 bucket_count -1
                 columns key1,key2,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int:int
 #### A masked pattern was here ####
                 name default.outputtbl3
@@ -1721,7 +1721,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -1743,7 +1743,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -1787,7 +1787,7 @@ STAGE PLANS:
                           COLUMN_STATS_ACCURATE true
                           bucket_count -1
                           columns key,cnt
-                          columns.comments 
+                          columns.comments 
                           columns.types int:int
 #### A masked pattern was here ####
                           name default.outputtbl1
@@ -1817,7 +1817,7 @@ STAGE PLANS:
                 COLUMN_STATS_ACCURATE true
                 bucket_count -1
                 columns key,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int
 #### A masked pattern was here ####
                 name default.outputtbl1
@@ -1979,7 +1979,7 @@ STAGE PLANS:
                                 COLUMN_STATS_ACCURATE true
                                 bucket_count -1
                                 columns key,cnt
-                                columns.comments 
+                                columns.comments 
                                 columns.types int:int
 #### A masked pattern was here ####
                                 name default.outputtbl1
@@ -2010,7 +2010,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -2032,7 +2032,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -2078,7 +2078,7 @@ STAGE PLANS:
                                 COLUMN_STATS_ACCURATE true
                                 bucket_count -1
                                 columns key,cnt
-                                columns.comments 
+                                columns.comments 
                                 columns.types int:int
 #### A masked pattern was here ####
                                 name default.outputtbl1
@@ -2109,7 +2109,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -2131,7 +2131,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -2161,7 +2161,7 @@ STAGE PLANS:
                 COLUMN_STATS_ACCURATE true
                 bucket_count -1
                 columns key,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int
 #### A masked pattern was here ####
                 name default.outputtbl1
@@ -2344,7 +2344,7 @@ STAGE PLANS:
                                   COLUMN_STATS_ACCURATE true
                                   bucket_count -1
                                   columns key,cnt
-                                  columns.comments 
+                                  columns.comments 
                                   columns.types int:int
 #### A masked pattern was here ####
                                   name default.outputtbl1
@@ -2375,7 +2375,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -2397,7 +2397,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -2452,7 +2452,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -2474,7 +2474,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -2515,7 +2515,7 @@ STAGE PLANS:
                           COLUMN_STATS_ACCURATE true
                           bucket_count -1
                           columns key,cnt
-                          columns.comments 
+                          columns.comments 
                           columns.types int:int
 #### A masked pattern was here ####
                           name default.outputtbl1
@@ -2545,7 +2545,7 @@ STAGE PLANS:
                 COLUMN_STATS_ACCURATE true
                 bucket_count -1
                 columns key,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int
 #### A masked pattern was here ####
                 name default.outputtbl1
@@ -2730,12 +2730,12 @@ STAGE PLANS:
                       keys: key (type: string)
                       mode: final
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 4 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: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                         tag: 0
                         value expressions: _col1 (type: bigint)
                         auto parallelism: false
@@ -2753,7 +2753,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -2775,7 +2775,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -2807,12 +2807,12 @@ STAGE PLANS:
                       keys: key (type: string)
                       mode: final
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 4 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: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                         tag: 1
                         value expressions: _col1 (type: bigint)
                         auto parallelism: false
@@ -2830,7 +2830,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -2852,7 +2852,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -2875,21 +2875,21 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {KEY.reducesinkkey0} {VALUE._col0}
-                  1 {VALUE._col0}
+                keys:
+                  0 _col0 (type: string)
+                  1 _col0 (type: string)
                 outputColumnNames: _col0, _col1, _col3
-                Statistics: Num rows: 3 Data size: 13 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
                   expressions: UDFToInteger(_col0) (type: int), UDFToInteger((_col1 + _col3)) (type: int)
                   outputColumnNames: _col0, _col1
-                  Statistics: Num rows: 3 Data size: 13 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
-                    Statistics: Num rows: 3 Data size: 13 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2898,7 +2898,7 @@ STAGE PLANS:
                           COLUMN_STATS_ACCURATE true
                           bucket_count -1
                           columns key,cnt
-                          columns.comments 
+                          columns.comments 
                           columns.types int:int
 #### A masked pattern was here ####
                           name default.outputtbl1
@@ -2928,7 +2928,7 @@ STAGE PLANS:
                 COLUMN_STATS_ACCURATE true
                 bucket_count -1
                 columns key,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int
 #### A masked pattern was here ####
                 name default.outputtbl1
@@ -3095,12 +3095,12 @@ STAGE PLANS:
                       keys: key (type: string)
                       mode: final
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 4 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: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                         tag: 0
                         value expressions: _col1 (type: bigint)
                         auto parallelism: false
@@ -3118,7 +3118,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -3140,7 +3140,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -3195,7 +3195,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t1
@@ -3217,7 +3217,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t1
@@ -3240,21 +3240,21 @@ STAGE PLANS:
               Join Operator
                 condition map:
                      Inner Join 0 to 1
-                condition expressions:
-                  0 {KEY.reducesinkkey0} {VALUE._col0}
-                  1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
+                keys:
+                  0 _col0 (type: string)
+                  1 _col0 (type: string)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4
-                Statistics: Num rows: 3 Data size: 13 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                 Select Operator
                   expressions: _col0 (type: string), _col1 (type: bigint), _col2 (type: string), _col3 (type: string), _col4 (type: bigint)
                   outputColumnNames: _col0, _col1, _col2, _col3, _col4
-                  Statistics: Num rows: 3 Data size: 13 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
-                    Statistics: Num rows: 3 Data size: 13 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -3278,12 +3278,12 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string), KEY._col1 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 1 Data size: 4 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: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
                   tag: 1
                   value expressions: _col1 (type: string), _col2 (type: bigint)
                   auto parallelism: false
@@ -3402,7 +3402,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t2
@@ -3424,7 +3424,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t2
@@ -3468,7 +3468,7 @@ STAGE PLANS:
                           COLUMN_STATS_ACCURATE true
                           bucket_count -1
                           columns key,cnt
-                          columns.comments 
+                          columns.comments 
                           columns.types int:int
 #### A masked pattern was here ####
                           name default.outputtbl1
@@ -3498,7 +3498,7 @@ STAGE PLANS:
                 COLUMN_STATS_ACCURATE true
                 bucket_count -1
                 columns key,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int
 #### A masked pattern was here ####
                 name default.outputtbl1
@@ -3631,7 +3631,7 @@ STAGE PLANS:
                                 COLUMN_STATS_ACCURATE true
                                 bucket_count -1
                                 columns key1,key2,key3,cnt
-                                columns.comments 
+                                columns.comments 
                                 columns.types int:int:string:int
 #### A masked pattern was here ####
                                 name default.outputtbl4
@@ -3662,7 +3662,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t2
@@ -3684,7 +3684,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t2
@@ -3714,7 +3714,7 @@ STAGE PLANS:
                 COLUMN_STATS_ACCURATE true
                 bucket_count -1
                 columns key1,key2,key3,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int:string:int
 #### A masked pattern was here ####
                 name default.outputtbl4
@@ -3860,7 +3860,7 @@ STAGE PLANS:
                               properties:
                                 bucket_count -1
                                 columns key1,key2,key3,key4,cnt
-                                columns.comments 
+                                columns.comments 
                                 columns.types int:int:string:int:int
 #### A masked pattern was here ####
                                 name default.outputtbl5
@@ -3887,7 +3887,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t2
@@ -3909,7 +3909,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t2
@@ -3938,7 +3938,7 @@ STAGE PLANS:
               properties:
                 bucket_count -1
                 columns key1,key2,key3,key4,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int:string:int:int
 #### A masked pattern was here ####
                 name default.outputtbl5
@@ -4095,7 +4095,7 @@ STAGE PLANS:
                                 COLUMN_STATS_ACCURATE true
                                 bucket_count -1
                                 columns key1,key2,key3,cnt
-                                columns.comments 
+                                columns.comments 
                                 columns.types int:int:string:int
 #### A masked pattern was here ####
                                 name default.outputtbl4
@@ -4126,7 +4126,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t2
@@ -4148,7 +4148,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t2
@@ -4178,7 +4178,7 @@ STAGE PLANS:
                 COLUMN_STATS_ACCURATE true
                 bucket_count -1
                 columns key1,key2,key3,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int:string:int
 #### A masked pattern was here ####
                 name default.outputtbl4
@@ -4368,7 +4368,7 @@ STAGE PLANS:
                                 COLUMN_STATS_ACCURATE true
                                 bucket_count -1
                                 columns key1,key2,key3,cnt
-                                columns.comments 
+                                columns.comments 
                                 columns.types int:int:string:int
 #### A masked pattern was here ####
                                 name default.outputtbl4
@@ -4399,7 +4399,7 @@ STAGE PLANS:
                     bucket_count 2
                     bucket_field_name key
                     columns key,val
-                    columns.comments 
+                    columns.comments 
                     columns.types string:string
 #### A masked pattern was here ####
                     name default.t2
@@ -4421,7 +4421,7 @@ STAGE PLANS:
                       bucket_count 2
                       bucket_field_name key
                       columns key,val
-                      columns.comments 
+                      columns.comments 
                       columns.types string:string
 #### A masked pattern was here ####
                       name default.t2
@@ -4451,7 +4451,7 @@ STAGE PLANS:
                 COLUMN_STATS_ACCURATE true
                 bucket_count -1
                 columns key1,key2,key3,cnt
-                columns.comments 
+                columns.comments 
                 columns.types int:int:string:int
 #### A masked pattern was here ####
                 name default.outputtbl4