You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/12/09 15:24:07 UTC
svn commit: r1549580 [11/11] - in /hive/trunk:
contrib/src/test/results/clientnegative/
contrib/src/test/results/clientpositive/
hbase-handler/src/test/results/positive/
ql/src/java/org/apache/hadoop/hive/ql/ ql/src/test/results/clientnegative/
ql/src/...
Modified: hive/trunk/ql/src/test/results/clientpositive/union31.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union31.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union31.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union31.q.out Mon Dec 9 14:23:53 2013
@@ -278,7 +278,6 @@ STAGE PLANS:
Stage: Stage-5
Stats-Aggr Operator
-
PREHOOK: query: from
(select * from t1
union all
@@ -644,7 +643,6 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
PREHOOK: query: from
(
select key as c1, count(1) as cnt from t1 group by key
@@ -1044,7 +1042,6 @@ STAGE PLANS:
Stage: Stage-5
Stats-Aggr Operator
-
PREHOOK: query: from
(
select key as c1, count(1) as cnt from t1 group by key
Modified: hive/trunk/ql/src/test/results/clientpositive/union32.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union32.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union32.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union32.q.out Mon Dec 9 14:23:53 2013
@@ -105,7 +105,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM
(SELECT CAST(key AS DOUBLE) AS key FROM t1
UNION ALL
@@ -278,7 +277,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM
(SELECT CAST(a.key AS BIGINT) AS key FROM t1 a JOIN t2 b ON a.key = b.key
UNION ALL
@@ -463,7 +461,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM
(SELECT CAST(key AS DOUBLE) AS key FROM t2
UNION ALL
@@ -663,7 +660,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM
(SELECT CAST(a.key AS BIGINT) AS key, CAST(b.key AS DOUBLE) AS value FROM t1 a JOIN t2 b ON a.key = b.key
UNION ALL
@@ -863,7 +859,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM
(SELECT CAST(key AS DOUBLE) AS key, CAST(key AS STRING) AS value FROM t2
UNION ALL
Modified: hive/trunk/ql/src/test/results/clientpositive/union33.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union33.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union33.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union33.q.out Mon Dec 9 14:23:53 2013
@@ -243,7 +243,6 @@ STAGE PLANS:
hdfs directory: true
#### A masked pattern was here ####
-
PREHOOK: query: INSERT OVERWRITE TABLE test_src
SELECT key, value FROM (
SELECT key, value FROM src
@@ -515,7 +514,6 @@ STAGE PLANS:
hdfs directory: true
#### A masked pattern was here ####
-
PREHOOK: query: INSERT OVERWRITE TABLE test_src
SELECT key, value FROM (
SELECT key, COUNT(*) AS value FROM src
Modified: hive/trunk/ql/src/test/results/clientpositive/union34.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union34.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union34.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union34.q.out Mon Dec 9 14:23:53 2013
@@ -249,7 +249,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM (
SELECT sub1.key,sub1.value FROM (SELECT * FROM src10_1) sub1 JOIN (SELECT * FROM src10_2) sub0 ON (sub0.key = sub1.key)
UNION ALL
@@ -529,7 +528,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM (
SELECT sub1.key,sub1.value FROM (SELECT * FROM src10_1) sub1 JOIN (SELECT * FROM src10_2) sub0 ON (sub0.key = sub1.key)
UNION ALL
Modified: hive/trunk/ql/src/test/results/clientpositive/union4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union4.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union4.q.out Mon Dec 9 14:23:53 2013
@@ -215,7 +215,6 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
PREHOOK: query: insert overwrite table tmptable
select unionsrc.key, unionsrc.value FROM (select 'tst1' as key, count(1) as value from src s1
UNION ALL
Modified: hive/trunk/ql/src/test/results/clientpositive/union5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union5.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union5.q.out Mon Dec 9 14:23:53 2013
@@ -194,7 +194,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select unionsrc.key, count(1) FROM (select 'tst1' as key, count(1) as value from src s1
UNION ALL
select 'tst2' as key, count(1) as value from src s2) unionsrc group by unionsrc.key
Modified: hive/trunk/ql/src/test/results/clientpositive/union6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union6.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union6.q.out Mon Dec 9 14:23:53 2013
@@ -181,7 +181,6 @@ STAGE PLANS:
hdfs directory: true
#### A masked pattern was here ####
-
PREHOOK: query: insert overwrite table tmptable
select unionsrc.key, unionsrc.value FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
UNION ALL
Modified: hive/trunk/ql/src/test/results/clientpositive/union7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union7.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union7.q.out Mon Dec 9 14:23:53 2013
@@ -160,7 +160,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select unionsrc.key, count(1) FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
UNION ALL
select s2.key as key, s2.value as value from src1 s2) unionsrc group by unionsrc.key
Modified: hive/trunk/ql/src/test/results/clientpositive/union8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union8.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union8.q.out Mon Dec 9 14:23:53 2013
@@ -103,7 +103,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select unionsrc.key, unionsrc.value FROM (select s1.key as key, s1.value as value from src s1 UNION ALL
select s2.key as key, s2.value as value from src s2 UNION ALL
select s3.key as key, s3.value as value from src s3) unionsrc
Modified: hive/trunk/ql/src/test/results/clientpositive/union9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union9.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union9.q.out Mon Dec 9 14:23:53 2013
@@ -119,7 +119,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION ALL
select s2.key as key, s2.value as value from src s2 UNION ALL
select s3.key as key, s3.value as value from src s3) unionsrc
Modified: hive/trunk/ql/src/test/results/clientpositive/union_lateralview.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union_lateralview.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union_lateralview.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union_lateralview.q.out Mon Dec 9 14:23:53 2013
@@ -264,7 +264,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: INSERT OVERWRITE TABLE test_union_lateral_view
SELECT b.key, d.arr_ele, d.value
FROM (
Modified: hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union_ppr.q.out Mon Dec 9 14:23:53 2013
@@ -279,7 +279,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM (
SELECT X.* FROM SRCPART X WHERE X.key < 100
UNION ALL
Modified: hive/trunk/ql/src/test/results/clientpositive/union_remove_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union_remove_6.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union_remove_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union_remove_6.q.out Mon Dec 9 14:23:53 2013
@@ -266,7 +266,6 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
PREHOOK: query: FROM (
SELECT key, count(1) as values from inputTbl1 group by key
UNION ALL
Modified: hive/trunk/ql/src/test/results/clientpositive/union_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union_view.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union_view.q.out Mon Dec 9 14:23:53 2013
@@ -106,7 +106,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_union_2))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value)) (TOK_SELEXPR (TOK_TABLE_OR_COL ds))) (TOK_WHERE (and (= (TOK_TABLE_OR_COL key) 86) (= (TOK_TABLE_OR_COL ds) '2')))))
@@ -185,7 +184,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_union_3))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value)) (TOK_SELEXPR (TOK_TABLE_OR_COL ds))) (TOK_WHERE (and (= (TOK_TABLE_OR_COL key) 86) (= (TOK_TABLE_OR_COL ds) '3')))))
@@ -264,7 +262,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
86 val_86 1
86 val_86 2
86 val_86 2
@@ -356,7 +353,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_union_2))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '2'))))
@@ -443,7 +439,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_union_3))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '3'))))
@@ -530,7 +525,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
500
1000
1000
@@ -694,7 +688,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_union_view))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value)) (TOK_SELEXPR (TOK_TABLE_OR_COL ds))) (TOK_WHERE (AND (= (TOK_TABLE_OR_COL key) 86) (= (TOK_TABLE_OR_COL ds) '2')))))
@@ -855,7 +848,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_union_view))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value)) (TOK_SELEXPR (TOK_TABLE_OR_COL ds))) (TOK_WHERE (AND (= (TOK_TABLE_OR_COL key) 86) (= (TOK_TABLE_OR_COL ds) '3')))))
@@ -1016,7 +1008,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_union_view))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value)) (TOK_SELEXPR (TOK_TABLE_OR_COL ds))) (TOK_WHERE (AND (= (TOK_TABLE_OR_COL key) 86) (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL ds)))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL ds)))))
@@ -1276,7 +1267,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
86 val_86 1
86 val_86 2
86 val_86 2
@@ -1449,7 +1439,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_union_view))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '2'))))
@@ -1612,7 +1601,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_union_view))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '3'))))
@@ -1775,7 +1763,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
500
1000
1000
@@ -1939,7 +1926,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
86 val_86 4
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_union_view))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '4'))))
@@ -2103,5 +2089,4 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
500
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_left_outer_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_left_outer_join.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_left_outer_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_left_outer_join.q.out Mon Dec 9 14:23:53 2013
@@ -132,7 +132,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(*) from (select c.ctinyint
from alltypesorc c
left outer join alltypesorc cd
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorization_div0.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_div0.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_div0.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_div0.q.out Mon Dec 9 14:23:53 2013
@@ -41,7 +41,6 @@ STAGE PLANS:
Fetch Operator
limit: 100
-
PREHOOK: query: select cdouble / 0.0 from alltypesorc limit 100
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
@@ -224,7 +223,6 @@ STAGE PLANS:
Fetch Operator
limit: 100
-
PREHOOK: query: select (cbigint - 988888L) as s1, cdouble / (cbigint - 988888L) as s2, 1.2 / (cbigint - 988888L)
from alltypesorc where cbigint > 0 and cbigint < 100000000 order by s1, s2 limit 100
PREHOOK: type: QUERY
@@ -419,7 +417,6 @@ STAGE PLANS:
Fetch Operator
limit: 100
-
PREHOOK: query: select (cdouble + 200.0) as s1, cbigint / (cdouble + 200.0) as s2, (cdouble + 200.0) / (cdouble + 200.0), cbigint / (cdouble + 200.0), 1 / (cdouble + 200.0), 1.2 / (cdouble + 200.0)
from alltypesorc where cdouble >= -500 and cdouble < -199 order by s1, s2 limit 100
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorization_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_limit.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_limit.q.out Mon Dec 9 14:23:53 2013
@@ -45,7 +45,6 @@ STAGE PLANS:
Fetch Operator
limit: 7
-
WARNING: Comparing a bigint and a double may result in a loss of precision.
PREHOOK: query: SELECT cbigint, cdouble FROM alltypesorc WHERE cbigint < cdouble and cint > 0 limit 7
PREHOOK: type: QUERY
@@ -134,7 +133,6 @@ STAGE PLANS:
Fetch Operator
limit: 20
-
PREHOOK: query: select ctinyint,cdouble,csmallint from alltypesorc where ctinyint is not null order by ctinyint,cdouble limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
@@ -247,7 +245,6 @@ STAGE PLANS:
Fetch Operator
limit: 20
-
PREHOOK: query: select ctinyint,avg(cdouble + 1) from alltypesorc group by ctinyint order by ctinyint limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
@@ -349,7 +346,6 @@ STAGE PLANS:
Fetch Operator
limit: 20
-
PREHOOK: query: select distinct(ctinyint) from alltypesorc limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
@@ -464,7 +460,6 @@ STAGE PLANS:
Fetch Operator
limit: 20
-
PREHOOK: query: select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
@@ -550,7 +545,6 @@ STAGE PLANS:
Fetch Operator
limit: 0
-
PREHOOK: query: select ctinyint,cdouble from alltypesorc order by ctinyint limit 0
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
@@ -677,7 +671,6 @@ STAGE PLANS:
Fetch Operator
limit: 20
-
PREHOOK: query: select cdouble, sum(ctinyint) as sum from alltypesorc where ctinyint is not null group by cdouble order by sum, cdouble limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorization_part_project.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_part_project.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_part_project.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_part_project.q.out Mon Dec 9 14:23:53 2013
@@ -118,7 +118,6 @@ STAGE PLANS:
Fetch Operator
limit: 10
-
PREHOOK: query: select (cdouble+2) from alltypesorc_part limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc_part
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorization_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_pushdown.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_pushdown.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_pushdown.q.out Mon Dec 9 14:23:53 2013
@@ -68,7 +68,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
WARNING: Comparing a bigint and a double may result in a loss of precision.
PREHOOK: query: SELECT AVG(cbigint) FROM alltypesorc WHERE cbigint < cdouble
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorization_short_regress.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_short_regress.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_short_regress.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_short_regress.q.out Mon Dec 9 14:23:53 2013
@@ -281,7 +281,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
WARNING: Comparing a bigint and a double may result in a loss of precision.
PREHOOK: query: SELECT AVG(cint),
(AVG(cint) + -3728),
@@ -582,7 +581,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT MAX(cint),
(MAX(cint) / -3728),
(MAX(cint) * -3728),
@@ -868,7 +866,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT VAR_POP(cbigint),
(-(VAR_POP(cbigint))),
(VAR_POP(cbigint) - (-(VAR_POP(cbigint)))),
@@ -1107,7 +1104,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
WARNING: Comparing a bigint and a double may result in a loss of precision.
PREHOOK: query: SELECT AVG(ctinyint),
(AVG(ctinyint) + 6981),
@@ -1315,7 +1311,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT cint,
cdouble,
ctimestamp2,
@@ -2778,7 +2773,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT cint,
cbigint,
cstring1,
@@ -3085,7 +3079,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
WARNING: Comparing a bigint and a double may result in a loss of precision.
PREHOOK: query: SELECT cint,
cstring1,
@@ -3915,7 +3908,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
WARNING: Comparing a bigint and a double may result in a loss of precision.
PREHOOK: query: SELECT ctimestamp1,
cstring2,
@@ -4845,7 +4837,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT csmallint,
(csmallint % -75),
STDDEV_SAMP(csmallint),
@@ -6586,7 +6577,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
WARNING: Comparing a bigint and a double may result in a loss of precision.
WARNING: Comparing a bigint and a double may result in a loss of precision.
PREHOOK: query: SELECT cdouble,
@@ -6981,7 +6971,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT ctimestamp1,
cstring1,
STDDEV_POP(cint),
@@ -7668,7 +7657,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
WARNING: Comparing a bigint and a double may result in a loss of precision.
PREHOOK: query: SELECT cboolean1,
MAX(cfloat),
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_casts.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_casts.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_casts.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_casts.q.out Mon Dec 9 14:23:53 2013
@@ -302,7 +302,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select
-- to boolean
cast (ctinyint as boolean)
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_context.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_context.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_context.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_context.q.out Mon Dec 9 14:23:53 2013
@@ -208,7 +208,6 @@ STAGE PLANS:
Fetch Operator
limit: 100
-
PREHOOK: query: select store.s_city, ss_net_profit
from store_sales
JOIN store ON store_sales.ss_store_sk = store.s_store_sk
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_mapjoin.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_mapjoin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_mapjoin.q.out Mon Dec 9 14:23:53 2013
@@ -119,7 +119,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT COUNT(t1.cint), MAX(t2.cint), MIN(t1.cint), AVG(t1.cint+t2.cint)
FROM alltypesorc t1
JOIN alltypesorc t2 ON t1.cint = t2.cint
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_math_funcs.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_math_funcs.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_math_funcs.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_math_funcs.q.out Mon Dec 9 14:23:53 2013
@@ -218,7 +218,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select
cdouble
,Round(cdouble, 2)
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out Mon Dec 9 14:23:53 2013
@@ -133,7 +133,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT COUNT(t1.cint), MAX(t2.cint), MIN(t1.cint), AVG(t1.cint+t2.cint)
FROM alltypesorc t1
JOIN alltypesorc t2 ON t1.cint = t2.cint
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_string_funcs.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_string_funcs.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_string_funcs.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_string_funcs.q.out Mon Dec 9 14:23:53 2013
@@ -108,7 +108,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select
substr(cstring1, 1, 2)
,substr(cstring1, 2)
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out Mon Dec 9 14:23:53 2013
@@ -148,7 +148,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT
to_unix_timestamp(ctimestamp1),
year(ctimestamp1),
@@ -300,7 +299,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT
to_unix_timestamp(stimestamp1),
year(stimestamp1),
@@ -452,7 +450,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- Should all be true or NULL
SELECT
to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1),
@@ -608,7 +605,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT
to_unix_timestamp(stimestamp1),
year(stimestamp1),