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
