You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2013/11/05 08:01:58 UTC
svn commit: r1538880 [13/46] - in /hive/branches/tez: ./ ant/
ant/src/org/apache/hadoop/hive/ant/ beeline/
beeline/src/java/org/apache/hive/beeline/ beeline/src/main/
beeline/src/test/org/apache/hive/beeline/src/test/ cli/ common/
common/src/java/conf/...
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udaf_corr.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udaf_corr.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udaf_corr.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udaf_corr.q Tue Nov 5 07:01:32 2013
@@ -2,7 +2,7 @@ DROP TABLE covar_tab;
CREATE TABLE covar_tab (a INT, b INT, c INT)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
+LOAD DATA LOCAL INPATH '../../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab;
DESCRIBE FUNCTION corr;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udaf_covar_pop.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udaf_covar_pop.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udaf_covar_pop.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udaf_covar_pop.q Tue Nov 5 07:01:32 2013
@@ -2,7 +2,7 @@ DROP TABLE covar_tab;
CREATE TABLE covar_tab (a INT, b INT, c INT)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
+LOAD DATA LOCAL INPATH '../../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab;
DESCRIBE FUNCTION covar_pop;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udaf_covar_samp.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udaf_covar_samp.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udaf_covar_samp.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udaf_covar_samp.q Tue Nov 5 07:01:32 2013
@@ -2,7 +2,7 @@ DROP TABLE covar_tab;
CREATE TABLE covar_tab (a INT, b INT, c INT)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
+LOAD DATA LOCAL INPATH '../../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab;
DESCRIBE FUNCTION covar_samp;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udaf_ngrams.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udaf_ngrams.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udaf_ngrams.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udaf_ngrams.q Tue Nov 5 07:01:32 2013
@@ -1,5 +1,5 @@
CREATE TABLE kafka (contents STRING);
-LOAD DATA LOCAL INPATH '../data/files/text-en.txt' INTO TABLE kafka;
+LOAD DATA LOCAL INPATH '../../data/files/text-en.txt' INTO TABLE kafka;
set mapred.reduce.tasks=1;
set hive.exec.reducers.max=1;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udaf_percentile_approx_20.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udaf_percentile_approx_20.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udaf_percentile_approx_20.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udaf_percentile_approx_20.q Tue Nov 5 07:01:32 2013
@@ -1,10 +1,10 @@
-- INCLUDE_HADOOP_MAJOR_VERSIONS(0.20, 0.20S)
CREATE TABLE bucket (key double, value string) CLUSTERED BY (key) SORTED BY (key DESC) INTO 4 BUCKETS STORED AS TEXTFILE;
-load data local inpath '../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket;
-load data local inpath '../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket;
-load data local inpath '../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket;
-load data local inpath '../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket;
create table t1 (result double);
create table t2 (result double);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q Tue Nov 5 07:01:32 2013
@@ -2,10 +2,10 @@
-- 0.23 changed input order of data in reducer task, which affects result of percentile_approx
CREATE TABLE bucket (key double, value string) CLUSTERED BY (key) SORTED BY (key DESC) INTO 4 BUCKETS STORED AS TEXTFILE;
-load data local inpath '../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket;
-load data local inpath '../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket;
-load data local inpath '../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket;
-load data local inpath '../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket;
+load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket;
create table t1 (result double);
create table t2 (result double);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_E.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_E.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_E.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_E.q Tue Nov 5 07:01:32 2013
@@ -1,14 +1,16 @@
-explain
-select E() FROM src LIMIT 1;
+set hive.fetch.task.conversion=more;
+
+explain
+select E() FROM src tablesample (1 rows);
-select E() FROM src LIMIT 1;
+select E() FROM src tablesample (1 rows);
DESCRIBE FUNCTION E;
DESCRIBE FUNCTION EXTENDED E;
explain
-select E() FROM src LIMIT 1;
+select E() FROM src tablesample (1 rows);
-select E() FROM src LIMIT 1;
+select E() FROM src tablesample (1 rows);
DESCRIBE FUNCTION E;
DESCRIBE FUNCTION EXTENDED E;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_PI.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_PI.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_PI.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_PI.q Tue Nov 5 07:01:32 2013
@@ -1,14 +1,16 @@
-explain
-select PI() FROM src LIMIT 1;
+set hive.fetch.task.conversion=more;
+
+explain
+select PI() FROM src tablesample (1 rows);
-select PI() FROM src LIMIT 1;
+select PI() FROM src tablesample (1 rows);
DESCRIBE FUNCTION PI;
DESCRIBE FUNCTION EXTENDED PI;
explain
-select PI() FROM src LIMIT 1;
+select PI() FROM src tablesample (1 rows);
-select PI() FROM src LIMIT 1;
+select PI() FROM src tablesample (1 rows);
DESCRIBE FUNCTION PI;
DESCRIBE FUNCTION EXTENDED PI;
\ No newline at end of file
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_abs.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_abs.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_abs.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_abs.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION abs;
DESCRIBE FUNCTION EXTENDED abs;
@@ -7,7 +9,7 @@ EXPLAIN SELECT
abs(123),
abs(-9223372036854775807),
abs(9223372036854775807)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
abs(0),
@@ -15,16 +17,16 @@ SELECT
abs(123),
abs(-9223372036854775807),
abs(9223372036854775807)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
EXPLAIN SELECT
abs(0.0),
abs(-3.14159265),
abs(3.14159265)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
abs(0.0),
abs(-3.14159265),
abs(3.14159265)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_acos.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_acos.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_acos.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_acos.q Tue Nov 5 07:01:32 2013
@@ -1,14 +1,16 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION acos;
DESCRIBE FUNCTION EXTENDED acos;
SELECT acos(null)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT acos(0)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT acos(-0.5), asin(0.66)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT acos(2)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_array.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_array.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_array.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_array.q Tue Nov 5 07:01:32 2013
@@ -1,8 +1,10 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION array;
DESCRIBE FUNCTION EXTENDED array;
EXPLAIN SELECT array(), array()[1], array(1, 2, 3), array(1, 2, 3)[2], array(1,"a", 2, 3), array(1,"a", 2, 3)[2],
-array(array(1), array(2), array(3), array(4))[1][0] FROM src LIMIT 1;
+array(array(1), array(2), array(3), array(4))[1][0] FROM src tablesample (1 rows);
SELECT array(), array()[1], array(1, 2, 3), array(1, 2, 3)[2], array(1,"a", 2, 3), array(1,"a", 2, 3)[2],
-array(array(1), array(2), array(3), array(4))[1][0] FROM src LIMIT 1;
+array(array(1), array(2), array(3), array(4))[1][0] FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_array_contains.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_array_contains.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_array_contains.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_array_contains.q Tue Nov 5 07:01:32 2013
@@ -1,9 +1,11 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION array_contains;
DESCRIBE FUNCTION EXTENDED array_contains;
-- evalutes function for array of primitives
-SELECT array_contains(array(1, 2, 3), 1) FROM src LIMIT 1;
+SELECT array_contains(array(1, 2, 3), 1) FROM src tablesample (1 rows);
-- evaluates function for nested arrays
SELECT array_contains(array(array(1,2), array(2,3), array(3,4)), array(1,2))
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_ascii.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_ascii.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_ascii.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_ascii.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION ascii;
DESCRIBE FUNCTION EXTENDED ascii;
@@ -5,10 +7,10 @@ EXPLAIN SELECT
ascii('Facebook'),
ascii(''),
ascii('!')
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
ascii('Facebook'),
ascii(''),
ascii('!')
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_asin.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_asin.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_asin.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_asin.q Tue Nov 5 07:01:32 2013
@@ -1,14 +1,16 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION asin;
DESCRIBE FUNCTION EXTENDED asin;
SELECT asin(null)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT asin(0)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT asin(-0.5), asin(0.66)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT asin(2)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_atan.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_atan.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_atan.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_atan.q Tue Nov 5 07:01:32 2013
@@ -1,16 +1,18 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION atan;
DESCRIBE FUNCTION EXTENDED atan;
SELECT atan(null)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT atan(1), atan(6), atan(-1.0)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
DESCRIBE FUNCTION atan;
DESCRIBE FUNCTION EXTENDED atan;
SELECT atan(null)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT atan(1), atan(6), atan(-1.0)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_between.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_between.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_between.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_between.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
describe function between;
describe function extended between;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_bin.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_bin.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_bin.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_bin.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION bin;
DESCRIBE FUNCTION EXTENDED bin;
@@ -5,7 +7,7 @@ SELECT
bin(1),
bin(0),
bin(99992421)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-- Negative numbers should be treated as two's complement (64 bit).
-SELECT bin(-5) FROM src LIMIT 1;
+SELECT bin(-5) FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_bitmap_and.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_bitmap_and.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_bitmap_and.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_bitmap_and.q Tue Nov 5 07:01:32 2013
@@ -1,11 +1,13 @@
-select ewah_bitmap_and(array(13,2,4,8589934592,4096,0), array(13,2,4,8589934592,4096,0)) from src limit 1;
-select ewah_bitmap_and(array(13,2,4,8589934592,4096,0), array(8,2,4,8589934592,128,0)) from src limit 1;
+set hive.fetch.task.conversion=more;
+
+select ewah_bitmap_and(array(13,2,4,8589934592,4096,0), array(13,2,4,8589934592,4096,0)) from src tablesample (1 rows);
+select ewah_bitmap_and(array(13,2,4,8589934592,4096,0), array(8,2,4,8589934592,128,0)) from src tablesample (1 rows);
drop table bitmap_test;
create table bitmap_test (a array<bigint>, b array<bigint>);
insert overwrite table bitmap_test
-select array(13,2,4,8589934592,4096,0), array(8,2,4,8589934592,128,0) from src limit 10;
+select array(13,2,4,8589934592,4096,0), array(8,2,4,8589934592,128,0) from src tablesample (10 rows);
select ewah_bitmap_and(a,b) from bitmap_test;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_bitmap_empty.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_bitmap_empty.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_bitmap_empty.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_bitmap_empty.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
-select ewah_bitmap_empty(array(13,2,4,8589934592,0,0)) from src limit 1;
+set hive.fetch.task.conversion=more;
-select ewah_bitmap_empty(array(13,2,4,8589934592,4096,0)) from src limit 1;
+select ewah_bitmap_empty(array(13,2,4,8589934592,0,0)) from src tablesample (1 rows);
+
+select ewah_bitmap_empty(array(13,2,4,8589934592,4096,0)) from src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_bitmap_or.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_bitmap_or.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_bitmap_or.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_bitmap_or.q Tue Nov 5 07:01:32 2013
@@ -1,11 +1,13 @@
-select ewah_bitmap_or(array(13,2,4,8589934592,4096,0), array(13,2,4,8589934592,4096,0)) from src limit 1;
-select ewah_bitmap_or(array(13,2,4,8589934592,4096,0), array(8,2,4,8589934592,128,0)) from src limit 1;
+set hive.fetch.task.conversion=more;
+
+select ewah_bitmap_or(array(13,2,4,8589934592,4096,0), array(13,2,4,8589934592,4096,0)) from src tablesample (1 rows);
+select ewah_bitmap_or(array(13,2,4,8589934592,4096,0), array(8,2,4,8589934592,128,0)) from src tablesample (1 rows);
drop table bitmap_test;
create table bitmap_test (a array<bigint>, b array<bigint>);
insert overwrite table bitmap_test
-select array(13,2,4,8589934592,4096,0), array(8,2,4,8589934592,128,0) from src limit 10;
+select array(13,2,4,8589934592,4096,0), array(8,2,4,8589934592,128,0) from src tablesample (10 rows);
select ewah_bitmap_or(a,b) from bitmap_test;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_case.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_case.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_case.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_case.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION case;
DESCRIBE FUNCTION EXTENDED case;
@@ -27,7 +29,7 @@ SELECT CASE 1
WHEN 22 THEN 23
WHEN 21 THEN 24
END
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT CASE 1
WHEN 1 THEN 2
@@ -54,10 +56,10 @@ SELECT CASE 1
WHEN 22 THEN 23
WHEN 21 THEN 24
END
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-- verify that short-circuiting is working correctly for CASE
-- we should never get to the ELSE branch, which would raise an exception
SELECT CASE 1 WHEN 1 THEN 'yo'
ELSE reflect('java.lang.String', 'bogus', 1) END
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_case_thrift.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_case_thrift.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_case_thrift.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_case_thrift.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
EXPLAIN
SELECT CASE src_thrift.lint[0]
WHEN 0 THEN src_thrift.lint[0] + 1
@@ -14,7 +16,7 @@ SELECT CASE src_thrift.lint[0]
WHEN '0' THEN src_thrift.lstring
ELSE NULL
END)[0]
-FROM src_thrift LIMIT 3;
+FROM src_thrift tablesample (3 rows);
SELECT CASE src_thrift.lint[0]
WHEN 0 THEN src_thrift.lint[0] + 1
@@ -31,4 +33,4 @@ SELECT CASE src_thrift.lint[0]
WHEN '0' THEN src_thrift.lstring
ELSE NULL
END)[0]
-FROM src_thrift LIMIT 3;
+FROM src_thrift tablesample (3 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_coalesce.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_coalesce.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_coalesce.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_coalesce.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION coalesce;
DESCRIBE FUNCTION EXTENDED coalesce;
@@ -20,7 +22,7 @@ SELECT COALESCE(1),
COALESCE(NULL, 2.0, 3.0),
COALESCE(2.0, NULL, 3.0),
COALESCE(IF(TRUE, NULL, 0), NULL)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT COALESCE(1),
COALESCE(1, 2),
@@ -40,7 +42,7 @@ SELECT COALESCE(1),
COALESCE(NULL, 2.0, 3.0),
COALESCE(2.0, NULL, 3.0),
COALESCE(IF(TRUE, NULL, 0), NULL)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
EXPLAIN
SELECT COALESCE(src_thrift.lint[1], 999),
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_compare_java_string.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_compare_java_string.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_compare_java_string.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_compare_java_string.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
EXPLAIN
CREATE TEMPORARY FUNCTION test_udf_get_java_string AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestGetJavaString';
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_concat.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_concat.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_concat.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_concat.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION concat;
DESCRIBE FUNCTION EXTENDED concat;
@@ -12,10 +14,10 @@ SELECT
concat(1, 2),
concat(1),
concat('1234', 'abc', 'extra argument')
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-- binary/mixed
SELECT
concat(cast('ab' as binary), cast('cd' as binary)),
concat('ab', cast('cd' as binary))
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_concat_ws.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_concat_ws.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_concat_ws.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_concat_ws.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION concat_ws;
DESCRIBE FUNCTION EXTENDED concat_ws;
@@ -24,7 +26,7 @@ SELECT concat_ws('.', array('www', 'face
concat_ws('_', array('www', 'face'), array('book', 'com', '1234')),
concat_ws('**', 'www', array('face'), array('book', 'com', '1234')),
concat_ws('[]', array('www'), 'face', array('book', 'com', '1234')),
- concat_ws('AAA', array('www'), array('face', 'book', 'com'), '1234') FROM dest1 LIMIT 1;
+ concat_ws('AAA', array('www'), array('face', 'book', 'com'), '1234') FROM dest1 tablesample (1 rows);
SELECT concat_ws('.', array('www', 'face', 'book', 'com'), '1234'),
concat_ws('-', 'www', array('face', 'book', 'com'), '1234'),
@@ -32,7 +34,7 @@ SELECT concat_ws('.', array('www', 'face
concat_ws('_', array('www', 'face'), array('book', 'com', '1234')),
concat_ws('**', 'www', array('face'), array('book', 'com', '1234')),
concat_ws('[]', array('www'), 'face', array('book', 'com', '1234')),
- concat_ws('AAA', array('www'), array('face', 'book', 'com'), '1234') FROM dest1 LIMIT 1;
+ concat_ws('AAA', array('www'), array('face', 'book', 'com'), '1234') FROM dest1 tablesample (1 rows);
SELECT concat_ws(NULL, array('www', 'face', 'book', 'com'), '1234'),
concat_ws(NULL, 'www', array('face', 'book', 'com'), '1234'),
@@ -40,4 +42,4 @@ SELECT concat_ws(NULL, array('www', 'fac
concat_ws(NULL, array('www', 'face'), array('book', 'com', '1234')),
concat_ws(NULL, 'www', array('face'), array('book', 'com', '1234')),
concat_ws(NULL, array('www'), 'face', array('book', 'com', '1234')),
- concat_ws(NULL, array('www'), array('face', 'book', 'com'), '1234') FROM dest1 LIMIT 1;
+ concat_ws(NULL, array('www'), array('face', 'book', 'com'), '1234') FROM dest1 tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_conv.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_conv.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_conv.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_conv.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION conv;
DESCRIBE FUNCTION EXTENDED conv;
@@ -9,7 +11,7 @@ SELECT
conv('22', 10, 10),
conv('110011', 2, 16),
conv('facebook', 36, 16)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-- Test negative numbers. If to_base is positive, the number should be handled
-- as a two's complement (64-bit)
@@ -18,7 +20,7 @@ SELECT
conv('1011', 2, -16),
conv('-1', 10, 16),
conv('-15', 10, 16)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-- Test overflow. If a number is two large, the result should be -1 (if signed)
-- or MAX_LONG (if unsigned)
@@ -27,7 +29,7 @@ SELECT
conv('9223372036854775807', 36, -16),
conv('-9223372036854775807', 36, 16),
conv('-9223372036854775807', 36, -16)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-- Test with invalid input. If one of the bases is invalid, the result should
-- be NULL. If there is an invalid digit in the number, the longest valid
@@ -37,7 +39,7 @@ SELECT
conv('131', 1, 5),
conv('515', 5, 100),
conv('10', -2, 2)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-- Perform the same tests with number arguments.
@@ -45,31 +47,31 @@ SELECT
conv(4521, 10, 36),
conv(22, 10, 10),
conv(110011, 2, 16)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
conv(-641, 10, -10),
conv(1011, 2, -16),
conv(-1, 10, 16),
conv(-15, 10, 16)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
conv(9223372036854775807, 36, 16),
conv(9223372036854775807, 36, -16),
conv(-9223372036854775807, 36, 16),
conv(-9223372036854775807, 36, -16)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
conv(123455, 3, 10),
conv(131, 1, 5),
conv(515, 5, 100),
conv('10', -2, 2)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-- Make sure that state is properly reset.
SELECT conv(key, 10, 16),
conv(key, 16, 10)
-FROM src LIMIT 3;
+FROM src tablesample (3 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_cos.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_cos.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_cos.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_cos.q Tue Nov 5 07:01:32 2013
@@ -1,8 +1,10 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION cos;
DESCRIBE FUNCTION EXTENDED cos;
SELECT cos(null)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT cos(0.98), cos(1.57), cos(-0.5)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_degrees.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_degrees.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_degrees.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_degrees.q Tue Nov 5 07:01:32 2013
@@ -1,14 +1,16 @@
-explain
-select degrees(PI()) FROM src LIMIT 1;
+set hive.fetch.task.conversion=more;
+
+explain
+select degrees(PI()) FROM src tablesample (1 rows);
-select degrees(PI()) FROM src LIMIT 1;
+select degrees(PI()) FROM src tablesample (1 rows);
DESCRIBE FUNCTION degrees;
DESCRIBE FUNCTION EXTENDED degrees;
explain
-select degrees(PI()) FROM src LIMIT 1;
+select degrees(PI()) FROM src tablesample (1 rows);
-select degrees(PI()) FROM src LIMIT 1;
+select degrees(PI()) FROM src tablesample (1 rows);
DESCRIBE FUNCTION degrees;
DESCRIBE FUNCTION EXTENDED degrees;
\ No newline at end of file
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_div.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_div.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_div.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_div.q Tue Nov 5 07:01:32 2013
@@ -1,4 +1,6 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION div;
DESCRIBE FUNCTION EXTENDED div;
-SELECT 3 DIV 2 FROM SRC LIMIT 1;
+SELECT 3 DIV 2 FROM SRC tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_divide.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_divide.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_divide.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_divide.q Tue Nov 5 07:01:32 2013
@@ -1,4 +1,6 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION /;
DESCRIBE FUNCTION EXTENDED /;
-SELECT 3 / 2 FROM SRC LIMIT 1;
+SELECT 3 / 2 FROM SRC tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_elt.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_elt.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_elt.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_elt.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION elt;
DESCRIBE FUNCTION EXTENDED elt;
@@ -13,7 +15,7 @@ SELECT elt(2, 'abc', 'defg'),
elt(null, 'abc', 'defg'),
elt(0, 'abc', 'defg'),
elt(3, 'abc', 'defg')
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT elt(2, 'abc', 'defg'),
elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
@@ -26,4 +28,4 @@ SELECT elt(2, 'abc', 'defg'),
elt(null, 'abc', 'defg'),
elt(0, 'abc', 'defg'),
elt(3, 'abc', 'defg')
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_equal.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_equal.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_equal.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_equal.q Tue Nov 5 07:01:32 2013
@@ -1,12 +1,14 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION =;
DESCRIBE FUNCTION EXTENDED =;
DESCRIBE FUNCTION ==;
DESCRIBE FUNCTION EXTENDED ==;
-SELECT true=false, false=true, false=false, true=true, NULL=NULL, true=NULL, NULL=true, false=NULL, NULL=false FROM src LIMIT 1;
+SELECT true=false, false=true, false=false, true=true, NULL=NULL, true=NULL, NULL=true, false=NULL, NULL=false FROM src tablesample (1 rows);
DESCRIBE FUNCTION <=>;
DESCRIBE FUNCTION EXTENDED <=>;
-SELECT true<=>false, false<=>true, false<=>false, true<=>true, NULL<=>NULL, true<=>NULL, NULL<=>true, false<=>NULL, NULL<=>false FROM src LIMIT 1;
+SELECT true<=>false, false<=>true, false<=>false, true<=>true, NULL<=>NULL, true<=>NULL, NULL<=>true, false<=>NULL, NULL<=>false FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_explode.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_explode.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_explode.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_explode.q Tue Nov 5 07:01:32 2013
@@ -1,22 +1,24 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION explode;
DESCRIBE FUNCTION EXTENDED explode;
-EXPLAIN EXTENDED SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3;
-EXPLAIN EXTENDED SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol;
+EXPLAIN EXTENDED SELECT explode(array(1,2,3)) AS myCol FROM src tablesample (1 rows);
+EXPLAIN EXTENDED SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src tablesample (1 rows)) a GROUP BY a.myCol;
-SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3;
-SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3;
-SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol;
+SELECT explode(array(1,2,3)) AS myCol FROM src tablesample (1 rows);
+SELECT explode(array(1,2,3)) AS (myCol) FROM src tablesample (1 rows);
+SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src tablesample (1 rows)) a GROUP BY a.myCol;
-EXPLAIN EXTENDED SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src LIMIT 3;
-EXPLAIN EXTENDED SELECT a.key, a.val, count(1) FROM (SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src LIMIT 3) a GROUP BY a.key, a.val;
+EXPLAIN EXTENDED SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src tablesample (1 rows);
+EXPLAIN EXTENDED SELECT a.key, a.val, count(1) FROM (SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src tablesample (1 rows)) a GROUP BY a.key, a.val;
-SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src LIMIT 3;
-SELECT a.key, a.val, count(1) FROM (SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src LIMIT 3) a GROUP BY a.key, a.val;
+SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src tablesample (1 rows);
+SELECT a.key, a.val, count(1) FROM (SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src tablesample (1 rows)) a GROUP BY a.key, a.val;
drop table lazy_array_map;
create table lazy_array_map (map_col map<int,string>, array_col array<string>);
-INSERT OVERWRITE TABLE lazy_array_map select map(1,'one',2,'two',3,'three'), array('100','200','300') FROM src LIMIT 1;
+INSERT OVERWRITE TABLE lazy_array_map select map(1,'one',2,'two',3,'three'), array('100','200','300') FROM src tablesample (1 rows);
SELECT array_col, myCol from lazy_array_map lateral view explode(array_col) X AS myCol;
SELECT map_col, myKey, myValue from lazy_array_map lateral view explode(map_col) X AS myKey, myValue;
\ No newline at end of file
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_field.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_field.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_field.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_field.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION field;
DESCRIBE FUNCTION EXTENDED field;
@@ -5,7 +7,7 @@ SELECT
field("x", "a", "b", "c", "d"),
field(NULL, "a", "b", "c", "d"),
field(0, 1, 2, 3, 4)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
field("a", "a", "b", "c", "d"),
@@ -13,7 +15,7 @@ SELECT
field("c", "a", "b", "c", "d"),
field("d", "a", "b", "c", "d"),
field("d", "a", "b", NULL, "d")
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
field(1, 1, 2, 3, 4),
@@ -21,11 +23,11 @@ SELECT
field(3, 1, 2, 3, 4),
field(4, 1, 2, 3, 4),
field(4, 1, 2, NULL, 4)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
CREATE TABLE test_table(col1 STRING, col2 STRING) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE test_table;
+LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE test_table;
select col1,col2,
field("66",col1),
@@ -42,7 +44,7 @@ from test_table where col1="86" or col1=
CREATE TABLE test_table1(col1 int, col2 string) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE test_table1;
+LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE test_table1;
select col1,col2,
field(66,col1),
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_find_in_set.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_find_in_set.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_find_in_set.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_find_in_set.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION find_in_set;
DESCRIBE FUNCTION EXTENDED find_in_set;
@@ -6,18 +8,18 @@ FROM src1 SELECT find_in_set(src1.key,co
FROM src1 SELECT find_in_set(src1.key,concat(src1.key,',',src1.value));
-SELECT find_in_set('ab','ab,abc,abcde') FROM src1 LIMIT 1;
-SELECT find_in_set('ab','abc,ab,bbb') FROM src1 LIMIT 1;
-SELECT find_in_set('ab','def,abc,ab') FROM src1 LIMIT 1;
-SELECT find_in_set('ab','abc,abd,abf') FROM src1 LIMIT 1;
-SELECT find_in_set(null,'a,b,c') FROM src1 LIMIT 1;
-SELECT find_in_set('a',null) FROM src1 LIMIT 1;
-SELECT find_in_set('', '') FROM src1 LIMIT 1;
-SELECT find_in_set('',',') FROM src1 LIMIT 1;
-SELECT find_in_set('','a,,b') FROM src1 LIMIT 1;
-SELECT find_in_set('','a,b,') FROM src1 LIMIT 1;
-SELECT find_in_set(',','a,b,d,') FROM src1 LIMIT 1;
-SELECT find_in_set('a','') FROM src1 LIMIT 1;
-SELECT find_in_set('a,','a,b,c,d') FROM src1 LIMIT 1;
+SELECT find_in_set('ab','ab,abc,abcde') FROM src1 tablesample (1 rows);
+SELECT find_in_set('ab','abc,ab,bbb') FROM src1 tablesample (1 rows);
+SELECT find_in_set('ab','def,abc,ab') FROM src1 tablesample (1 rows);
+SELECT find_in_set('ab','abc,abd,abf') FROM src1 tablesample (1 rows);
+SELECT find_in_set(null,'a,b,c') FROM src1 tablesample (1 rows);
+SELECT find_in_set('a',null) FROM src1 tablesample (1 rows);
+SELECT find_in_set('', '') FROM src1 tablesample (1 rows);
+SELECT find_in_set('',',') FROM src1 tablesample (1 rows);
+SELECT find_in_set('','a,,b') FROM src1 tablesample (1 rows);
+SELECT find_in_set('','a,b,') FROM src1 tablesample (1 rows);
+SELECT find_in_set(',','a,b,d,') FROM src1 tablesample (1 rows);
+SELECT find_in_set('a','') FROM src1 tablesample (1 rows);
+SELECT find_in_set('a,','a,b,c,d') FROM src1 tablesample (1 rows);
SELECT * FROM src1 WHERE NOT find_in_set(key,'311,128,345,2,956')=0;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_format_number.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_format_number.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_format_number.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_format_number.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
use default;
-- Test format_number() UDF
@@ -7,26 +9,26 @@ DESCRIBE FUNCTION EXTENDED format_number
EXPLAIN
SELECT format_number(12332.123456, 4),
format_number(12332.1,4),
- format_number(12332.2,0) FROM src limit 1;
+ format_number(12332.2,0) FROM src tablesample (1 rows);
SELECT format_number(12332.123456, 4),
format_number(12332.1,4),
format_number(12332.2,0)
-FROM src limit 1;
+FROM src tablesample (1 rows);
-- positive numbers
SELECT format_number(0.123456789, 12),
format_number(12345678.123456789, 5),
format_number(1234567.123456789, 7),
format_number(123456.123456789, 0)
-FROM src limit 1;
+FROM src tablesample (1 rows);
-- negative numbers
SELECT format_number(-123456.123456789, 0),
format_number(-1234567.123456789, 2),
format_number(-0.123456789, 15),
format_number(-12345.123456789, 4)
-FROM src limit 1;
+FROM src tablesample (1 rows);
-- zeros
SELECT format_number(0.0, 4),
@@ -34,7 +36,7 @@ SELECT format_number(0.0, 4),
format_number(000.0000, 1),
format_number(00000.0000, 1),
format_number(-00.0, 4)
-FROM src limit 1;
+FROM src tablesample (1 rows);
-- integers
SELECT format_number(0, 0),
@@ -42,7 +44,7 @@ SELECT format_number(0, 0),
format_number(12, 2),
format_number(123, 5),
format_number(1234, 7)
-FROM src limit 1;
+FROM src tablesample (1 rows);
-- long and double boundary
-- 9223372036854775807 is LONG_MAX
@@ -54,4 +56,4 @@ SELECT format_number(-922337203685477580
format_number(9223372036854775807, 20),
format_number(4.9E-324, 324),
format_number(1.7976931348623157E308, 308)
-FROM src limit 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_get_json_object.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_get_json_object.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_get_json_object.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_get_json_object.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION get_json_object;
DESCRIBE FUNCTION EXTENDED get_json_object;
@@ -5,6 +7,8 @@ CREATE TABLE dest1(c1 STRING) STORED AS
FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86;
+set hive.fetch.task.conversion=more;
+
EXPLAIN
SELECT get_json_object(src_json.json, '$.owner') FROM src_json;
@@ -33,8 +37,8 @@ SELECT get_json_object(src_json.json, '$
CREATE TABLE dest2(c1 STRING) STORED AS RCFILE;
-INSERT OVERWRITE TABLE dest2 SELECT '{"a":"b\nc"}' FROM src LIMIT 1;
+INSERT OVERWRITE TABLE dest2 SELECT '{"a":"b\nc"}' FROM src tablesample (1 rows);
SELECT * FROM dest2;
-SELECT get_json_object(c1, '$.a') FROM dest2;
\ No newline at end of file
+SELECT get_json_object(c1, '$.a') FROM dest2;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_greaterthan.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_greaterthan.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_greaterthan.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_greaterthan.q Tue Nov 5 07:01:32 2013
@@ -1,4 +1,6 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION >;
DESCRIBE FUNCTION EXTENDED >;
-SELECT true>false, false>true, false>false, true>true FROM src LIMIT 1;
\ No newline at end of file
+SELECT true>false, false>true, false>false, true>true FROM src tablesample (1 rows);
\ No newline at end of file
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_greaterthanorequal.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_greaterthanorequal.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_greaterthanorequal.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_greaterthanorequal.q Tue Nov 5 07:01:32 2013
@@ -1,4 +1,6 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION >=;
DESCRIBE FUNCTION EXTENDED >=;
-SELECT true>=false, false>=true, false>=false, true>=true FROM src LIMIT 1;
\ No newline at end of file
+SELECT true>=false, false>=true, false>=false, true>=true FROM src tablesample (1 rows);
\ No newline at end of file
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_hash.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_hash.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_hash.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_hash.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION hash;
DESCRIBE FUNCTION EXTENDED hash;
@@ -7,11 +9,11 @@ SELECT hash(CAST(1 AS TINYINT)), hash(CA
hash(CAST(1.25 AS FLOAT)), hash(CAST(16.0 AS DOUBLE)),
hash('400'), hash('abc'), hash(TRUE), hash(FALSE),
hash(1, 2, 3)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT hash(CAST(1 AS TINYINT)), hash(CAST(2 AS SMALLINT)),
hash(3), hash(CAST('123456789012' AS BIGINT)),
hash(CAST(1.25 AS FLOAT)), hash(CAST(16.0 AS DOUBLE)),
hash('400'), hash('abc'), hash(TRUE), hash(FALSE),
hash(1, 2, 3)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_hex.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_hex.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_hex.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_hex.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION hex;
DESCRIBE FUNCTION EXTENDED hex;
@@ -7,14 +9,14 @@ SELECT
hex('Facebook'),
hex('\0'),
hex('qwertyuiopasdfghjkl')
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-- If the argument is a number, hex should convert it to hexadecimal.
SELECT
hex(1),
hex(0),
hex(4207849477)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-- Negative numbers should be treated as two's complement (64 bit).
-SELECT hex(-5) FROM src LIMIT 1;
+SELECT hex(-5) FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_hour.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_hour.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_hour.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_hour.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION hour;
DESCRIBE FUNCTION EXTENDED hour;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_if.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_if.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_if.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_if.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION if;
DESCRIBE FUNCTION EXTENDED if;
@@ -8,7 +10,7 @@ SELECT IF(TRUE, 1, 2) AS COL1,
IF(2=2, 1, NULL) AS COL4,
IF(2=2, NULL, 1) AS COL5,
IF(IF(TRUE, NULL, FALSE), 1, 2) AS COL6
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT IF(TRUE, 1, 2) AS COL1,
@@ -17,7 +19,7 @@ SELECT IF(TRUE, 1, 2) AS COL1,
IF(2=2, 1, NULL) AS COL4,
IF(2=2, NULL, 1) AS COL5,
IF(IF(TRUE, NULL, FALSE), 1, 2) AS COL6
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-- Type conversions
EXPLAIN
@@ -25,10 +27,10 @@ SELECT IF(TRUE, CAST(128 AS SMALLINT), C
IF(FALSE, 1, 1.1) AS COL2,
IF(FALSE, 1, 'ABC') AS COL3,
IF(FALSE, 'ABC', 12.3) AS COL4
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT IF(TRUE, CAST(128 AS SMALLINT), CAST(1 AS TINYINT)) AS COL1,
IF(FALSE, 1, 1.1) AS COL2,
IF(FALSE, 1, 'ABC') AS COL3,
IF(FALSE, 'ABC', 12.3) AS COL4
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_in.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_in.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_in.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_in.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
SELECT 1 IN (1, 2, 3),
4 IN (1, 2, 3),
array(1,2,3) IN (array(1,2,3)),
@@ -8,6 +10,6 @@ SELECT 1 IN (1, 2, 3),
1 IN (1, 2, 3) OR false IN(false),
NULL IN (1, 2, 3),
4 IN (1, 2, 3, NULL),
- (1+3) IN (5, 6, (1+2) + 1) FROM src LIMIT 1;
+ (1+3) IN (5, 6, (1+2) + 1) FROM src tablesample (1 rows);
SELECT key FROM src WHERE key IN ("238", 86);
\ No newline at end of file
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_in_file.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_in_file.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_in_file.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_in_file.q Tue Nov 5 07:01:32 2013
@@ -1,12 +1,12 @@
DESCRIBE FUNCTION in_file;
EXPLAIN
-SELECT in_file("303", "../data/files/test2.dat"),
- in_file("304", "../data/files/test2.dat"),
- in_file(CAST(NULL AS STRING), "../data/files/test2.dat")
+SELECT in_file("303", "../../data/files/test2.dat"),
+ in_file("304", "../../data/files/test2.dat"),
+ in_file(CAST(NULL AS STRING), "../../data/files/test2.dat")
FROM src LIMIT 1;
-SELECT in_file("303", "../data/files/test2.dat"),
- in_file("304", "../data/files/test2.dat"),
- in_file(CAST(NULL AS STRING), "../data/files/test2.dat")
+SELECT in_file("303", "../../data/files/test2.dat"),
+ in_file("304", "../../data/files/test2.dat"),
+ in_file(CAST(NULL AS STRING), "../../data/files/test2.dat")
FROM src LIMIT 1;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_inline.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_inline.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_inline.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_inline.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
describe function inline;
explain SELECT inline(
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_instr.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_instr.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_instr.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_instr.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION instr;
DESCRIBE FUNCTION EXTENDED instr;
@@ -15,7 +17,7 @@ SELECT instr('abcd', 'abc'),
instr(CAST(16.0 AS DOUBLE), '.0'),
instr(null, 'abc'),
instr('abcd', null)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT instr('abcd', 'abc'),
instr('abcabc', 'ccc'),
@@ -30,4 +32,4 @@ SELECT instr('abcd', 'abc'),
instr(CAST(16.0 AS DOUBLE), '.0'),
instr(null, 'abc'),
instr('abcd', null)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_isnull_isnotnull.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_isnull_isnotnull.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_isnull_isnotnull.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_isnull_isnotnull.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION isnull;
DESCRIBE FUNCTION EXTENDED isnull;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_java_method.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_java_method.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_java_method.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_java_method.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION java_method;
DESCRIBE FUNCTION EXTENDED java_method;
@@ -11,7 +13,7 @@ SELECT java_method("java.lang.String", "
java_method("java.lang.Math", "round", 2.5),
java_method("java.lang.Math", "exp", 1.0),
java_method("java.lang.Math", "floor", 1.9)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT java_method("java.lang.String", "valueOf", 1),
@@ -21,5 +23,5 @@ SELECT java_method("java.lang.String", "
java_method("java.lang.Math", "round", 2.5),
java_method("java.lang.Math", "exp", 1.0),
java_method("java.lang.Math", "floor", 1.9)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_length.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_length.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_length.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_length.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION length;
DESCRIBE FUNCTION EXTENDED length;
@@ -9,6 +11,6 @@ DROP TABLE dest1;
-- Test with non-ascii characters.
CREATE TABLE dest1(name STRING) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/kv4.txt' INTO TABLE dest1;
+LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1;
EXPLAIN SELECT length(dest1.name) FROM dest1;
SELECT length(dest1.name) FROM dest1;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_lessthan.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_lessthan.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_lessthan.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_lessthan.q Tue Nov 5 07:01:32 2013
@@ -1,4 +1,6 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION <;
DESCRIBE FUNCTION EXTENDED <;
-SELECT true<false, false<true, false<false, true<true FROM src LIMIT 1;
+SELECT true<false, false<true, false<false, true<true FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_lessthanorequal.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_lessthanorequal.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_lessthanorequal.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_lessthanorequal.q Tue Nov 5 07:01:32 2013
@@ -1,4 +1,6 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION <=;
DESCRIBE FUNCTION EXTENDED <=;
-SELECT true<=false, false<=true, false<=false, true<=true FROM src LIMIT 1;
+SELECT true<=false, false<=true, false<=false, true<=true FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_like.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_like.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_like.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_like.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION like;
DESCRIBE FUNCTION EXTENDED like;
@@ -18,4 +20,4 @@ SELECT '1+2' LIKE '_+_',
'112' LIKE '1+_',
'|||' LIKE '|_|',
'+++' LIKE '1+_'
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_locate.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_locate.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_locate.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_locate.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION locate;
DESCRIBE FUNCTION EXTENDED locate;
@@ -19,7 +21,7 @@ SELECT locate('abc', 'abcd'),
locate('abc', null),
locate('abc', 'abcd', null),
locate('abc', 'abcd', 'invalid number')
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT locate('abc', 'abcd'),
locate('ccc', 'abcabc'),
@@ -38,4 +40,4 @@ SELECT locate('abc', 'abcd'),
locate('abc', null),
locate('abc', 'abcd', null),
locate('abc', 'abcd', 'invalid number')
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_logic_java_boolean.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_logic_java_boolean.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_logic_java_boolean.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_logic_java_boolean.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
EXPLAIN
CREATE TEMPORARY FUNCTION test_udf_get_java_boolean AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestGetJavaBoolean';
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_lpad.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_lpad.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_lpad.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_lpad.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION lpad;
DESCRIBE FUNCTION EXTENDED lpad;
@@ -5,10 +7,10 @@ EXPLAIN SELECT
lpad('hi', 1, '?'),
lpad('hi', 5, '.'),
lpad('hi', 6, '123')
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
lpad('hi', 1, '?'),
lpad('hi', 5, '.'),
lpad('hi', 6, '123')
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_map.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_map.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_map.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_map.q Tue Nov 5 07:01:32 2013
@@ -1,8 +1,10 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION map;
DESCRIBE FUNCTION EXTENDED map;
EXPLAIN SELECT map(), map(1, "a", 2, "b", 3, "c"), map(1, 2, "a", "b"),
-map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src LIMIT 1;
+map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src tablesample (1 rows);
SELECT map(), map(1, "a", 2, "b", 3, "c"), map(1, 2, "a", "b"),
-map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src LIMIT 1;
+map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_map_keys.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_map_keys.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_map_keys.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_map_keys.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
use default;
-- Test map_keys() UDF
@@ -5,7 +7,7 @@ DESCRIBE FUNCTION map_keys;
DESCRIBE FUNCTION EXTENDED map_keys;
-- Evaluate function against INT valued keys
-SELECT map_keys(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1;
+SELECT map_keys(map(1, "a", 2, "b", 3, "c")) FROM src tablesample (1 rows);
-- Evaluate function against STRING valued keys
-SELECT map_keys(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1;
+SELECT map_keys(map("a", 1, "b", 2, "c", 3)) FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_map_values.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_map_values.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_map_values.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_map_values.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
use default;
-- Test map_values() UDF
@@ -5,7 +7,7 @@ DESCRIBE FUNCTION map_values;
DESCRIBE FUNCTION EXTENDED map_values;
-- Evaluate function against STRING valued values
-SELECT map_values(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1;
+SELECT map_values(map(1, "a", 2, "b", 3, "c")) FROM src tablesample (1 rows);
-- Evaluate function against INT valued keys
-SELECT map_values(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1;
+SELECT map_values(map("a", 1, "b", 2, "c", 3)) FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_named_struct.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_named_struct.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_named_struct.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_named_struct.q Tue Nov 5 07:01:32 2013
@@ -1,9 +1,11 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION named_struct;
DESCRIBE FUNCTION EXTENDED named_struct;
EXPLAIN
SELECT named_struct("foo", 1, "bar", 2),
- named_struct("foo", 1, "bar", 2).foo FROM src LIMIT 1;
+ named_struct("foo", 1, "bar", 2).foo FROM src tablesample (1 rows);
SELECT named_struct("foo", 1, "bar", 2),
- named_struct("foo", 1, "bar", 2).foo FROM src LIMIT 1;
+ named_struct("foo", 1, "bar", 2).foo FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_negative.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_negative.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_negative.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_negative.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION negative;
DESCRIBE FUNCTION EXTENDED negative;
@@ -5,9 +7,9 @@ DESCRIBE FUNCTION EXTENDED negative;
DESCRIBE FUNCTION -;
DESCRIBE FUNCTION EXTENDED -;
-select - null from src limit 1;
-select - cast(null as int) from src limit 1;
-select - cast(null as smallint) from src limit 1;
-select - cast(null as bigint) from src limit 1;
-select - cast(null as double) from src limit 1;
-select - cast(null as float) from src limit 1;
+select - null from src tablesample (1 rows);
+select - cast(null as int) from src tablesample (1 rows);
+select - cast(null as smallint) from src tablesample (1 rows);
+select - cast(null as bigint) from src tablesample (1 rows);
+select - cast(null as double) from src tablesample (1 rows);
+select - cast(null as float) from src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_notequal.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_notequal.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_notequal.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_notequal.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION <>;
DESCRIBE FUNCTION EXTENDED <>;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_notop.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_notop.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_notop.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_notop.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
SELECT 1 NOT IN (1, 2, 3),
4 NOT IN (1, 2, 3),
1 = 2 NOT IN (true, false),
@@ -7,4 +9,4 @@ SELECT 1 NOT IN (1, 2, 3),
"abc" NOT RLIKE "^bc",
"abc" NOT REGEXP "^ab",
"abc" NOT REGEXP "^bc",
- 1 IN (1, 2) AND "abc" NOT LIKE "bc%" FROM src LIMIT 1;
+ 1 IN (1, 2) AND "abc" NOT LIKE "bc%" FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_nvl.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_nvl.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_nvl.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_nvl.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,4 @@
+set hive.fetch.task.conversion=more;
DESCRIBE FUNCTION nvl;
DESCRIBE FUNCTION EXTENDED nvl;
@@ -5,9 +6,9 @@ DESCRIBE FUNCTION EXTENDED nvl;
EXPLAIN
SELECT NVL( 1 , 2 ) AS COL1,
NVL( NULL, 5 ) AS COL2
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT NVL( 1 , 2 ) AS COL1,
NVL( NULL, 5 ) AS COL2
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_pmod.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_pmod.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_pmod.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_pmod.q Tue Nov 5 07:01:32 2013
@@ -1,20 +1,22 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION pmod;
DESCRIBE FUNCTION EXTENDED pmod;
SELECT pmod(null, null)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT pmod(-100,9), pmod(-50,101), pmod(-1000,29)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT pmod(100,19), pmod(50,125), pmod(300,15)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-SELECT pmod(CAST(-100 AS TINYINT),CAST(9 AS TINYINT)), pmod(CAST(-50 AS TINYINT),CAST(101 AS TINYINT)), pmod(CAST(-100 AS TINYINT),CAST(29 AS TINYINT)) FROM src LIMIT 1;
-SELECT pmod(CAST(-100 AS SMALLINT),CAST(9 AS SMALLINT)), pmod(CAST(-50 AS SMALLINT),CAST(101 AS SMALLINT)), pmod(CAST(-100 AS SMALLINT),CAST(29 AS SMALLINT)) FROM src LIMIT 1;
-SELECT pmod(CAST(-100 AS BIGINT),CAST(9 AS BIGINT)), pmod(CAST(-50 AS BIGINT),CAST(101 AS BIGINT)), pmod(CAST(-100 AS BIGINT),CAST(29 AS BIGINT)) FROM src LIMIT 1;
-
-SELECT pmod(CAST(-100.91 AS FLOAT),CAST(9.8 AS FLOAT)), pmod(CAST(-50.1 AS FLOAT),CAST(101.8 AS FLOAT)), pmod(CAST(-100.91 AS FLOAT),CAST(29.75 AS FLOAT)) FROM src LIMIT 1;
-SELECT pmod(CAST(-100.91 AS DOUBLE),CAST(9.8 AS DOUBLE)), pmod(CAST(-50.1 AS DOUBLE),CAST(101.8 AS DOUBLE)), pmod(CAST(-100.91 AS DOUBLE),CAST(29.75 AS DOUBLE)) FROM src LIMIT 1;
-SELECT pmod(CAST(-100.91 AS DECIMAL(5,2)),CAST(9.8 AS DECIMAL(2,1))), pmod(CAST(-50.1 AS DECIMAL(3,1)),CAST(101.8 AS DECIMAL(4,1))), pmod(CAST(-100.91 AS DECIMAL(5,2)),CAST(29.75 AS DECIMAL(4,2))) FROM src LIMIT 1;
+SELECT pmod(CAST(-100 AS TINYINT),CAST(9 AS TINYINT)), pmod(CAST(-50 AS TINYINT),CAST(101 AS TINYINT)), pmod(CAST(-100 AS TINYINT),CAST(29 AS TINYINT)) FROM src tablesample (1 rows);
+SELECT pmod(CAST(-100 AS SMALLINT),CAST(9 AS SMALLINT)), pmod(CAST(-50 AS SMALLINT),CAST(101 AS SMALLINT)), pmod(CAST(-100 AS SMALLINT),CAST(29 AS SMALLINT)) FROM src tablesample (1 rows);
+SELECT pmod(CAST(-100 AS BIGINT),CAST(9 AS BIGINT)), pmod(CAST(-50 AS BIGINT),CAST(101 AS BIGINT)), pmod(CAST(-100 AS BIGINT),CAST(29 AS BIGINT)) FROM src tablesample (1 rows);
+
+SELECT pmod(CAST(-100.91 AS FLOAT),CAST(9.8 AS FLOAT)), pmod(CAST(-50.1 AS FLOAT),CAST(101.8 AS FLOAT)), pmod(CAST(-100.91 AS FLOAT),CAST(29.75 AS FLOAT)) FROM src tablesample (1 rows);
+SELECT pmod(CAST(-100.91 AS DOUBLE),CAST(9.8 AS DOUBLE)), pmod(CAST(-50.1 AS DOUBLE),CAST(101.8 AS DOUBLE)), pmod(CAST(-100.91 AS DOUBLE),CAST(29.75 AS DOUBLE)) FROM src tablesample (1 rows);
+SELECT pmod(CAST(-100.91 AS DECIMAL(5,2)),CAST(9.8 AS DECIMAL(2,1))), pmod(CAST(-50.1 AS DECIMAL(3,1)),CAST(101.8 AS DECIMAL(4,1))), pmod(CAST(-100.91 AS DECIMAL(5,2)),CAST(29.75 AS DECIMAL(4,2))) FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_printf.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_printf.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_printf.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_printf.q Tue Nov 5 07:01:32 2013
@@ -4,21 +4,23 @@ use default;
DESCRIBE FUNCTION printf;
DESCRIBE FUNCTION EXTENDED printf;
+set hive.fetch.task.conversion=more;
+
EXPLAIN
-SELECT printf("Hello World %d %s", 100, "days") FROM src LIMIT 1;
+SELECT printf("Hello World %d %s", 100, "days") FROM src tablesample (1 rows);
-- Test Primitive Types
-SELECT printf("Hello World %d %s", 100, "days") FROM src LIMIT 1;
-SELECT printf("All Type Test: %b, %c, %d, %e, %+10.4f, %g, %h, %s, %a", false, 65, 15000, 12.3400, 27183.240051, 2300.41, 50, "corret", 256.125) FROM src LIMIT 1;
+SELECT printf("Hello World %d %s", 100, "days") FROM src tablesample (1 rows);
+SELECT printf("All Type Test: %b, %c, %d, %e, %+10.4f, %g, %h, %s, %a", false, 65, 15000, 12.3400, 27183.240051, 2300.41, 50, "corret", 256.125) FROM src tablesample (1 rows);
-- Test NULL Values
-SELECT printf("Color %s, String Null: %s, number1 %d, number2 %05d, Integer Null: %d, hex %#x, float %5.2f Double Null: %f\n", "red", NULL, 123456, 89, NULL, 255, 3.14159, NULL) FROM src LIMIT 1;
+SELECT printf("Color %s, String Null: %s, number1 %d, number2 %05d, Integer Null: %d, hex %#x, float %5.2f Double Null: %f\n", "red", NULL, 123456, 89, NULL, 255, 3.14159, NULL) FROM src tablesample (1 rows);
-- Test Timestamp
create table timestamp_udf (t timestamp);
-from src
+from (select * from src tablesample (1 rows)) s
insert overwrite table timestamp_udf
- select '2011-05-06 07:08:09.1234567' limit 1;
+ select '2011-05-06 07:08:09.1234567';
select printf("timestamp: %s", t) from timestamp_udf;
drop table timestamp_udf;
@@ -27,7 +29,7 @@ CREATE TABLE binay_udf(key binary, value
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '9'
STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/string.txt' INTO TABLE binay_udf;
+LOAD DATA LOCAL INPATH '../../data/files/string.txt' INTO TABLE binay_udf;
create table dest1 (key binary, value int);
insert overwrite table dest1 select transform(*) using 'cat' as key binary, value int from binay_udf;
select value, printf("format key: %s", key) from dest1;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_radians.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_radians.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_radians.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_radians.q Tue Nov 5 07:01:32 2013
@@ -1,16 +1,18 @@
-explain
-select radians(57.2958) FROM src LIMIT 1;
+set hive.fetch.task.conversion=more;
+
+explain
+select radians(57.2958) FROM src tablesample (1 rows);
-select radians(57.2958) FROM src LIMIT 1;
-select radians(143.2394) FROM src LIMIT 1;
+select radians(57.2958) FROM src tablesample (1 rows);
+select radians(143.2394) FROM src tablesample (1 rows);
DESCRIBE FUNCTION radians;
DESCRIBE FUNCTION EXTENDED radians;
explain
-select radians(57.2958) FROM src LIMIT 1;
+select radians(57.2958) FROM src tablesample (1 rows);
-select radians(57.2958) FROM src LIMIT 1;
-select radians(143.2394) FROM src LIMIT 1;
+select radians(57.2958) FROM src tablesample (1 rows);
+select radians(143.2394) FROM src tablesample (1 rows);
DESCRIBE FUNCTION radians;
DESCRIBE FUNCTION EXTENDED radians;
\ No newline at end of file
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_reflect.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_reflect.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_reflect.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_reflect.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION reflect;
DESCRIBE FUNCTION EXTENDED reflect;
@@ -10,7 +12,7 @@ SELECT reflect("java.lang.String", "valu
reflect("java.lang.Math", "exp", 1.0),
reflect("java.lang.Math", "floor", 1.9),
reflect("java.lang.Integer", "valueOf", key, 16)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT reflect("java.lang.String", "valueOf", 1),
@@ -21,4 +23,4 @@ SELECT reflect("java.lang.String", "valu
reflect("java.lang.Math", "exp", 1.0),
reflect("java.lang.Math", "floor", 1.9),
reflect("java.lang.Integer", "valueOf", key, 16)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_reflect2.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_reflect2.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_reflect2.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_reflect2.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION reflect2;
DESCRIBE FUNCTION EXTENDED reflect2;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_regexp.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_regexp.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_regexp.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_regexp.q Tue Nov 5 07:01:32 2013
@@ -1,6 +1,8 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION regexp;
DESCRIBE FUNCTION EXTENDED regexp;
SELECT 'fofo' REGEXP '^fo', 'fo\no' REGEXP '^fo\no$', 'Bn' REGEXP '^Ba*n', 'afofo' REGEXP 'fo',
'afofo' REGEXP '^fo', 'Baan' REGEXP '^Ba?n', 'axe' REGEXP 'pi|apa', 'pip' REGEXP '^(pi)*$'
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_repeat.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_repeat.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_repeat.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_repeat.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION repeat;
DESCRIBE FUNCTION EXTENDED repeat;
@@ -6,11 +8,11 @@ EXPLAIN SELECT
repeat("", 4),
repeat("asd", 0),
repeat("asdf", -1)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
repeat("Facebook", 3),
repeat("", 4),
repeat("asd", 0),
repeat("asdf", -1)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_reverse.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_reverse.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_reverse.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_reverse.q Tue Nov 5 07:01:32 2013
@@ -11,5 +11,5 @@ DROP TABLE dest1;
-- kv4.txt contains the text 0xE982B5E993AE, which should be reversed to
-- 0xE993AEE982B5
CREATE TABLE dest1(name STRING) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../data/files/kv4.txt' INTO TABLE dest1;
+LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1;
SELECT count(1) FROM dest1 WHERE reverse(dest1.name) = _UTF-8 0xE993AEE982B5;
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_round.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_round.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_round.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_round.q Tue Nov 5 07:01:32 2013
@@ -1,15 +1,17 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION round;
DESCRIBE FUNCTION EXTENDED round;
SELECT round(null), round(null, 0), round(125, null),
round(1.0/0.0, 0), round(power(-1.0,0.5), 0)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
round(55555), round(55555, 0), round(55555, 1), round(55555, 2), round(55555, 3),
round(55555, -1), round(55555, -2), round(55555, -3), round(55555, -4),
round(55555, -5), round(55555, -6), round(55555, -7), round(55555, -8)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
round(125.315), round(125.315, 0),
@@ -18,7 +20,7 @@ SELECT
round(-125.315), round(-125.315, 0),
round(-125.315, 1), round(-125.315, 2), round(-125.315, 3), round(-125.315, 4),
round(-125.315, -1), round(-125.315, -2), round(-125.315, -3), round(-125.315, -4)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
round(3.141592653589793, -15), round(3.141592653589793, -16),
@@ -38,7 +40,7 @@ SELECT
round(3.141592653589793, 12), round(3.141592653589793, 13),
round(3.141592653589793, 13), round(3.141592653589793, 14),
round(3.141592653589793, 15), round(3.141592653589793, 16)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT round(1809242.3151111344, 9), round(-1809242.3151111344, 9)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_round_2.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_round_2.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_round_2.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_round_2.q Tue Nov 5 07:01:32 2013
@@ -1,8 +1,10 @@
--- test for NaN (not-a-number)
+set hive.fetch.task.conversion=more;
+
+-- test for NaN (not-a-number)
create table tstTbl1(n double);
insert overwrite table tstTbl1
-select 'NaN' from src limit 1;
+select 'NaN' from src tablesample (1 rows);
select * from tstTbl1;
@@ -10,4 +12,4 @@ select round(n, 1) from tstTbl1;
select round(n) from tstTbl1;
-- test for Infinity
-select round(1/0), round(1/0, 2), round(1.0/0.0), round(1.0/0.0, 2) from src limit 1;
+select round(1/0), round(1/0, 2), round(1.0/0.0), round(1.0/0.0, 2) from src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_round_3.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_round_3.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_round_3.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_round_3.q Tue Nov 5 07:01:32 2013
@@ -1,14 +1,16 @@
+set hive.fetch.task.conversion=more;
+
-- test for TINYINT
-select round(-128), round(127), round(0) from src limit 1;
+select round(-128), round(127), round(0) from src tablesample (1 rows);
-- test for SMALLINT
-select round(-32768), round(32767), round(-129), round(128) from src limit 1;
+select round(-32768), round(32767), round(-129), round(128) from src tablesample (1 rows);
-- test for INT
-select round(cast(negative(pow(2, 31)) as INT)), round(cast((pow(2, 31) - 1) as INT)), round(-32769), round(32768) from src limit 1;
+select round(cast(negative(pow(2, 31)) as INT)), round(cast((pow(2, 31) - 1) as INT)), round(-32769), round(32768) from src tablesample (1 rows);
-- test for BIGINT
-select round(cast(negative(pow(2, 63)) as BIGINT)), round(cast((pow(2, 63) - 1) as BIGINT)), round(cast(negative(pow(2, 31) + 1) as BIGINT)), round(cast(pow(2, 31) as BIGINT)) from src limit 1;
+select round(cast(negative(pow(2, 63)) as BIGINT)), round(cast((pow(2, 63) - 1) as BIGINT)), round(cast(negative(pow(2, 31) + 1) as BIGINT)), round(cast(pow(2, 31) as BIGINT)) from src tablesample (1 rows);
-- test for DOUBLE
-select round(126.1), round(126.7), round(32766.1), round(32766.7) from src limit 1;
+select round(126.1), round(126.7), round(32766.1), round(32766.7) from src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_rpad.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_rpad.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_rpad.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_rpad.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION rpad;
DESCRIBE FUNCTION EXTENDED rpad;
@@ -5,10 +7,10 @@ EXPLAIN SELECT
rpad('hi', 1, '?'),
rpad('hi', 5, '.'),
rpad('hi', 6, '123')
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
rpad('hi', 1, '?'),
rpad('hi', 5, '.'),
rpad('hi', 6, '123')
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/branches/tez/ql/src/test/queries/clientpositive/udf_second.q
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/queries/clientpositive/udf_second.q?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/queries/clientpositive/udf_second.q (original)
+++ hive/branches/tez/ql/src/test/queries/clientpositive/udf_second.q Tue Nov 5 07:01:32 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION second;
DESCRIBE FUNCTION EXTENDED second;