hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1640577 [13/30] - in /hive/trunk: accumulo-handler/src/test/results/positive/ common/src/java/org/apache/hadoop/hive/conf/ hbase-handler/src/test/results/positive/ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/h...
Date Wed, 19 Nov 2014 15:54:21 GMT
Modified: hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out?rev=1640577&r1=1640576&r2=1640577&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out Wed Nov 19 15:54:15
2014
@@ -245,31 +245,25 @@ STAGE PLANS:
                   1 key (type: string)
                 outputColumnNames: _col1
                 Statistics: Num rows: 1375 Data size: 14608 Basic stats: COMPLETE Column
stats: NONE
-                Select Operator
-                  expressions: _col1 (type: string)
-                  outputColumnNames: _col1
-                  Statistics: Num rows: 1375 Data size: 14608 Basic stats: COMPLETE Column
stats: NONE
-                  Map Join Operator
-                    condition map:
-                         Inner Join 0 to 1
-                    condition expressions:
-                      0 
-                      1 
-                    keys:
-                      0 _col1 (type: string)
-                      1 value (type: string)
-                    Statistics: Num rows: 1512 Data size: 16068 Basic stats: COMPLETE Column
stats: NONE
-                    Select Operator
-                      Statistics: Num rows: 1512 Data size: 16068 Basic stats: COMPLETE Column
stats: NONE
-                      Group By Operator
-                        aggregations: count()
-                        mode: hash
-                        outputColumnNames: _col0
-                        Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column
stats: NONE
-                        Reduce Output Operator
-                          sort order: 
-                          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column
stats: NONE
-                          value expressions: _col0 (type: bigint)
+                Map Join Operator
+                  condition map:
+                       Inner Join 0 to 1
+                  condition expressions:
+                    0 
+                    1 
+                  keys:
+                    0 _col1 (type: string)
+                    1 value (type: string)
+                  Statistics: Num rows: 1512 Data size: 16068 Basic stats: COMPLETE Column
stats: NONE
+                  Group By Operator
+                    aggregations: count()
+                    mode: hash
+                    outputColumnNames: _col0
+                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
+                    Reduce Output Operator
+                      sort order: 
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
+                      value expressions: _col0 (type: bigint)
       Local Work:
         Map Reduce Local Work
       Reduce Operator Tree:
@@ -410,31 +404,25 @@ STAGE PLANS:
                   1 key (type: string)
                 outputColumnNames: _col1
                 Statistics: Num rows: 1375 Data size: 14608 Basic stats: COMPLETE Column
stats: NONE
-                Select Operator
-                  expressions: _col1 (type: string)
-                  outputColumnNames: _col1
-                  Statistics: Num rows: 1375 Data size: 14608 Basic stats: COMPLETE Column
stats: NONE
-                  Map Join Operator
-                    condition map:
-                         Inner Join 0 to 1
-                    condition expressions:
-                      0 
-                      1 
-                    keys:
-                      0 _col1 (type: string)
-                      1 value (type: string)
-                    Statistics: Num rows: 1512 Data size: 16068 Basic stats: COMPLETE Column
stats: NONE
-                    Select Operator
-                      Statistics: Num rows: 1512 Data size: 16068 Basic stats: COMPLETE Column
stats: NONE
-                      Group By Operator
-                        aggregations: count()
-                        mode: hash
-                        outputColumnNames: _col0
-                        Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column
stats: NONE
-                        Reduce Output Operator
-                          sort order: 
-                          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column
stats: NONE
-                          value expressions: _col0 (type: bigint)
+                Map Join Operator
+                  condition map:
+                       Inner Join 0 to 1
+                  condition expressions:
+                    0 
+                    1 
+                  keys:
+                    0 _col1 (type: string)
+                    1 value (type: string)
+                  Statistics: Num rows: 1512 Data size: 16068 Basic stats: COMPLETE Column
stats: NONE
+                  Group By Operator
+                    aggregations: count()
+                    mode: hash
+                    outputColumnNames: _col0
+                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
+                    Reduce Output Operator
+                      sort order: 
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
+                      value expressions: _col0 (type: bigint)
       Local Work:
         Map Reduce Local Work
       Reduce Operator Tree:
@@ -579,37 +567,29 @@ STAGE PLANS:
                   1 key (type: string)
                 outputColumnNames: _col1
                 Statistics: Num rows: 1375 Data size: 14608 Basic stats: COMPLETE Column
stats: NONE
-                Select Operator
-                  expressions: _col1 (type: string)
-                  outputColumnNames: _col1
-                  Statistics: Num rows: 1375 Data size: 14608 Basic stats: COMPLETE Column
stats: NONE
-                  Map Join Operator
-                    condition map:
-                         Inner Join 0 to 1
-                    condition expressions:
-                      0 
-                      1 {key}
-                    keys:
-                      0 _col1 (type: string)
-                      1 value (type: string)
-                    outputColumnNames: _col3
+                Map Join Operator
+                  condition map:
+                       Inner Join 0 to 1
+                  condition expressions:
+                    0 
+                    1 {key}
+                  keys:
+                    0 _col1 (type: string)
+                    1 value (type: string)
+                  outputColumnNames: _col3
+                  Statistics: Num rows: 1512 Data size: 16068 Basic stats: COMPLETE Column
stats: NONE
+                  Group By Operator
+                    aggregations: count()
+                    keys: _col3 (type: string)
+                    mode: hash
+                    outputColumnNames: _col0, _col1
                     Statistics: Num rows: 1512 Data size: 16068 Basic stats: COMPLETE Column
stats: NONE
-                    Select Operator
-                      expressions: _col3 (type: string)
-                      outputColumnNames: _col3
+                    Reduce Output Operator
+                      key expressions: _col0 (type: string)
+                      sort order: +
+                      Map-reduce partition columns: _col0 (type: string)
                       Statistics: Num rows: 1512 Data size: 16068 Basic stats: COMPLETE Column
stats: NONE
-                      Group By Operator
-                        aggregations: count()
-                        keys: _col3 (type: string)
-                        mode: hash
-                        outputColumnNames: _col0, _col1
-                        Statistics: Num rows: 1512 Data size: 16068 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: 1512 Data size: 16068 Basic stats: COMPLETE
Column stats: NONE
-                          value expressions: _col1 (type: bigint)
+                      value expressions: _col1 (type: bigint)
       Local Work:
         Map Reduce Local Work
       Reduce Operator Tree:
@@ -935,15 +915,12 @@ STAGE PLANS:
                 0 _col3 (type: string)
                 1 value (type: string)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-              Select Operator
-                expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col5 (type: string), _col3 (type: string), _col4 (type: string)
-                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-                File Output Operator
-                  compressed: false
-                  table:
-                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+              File Output Operator
+                compressed: false
+                table:
+                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
 
@@ -984,15 +961,12 @@ STAGE PLANS:
                 0 _col1 (type: string)
                 1 key (type: string)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-              Select Operator
-                expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col3 (type: string), _col6 (type: string), _col4 (type: string), _col5 (type: string)
-                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-                File Output Operator
-                  compressed: false
-                  table:
-                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+              File Output Operator
+                compressed: false
+                table:
+                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
 
@@ -1205,15 +1179,12 @@ STAGE PLANS:
                   0 _col1 (type: string)
                   1 key (type: string)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-                Select Operator
-                  expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col3 (type: string), _col6 (type: string), _col4 (type: string), _col5 (type: string)
-                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-                  File Output Operator
-                    compressed: false
-                    table:
-                        input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                        output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                        serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+                File Output Operator
+                  compressed: false
+                  table:
+                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
 
@@ -1247,16 +1218,12 @@ STAGE PLANS:
             1 {KEY.reducesinkkey0}
           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
           Statistics: Num rows: 830 Data size: 12007 Basic stats: COMPLETE Column stats:
NONE
-          Select Operator
-            expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col3 (type: string), _col6 (type: string), _col4 (type: string), _col5 (type: string)
-            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-            Statistics: Num rows: 830 Data size: 12007 Basic stats: COMPLETE Column stats:
NONE
-            File Output Operator
-              compressed: false
-              table:
-                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+          File Output Operator
+            compressed: false
+            table:
+                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
 
   Stage: Stage-26
     Map Reduce Local Work
@@ -1292,15 +1259,12 @@ STAGE PLANS:
                   0 _col3 (type: string)
                   1 value (type: string)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-                Select Operator
-                  expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col5 (type: string), _col3 (type: string), _col4 (type: string)
-                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-                  File Output Operator
-                    compressed: false
-                    table:
-                        input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                        output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                        serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+                File Output Operator
+                  compressed: false
+                  table:
+                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
 
@@ -1335,16 +1299,12 @@ STAGE PLANS:
             1 {VALUE._col0}
           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
           Statistics: Num rows: 755 Data size: 10916 Basic stats: COMPLETE Column stats:
NONE
-          Select Operator
-            expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col5 (type: string), _col3 (type: string), _col4 (type: string)
-            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-            Statistics: Num rows: 755 Data size: 10916 Basic stats: COMPLETE Column stats:
NONE
-            File Output Operator
-              compressed: false
-              table:
-                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+          File Output Operator
+            compressed: false
+            table:
+                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
 
   Stage: Stage-28
     Map Reduce Local Work
@@ -1536,7 +1496,7 @@ RUN: Stage-11:CONDITIONAL
 RUN: Stage-21:MAPREDLOCAL
 RUN: Stage-9:MAPRED
 RUN: Stage-4:MAPRED
-247580	247580	247580	247580	247580	247580	548662743780	548662743780
+247580	247580	247580	548662743780	548662743780	247580	247580	247580
 PREHOOK: query: -- Enable noconditionaltask and set the size of hive.auto.convert.join.noconditionaltask.size
 -- to 10000, which is large enough to fit all four small tables (smallTbl1 to smallTbl4).
 -- We will use a single MR job to evaluate this query.
@@ -1723,49 +1683,41 @@ STAGE PLANS:
                       1 value (type: string)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 755 Data size: 10916 Basic stats: COMPLETE Column
stats: NONE
-                    Select Operator
-                      expressions: _col0 (type: string), _col1 (type: string), _col2 (type:
string), _col5 (type: string), _col3 (type: string), _col4 (type: string)
-                      outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-                      Statistics: Num rows: 755 Data size: 10916 Basic stats: COMPLETE Column
stats: NONE
+                    Map Join Operator
+                      condition map:
+                           Inner Join 0 to 1
+                      condition expressions:
+                        0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5}
+                        1 {key}
+                      keys:
+                        0 _col1 (type: string)
+                        1 key (type: string)
+                      outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
+                      Statistics: Num rows: 830 Data size: 12007 Basic stats: COMPLETE Column
stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
                         condition expressions:
-                          0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5}
+                          0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
                           1 {key}
                         keys:
-                          0 _col1 (type: string)
+                          0 _col2 (type: string)
                           1 key (type: string)
-                        outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-                        Statistics: Num rows: 830 Data size: 12007 Basic stats: COMPLETE
Column stats: NONE
+                        outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6,
_col7
+                        Statistics: Num rows: 913 Data size: 13207 Basic stats: COMPLETE
Column stats: NONE
                         Select Operator
-                          expressions: _col0 (type: string), _col1 (type: string), _col2
(type: string), _col3 (type: string), _col6 (type: string), _col4 (type: string), _col5 (type:
string)
-                          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-                          Statistics: Num rows: 830 Data size: 12007 Basic stats: COMPLETE
Column stats: NONE
-                          Map Join Operator
-                            condition map:
-                                 Inner Join 0 to 1
-                            condition expressions:
-                              0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
-                              1 {key}
-                            keys:
-                              0 _col2 (type: string)
-                              1 key (type: string)
+                          expressions: _col0 (type: string), _col1 (type: string), _col2
(type: string), _col3 (type: string), _col4 (type: string), _col7 (type: string), _col5 (type:
string), _col6 (type: string)
+                          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col7, _col5,
_col6
+                          Statistics: Num rows: 913 Data size: 13207 Basic stats: COMPLETE
Column stats: NONE
+                          Group By Operator
+                            aggregations: sum(hash(_col0)), sum(hash(_col1)), sum(hash(_col2)),
sum(hash(_col3)), sum(hash(_col4)), sum(hash(_col7)), sum(hash(_col5)), sum(hash(_col6))
+                            mode: hash
                             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5,
_col6, _col7
-                            Statistics: Num rows: 913 Data size: 13207 Basic stats: COMPLETE
Column stats: NONE
-                            Select Operator
-                              expressions: _col0 (type: string), _col1 (type: string), _col2
(type: string), _col3 (type: string), _col4 (type: string), _col7 (type: string), _col5 (type:
string), _col6 (type: string)
-                              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col7,
_col5, _col6
-                              Statistics: Num rows: 913 Data size: 13207 Basic stats: COMPLETE
Column stats: NONE
-                              Group By Operator
-                                aggregations: sum(hash(_col0)), sum(hash(_col1)), sum(hash(_col2)),
sum(hash(_col3)), sum(hash(_col4)), sum(hash(_col7)), sum(hash(_col5)), sum(hash(_col6))
-                                mode: hash
-                                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5,
_col6, _col7
-                                Statistics: Num rows: 1 Data size: 64 Basic stats: COMPLETE
Column stats: NONE
-                                Reduce Output Operator
-                                  sort order: 
-                                  Statistics: Num rows: 1 Data size: 64 Basic stats: COMPLETE
Column stats: NONE
-                                  value expressions: _col0 (type: bigint), _col1 (type: bigint),
_col2 (type: bigint), _col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint), _col6
(type: bigint), _col7 (type: bigint)
+                            Statistics: Num rows: 1 Data size: 64 Basic stats: COMPLETE Column
stats: NONE
+                            Reduce Output Operator
+                              sort order: 
+                              Statistics: Num rows: 1 Data size: 64 Basic stats: COMPLETE
Column stats: NONE
+                              value expressions: _col0 (type: bigint), _col1 (type: bigint),
_col2 (type: bigint), _col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint), _col6
(type: bigint), _col7 (type: bigint)
       Local Work:
         Map Reduce Local Work
       Reduce Operator Tree:
@@ -1870,7 +1822,7 @@ POSTHOOK: Input: default@smalltbl4
 #### A masked pattern was here ####
 RUN: Stage-13:MAPREDLOCAL
 RUN: Stage-4:MAPRED
-247580	247580	247580	247580	247580	247580	548662743780	548662743780
+247580	247580	247580	548662743780	548662743780	247580	247580	247580
 PREHOOK: query: -- Enable noconditionaltask and set the size of hive.auto.convert.join.noconditionaltask.size
 -- to 200, which is large enough to fit two small tables. We will have two jobs to evaluate
this
 -- query. The first job is a Map-only job to evaluate join1 and join2.
@@ -2027,16 +1979,12 @@ STAGE PLANS:
                       1 value (type: string)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 755 Data size: 10916 Basic stats: COMPLETE Column
stats: NONE
-                    Select Operator
-                      expressions: _col0 (type: string), _col1 (type: string), _col2 (type:
string), _col5 (type: string), _col3 (type: string), _col4 (type: string)
-                      outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-                      Statistics: Num rows: 755 Data size: 10916 Basic stats: COMPLETE Column
stats: NONE
-                      File Output Operator
-                        compressed: false
-                        table:
-                            input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                            output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                            serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+                    File Output Operator
+                      compressed: false
+                      table:
+                          input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                          output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                          serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
 
@@ -2094,34 +2042,30 @@ STAGE PLANS:
                 1 key (type: string)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
               Statistics: Num rows: 830 Data size: 12007 Basic stats: COMPLETE Column stats:
NONE
-              Select Operator
-                expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col3 (type: string), _col6 (type: string), _col4 (type: string), _col5 (type: string)
-                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-                Statistics: Num rows: 830 Data size: 12007 Basic stats: COMPLETE Column stats:
NONE
-                Map Join Operator
-                  condition map:
-                       Inner Join 0 to 1
-                  condition expressions:
-                    0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
-                    1 {key}
-                  keys:
-                    0 _col2 (type: string)
-                    1 key (type: string)
-                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+              Map Join Operator
+                condition map:
+                     Inner Join 0 to 1
+                condition expressions:
+                  0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
+                  1 {key}
+                keys:
+                  0 _col2 (type: string)
+                  1 key (type: string)
+                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+                Statistics: Num rows: 913 Data size: 13207 Basic stats: COMPLETE Column stats:
NONE
+                Select Operator
+                  expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col3 (type: string), _col4 (type: string), _col7 (type: string), _col5 (type: string), _col6
(type: string)
+                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col7, _col5, _col6
                   Statistics: Num rows: 913 Data size: 13207 Basic stats: COMPLETE Column
stats: NONE
-                  Select Operator
-                    expressions: _col0 (type: string), _col1 (type: string), _col2 (type:
string), _col3 (type: string), _col4 (type: string), _col7 (type: string), _col5 (type: string),
_col6 (type: string)
-                    outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col7, _col5, _col6
-                    Statistics: Num rows: 913 Data size: 13207 Basic stats: COMPLETE Column
stats: NONE
-                    Group By Operator
-                      aggregations: sum(hash(_col0)), sum(hash(_col1)), sum(hash(_col2)),
sum(hash(_col3)), sum(hash(_col4)), sum(hash(_col7)), sum(hash(_col5)), sum(hash(_col6))
-                      mode: hash
-                      outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6,
_col7
+                  Group By Operator
+                    aggregations: sum(hash(_col0)), sum(hash(_col1)), sum(hash(_col2)), sum(hash(_col3)),
sum(hash(_col4)), sum(hash(_col7)), sum(hash(_col5)), sum(hash(_col6))
+                    mode: hash
+                    outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+                    Statistics: Num rows: 1 Data size: 64 Basic stats: COMPLETE Column stats:
NONE
+                    Reduce Output Operator
+                      sort order: 
                       Statistics: Num rows: 1 Data size: 64 Basic stats: COMPLETE Column
stats: NONE
-                      Reduce Output Operator
-                        sort order: 
-                        Statistics: Num rows: 1 Data size: 64 Basic stats: COMPLETE Column
stats: NONE
-                        value expressions: _col0 (type: bigint), _col1 (type: bigint), _col2
(type: bigint), _col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint), _col6 (type:
bigint), _col7 (type: bigint)
+                      value expressions: _col0 (type: bigint), _col1 (type: bigint), _col2
(type: bigint), _col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint), _col6 (type:
bigint), _col7 (type: bigint)
       Local Work:
         Map Reduce Local Work
       Reduce Operator Tree:
@@ -2228,7 +2172,7 @@ RUN: Stage-14:MAPREDLOCAL
 RUN: Stage-11:MAPRED
 RUN: Stage-13:MAPREDLOCAL
 RUN: Stage-4:MAPRED
-247580	247580	247580	247580	247580	247580	548662743780	548662743780
+247580	247580	247580	548662743780	548662743780	247580	247580	247580
 PREHOOK: query: -- Enable noconditionaltask and but set the size of hive.auto.convert.join.noconditionaltask.size
 -- to 0. The plan will be the same as the one with a disabled nonconditionaltask.
 EXPLAIN
@@ -2417,15 +2361,12 @@ STAGE PLANS:
                 0 _col3 (type: string)
                 1 value (type: string)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-              Select Operator
-                expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col5 (type: string), _col3 (type: string), _col4 (type: string)
-                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-                File Output Operator
-                  compressed: false
-                  table:
-                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+              File Output Operator
+                compressed: false
+                table:
+                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
 
@@ -2466,15 +2407,12 @@ STAGE PLANS:
                 0 _col1 (type: string)
                 1 key (type: string)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-              Select Operator
-                expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col3 (type: string), _col6 (type: string), _col4 (type: string), _col5 (type: string)
-                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-                File Output Operator
-                  compressed: false
-                  table:
-                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+              File Output Operator
+                compressed: false
+                table:
+                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
 
@@ -2687,15 +2625,12 @@ STAGE PLANS:
                   0 _col1 (type: string)
                   1 key (type: string)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-                Select Operator
-                  expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col3 (type: string), _col6 (type: string), _col4 (type: string), _col5 (type: string)
-                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-                  File Output Operator
-                    compressed: false
-                    table:
-                        input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                        output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                        serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+                File Output Operator
+                  compressed: false
+                  table:
+                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
 
@@ -2729,16 +2664,12 @@ STAGE PLANS:
             1 {KEY.reducesinkkey0}
           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
           Statistics: Num rows: 830 Data size: 12007 Basic stats: COMPLETE Column stats:
NONE
-          Select Operator
-            expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col3 (type: string), _col6 (type: string), _col4 (type: string), _col5 (type: string)
-            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-            Statistics: Num rows: 830 Data size: 12007 Basic stats: COMPLETE Column stats:
NONE
-            File Output Operator
-              compressed: false
-              table:
-                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+          File Output Operator
+            compressed: false
+            table:
+                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
 
   Stage: Stage-26
     Map Reduce Local Work
@@ -2774,15 +2705,12 @@ STAGE PLANS:
                   0 _col3 (type: string)
                   1 value (type: string)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-                Select Operator
-                  expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col5 (type: string), _col3 (type: string), _col4 (type: string)
-                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-                  File Output Operator
-                    compressed: false
-                    table:
-                        input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                        output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                        serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+                File Output Operator
+                  compressed: false
+                  table:
+                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
       Local Work:
         Map Reduce Local Work
 
@@ -2817,16 +2745,12 @@ STAGE PLANS:
             1 {VALUE._col0}
           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
           Statistics: Num rows: 755 Data size: 10916 Basic stats: COMPLETE Column stats:
NONE
-          Select Operator
-            expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string),
_col5 (type: string), _col3 (type: string), _col4 (type: string)
-            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-            Statistics: Num rows: 755 Data size: 10916 Basic stats: COMPLETE Column stats:
NONE
-            File Output Operator
-              compressed: false
-              table:
-                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+          File Output Operator
+            compressed: false
+            table:
+                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
 
   Stage: Stage-28
     Map Reduce Local Work
@@ -3018,4 +2942,4 @@ RUN: Stage-11:CONDITIONAL
 RUN: Stage-21:MAPREDLOCAL
 RUN: Stage-9:MAPRED
 RUN: Stage-4:MAPRED
-247580	247580	247580	247580	247580	247580	548662743780	548662743780
+247580	247580	247580	548662743780	548662743780	247580	247580	247580



Mime
View raw message