hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ser...@apache.org
Subject [3/4] hive git commit: HIVE-12727 : refactor Hive strict checks to be more granular, allow order by no limit and no partition filter by default for now (Sergey Shelukhin, reviewed by Xuefu Zhang)
Date Fri, 29 Jan 2016 20:17:33 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/27800976/ql/src/test/results/clientpositive/tez/empty_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/empty_join.q.out b/ql/src/test/results/clientpositive/tez/empty_join.q.out
index ca351ec..61f6be8 100644
--- a/ql/src/test/results/clientpositive/tez/empty_join.q.out
+++ b/ql/src/test/results/clientpositive/tez/empty_join.q.out
@@ -50,7 +50,7 @@ FROM test_1 t1
 LEFT JOIN test_2 t2 ON t1.id = t2.id
 INNER JOIN test_3 t3 ON t1.id = t3.id
 POSTHOOK: type: QUERY
-Plan not optimized by CBO.
+Plan optimized by CBO.
 
 Vertex dependency in root stage
 Map 1 <- Map 2 (BROADCAST_EDGE), Map 3 (BROADCAST_EDGE)
@@ -60,39 +60,54 @@ Stage-0
       limit:-1
       Stage-1
          Map 1
-         File Output Operator [FS_8]
+         File Output Operator [FS_14]
             compressed:false
             Statistics:Num rows: 2 Data size: 2 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"}
-            Select Operator [SEL_7]
-               outputColumnNames:["_col0","_col1","_col2"]
-               Statistics:Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats: NONE
-               Map Join Operator [MAPJOIN_16]
-               |  condition map:[{"":"Left Outer Join0 to 1"},{"":"Inner Join 0 to 2"}]
-               |  keys:{"Map 1":"id (type: int)","Map 2":"id (type: int)","Map 3":"id (type:
int)"}
-               |  outputColumnNames:["_col0","_col4","_col8"]
-               |  Statistics:Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats:
NONE
-               |<-Map 2 [BROADCAST_EDGE]
-               |  Reduce Output Operator [RS_4]
-               |     key expressions:id (type: int)
-               |     Map-reduce partition columns:id (type: int)
-               |     sort order:+
-               |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
-               |     TableScan [TS_1]
-               |        alias:t2
-               |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
-               |<-Map 3 [BROADCAST_EDGE]
-               |  Reduce Output Operator [RS_5]
-               |     key expressions:id (type: int)
-               |     Map-reduce partition columns:id (type: int)
-               |     sort order:+
-               |     Statistics:Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats:
NONE
-               |     TableScan [TS_2]
-               |        alias:t3
-               |        Statistics:Num rows: 1 Data size: 1 Basic stats: COMPLETE Column
stats: NONE
-               |<-TableScan [TS_0]
-                     alias:t1
+            Map Join Operator [MAPJOIN_22]
+            |  condition map:[{"":"Left Outer Join0 to 1"},{"":"Inner Join 0 to 2"}]
+            |  keys:{"Map 1":"_col0 (type: int)","Map 2":"_col0 (type: int)","Map 3":"_col0
(type: int)"}
+            |  outputColumnNames:["_col0","_col1","_col2"]
+            |  Statistics:Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats: NONE
+            |<-Map 2 [BROADCAST_EDGE]
+            |  Reduce Output Operator [RS_10]
+            |     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
+            |     Select Operator [SEL_5]
+            |        outputColumnNames:["_col0"]
+            |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+            |        Filter Operator [FIL_20]
+            |           predicate:id is not null (type: boolean)
+            |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+            |           TableScan [TS_3]
+            |              alias:t2
+            |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
+            |<-Map 3 [BROADCAST_EDGE]
+            |  Reduce Output Operator [RS_11]
+            |     key expressions:_col0 (type: int)
+            |     Map-reduce partition columns:_col0 (type: int)
+            |     sort order:+
+            |     Statistics:Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats:
NONE
+            |     Select Operator [SEL_8]
+            |        outputColumnNames:["_col0"]
+            |        Statistics:Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats:
NONE
+            |        Filter Operator [FIL_21]
+            |           predicate:id is not null (type: boolean)
+            |           Statistics:Num rows: 1 Data size: 1 Basic stats: COMPLETE Column
stats: NONE
+            |           TableScan [TS_6]
+            |              alias:t3
+            |              Statistics:Num rows: 1 Data size: 1 Basic stats: COMPLETE Column
stats: NONE
+            |<-Select Operator [SEL_2]
+                  outputColumnNames:["_col0"]
+                  Statistics:Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats:
NONE
+                  Filter Operator [FIL_19]
+                     predicate:id is not null (type: boolean)
                      Statistics:Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats:
NONE
+                     TableScan [TS_0]
+                        alias:t1
+                        Statistics:Num rows: 1 Data size: 1 Basic stats: COMPLETE Column
stats: NONE
 
 PREHOOK: query: SELECT t1.id, t2.id, t3.id
 FROM test_1 t1

http://git-wip-us.apache.org/repos/asf/hive/blob/27800976/ql/src/test/results/clientpositive/tez/vector_when_case_null.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/vector_when_case_null.q.out b/ql/src/test/results/clientpositive/tez/vector_when_case_null.q.out
index b32dd30..eb5806a 100644
--- a/ql/src/test/results/clientpositive/tez/vector_when_case_null.q.out
+++ b/ql/src/test/results/clientpositive/tez/vector_when_case_null.q.out
@@ -44,12 +44,12 @@ STAGE PLANS:
                   alias: count_case_groupby
                   Statistics: Num rows: 5 Data size: 452 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
-                    expressions: key (type: string), bool (type: boolean)
-                    outputColumnNames: key, bool
+                    expressions: key (type: string), CASE WHEN (bool) THEN (1) WHEN ((not
bool)) THEN (0) ELSE (null) END (type: int)
+                    outputColumnNames: _col0, _col1
                     Statistics: Num rows: 5 Data size: 452 Basic stats: COMPLETE Column stats:
NONE
                     Group By Operator
-                      aggregations: count(CASE WHEN (bool) THEN (1) WHEN ((not bool)) THEN
(0) ELSE (null) END)
-                      keys: key (type: string)
+                      aggregations: count(_col1)
+                      keys: _col0 (type: string)
                       mode: hash
                       outputColumnNames: _col0, _col1
                       Statistics: Num rows: 5 Data size: 452 Basic stats: COMPLETE Column
stats: NONE

http://git-wip-us.apache.org/repos/asf/hive/blob/27800976/ql/src/test/results/clientpositive/udf_concat_insert2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_concat_insert2.q.out b/ql/src/test/results/clientpositive/udf_concat_insert2.q.out
index f1b70fe..d68bd76 100644
--- a/ql/src/test/results/clientpositive/udf_concat_insert2.q.out
+++ b/ql/src/test/results/clientpositive/udf_concat_insert2.q.out
@@ -16,7 +16,7 @@ INSERT OVERWRITE TABLE dest1 SELECT concat('1234', 'abc', 'extra argument'),
src
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1.key EXPRESSION []
+POSTHOOK: Lineage: dest1.key SIMPLE []
 POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default),
]
 PREHOOK: query: SELECT dest1.* FROM dest1
 PREHOOK: type: QUERY

http://git-wip-us.apache.org/repos/asf/hive/blob/27800976/ql/src/test/results/clientpositive/union_date_trim.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_date_trim.q.out b/ql/src/test/results/clientpositive/union_date_trim.q.out
index e2f5269..324e8b7 100644
--- a/ql/src/test/results/clientpositive/union_date_trim.q.out
+++ b/ql/src/test/results/clientpositive/union_date_trim.q.out
@@ -51,4 +51,4 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@testdate
 POSTHOOK: Output: default@testdate
 POSTHOOK: Lineage: testdate.dt EXPRESSION [(testdate)testdate.FieldSchema(name:dt, type:date,
comment:null), ]
-POSTHOOK: Lineage: testdate.id EXPRESSION [(testdate)testdate.FieldSchema(name:id, type:int,
comment:null), ]
+POSTHOOK: Lineage: testdate.id EXPRESSION []

http://git-wip-us.apache.org/repos/asf/hive/blob/27800976/ql/src/test/results/clientpositive/union_remove_26.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_remove_26.q.out b/ql/src/test/results/clientpositive/union_remove_26.q.out
index 8afaf08..3e2cc18 100644
--- a/ql/src/test/results/clientpositive/union_remove_26.q.out
+++ b/ql/src/test/results/clientpositive/union_remove_26.q.out
@@ -151,10 +151,10 @@ STAGE PLANS:
             Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: val (type: int)
-              outputColumnNames: val
+              outputColumnNames: _col1
               Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
-                aggregations: count(1), min(val), max(val)
+                aggregations: count(1), min(_col1), max(_col1)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
@@ -184,10 +184,10 @@ STAGE PLANS:
             Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: val (type: int)
-              outputColumnNames: val
+              outputColumnNames: _col1
               Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
-                aggregations: count(1), min(val), max(val)
+                aggregations: count(1), min(_col1), max(_col1)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
@@ -217,10 +217,10 @@ STAGE PLANS:
             Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: val (type: int)
-              outputColumnNames: val
+              outputColumnNames: _col1
               Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
-                aggregations: count(1), min(val), max(val)
+                aggregations: count(1), min(_col1), max(_col1)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
@@ -359,11 +359,11 @@ STAGE PLANS:
             Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: key (type: string), val (type: int)
-              outputColumnNames: key, val
+              outputColumnNames: _col0, _col2
               Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
-                aggregations: count(1), min(val), max(val)
-                keys: key (type: string)
+                aggregations: count(1), min(_col2), max(_col2)
+                keys: _col0 (type: string)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats:
NONE
@@ -396,11 +396,11 @@ STAGE PLANS:
             Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: key (type: string), val (type: int)
-              outputColumnNames: key, val
+              outputColumnNames: _col0, _col2
               Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
-                aggregations: count(1), min(val), max(val)
-                keys: key (type: string)
+                aggregations: count(1), min(_col2), max(_col2)
+                keys: _col0 (type: string)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats:
NONE
@@ -433,11 +433,11 @@ STAGE PLANS:
             Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: key (type: string), val (type: int)
-              outputColumnNames: key, val
+              outputColumnNames: _col0, _col2
               Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
-                aggregations: count(1), min(val), max(val)
-                keys: key (type: string)
+                aggregations: count(1), min(_col2), max(_col2)
+                keys: _col0 (type: string)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
@@ -520,10 +520,10 @@ STAGE PLANS:
             Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: val (type: int)
-              outputColumnNames: val
+              outputColumnNames: _col1
               Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
-                aggregations: count(1), min(val), max(val)
+                aggregations: count(1), min(_col1), max(_col1)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
@@ -553,10 +553,10 @@ STAGE PLANS:
             Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: val (type: int)
-              outputColumnNames: val
+              outputColumnNames: _col1
               Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
-                aggregations: count(1), min(val), max(val)
+                aggregations: count(1), min(_col1), max(_col1)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
@@ -586,10 +586,10 @@ STAGE PLANS:
             Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: val (type: int)
-              outputColumnNames: val
+              outputColumnNames: _col1
               Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
-                aggregations: count(1), min(val), max(val)
+                aggregations: count(1), min(_col1), max(_col1)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
@@ -670,10 +670,10 @@ STAGE PLANS:
             Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: val (type: int)
-              outputColumnNames: val
+              outputColumnNames: _col1
               Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
-                aggregations: count(1), min(val), max(val)
+                aggregations: count(1), min(_col1), max(_col1)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
@@ -736,10 +736,10 @@ STAGE PLANS:
             Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: val (type: int)
-              outputColumnNames: val
+              outputColumnNames: _col1
               Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
-                aggregations: count(1), min(val), max(val)
+                aggregations: count(1), min(_col1), max(_col1)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
@@ -768,10 +768,10 @@ STAGE PLANS:
             Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: val (type: int)
-              outputColumnNames: val
+              outputColumnNames: _col1
               Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
-                aggregations: count(1), min(val), max(val)
+                aggregations: count(1), min(_col1), max(_col1)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats:
NONE

http://git-wip-us.apache.org/repos/asf/hive/blob/27800976/ql/src/test/results/clientpositive/vector_when_case_null.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_when_case_null.q.out b/ql/src/test/results/clientpositive/vector_when_case_null.q.out
index 679fddc..b21bc90 100644
--- a/ql/src/test/results/clientpositive/vector_when_case_null.q.out
+++ b/ql/src/test/results/clientpositive/vector_when_case_null.q.out
@@ -38,12 +38,12 @@ STAGE PLANS:
             alias: count_case_groupby
             Statistics: Num rows: 5 Data size: 452 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: key (type: string), bool (type: boolean)
-              outputColumnNames: key, bool
+              expressions: key (type: string), CASE WHEN (bool) THEN (1) WHEN ((not bool))
THEN (0) ELSE (null) END (type: int)
+              outputColumnNames: _col0, _col1
               Statistics: Num rows: 5 Data size: 452 Basic stats: COMPLETE Column stats:
NONE
               Group By Operator
-                aggregations: count(CASE WHEN (bool) THEN (1) WHEN ((not bool)) THEN (0)
ELSE (null) END)
-                keys: key (type: string)
+                aggregations: count(_col1)
+                keys: _col0 (type: string)
                 mode: hash
                 outputColumnNames: _col0, _col1
                 Statistics: Num rows: 5 Data size: 452 Basic stats: COMPLETE Column stats:
NONE


Mime
View raw message