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 [4/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/t...
Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer9.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer9.q.out Mon Dec 9 14:23:53 2013
@@ -273,7 +273,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT xx.key, yy.key, xx.cnt, yy.cnt
FROM
(SELECT x.c1 AS key, count(1) AS cnt FROM tmp x WHERE x.c1 < 120 GROUP BY x.c1) xx
@@ -534,7 +533,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT xx.key, yy.key, xx.cnt, yy.cnt
FROM
(SELECT x.c1 AS key, count(1) AS cnt FROM tmp x WHERE x.c1 < 120 GROUP BY x.c1) xx
@@ -870,7 +868,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT xx.key1, xx.key2, yy.key1, yy.key2, xx.cnt, yy.cnt
FROM
(SELECT x.c1 AS key1, x.c3 AS key2, count(1) AS cnt FROM tmp x WHERE x.c1 < 120 GROUP BY x.c1, x.c3) xx
@@ -1169,7 +1166,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT xx.key1, xx.key2, yy.key1, yy.key2, xx.cnt, yy.cnt
FROM
(SELECT x.c1 AS key1, x.c3 AS key2, count(1) AS cnt FROM tmp x WHERE x.c1 < 120 GROUP BY x.c1, x.c3) xx
Modified: hive/trunk/ql/src/test/results/clientpositive/count.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/count.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/count.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/count.q.out Mon Dec 9 14:23:53 2013
@@ -123,7 +123,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
PREHOOK: type: QUERY
PREHOOK: Input: default@abcd
@@ -339,7 +338,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
PREHOOK: type: QUERY
PREHOOK: Input: default@abcd
@@ -429,7 +427,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
PREHOOK: type: QUERY
PREHOOK: Input: default@abcd
@@ -570,7 +567,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
PREHOOK: type: QUERY
PREHOOK: Input: default@abcd
Modified: hive/trunk/ql/src/test/results/clientpositive/create_genericudaf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_genericudaf.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_genericudaf.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_genericudaf.q.out Mon Dec 9 14:23:53 2013
@@ -13,7 +13,6 @@ STAGE DEPENDENCIES:
STAGE PLANS:
Stage: Stage-0
-
PREHOOK: query: CREATE TEMPORARY FUNCTION test_avg AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDAFAverage'
PREHOOK: type: CREATEFUNCTION
POSTHOOK: query: CREATE TEMPORARY FUNCTION test_avg AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDAFAverage'
@@ -91,7 +90,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT
test_avg(1),
test_avg(substr(value,5))
Modified: hive/trunk/ql/src/test/results/clientpositive/create_genericudf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_genericudf.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_genericudf.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_genericudf.q.out Mon Dec 9 14:23:53 2013
@@ -13,7 +13,6 @@ STAGE DEPENDENCIES:
STAGE PLANS:
Stage: Stage-0
-
PREHOOK: query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
PREHOOK: type: CREATEFUNCTION
POSTHOOK: query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
Modified: hive/trunk/ql/src/test/results/clientpositive/create_udaf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_udaf.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_udaf.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_udaf.q.out Mon Dec 9 14:23:53 2013
@@ -13,7 +13,6 @@ STAGE DEPENDENCIES:
STAGE PLANS:
Stage: Stage-0
-
PREHOOK: query: CREATE TEMPORARY FUNCTION test_max AS 'org.apache.hadoop.hive.ql.udf.UDAFTestMax'
PREHOOK: type: CREATEFUNCTION
POSTHOOK: query: CREATE TEMPORARY FUNCTION test_max AS 'org.apache.hadoop.hive.ql.udf.UDAFTestMax'
Modified: hive/trunk/ql/src/test/results/clientpositive/create_union_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_union_table.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_union_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_union_table.q.out Mon Dec 9 14:23:53 2013
@@ -22,7 +22,6 @@ STAGE PLANS:
name: abc
isExternal: false
-
PREHOOK: query: create table abc(mydata uniontype<int,double,array<string>,struct<a:int,b:string>>,
strct struct<a:int, b:string, c:string>)
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/create_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_view.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_view.q.out Mon Dec 9 14:23:53 2013
@@ -162,7 +162,6 @@ STAGE PLANS:
name: view0
original text: SELECT upper(value) FROM src WHERE key=86
-
PREHOOK: query: -- make sure EXPLAIN works with a query which references a view
EXPLAIN
SELECT * from view2 where key=18
@@ -208,7 +207,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SHOW TABLES 'view.*'
PREHOOK: type: SHOWTABLES
POSTHOOK: query: SHOW TABLES 'view.*'
Modified: hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out Mon Dec 9 14:23:53 2013
@@ -132,7 +132,6 @@ STAGE PLANS:
name: priceview
original text: SELECT items.id, items.info['price'] FROM items
-
PREHOOK: query: CREATE VIEW priceview AS SELECT items.id, items.info['price'] FROM items
PREHOOK: type: CREATEVIEW
POSTHOOK: query: CREATE VIEW priceview AS SELECT items.id, items.info['price'] FROM items
Modified: hive/trunk/ql/src/test/results/clientpositive/cross_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/cross_join.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/cross_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/cross_join.q.out Mon Dec 9 14:23:53 2013
@@ -56,7 +56,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- ansi cross join
explain select src.key from src cross join src src2
PREHOOK: type: QUERY
@@ -115,7 +114,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- appending condition is allowed
explain select src.key from src cross join src src2 on src.key=src2.key
PREHOOK: type: QUERY
@@ -186,4 +184,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out Mon Dec 9 14:23:53 2013
@@ -98,7 +98,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: create table summary as select *, sum(key), count(value) from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
@@ -232,7 +231,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: create table x4 as select *, rank() over(partition by key order by value) as rr from src1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src1
@@ -415,7 +413,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: create table x5 as select *, lead(key,1) over(partition by key order by value) as lead1 from src limit 20
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
@@ -570,7 +567,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: create table x6 as select * from (select *, max(key) from src1) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src1
@@ -706,7 +702,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: create table x7 as select * from (select * from src group by key) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
@@ -1153,7 +1148,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: create table x8 as select * from (select * from src group by key having key < 9) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
@@ -1311,7 +1305,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: create table x9 as select * from (select max(value),key from src group by key having key < 9 AND max(value) IS NOT NULL) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/ctas_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_hadoop20.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_hadoop20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_hadoop20.q.out Mon Dec 9 14:23:53 2013
@@ -117,7 +117,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: create table nzhang_CTAS1 as select key k, value from src sort by k, value limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
@@ -279,7 +278,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: create table nzhang_ctas2 as select * from src sort by key, value limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
@@ -442,7 +440,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: create table nzhang_ctas3 row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" stored as RCFile as select key/2 half_key, concat(value, "_con") conb from src sort by half_key, conb limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
@@ -512,7 +509,6 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
STAGE PLANS:
-STAGE PLANS:
PREHOOK: query: create table if not exists nzhang_ctas3 as select key, value from src sort by key, value limit 2
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table if not exists nzhang_ctas3 as select key, value from src sort by key, value limit 2
@@ -672,7 +668,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: create table nzhang_ctas4 row format delimited fields terminated by ',' stored as textfile as select key, value from src sort by key, value limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
@@ -958,7 +953,6 @@ STAGE PLANS:
Stats-Aggr Operator
#### A masked pattern was here ####
-
PREHOOK: query: create table nzhang_ctas5 row format delimited fields terminated by ',' lines terminated by '\012' stored as textfile as select key, value from src sort by key, value limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/decimal_udf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/decimal_udf.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/decimal_udf.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/decimal_udf.q.out Mon Dec 9 14:23:53 2013
@@ -45,7 +45,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key + key FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -116,7 +115,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key + value FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -187,7 +185,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key + (value/2) FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -258,7 +255,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key + '1.0' FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -331,7 +327,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key - key FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -402,7 +397,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key - value FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -473,7 +467,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key - (value/2) FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -544,7 +537,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key - '1.0' FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -617,7 +609,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key * key FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -688,7 +679,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key * value FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -759,7 +749,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key * (value/2) FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -830,7 +819,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key * '2.0' FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -904,7 +892,6 @@ STAGE PLANS:
Limit
ListSink
-
PREHOOK: query: SELECT key / 0 FROM DECIMAL_UDF limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -939,7 +926,6 @@ STAGE PLANS:
Limit
ListSink
-
PREHOOK: query: SELECT key / NULL FROM DECIMAL_UDF limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -977,7 +963,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key / key FROM DECIMAL_UDF WHERE key is not null and key <> 0
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -1048,7 +1033,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key / value FROM DECIMAL_UDF WHERE value is not null and value <> 0
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -1109,7 +1093,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -1166,7 +1149,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT key / '2.0' FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -1239,7 +1221,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT abs(key) FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -1402,7 +1383,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT value, sum(key) / count(key), avg(key) FROM DECIMAL_UDF GROUP BY value ORDER BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -1454,7 +1434,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT -key FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -1527,7 +1506,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT +key FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -1600,7 +1578,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT CEIL(key) FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -1673,7 +1650,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT FLOOR(key) FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -1746,7 +1722,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT ROUND(key, 2) FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -1819,7 +1794,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT POWER(key, 2) FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -1892,7 +1866,6 @@ STAGE PLANS:
outputColumnNames: _col0
ListSink
-
PREHOOK: query: SELECT (key + 1) % (key / 2) FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -2022,7 +1995,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT value, stddev(key), variance(key) FROM DECIMAL_UDF GROUP BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -2131,7 +2103,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT value, stddev_samp(key), var_samp(key) FROM DECIMAL_UDF GROUP BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -2218,7 +2189,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT histogram_numeric(key, 3) FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -2289,7 +2259,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT MIN(key) FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -2360,7 +2329,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT MAX(key) FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
@@ -2431,7 +2399,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT COUNT(key) FROM DECIMAL_UDF
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_udf
Modified: hive/trunk/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out Mon Dec 9 14:23:53 2013
@@ -167,7 +167,6 @@ STAGE PLANS:
Stats-Aggr Operator
#### A masked pattern was here ####
-
PREHOOK: query: insert overwrite table bucket2_1
select * from src
PREHOOK: type: QUERY
@@ -238,7 +237,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select * from bucket2_1 tablesample (bucket 1 out of 2) s order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket2_1
Modified: hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out Mon Dec 9 14:23:53 2013
@@ -47,7 +47,6 @@ STAGE PLANS:
Drop Table
table: mp
-
PREHOOK: query: alter table mp drop partition (b='1')
PREHOOK: type: ALTERTABLE_DROPPARTS
PREHOOK: Input: default@mp
Modified: hive/trunk/ql/src/test/results/clientpositive/drop_udf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/drop_udf.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/drop_udf.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/drop_udf.q.out Mon Dec 9 14:23:53 2013
@@ -17,7 +17,6 @@ STAGE DEPENDENCIES:
STAGE PLANS:
Stage: Stage-0
-
PREHOOK: query: DROP TEMPORARY FUNCTION test_translate
PREHOOK: type: DROPFUNCTION
POSTHOOK: query: DROP TEMPORARY FUNCTION test_translate
Modified: hive/trunk/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out Mon Dec 9 14:23:53 2013
@@ -151,7 +151,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain extended select intcol from dynamic_part_table where partcol1=1 and partcol2=1
PREHOOK: type: QUERY
POSTHOOK: query: explain extended select intcol from dynamic_part_table where partcol1=1 and partcol2=1
@@ -258,7 +257,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain extended select intcol from dynamic_part_table where (partcol1=1 and partcol2=1)or (partcol1=1 and partcol2='__HIVE_DEFAULT_PARTITION__')
PREHOOK: type: QUERY
POSTHOOK: query: explain extended select intcol from dynamic_part_table where (partcol1=1 and partcol2=1)or (partcol1=1 and partcol2='__HIVE_DEFAULT_PARTITION__')
@@ -408,4 +406,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/escape_clusterby1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/escape_clusterby1.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/escape_clusterby1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/escape_clusterby1.q.out Mon Dec 9 14:23:53 2013
@@ -59,7 +59,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain
select `key`, value from src cluster by `key`, value
PREHOOK: type: QUERY
@@ -119,4 +118,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/escape_distributeby1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/escape_distributeby1.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/escape_distributeby1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/escape_distributeby1.q.out Mon Dec 9 14:23:53 2013
@@ -54,7 +54,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain
select `key`, value from src distribute by `key`, value
PREHOOK: type: QUERY
@@ -109,4 +108,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/escape_orderby1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/escape_orderby1.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/escape_orderby1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/escape_orderby1.q.out Mon Dec 9 14:23:53 2013
@@ -54,7 +54,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain
select `key`, value from src order by `key`, value
PREHOOK: type: QUERY
@@ -109,4 +108,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/escape_sortby1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/escape_sortby1.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/escape_sortby1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/escape_sortby1.q.out Mon Dec 9 14:23:53 2013
@@ -54,7 +54,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain
select `key`, value from src sort by `key`, value
PREHOOK: type: QUERY
@@ -109,4 +108,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/explain_logical.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/explain_logical.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/explain_logical.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/explain_logical.q.out Mon Dec 9 14:23:53 2013
@@ -100,7 +100,6 @@ srcpart
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
PREHOOK: query: EXPLAIN LOGICAL
SELECT key, count(1) FROM (SELECT key, value FROM src) subq1 GROUP BY key
PREHOOK: type: QUERY
@@ -161,7 +160,6 @@ subq1:src
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
PREHOOK: query: EXPLAIN LOGICAL
SELECT * FROM (
SELECT key, value FROM src UNION ALL SELECT key, value FROM srcpart WHERE ds IS NOT NULL
@@ -210,7 +208,6 @@ null-subquery2:s1-subquery2:srcpart
outputColumnNames: _col0, _col1
Union (UNION_5)
-
PREHOOK: query: EXPLAIN LOGICAL
SELECT S1.key, S2.value FROM src S1 JOIN srcpart S2 ON S1.key = S2.key WHERE ds IS NOT NULL
PREHOOK: type: QUERY
@@ -279,7 +276,6 @@ s2
handleSkewJoin: false
outputColumnNames: _col0, _col5
-
PREHOOK: query: -- With views
EXPLAIN LOGICAL SELECT * FROM V1
PREHOOK: type: QUERY
@@ -305,7 +301,6 @@ v1:src
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V2
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM V2
@@ -331,7 +326,6 @@ v2:srcpart
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V3
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM V3
@@ -403,7 +397,6 @@ v3:src2
handleSkewJoin: false
outputColumnNames: _col1, _col4
-
PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V4
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM V4
@@ -513,7 +506,6 @@ v4:src3
handleSkewJoin: false
outputColumnNames: _col0, _col4, _col6
-
PREHOOK: query: -- The table should show up in the explain logical even if none
-- of the partitions are selected.
CREATE VIEW V5 as SELECT * FROM srcpart where ds = '10'
@@ -554,7 +546,6 @@ v5:srcpart
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
PREHOOK: query: EXPLAIN LOGICAL SELECT s1.key, s1.cnt, s2.value FROM (SELECT key, count(value) as cnt FROM src GROUP BY key) s1 JOIN src s2 ON (s1.key = s2.key) ORDER BY s1.key
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN LOGICAL SELECT s1.key, s1.cnt, s2.value FROM (SELECT key, count(value) as cnt FROM src GROUP BY key) s1 JOIN src s2 ON (s1.key = s2.key) ORDER BY s1.key
@@ -683,4 +674,3 @@ s2
handleSkewJoin: false
outputColumnNames: _col0, _col1, _col3
-
Modified: hive/trunk/ql/src/test/results/clientpositive/explain_rearrange.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/explain_rearrange.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/explain_rearrange.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/explain_rearrange.q.out Mon Dec 9 14:23:53 2013
@@ -414,7 +414,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- changes id only
explain
@@ -817,7 +816,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- assign ids in traverse order
explain
@@ -1220,7 +1218,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- assign ids in execution order
explain
@@ -1623,4 +1620,3 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
Modified: hive/trunk/ql/src/test/results/clientpositive/fetch_aggregation.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/fetch_aggregation.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/fetch_aggregation.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/fetch_aggregation.q.out Mon Dec 9 14:23:53 2013
@@ -78,7 +78,6 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
ListSink
-
PREHOOK: query: select count(key),sum(key),avg(key),min(key),max(key),std(key),variance(key) from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out Mon Dec 9 14:23:53 2013
@@ -26,7 +26,6 @@ STAGE PLANS:
name: dest1
isExternal: false
-
PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS
INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
Modified: hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out Mon Dec 9 14:23:53 2013
@@ -26,7 +26,6 @@ STAGE PLANS:
name: dest1
isExternal: false
-
PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS
INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
Modified: hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out Mon Dec 9 14:23:53 2013
@@ -331,7 +331,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT f.key, g.value
FROM filter_join_breaktask f JOIN filter_join_breaktask m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' AND f.key is not null)
JOIN filter_join_breaktask g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08' AND m.value is not null AND m.value !='')
Modified: hive/trunk/ql/src/test/results/clientpositive/filter_numeric.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/filter_numeric.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/filter_numeric.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/filter_numeric.q.out Mon Dec 9 14:23:53 2013
@@ -67,7 +67,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select key, value, hr from partint where hr < 11
PREHOOK: type: QUERY
PREHOOK: Input: default@partint
@@ -123,7 +122,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select key, value, hr from partint where hr <= 12 and hr > 11
PREHOOK: type: QUERY
PREHOOK: Input: default@partint
@@ -681,7 +679,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select key, value, hr from partint where hr between 11 and 12
PREHOOK: type: QUERY
PREHOOK: Input: default@partint
@@ -1741,7 +1738,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select key, value, hr from partint where hr not between 12 and 14
PREHOOK: type: QUERY
PREHOOK: Input: default@partint
@@ -2299,7 +2295,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select key, value, hr from partint where hr < 13
PREHOOK: type: QUERY
PREHOOK: Input: default@partint
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1.q.out Mon Dec 9 14:23:53 2013
@@ -118,7 +118,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out Mon Dec 9 14:23:53 2013
@@ -219,7 +219,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM INPUT
INSERT OVERWRITE TABLE dest1 SELECT INPUT.key, count(substr(INPUT.value,5)), count(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
INSERT OVERWRITE TABLE dest2 SELECT INPUT.key, sum(substr(INPUT.value,5)), sum(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
@@ -514,7 +513,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM INPUT
INSERT OVERWRITE TABLE dest1 SELECT INPUT.key, count(substr(INPUT.value,5)), count(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
INSERT OVERWRITE TABLE dest2 SELECT INPUT.key, sum(substr(INPUT.value,5)), sum(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
@@ -835,7 +833,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM INPUT
INSERT OVERWRITE TABLE dest1 SELECT INPUT.key, sum(distinct substr(INPUT.value,5)), count(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
INSERT OVERWRITE TABLE dest2 SELECT INPUT.key, sum(distinct substr(INPUT.value,5)), avg(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby11.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby11.q.out Mon Dec 9 14:23:53 2013
@@ -218,7 +218,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 partition(ds='111')
SELECT src.value, count(src.key), count(distinct src.key) GROUP BY src.value
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out Mon Dec 9 14:23:53 2013
@@ -124,7 +124,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out Mon Dec 9 14:23:53 2013
@@ -91,7 +91,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby1_map_nomap.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_nomap.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_map_nomap.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_map_nomap.q.out Mon Dec 9 14:23:53 2013
@@ -91,7 +91,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out Mon Dec 9 14:23:53 2013
@@ -127,7 +127,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out Mon Dec 9 14:23:53 2013
@@ -82,7 +82,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2.q.out Mon Dec 9 14:23:53 2013
@@ -86,7 +86,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest_g2 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))) GROUP BY substr(src.key,1,1)
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_limit.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_limit.q.out Mon Dec 9 14:23:53 2013
@@ -76,7 +76,6 @@ STAGE PLANS:
Fetch Operator
limit: 5
-
PREHOOK: query: SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key LIMIT 5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out Mon Dec 9 14:23:53 2013
@@ -103,7 +103,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))) GROUP BY substr(src.key,1,1)
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out Mon Dec 9 14:23:53 2013
@@ -115,7 +115,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) GROUP BY substr(src.key,1,1)
PREHOOK: type: QUERY
@@ -275,7 +274,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1), count(DISTINCT substr(src.key,1,1)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) GROUP BY substr(src.key,1,1)
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_map_skew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_map_skew.q.out Mon Dec 9 14:23:53 2013
@@ -103,7 +103,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))) GROUP BY substr(src.key,1,1)
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out Mon Dec 9 14:23:53 2013
@@ -86,7 +86,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest_g2 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))) GROUP BY substr(src.key,1,1)
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out Mon Dec 9 14:23:53 2013
@@ -95,7 +95,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest_g2 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) GROUP BY substr(src.key,1,1)
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby3.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby3.q.out Mon Dec 9 14:23:53 2013
@@ -167,7 +167,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT
sum(substr(src.value,5)),
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out Mon Dec 9 14:23:53 2013
@@ -149,7 +149,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT
sum(substr(src.value,5)),
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby3_map_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_multi_distinct.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby3_map_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby3_map_multi_distinct.q.out Mon Dec 9 14:23:53 2013
@@ -165,7 +165,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT
sum(substr(src.value,5)),
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out Mon Dec 9 14:23:53 2013
@@ -203,7 +203,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT
sum(substr(src.value,5)),
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out Mon Dec 9 14:23:53 2013
@@ -113,7 +113,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT
sum(substr(src.value,5)),
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew_multi_distinct.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew_multi_distinct.q.out Mon Dec 9 14:23:53 2013
@@ -123,7 +123,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT
sum(substr(src.value,5)),
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out Mon Dec 9 14:23:53 2013
@@ -106,7 +106,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1) GROUP BY substr(src.key,1,1)
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby4_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby4_map.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby4_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby4_map.q.out Mon Dec 9 14:23:53 2013
@@ -71,7 +71,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT count(1)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby4_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby4_map_skew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby4_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby4_map_skew.q.out Mon Dec 9 14:23:53 2013
@@ -71,7 +71,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT count(1)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out Mon Dec 9 14:23:53 2013
@@ -75,7 +75,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1) GROUP BY substr(src.key,1,1)
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out Mon Dec 9 14:23:53 2013
@@ -124,7 +124,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: INSERT OVERWRITE TABLE dest1
SELECT src.key, sum(substr(src.value,5))
FROM src
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out Mon Dec 9 14:23:53 2013
@@ -75,7 +75,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT sum(src.key)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out Mon Dec 9 14:23:53 2013
@@ -75,7 +75,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT sum(src.key)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out Mon Dec 9 14:23:53 2013
@@ -88,7 +88,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: INSERT OVERWRITE TABLE dest1
SELECT src.key, sum(substr(src.value,5))
FROM src
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out Mon Dec 9 14:23:53 2013
@@ -106,7 +106,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT DISTINCT substr(src.value,5,1)
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out Mon Dec 9 14:23:53 2013
@@ -82,7 +82,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT DISTINCT substr(src.value,5,1)
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out Mon Dec 9 14:23:53 2013
@@ -113,7 +113,6 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT DISTINCT substr(src.value,5,1)
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out Mon Dec 9 14:23:53 2013
@@ -75,7 +75,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT DISTINCT substr(src.value,5,1)
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out Mon Dec 9 14:23:53 2013
@@ -182,7 +182,6 @@ STAGE PLANS:
Stage: Stage-5
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out Mon Dec 9 14:23:53 2013
@@ -131,7 +131,6 @@ STAGE PLANS:
Stage: Stage-4
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out Mon Dec 9 14:23:53 2013
@@ -254,7 +254,6 @@ STAGE PLANS:
Stage: Stage-7
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out Mon Dec 9 14:23:53 2013
@@ -164,7 +164,6 @@ STAGE PLANS:
Stage: Stage-5
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew_multi_single_reducer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew_multi_single_reducer.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew_multi_single_reducer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew_multi_single_reducer.q.out Mon Dec 9 14:23:53 2013
@@ -197,7 +197,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key limit 10
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key limit 10
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out Mon Dec 9 14:23:53 2013
@@ -196,7 +196,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
@@ -1049,7 +1048,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out Mon Dec 9 14:23:53 2013
@@ -196,7 +196,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out Mon Dec 9 14:23:53 2013
@@ -196,7 +196,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out Mon Dec 9 14:23:53 2013
@@ -196,7 +196,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out Mon Dec 9 14:23:53 2013
@@ -208,7 +208,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, SRC.value, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key, SRC.value
@@ -1077,7 +1076,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, SRC.value, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.value, SRC.key
@@ -1966,7 +1964,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, SRC.value, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key, SRC.value
@@ -2859,7 +2856,6 @@ STAGE PLANS:
Stage: Stage-5
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, SRC.value, COUNT(SUBSTR(SRC.value,5)) GROUP BY SRC.key, SRC.value
@@ -3788,7 +3784,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, SRC.value, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.value, SRC.key
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_complex_types.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_complex_types.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_complex_types.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_complex_types.q.out Mon Dec 9 14:23:53 2013
@@ -269,7 +269,6 @@ STAGE PLANS:
Stage: Stage-8
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT ARRAY(SRC.key), COUNT(1) GROUP BY ARRAY(SRC.key)
INSERT OVERWRITE TABLE DEST2 SELECT MAP(SRC.key, SRC.value), COUNT(1) GROUP BY MAP(SRC.key, SRC.value)
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_complex_types_multi_single_reducer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_complex_types_multi_single_reducer.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_complex_types_multi_single_reducer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_complex_types_multi_single_reducer.q.out Mon Dec 9 14:23:53 2013
@@ -232,7 +232,6 @@ STAGE PLANS:
Stage: Stage-7
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT ARRAY(SRC.key), COUNT(1) GROUP BY ARRAY(SRC.key) limit 10
INSERT OVERWRITE TABLE DEST2 SELECT MAP(SRC.key, SRC.value), COUNT(1) GROUP BY MAP(SRC.key, SRC.value) limit 10
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_cube1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_cube1.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_cube1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_cube1.q.out Mon Dec 9 14:23:53 2013
@@ -104,7 +104,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT key, val, count(1) FROM T1 GROUP BY key, val with cube
ORDER BY key, val
PREHOOK: type: QUERY
@@ -222,7 +221,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT key, count(distinct val) FROM T1 GROUP BY key with cube
ORDER BY key
PREHOOK: type: QUERY
@@ -376,7 +374,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT key, val, count(1) FROM T1 GROUP BY key, val with cube
ORDER BY key, val
PREHOOK: type: QUERY
@@ -492,7 +489,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT key, count(distinct val) FROM T1 GROUP BY key with cube
ORDER BY key
PREHOOK: type: QUERY
@@ -813,7 +809,6 @@ STAGE PLANS:
Stage: Stage-7
Stats-Aggr Operator
-
PREHOOK: query: FROM T1
INSERT OVERWRITE TABLE T2 SELECT key, val, count(1) group by key, val with cube
INSERT OVERWRITE TABLE T3 SELECT key, val, sum(1) group by key, val with cube
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_distinct_samekey.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_distinct_samekey.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_distinct_samekey.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_distinct_samekey.q.out Mon Dec 9 14:23:53 2013
@@ -142,7 +142,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: explain select int1, sum(distinct int1) from t1 group by int1
PREHOOK: type: QUERY
POSTHOOK: query: explain select int1, sum(distinct int1) from t1 group by int1
@@ -220,7 +219,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: select Q1.int1, sum(distinct Q1.int1) from (select * from t1 order by int1) Q1 group by Q1.int1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out Mon Dec 9 14:23:53 2013
@@ -148,7 +148,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT a, b, count(*) from T1 group by a, b with cube
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
@@ -311,7 +310,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT a, b, sum(c) from T1 group by a, b with cube
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
@@ -499,7 +497,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT a, b, sum(c+d) from T2 group by a, b with cube
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets3.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets3.q.out Mon Dec 9 14:23:53 2013
@@ -132,7 +132,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT a, b, avg(c), count(*) from T1 group by a, b with cube
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
@@ -309,7 +308,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT a, b, avg(c), count(*) from T1 group by a, b with cube
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out Mon Dec 9 14:23:53 2013
@@ -317,7 +317,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
@@ -737,7 +736,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT * FROM
(SELECT a, b, count(*) from T1 where a < 3 group by a, b with cube) subq1
join
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets5.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets5.q.out Mon Dec 9 14:23:53 2013
@@ -172,7 +172,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT a, b, count(*) FROM
(SELECT a, b, count(1) from T1 group by a, b) subq1 group by a, b with cube
PREHOOK: type: QUERY
@@ -399,7 +398,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT a, b, count(*) FROM
(SELECT a, b, count(1) from T1 group by a, b) subq1 group by a, b with cube
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out Mon Dec 9 14:23:53 2013
@@ -244,7 +244,6 @@ STAGE PLANS:
Stats-Aggr Operator
#### A masked pattern was here ####
-
PREHOOK: query: FROM srcpart src
INSERT OVERWRITE TABLE dest1
SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5)))
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out Mon Dec 9 14:23:53 2013
@@ -260,7 +260,6 @@ STAGE PLANS:
Stats-Aggr Operator
#### A masked pattern was here ####
-
PREHOOK: query: FROM srcpart src
INSERT OVERWRITE TABLE dest1
SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(DISTINCT src.value)
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_multi_insert_common_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_multi_insert_common_distinct.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_multi_insert_common_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_multi_insert_common_distinct.q.out Mon Dec 9 14:23:53 2013
@@ -198,7 +198,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: from src
insert overwrite table dest1 select key, count(distinct value) group by key
insert overwrite table dest2 select key+key, count(distinct value) group by key+key
@@ -441,7 +440,6 @@ STAGE PLANS:
Stage: Stage-5
Stats-Aggr Operator
-
PREHOOK: query: from src
insert overwrite table dest1 select key, count(distinct value) group by key
insert overwrite table dest2 select key+key, count(distinct value) group by key+key
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out Mon Dec 9 14:23:53 2013
@@ -224,7 +224,6 @@ STAGE PLANS:
Stage: Stage-6
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest_g2 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) WHERE substr(src.key,1,1) >= 5 GROUP BY substr(src.key,1,1)
INSERT OVERWRITE TABLE dest_g3 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) WHERE substr(src.key,1,1) < 5 GROUP BY substr(src.key,1,1)
@@ -755,7 +754,6 @@ STAGE PLANS:
Stage: Stage-12
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest_g2 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) WHERE substr(src.key,1,1) >= 5 GROUP BY substr(src.key,1,1)
INSERT OVERWRITE TABLE dest_g3 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) WHERE substr(src.key,1,1) < 5 GROUP BY substr(src.key,1,1)
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer2.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer2.q.out Mon Dec 9 14:23:53 2013
@@ -148,7 +148,6 @@ STAGE PLANS:
Stage: Stage-4
Stats-Aggr Operator
-
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest_g2 SELECT substr(src.key,1,1), count(DISTINCT src.key) WHERE substr(src.key,1,1) >= 5 GROUP BY substr(src.key,1,1)
INSERT OVERWRITE TABLE dest_g3 SELECT substr(src.key,1,1), count(DISTINCT src.key), count(src.value) WHERE substr(src.key,1,1) < 5 GROUP BY substr(src.key,1,1)
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out Mon Dec 9 14:23:53 2013
@@ -157,7 +157,6 @@ STAGE PLANS:
Stage: Stage-4
Stats-Aggr Operator
-
PREHOOK: query: from src
insert overwrite table e1
select key, count(*)
@@ -366,7 +365,6 @@ STAGE PLANS:
Stage: Stage-4
Stats-Aggr Operator
-
PREHOOK: query: from src
insert overwrite table e1
select value, count(*)
@@ -591,7 +589,6 @@ STAGE PLANS:
Stage: Stage-4
Stats-Aggr Operator
-
PREHOOK: query: from src
insert overwrite table e1
select key, count(*)
@@ -832,7 +829,6 @@ STAGE PLANS:
Stage: Stage-4
Stats-Aggr Operator
-
PREHOOK: query: from src
insert overwrite table e1
select value, count(*)
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_position.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_position.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_position.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_position.q.out Mon Dec 9 14:23:53 2013
@@ -212,7 +212,6 @@ STAGE PLANS:
Stage: Stage-5
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE testTable1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) WHERE SRC.key < 20 GROUP BY 1
INSERT OVERWRITE TABLE testTable2 SELECT SRC.key, SRC.value, COUNT(DISTINCT SUBSTR(SRC.value,5)) WHERE SRC.key < 20 GROUP BY 1, 2
@@ -489,7 +488,6 @@ STAGE PLANS:
Stage: Stage-5
Stats-Aggr Operator
-
PREHOOK: query: FROM SRC
INSERT OVERWRITE TABLE testTable1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) WHERE SRC.key < 20 GROUP BY 1
INSERT OVERWRITE TABLE testTable2 SELECT SRC.key, SRC.value, COUNT(DISTINCT SUBSTR(SRC.value,5)) WHERE SRC.key < 20 GROUP BY 2, 1
@@ -702,7 +700,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT t.key, t.value
FROM (SELECT b.key as key, count(1) as value FROM src b WHERE b.key <= 20 GROUP BY 1) t
ORDER BY 2 DESC, 1 ASC
@@ -1034,7 +1031,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: SELECT c1, c2, c3, c4
FROM (
FROM
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_ppd.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_ppd.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_ppd.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_ppd.q.out Mon Dec 9 14:23:53 2013
@@ -137,7 +137,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: drop table invites
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@invites
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_ppr.q.out?rev=1549580&r1=1549579&r2=1549580&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_ppr.q.out Mon Dec 9 14:23:53 2013
@@ -225,7 +225,6 @@ STAGE PLANS:
Stats-Aggr Operator
#### A masked pattern was here ####
-
PREHOOK: query: FROM srcpart src
INSERT OVERWRITE TABLE dest1
SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5)))