hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject [1/2] hive git commit: HIVE-17148 : Incorrect result for Hive join query with COALESCE in WHERE condition (Vlad Gudikov via Ashutosh Chauhan)
Date Fri, 11 Aug 2017 23:48:34 GMT
Repository: hive
Updated Branches:
  refs/heads/master 51067945c -> 3a3ffaa90


http://git-wip-us.apache.org/repos/asf/hive/blob/3a3ffaa9/ql/src/test/results/clientpositive/spark/smb_mapjoin_15.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/smb_mapjoin_15.q.out b/ql/src/test/results/clientpositive/spark/smb_mapjoin_15.q.out
index 1916075..9ce04d8 100644
--- a/ql/src/test/results/clientpositive/spark/smb_mapjoin_15.q.out
+++ b/ql/src/test/results/clientpositive/spark/smb_mapjoin_15.q.out
@@ -618,7 +618,7 @@ STAGE PLANS:
                   GatherStats: false
                   Filter Operator
                     isSamplingPred: false
-                    predicate: (key is not null and key2 is not null) (type: boolean)
+                    predicate: (key2 is not null and key is not null) (type: boolean)
                     Statistics: Num rows: 500 Data size: 7218 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
@@ -696,7 +696,7 @@ STAGE PLANS:
                   GatherStats: false
                   Filter Operator
                     isSamplingPred: false
-                    predicate: (key is not null and key2 is not null) (type: boolean)
+                    predicate: (key2 is not null and key is not null) (type: boolean)
                     Statistics: Num rows: 500 Data size: 7218 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/3a3ffaa9/ql/src/test/results/clientpositive/spark/subquery_in.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/subquery_in.q.out b/ql/src/test/results/clientpositive/spark/subquery_in.q.out
index 8bc1783..8912450 100644
--- a/ql/src/test/results/clientpositive/spark/subquery_in.q.out
+++ b/ql/src/test/results/clientpositive/spark/subquery_in.q.out
@@ -1697,7 +1697,7 @@ STAGE PLANS:
                   alias: part
                   Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
-                    predicate: p_retailprice is not null (type: boolean)
+                    predicate: floor(p_retailprice) is not null (type: boolean)
                     Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: p_partkey (type: int), p_name (type: string), p_mfgr (type:
string), p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type:
string), p_retailprice (type: double), p_comment (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/3a3ffaa9/ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out b/ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out
index 84b9250..f914d28 100644
--- a/ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out
+++ b/ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out
@@ -202,7 +202,7 @@ STAGE PLANS:
             alias: vectortab_b_1korc
             Statistics: Num rows: 1000 Data size: 458448 Basic stats: COMPLETE Column stats:
NONE
             Filter Operator
-              predicate: (s is not null and dt is not null and ts is not null) (type: boolean)
+              predicate: (dt is not null and ts is not null and s is not null) (type: boolean)
               Statistics: Num rows: 1000 Data size: 458448 Basic stats: COMPLETE Column stats:
NONE
               Select Operator
                 expressions: s (type: string), (dt - CAST( ts AS DATE)) (type: interval_day_time)
@@ -226,8 +226,8 @@ STAGE PLANS:
               Filter Vectorization:
                   className: VectorFilterOperator
                   native: true
-                  predicateExpression: FilterExprAndExpr(children: SelectColumnIsNotNull(col
8) -> boolean, SelectColumnIsNotNull(col 12) -> boolean, SelectColumnIsNotNull(col 10)
-> boolean) -> boolean
-              predicate: (s is not null and dt is not null and ts is not null) (type: boolean)
+                  predicateExpression: FilterExprAndExpr(children: SelectColumnIsNotNull(col
12) -> boolean, SelectColumnIsNotNull(col 10) -> boolean, SelectColumnIsNotNull(col
8) -> boolean) -> boolean
+              predicate: (dt is not null and ts is not null and s is not null) (type: boolean)
               Statistics: Num rows: 1000 Data size: 460264 Basic stats: COMPLETE Column stats:
NONE
               Select Operator
                 expressions: s (type: string), (dt - CAST( ts AS DATE)) (type: interval_day_time)


Mime
View raw message