hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1656553 - in /hive/trunk/ql/src/test: queries/clientpositive/orc_vectorization_ppd.q queries/clientpositive/vector_coalesce.q results/clientpositive/tez/vector_coalesce.q.out results/clientpositive/vector_coalesce.q.out
Date Mon, 02 Feb 2015 19:57:44 GMT
Author: hashutosh
Date: Mon Feb  2 19:57:44 2015
New Revision: 1656553

URL: http://svn.apache.org/r1656553
Log:
HIVE-9525 : Enable constant propagation optimization in few existing tests where it was disabled.
(Ashutosh Chauhan via Prasanth J)

Modified:
    hive/trunk/ql/src/test/queries/clientpositive/orc_vectorization_ppd.q
    hive/trunk/ql/src/test/queries/clientpositive/vector_coalesce.q
    hive/trunk/ql/src/test/results/clientpositive/tez/vector_coalesce.q.out
    hive/trunk/ql/src/test/results/clientpositive/vector_coalesce.q.out

Modified: hive/trunk/ql/src/test/queries/clientpositive/orc_vectorization_ppd.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/orc_vectorization_ppd.q?rev=1656553&r1=1656552&r2=1656553&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/orc_vectorization_ppd.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/orc_vectorization_ppd.q Mon Feb  2 19:57:44
2015
@@ -13,14 +13,12 @@ stored as ORC tblproperties("orc.row.ind
 
 -- insert creates separate orc files
 insert overwrite table vectororc select "apple", "a", rand(1), "zoo" from srcorc;
-set hive.optimize.constant.propagation=false;
 insert into table vectororc select null, "b", rand(2), "zoo" from srcorc;
 insert into table vectororc select null, "c", rand(3), "zoo" from srcorc;
 insert into table vectororc select "apple", "d", rand(4), "zoo" from srcorc;
 insert into table vectororc select null, "e", rand(5), "z" from srcorc;
 insert into table vectororc select "apple", "f", rand(6), "z" from srcorc;
 insert into table vectororc select null, "g", rand(7), "zoo" from srcorc;
-set hive.optimize.constant.propagation=true;
 
 -- since vectororc table has multiple orc file we will load them into a single file using
another table
 create table if not exists testorc

Modified: hive/trunk/ql/src/test/queries/clientpositive/vector_coalesce.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/vector_coalesce.q?rev=1656553&r1=1656552&r2=1656553&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/vector_coalesce.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/vector_coalesce.q Mon Feb  2 19:57:44 2015
@@ -7,8 +7,6 @@ SELECT cdouble, cstring1, cint, cfloat,
 FROM alltypesorc
 WHERE (cdouble IS NULL) LIMIT 10;
 
-SET hive.optimize.constant.propagation=false;
-   
 EXPLAIN SELECT ctinyint, cdouble, cint, coalesce(ctinyint+10, (cdouble+log2(cint)), 0) 
 FROM alltypesorc
 WHERE (ctinyint IS NULL) LIMIT 10;
@@ -17,8 +15,6 @@ SELECT ctinyint, cdouble, cint, coalesce
 FROM alltypesorc
 WHERE (ctinyint IS NULL) LIMIT 10;
 
-SET hive.optimize.constant.propagation=true;
-
 EXPLAIN SELECT cfloat, cbigint, coalesce(cfloat, cbigint, 0) 
 FROM alltypesorc
 WHERE (cfloat IS NULL AND cbigint IS NULL) LIMIT 10;

Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vector_coalesce.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_coalesce.q.out?rev=1656553&r1=1656552&r2=1656553&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_coalesce.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_coalesce.q.out Mon Feb  2 19:57:44
2015
@@ -68,7 +68,7 @@ STAGE PLANS:
           Filter Operator
             predicate: ctinyint is null (type: boolean)
             Select Operator
-              expressions: ctinyint (type: tinyint), cdouble (type: double), cint (type:
int), COALESCE((UDFToInteger(ctinyint) + 10),(cdouble + log2(cint)),0) (type: double)
+              expressions: null (type: void), cdouble (type: double), cint (type: int), COALESCE((UDFToInteger(null)
+ 10),(cdouble + log2(cint)),0) (type: double)
               outputColumnNames: _col0, _col1, _col2, _col3
               Limit
                 Number of rows: 10

Modified: hive/trunk/ql/src/test/results/clientpositive/vector_coalesce.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_coalesce.q.out?rev=1656553&r1=1656552&r2=1656553&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_coalesce.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_coalesce.q.out Mon Feb  2 19:57:44
2015
@@ -87,7 +87,7 @@ STAGE PLANS:
               predicate: ctinyint is null (type: boolean)
               Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats:
NONE
               Select Operator
-                expressions: ctinyint (type: tinyint), cdouble (type: double), cint (type:
int), COALESCE((UDFToInteger(ctinyint) + 10),(cdouble + log2(cint)),0) (type: double)
+                expressions: null (type: void), cdouble (type: double), cint (type: int),
COALESCE((UDFToInteger(null) + 10),(cdouble + log2(cint)),0) (type: double)
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column
stats: NONE
                 Limit



Mime
View raw message