hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jcama...@apache.org
Subject [30/51] [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 Fri, 20 Nov 2015 22:32:57 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/7dab21ac/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out b/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out
index 72a5d0d..a1addb7 100644
--- a/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out
+++ b/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out
@@ -38,76 +38,79 @@ union all
 select 2 as id from tb2 limit 1) b
 on a.id=b.id
 POSTHOOK: type: QUERY
-Plan not optimized by CBO due to missing statistics. Please check log for more details.
+Plan optimized by CBO.
 
 Vertex dependency in root stage
-Map 1 <- Union 2 (CONTAINS)
-Map 5 <- Union 2 (CONTAINS)
-Reducer 3 <- Union 2 (SIMPLE_EDGE)
-Reducer 4 <- Map 6 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE)
+Map 3 <- Union 4 (CONTAINS)
+Map 6 <- Union 4 (CONTAINS)
+Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 5 (SIMPLE_EDGE)
+Reducer 5 <- Union 4 (SIMPLE_EDGE)
 
 Stage-0
    Fetch Operator
       limit:-1
       Stage-1
-         Reducer 4 llap
-         File Output Operator [FS_16]
+         Reducer 2 llap
+         File Output Operator [FS_17]
             compressed:false
             Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL 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"}
-            Merge Join Operator [MERGEJOIN_20]
+            Merge Join Operator [MERGEJOIN_21]
             |  condition map:[{"":"Left Outer Join0 to 1"}]
-            |  keys:{"0":"id (type: int)","1":"_col0 (type: int)"}
+            |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
             |  outputColumnNames:["_col0"]
             |  Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-            |<-Map 6 [SIMPLE_EDGE] llap
-            |  Reduce Output Operator [RS_12]
-            |     key expressions:id (type: int)
-            |     Map-reduce partition columns:id (type: int)
+            |<-Map 1 [SIMPLE_EDGE] llap
+            |  Reduce Output Operator [RS_13]
+            |     key expressions:_col0 (type: int)
+            |     Map-reduce partition columns:_col0 (type: int)
             |     sort order:+
             |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
-            |     TableScan [TS_11]
-            |        alias:a
+            |     Select Operator [SEL_1]
+            |        outputColumnNames:["_col0"]
             |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
-            |<-Reducer 3 [SIMPLE_EDGE] llap
-               Reduce Output Operator [RS_13]
+            |        TableScan [TS_0]
+            |           alias:a
+            |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+            |<-Reducer 5 [SIMPLE_EDGE] llap
+               Reduce Output Operator [RS_14]
                   key expressions:_col0 (type: int)
                   Map-reduce partition columns:_col0 (type: int)
                   sort order:+
                   Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
COMPLETE
-                  Limit [LIM_10]
+                  Limit [LIM_11]
                      Number of rows:1
                      Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
COMPLETE
-                     Select Operator [SEL_9]
+                     Select Operator [SEL_10]
                      |  outputColumnNames:["_col0"]
                      |  Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
COMPLETE
-                     |<-Union 2 [SIMPLE_EDGE]
-                        |<-Map 1 [CONTAINS] llap
-                        |  Reduce Output Operator [RS_8]
+                     |<-Union 4 [SIMPLE_EDGE]
+                        |<-Map 3 [CONTAINS] llap
+                        |  Reduce Output Operator [RS_9]
                         |     sort order:
                         |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: COMPLETE
                         |     value expressions:_col0 (type: int)
-                        |     Limit [LIM_7]
+                        |     Limit [LIM_8]
                         |        Number of rows:1
                         |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: COMPLETE
-                        |        Select Operator [SEL_1]
+                        |        Select Operator [SEL_3]
                         |           outputColumnNames:["_col0"]
                         |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-                        |           TableScan [TS_0]
+                        |           TableScan [TS_2]
                         |              alias:tb2
                         |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-                        |<-Map 5 [CONTAINS] llap
-                           Reduce Output Operator [RS_8]
+                        |<-Map 6 [CONTAINS] llap
+                           Reduce Output Operator [RS_9]
                               sort order:
                               Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: COMPLETE
                               value expressions:_col0 (type: int)
-                              Limit [LIM_7]
+                              Limit [LIM_8]
                                  Number of rows:1
                                  Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: COMPLETE
-                                 Select Operator [SEL_3]
+                                 Select Operator [SEL_5]
                                     outputColumnNames:["_col0"]
                                     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: COMPLETE
-                                    TableScan [TS_2]
+                                    TableScan [TS_4]
                                        alias:tb2
                                        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: COMPLETE
 


Mime
View raw message