hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From omal...@apache.org
Subject [01/55] [partial] hive git commit: HIVE-12017: Do not disable CBO by default when number of joins in a query is equal or less than 1 (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
Date Mon, 23 Nov 2015 17:23:24 GMT
Repository: hive
Updated Branches:
  refs/heads/master-fixed 4a13e5fb2 -> 5f726d58e


http://git-wip-us.apache.org/repos/asf/hive/blob/855e43df/ql/src/test/results/clientpositive/spark/join_star.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/join_star.q.out b/ql/src/test/results/clientpositive/spark/join_star.q.out
index 69c2fd7..487e0c9 100644
--- a/ql/src/test/results/clientpositive/spark/join_star.q.out
+++ b/ql/src/test/results/clientpositive/spark/join_star.q.out
@@ -148,10 +148,14 @@ STAGE PLANS:
                   Filter Operator
                     predicate: f1 is not null (type: boolean)
                     Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
-                    Spark HashTable Sink Operator
-                      keys:
-                        0 d1 (type: int)
-                        1 f1 (type: int)
+                    Select Operator
+                      expressions: f1 (type: int), f2 (type: int)
+                      outputColumnNames: _col0, _col1
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
+                      Spark HashTable Sink Operator
+                        keys:
+                          0 _col2 (type: int)
+                          1 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
 
@@ -167,27 +171,31 @@ STAGE PLANS:
                   Filter Operator
                     predicate: d1 is not null (type: boolean)
                     Statistics: Num rows: 4 Data size: 49 Basic stats: COMPLETE Column stats:
NONE
-                    Map Join Operator
-                      condition map:
-                           Inner Join 0 to 1
-                      keys:
-                        0 d1 (type: int)
-                        1 f1 (type: int)
-                      outputColumnNames: _col0, _col1, _col8
-                      input vertices:
-                        1 Map 2
-                      Statistics: Num rows: 4 Data size: 53 Basic stats: COMPLETE Column
stats: NONE
-                      Select Operator
-                        expressions: _col0 (type: int), _col1 (type: int), _col8 (type: int)
-                        outputColumnNames: _col0, _col1, _col2
+                    Select Operator
+                      expressions: m1 (type: int), m2 (type: int), d1 (type: int)
+                      outputColumnNames: _col0, _col1, _col2
+                      Statistics: Num rows: 4 Data size: 49 Basic stats: COMPLETE Column
stats: NONE
+                      Map Join Operator
+                        condition map:
+                             Inner Join 0 to 1
+                        keys:
+                          0 _col2 (type: int)
+                          1 _col0 (type: int)
+                        outputColumnNames: _col0, _col1, _col4
+                        input vertices:
+                          1 Map 2
                         Statistics: Num rows: 4 Data size: 53 Basic stats: COMPLETE Column
stats: NONE
-                        File Output Operator
-                          compressed: false
+                        Select Operator
+                          expressions: _col0 (type: int), _col1 (type: int), _col4 (type:
int)
+                          outputColumnNames: _col0, _col1, _col2
                           Statistics: Num rows: 4 Data size: 53 Basic stats: COMPLETE Column
stats: NONE
-                          table:
-                              input format: org.apache.hadoop.mapred.TextInputFormat
-                              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                          File Output Operator
+                            compressed: false
+                            Statistics: Num rows: 4 Data size: 53 Basic stats: COMPLETE Column
stats: NONE
+                            table:
+                                input format: org.apache.hadoop.mapred.TextInputFormat
+                                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
             Local Work:
               Map Reduce Local Work
 
@@ -239,10 +247,14 @@ STAGE PLANS:
                   Filter Operator
                     predicate: f1 is not null (type: boolean)
                     Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
-                    Spark HashTable Sink Operator
-                      keys:
-                        0 d1 (type: int)
-                        1 f1 (type: int)
+                    Select Operator
+                      expressions: f1 (type: int), f2 (type: int)
+                      outputColumnNames: _col0, _col1
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
+                      Spark HashTable Sink Operator
+                        keys:
+                          0 _col2 (type: int)
+                          1 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
         Map 3 
@@ -253,10 +265,14 @@ STAGE PLANS:
                   Filter Operator
                     predicate: f3 is not null (type: boolean)
                     Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
-                    Spark HashTable Sink Operator
-                      keys:
-                        0 _col3 (type: int)
-                        1 f3 (type: int)
+                    Select Operator
+                      expressions: f3 (type: int), f4 (type: int)
+                      outputColumnNames: _col0, _col1
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
+                      Spark HashTable Sink Operator
+                        keys:
+                          0 _col3 (type: int)
+                          1 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
 
@@ -272,37 +288,41 @@ STAGE PLANS:
                   Filter Operator
                     predicate: (d1 is not null and d2 is not null) (type: boolean)
                     Statistics: Num rows: 2 Data size: 32 Basic stats: COMPLETE Column stats:
NONE
-                    Map Join Operator
-                      condition map:
-                           Inner Join 0 to 1
-                      keys:
-                        0 d1 (type: int)
-                        1 f1 (type: int)
-                      outputColumnNames: _col0, _col1, _col3, _col8
-                      input vertices:
-                        1 Map 2
-                      Statistics: Num rows: 2 Data size: 35 Basic stats: COMPLETE Column
stats: NONE
+                    Select Operator
+                      expressions: m1 (type: int), m2 (type: int), d1 (type: int), d2 (type:
int)
+                      outputColumnNames: _col0, _col1, _col2, _col3
+                      Statistics: Num rows: 2 Data size: 32 Basic stats: COMPLETE Column
stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
                         keys:
-                          0 _col3 (type: int)
-                          1 f3 (type: int)
-                        outputColumnNames: _col0, _col1, _col8, _col13
+                          0 _col2 (type: int)
+                          1 _col0 (type: int)
+                        outputColumnNames: _col0, _col1, _col3, _col5
                         input vertices:
-                          1 Map 3
-                        Statistics: Num rows: 2 Data size: 38 Basic stats: COMPLETE Column
stats: NONE
-                        Select Operator
-                          expressions: _col0 (type: int), _col1 (type: int), _col8 (type:
int), _col13 (type: int)
-                          outputColumnNames: _col0, _col1, _col2, _col3
+                          1 Map 2
+                        Statistics: Num rows: 2 Data size: 35 Basic stats: COMPLETE Column
stats: NONE
+                        Map Join Operator
+                          condition map:
+                               Inner Join 0 to 1
+                          keys:
+                            0 _col3 (type: int)
+                            1 _col0 (type: int)
+                          outputColumnNames: _col0, _col1, _col5, _col7
+                          input vertices:
+                            1 Map 3
                           Statistics: Num rows: 2 Data size: 38 Basic stats: COMPLETE Column
stats: NONE
-                          File Output Operator
-                            compressed: false
+                          Select Operator
+                            expressions: _col0 (type: int), _col1 (type: int), _col5 (type:
int), _col7 (type: int)
+                            outputColumnNames: _col0, _col1, _col2, _col3
                             Statistics: Num rows: 2 Data size: 38 Basic stats: COMPLETE Column
stats: NONE
-                            table:
-                                input format: org.apache.hadoop.mapred.TextInputFormat
-                                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                            File Output Operator
+                              compressed: false
+                              Statistics: Num rows: 2 Data size: 38 Basic stats: COMPLETE
Column stats: NONE
+                              table:
+                                  input format: org.apache.hadoop.mapred.TextInputFormat
+                                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
             Local Work:
               Map Reduce Local Work
 
@@ -356,10 +376,14 @@ STAGE PLANS:
                   Filter Operator
                     predicate: (f1 is not null and f2 is not null) (type: boolean)
                     Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
-                    Spark HashTable Sink Operator
-                      keys:
-                        0 d1 (type: int)
-                        1 f1 (type: int)
+                    Select Operator
+                      expressions: f1 (type: int), f2 (type: int)
+                      outputColumnNames: _col0, _col1
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
+                      Spark HashTable Sink Operator
+                        keys:
+                          0 _col2 (type: int)
+                          1 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
         Map 3 
@@ -370,10 +394,14 @@ STAGE PLANS:
                   Filter Operator
                     predicate: f3 is not null (type: boolean)
                     Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
-                    Spark HashTable Sink Operator
-                      keys:
-                        0 _col8 (type: int)
-                        1 f3 (type: int)
+                    Select Operator
+                      expressions: f3 (type: int), f4 (type: int)
+                      outputColumnNames: _col0, _col1
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
+                      Spark HashTable Sink Operator
+                        keys:
+                          0 _col4 (type: int)
+                          1 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
 
@@ -389,37 +417,41 @@ STAGE PLANS:
                   Filter Operator
                     predicate: d1 is not null (type: boolean)
                     Statistics: Num rows: 4 Data size: 49 Basic stats: COMPLETE Column stats:
NONE
-                    Map Join Operator
-                      condition map:
-                           Inner Join 0 to 1
-                      keys:
-                        0 d1 (type: int)
-                        1 f1 (type: int)
-                      outputColumnNames: _col0, _col1, _col8
-                      input vertices:
-                        1 Map 2
-                      Statistics: Num rows: 4 Data size: 53 Basic stats: COMPLETE Column
stats: NONE
+                    Select Operator
+                      expressions: m1 (type: int), m2 (type: int), d1 (type: int)
+                      outputColumnNames: _col0, _col1, _col2
+                      Statistics: Num rows: 4 Data size: 49 Basic stats: COMPLETE Column
stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
                         keys:
-                          0 _col8 (type: int)
-                          1 f3 (type: int)
-                        outputColumnNames: _col0, _col1, _col8, _col13
+                          0 _col2 (type: int)
+                          1 _col0 (type: int)
+                        outputColumnNames: _col0, _col1, _col4
                         input vertices:
-                          1 Map 3
-                        Statistics: Num rows: 4 Data size: 58 Basic stats: COMPLETE Column
stats: NONE
-                        Select Operator
-                          expressions: _col0 (type: int), _col1 (type: int), _col8 (type:
int), _col13 (type: int)
-                          outputColumnNames: _col0, _col1, _col2, _col3
+                          1 Map 2
+                        Statistics: Num rows: 4 Data size: 53 Basic stats: COMPLETE Column
stats: NONE
+                        Map Join Operator
+                          condition map:
+                               Inner Join 0 to 1
+                          keys:
+                            0 _col4 (type: int)
+                            1 _col0 (type: int)
+                          outputColumnNames: _col0, _col1, _col4, _col6
+                          input vertices:
+                            1 Map 3
                           Statistics: Num rows: 4 Data size: 58 Basic stats: COMPLETE Column
stats: NONE
-                          File Output Operator
-                            compressed: false
+                          Select Operator
+                            expressions: _col0 (type: int), _col1 (type: int), _col4 (type:
int), _col6 (type: int)
+                            outputColumnNames: _col0, _col1, _col2, _col3
                             Statistics: Num rows: 4 Data size: 58 Basic stats: COMPLETE Column
stats: NONE
-                            table:
-                                input format: org.apache.hadoop.mapred.TextInputFormat
-                                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                            File Output Operator
+                              compressed: false
+                              Statistics: Num rows: 4 Data size: 58 Basic stats: COMPLETE
Column stats: NONE
+                              table:
+                                  input format: org.apache.hadoop.mapred.TextInputFormat
+                                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
             Local Work:
               Map Reduce Local Work
 
@@ -470,10 +502,14 @@ STAGE PLANS:
                 TableScan
                   alias: dim1
                   Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
-                  Spark HashTable Sink Operator
-                    keys:
-                      0 d1 (type: int)
-                      1 f1 (type: int)
+                  Select Operator
+                    expressions: f1 (type: int), f2 (type: int)
+                    outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
+                    Spark HashTable Sink Operator
+                      keys:
+                        0 _col2 (type: int)
+                        1 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
         Map 3 
@@ -481,10 +517,14 @@ STAGE PLANS:
                 TableScan
                   alias: dim2
                   Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
-                  Spark HashTable Sink Operator
-                    keys:
-                      0 _col8 (type: int)
-                      1 f3 (type: int)
+                  Select Operator
+                    expressions: f3 (type: int), f4 (type: int)
+                    outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
+                    Spark HashTable Sink Operator
+                      keys:
+                        0 _col4 (type: int)
+                        1 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
 
@@ -497,37 +537,41 @@ STAGE PLANS:
                 TableScan
                   alias: fact
                   Statistics: Num rows: 8 Data size: 98 Basic stats: COMPLETE Column stats:
NONE
-                  Map Join Operator
-                    condition map:
-                         Left Outer Join0 to 1
-                    keys:
-                      0 d1 (type: int)
-                      1 f1 (type: int)
-                    outputColumnNames: _col0, _col1, _col8
-                    input vertices:
-                      1 Map 2
-                    Statistics: Num rows: 8 Data size: 107 Basic stats: COMPLETE Column stats:
NONE
+                  Select Operator
+                    expressions: m1 (type: int), m2 (type: int), d1 (type: int)
+                    outputColumnNames: _col0, _col1, _col2
+                    Statistics: Num rows: 8 Data size: 98 Basic stats: COMPLETE Column stats:
NONE
                     Map Join Operator
                       condition map:
                            Left Outer Join0 to 1
                       keys:
-                        0 _col8 (type: int)
-                        1 f3 (type: int)
-                      outputColumnNames: _col0, _col1, _col8, _col13
+                        0 _col2 (type: int)
+                        1 _col0 (type: int)
+                      outputColumnNames: _col0, _col1, _col4
                       input vertices:
-                        1 Map 3
-                      Statistics: Num rows: 8 Data size: 117 Basic stats: COMPLETE Column
stats: NONE
-                      Select Operator
-                        expressions: _col0 (type: int), _col1 (type: int), _col8 (type: int),
_col13 (type: int)
-                        outputColumnNames: _col0, _col1, _col2, _col3
+                        1 Map 2
+                      Statistics: Num rows: 8 Data size: 107 Basic stats: COMPLETE Column
stats: NONE
+                      Map Join Operator
+                        condition map:
+                             Left Outer Join0 to 1
+                        keys:
+                          0 _col4 (type: int)
+                          1 _col0 (type: int)
+                        outputColumnNames: _col0, _col1, _col4, _col6
+                        input vertices:
+                          1 Map 3
                         Statistics: Num rows: 8 Data size: 117 Basic stats: COMPLETE Column
stats: NONE
-                        File Output Operator
-                          compressed: false
+                        Select Operator
+                          expressions: _col0 (type: int), _col1 (type: int), _col4 (type:
int), _col6 (type: int)
+                          outputColumnNames: _col0, _col1, _col2, _col3
                           Statistics: Num rows: 8 Data size: 117 Basic stats: COMPLETE Column
stats: NONE
-                          table:
-                              input format: org.apache.hadoop.mapred.TextInputFormat
-                              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                          File Output Operator
+                            compressed: false
+                            Statistics: Num rows: 8 Data size: 117 Basic stats: COMPLETE
Column stats: NONE
+                            table:
+                                input format: org.apache.hadoop.mapred.TextInputFormat
+                                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
             Local Work:
               Map Reduce Local Work
 
@@ -594,10 +638,14 @@ STAGE PLANS:
                 TableScan
                   alias: dim1
                   Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
-                  Spark HashTable Sink Operator
-                    keys:
-                      0 d1 (type: int)
-                      1 f1 (type: int)
+                  Select Operator
+                    expressions: f1 (type: int), f2 (type: int)
+                    outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
+                    Spark HashTable Sink Operator
+                      keys:
+                        0 _col2 (type: int)
+                        1 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
         Map 3 
@@ -605,10 +653,14 @@ STAGE PLANS:
                 TableScan
                   alias: dim2
                   Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
-                  Spark HashTable Sink Operator
-                    keys:
-                      0 _col8 (type: int)
-                      1 f3 (type: int)
+                  Select Operator
+                    expressions: f3 (type: int), f4 (type: int)
+                    outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
+                    Spark HashTable Sink Operator
+                      keys:
+                        0 _col5 (type: int)
+                        1 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
         Map 4 
@@ -616,10 +668,14 @@ STAGE PLANS:
                 TableScan
                   alias: dim3
                   Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
-                  Spark HashTable Sink Operator
-                    keys:
-                      0 _col3 (type: int)
-                      1 f5 (type: int)
+                  Select Operator
+                    expressions: f5 (type: int), f6 (type: int)
+                    outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
+                    Spark HashTable Sink Operator
+                      keys:
+                        0 _col3 (type: int)
+                        1 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
         Map 5 
@@ -627,11 +683,15 @@ STAGE PLANS:
                 TableScan
                   alias: dim4
                   Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
-                  Spark HashTable Sink Operator
-                    keys:
-                      0 _col18 (type: int)
-                      1 f7 (type: int)
-                      2 f11 (type: int)
+                  Select Operator
+                    expressions: f7 (type: int), f8 (type: int)
+                    outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
+                    Spark HashTable Sink Operator
+                      keys:
+                        0 _col9 (type: int)
+                        1 _col0 (type: int)
+                        2 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
         Map 6 
@@ -639,10 +699,14 @@ STAGE PLANS:
                 TableScan
                   alias: dim5
                   Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
-                  Spark HashTable Sink Operator
-                    keys:
-                      0 _col23 (type: int)
-                      1 f9 (type: int)
+                  Select Operator
+                    expressions: f9 (type: int), f10 (type: int)
+                    outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
+                    Spark HashTable Sink Operator
+                      keys:
+                        0 _col11 (type: int)
+                        1 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
         Map 7 
@@ -650,11 +714,15 @@ STAGE PLANS:
                 TableScan
                   alias: dim6
                   Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
-                  Spark HashTable Sink Operator
-                    keys:
-                      0 _col18 (type: int)
-                      1 f7 (type: int)
-                      2 f11 (type: int)
+                  Select Operator
+                    expressions: f11 (type: int), f12 (type: int)
+                    outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
+                    Spark HashTable Sink Operator
+                      keys:
+                        0 _col9 (type: int)
+                        1 _col0 (type: int)
+                        2 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
         Map 8 
@@ -662,10 +730,14 @@ STAGE PLANS:
                 TableScan
                   alias: dim7
                   Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
-                  Spark HashTable Sink Operator
-                    keys:
-                      0 _col28 (type: int)
-                      1 f13 (type: int)
+                  Select Operator
+                    expressions: f13 (type: int), f14 (type: int)
+                    outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
+                    Spark HashTable Sink Operator
+                      keys:
+                        0 _col13 (type: int)
+                        1 _col0 (type: int)
             Local Work:
               Map Reduce Local Work
 
@@ -678,80 +750,84 @@ STAGE PLANS:
                 TableScan
                   alias: fact
                   Statistics: Num rows: 6 Data size: 98 Basic stats: COMPLETE Column stats:
NONE
-                  Map Join Operator
-                    condition map:
-                         Left Outer Join0 to 1
-                    keys:
-                      0 d1 (type: int)
-                      1 f1 (type: int)
-                    outputColumnNames: _col0, _col1, _col3, _col8
-                    input vertices:
-                      1 Map 2
-                    Statistics: Num rows: 6 Data size: 107 Basic stats: COMPLETE Column stats:
NONE
+                  Select Operator
+                    expressions: m1 (type: int), m2 (type: int), d1 (type: int), d2 (type:
int)
+                    outputColumnNames: _col0, _col1, _col2, _col3
+                    Statistics: Num rows: 6 Data size: 98 Basic stats: COMPLETE Column stats:
NONE
                     Map Join Operator
                       condition map:
                            Left Outer Join0 to 1
                       keys:
-                        0 _col8 (type: int)
-                        1 f3 (type: int)
-                      outputColumnNames: _col0, _col1, _col3, _col8, _col13
+                        0 _col2 (type: int)
+                        1 _col0 (type: int)
+                      outputColumnNames: _col0, _col1, _col3, _col5
                       input vertices:
-                        1 Map 3
-                      Statistics: Num rows: 6 Data size: 117 Basic stats: COMPLETE Column
stats: NONE
+                        1 Map 2
+                      Statistics: Num rows: 6 Data size: 107 Basic stats: COMPLETE Column
stats: NONE
                       Map Join Operator
                         condition map:
                              Left Outer Join0 to 1
                         keys:
-                          0 _col3 (type: int)
-                          1 f5 (type: int)
-                        outputColumnNames: _col0, _col1, _col8, _col13, _col18
+                          0 _col5 (type: int)
+                          1 _col0 (type: int)
+                        outputColumnNames: _col0, _col1, _col3, _col5, _col7
                         input vertices:
-                          1 Map 4
-                        Statistics: Num rows: 6 Data size: 128 Basic stats: COMPLETE Column
stats: NONE
+                          1 Map 3
+                        Statistics: Num rows: 6 Data size: 117 Basic stats: COMPLETE Column
stats: NONE
                         Map Join Operator
                           condition map:
                                Left Outer Join0 to 1
-                               Left Outer Join0 to 2
                           keys:
-                            0 _col18 (type: int)
-                            1 f7 (type: int)
-                            2 f11 (type: int)
-                          outputColumnNames: _col0, _col1, _col8, _col13, _col18, _col23,
_col28
+                            0 _col3 (type: int)
+                            1 _col0 (type: int)
+                          outputColumnNames: _col0, _col1, _col5, _col7, _col9
                           input vertices:
-                            1 Map 5
-                            2 Map 7
-                          Statistics: Num rows: 13 Data size: 281 Basic stats: COMPLETE Column
stats: NONE
+                            1 Map 4
+                          Statistics: Num rows: 6 Data size: 128 Basic stats: COMPLETE Column
stats: NONE
                           Map Join Operator
                             condition map:
                                  Left Outer Join0 to 1
+                                 Left Outer Join0 to 2
                             keys:
-                              0 _col23 (type: int)
-                              1 f9 (type: int)
-                            outputColumnNames: _col0, _col1, _col8, _col13, _col18, _col23,
_col28, _col33
+                              0 _col9 (type: int)
+                              1 _col0 (type: int)
+                              2 _col0 (type: int)
+                            outputColumnNames: _col0, _col1, _col5, _col7, _col9, _col11,
_col13
                             input vertices:
-                              1 Map 6
-                            Statistics: Num rows: 14 Data size: 309 Basic stats: COMPLETE
Column stats: NONE
+                              1 Map 5
+                              2 Map 7
+                            Statistics: Num rows: 13 Data size: 281 Basic stats: COMPLETE
Column stats: NONE
                             Map Join Operator
                               condition map:
                                    Left Outer Join0 to 1
                               keys:
-                                0 _col28 (type: int)
-                                1 f13 (type: int)
-                              outputColumnNames: _col0, _col1, _col8, _col13, _col18, _col23,
_col28, _col33, _col38
+                                0 _col11 (type: int)
+                                1 _col0 (type: int)
+                              outputColumnNames: _col0, _col1, _col5, _col7, _col9, _col11,
_col13, _col15
                               input vertices:
-                                1 Map 8
-                              Statistics: Num rows: 15 Data size: 339 Basic stats: COMPLETE
Column stats: NONE
-                              Select Operator
-                                expressions: _col0 (type: int), _col1 (type: int), _col8
(type: int), _col13 (type: int), _col18 (type: int), _col23 (type: int), _col33 (type: int),
_col28 (type: int), _col38 (type: int)
-                                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5,
_col6, _col7, _col8
+                                1 Map 6
+                              Statistics: Num rows: 14 Data size: 309 Basic stats: COMPLETE
Column stats: NONE
+                              Map Join Operator
+                                condition map:
+                                     Left Outer Join0 to 1
+                                keys:
+                                  0 _col13 (type: int)
+                                  1 _col0 (type: int)
+                                outputColumnNames: _col0, _col1, _col5, _col7, _col9, _col11,
_col13, _col15, _col17
+                                input vertices:
+                                  1 Map 8
                                 Statistics: Num rows: 15 Data size: 339 Basic stats: COMPLETE
Column stats: NONE
-                                File Output Operator
-                                  compressed: false
+                                Select Operator
+                                  expressions: _col0 (type: int), _col1 (type: int), _col5
(type: int), _col7 (type: int), _col9 (type: int), _col11 (type: int), _col15 (type: int),
_col13 (type: int), _col17 (type: int)
+                                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5,
_col6, _col7, _col8
                                   Statistics: Num rows: 15 Data size: 339 Basic stats: COMPLETE
Column stats: NONE
-                                  table:
-                                      input format: org.apache.hadoop.mapred.TextInputFormat
-                                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                                  File Output Operator
+                                    compressed: false
+                                    Statistics: Num rows: 15 Data size: 339 Basic stats:
COMPLETE Column stats: NONE
+                                    table:
+                                        input format: org.apache.hadoop.mapred.TextInputFormat
+                                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
             Local Work:
               Map Reduce Local Work
 


Mime
View raw message