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/10/31 17:00:41 UTC
svn commit: r1537540 [2/10] - in /hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_array_contains.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_array_contains.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_array_contains.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_array_contains.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_ascii.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_ascii.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_ascii.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_ascii.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_asin.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_asin.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_asin.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_asin.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_atan.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_atan.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_atan.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_atan.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_between.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_between.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_between.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_between.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
describe function between;
describe function extended between;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_bin.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_bin.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_bin.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_bin.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_bitmap_and.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_bitmap_and.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_bitmap_and.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_bitmap_and.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_bitmap_empty.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_bitmap_empty.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_bitmap_empty.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_bitmap_empty.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_bitmap_or.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_bitmap_or.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_bitmap_or.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_bitmap_or.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_case.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_case.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_case.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_case.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_case_thrift.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_case_thrift.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_case_thrift.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_case_thrift.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_coalesce.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_coalesce.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_coalesce.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_coalesce.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_compare_java_string.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_compare_java_string.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_compare_java_string.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_compare_java_string.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_concat.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_concat.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_concat.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_concat.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_concat_ws.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_concat_ws.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_concat_ws.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_concat_ws.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_conv.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_conv.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_conv.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_conv.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_cos.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_cos.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_cos.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_cos.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_degrees.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_degrees.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_degrees.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_degrees.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_div.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_div.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_div.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_div.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_divide.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_divide.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_divide.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_divide.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_elt.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_elt.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_elt.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_elt.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_equal.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_equal.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_equal.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_equal.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_explode.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_explode.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_explode.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_explode.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_field.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_field.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_field.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_field.q Thu Oct 31 16:00:36 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,7 +23,7 @@ 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;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_find_in_set.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_find_in_set.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_find_in_set.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_find_in_set.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_format_number.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_format_number.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_format_number.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_format_number.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_get_json_object.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_get_json_object.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_get_json_object.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_get_json_object.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_greaterthan.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthan.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthan.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthan.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_greaterthanorequal.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthanorequal.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthanorequal.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthanorequal.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_hash.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_hash.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_hash.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_hash.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_hex.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_hex.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_hex.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_hex.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_hour.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_hour.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_hour.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_hour.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION hour;
DESCRIBE FUNCTION EXTENDED hour;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_if.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_if.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_if.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_if.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_in.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_in.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_in.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_in.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_inline.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_inline.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_inline.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_inline.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
describe function inline;
explain SELECT inline(
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_instr.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_instr.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_instr.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_instr.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_isnull_isnotnull.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_isnull_isnotnull.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_isnull_isnotnull.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_isnull_isnotnull.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION isnull;
DESCRIBE FUNCTION EXTENDED isnull;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_java_method.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_java_method.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_java_method.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_java_method.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_length.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_length.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_length.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_length.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION length;
DESCRIBE FUNCTION EXTENDED length;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_lessthan.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_lessthan.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_lessthan.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_lessthan.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_lessthanorequal.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_lessthanorequal.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_lessthanorequal.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_lessthanorequal.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_like.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_like.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_like.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_like.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_locate.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_locate.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_locate.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_locate.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_logic_java_boolean.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_logic_java_boolean.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_logic_java_boolean.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_logic_java_boolean.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_lpad.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_lpad.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_lpad.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_lpad.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_map.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_map.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_map.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_map.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_map_keys.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_map_keys.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_map_keys.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_map_keys.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_map_values.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_map_values.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_map_values.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_map_values.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_named_struct.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_named_struct.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_named_struct.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_named_struct.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_negative.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_negative.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_negative.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_negative.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_notequal.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_notequal.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_notequal.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_notequal.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION <>;
DESCRIBE FUNCTION EXTENDED <>;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_notop.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_notop.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_notop.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_notop.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_nvl.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_nvl.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_nvl.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_nvl.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_pmod.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_pmod.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_pmod.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_pmod.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_printf.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_printf.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_printf.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_printf.q Thu Oct 31 16:00:36 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;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_radians.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_radians.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_radians.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_radians.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_reflect.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_reflect.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_reflect.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_reflect.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_reflect2.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_reflect2.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_reflect2.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_reflect2.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION reflect2;
DESCRIBE FUNCTION EXTENDED reflect2;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_regexp.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_regexp.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_regexp.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_regexp.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_repeat.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_repeat.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_repeat.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_repeat.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_round.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_round.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_round.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_round.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_round_2.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_round_2.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_round_2.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_round_2.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_round_3.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_round_3.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_round_3.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_round_3.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_rpad.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_rpad.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_rpad.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_rpad.q Thu Oct 31 16:00:36 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/trunk/ql/src/test/queries/clientpositive/udf_second.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_second.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_second.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_second.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION second;
DESCRIBE FUNCTION EXTENDED second;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_sign.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_sign.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_sign.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_sign.q Thu Oct 31 16:00:36 2013
@@ -1,20 +1,22 @@
-explain
-select sign(0) FROM src LIMIT 1;
-select sign(0) FROM src LIMIT 1;
+set hive.fetch.task.conversion=more;
+
+explain
+select sign(0) FROM src tablesample (1 rows);
+select sign(0) FROM src tablesample (1 rows);
-select sign(-45) FROM src LIMIT 1;
+select sign(-45) FROM src tablesample (1 rows);
-select sign(46) FROM src LIMIT 1;
+select sign(46) FROM src tablesample (1 rows);
DESCRIBE FUNCTION sign;
DESCRIBE FUNCTION EXTENDED sign;
explain
-select sign(0) FROM src LIMIT 1;
-select sign(0) FROM src LIMIT 1;
+select sign(0) FROM src tablesample (1 rows);
+select sign(0) FROM src tablesample (1 rows);
-select sign(-45) FROM src LIMIT 1;
+select sign(-45) FROM src tablesample (1 rows);
-select sign(46) FROM src LIMIT 1;
+select sign(46) FROM src tablesample (1 rows);
DESCRIBE FUNCTION sign;
DESCRIBE FUNCTION EXTENDED sign;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_sin.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_sin.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_sin.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_sin.q Thu Oct 31 16:00:36 2013
@@ -1,8 +1,10 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION sin;
DESCRIBE FUNCTION EXTENDED sin;
SELECT sin(null)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT sin(0.98), sin(1.57), sin(-0.5)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_size.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_size.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_size.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_size.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION size;
DESCRIBE FUNCTION EXTENDED size;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_sort_array.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_sort_array.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_sort_array.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_sort_array.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
use default;
-- Test sort_array() UDF
@@ -6,16 +8,16 @@ DESCRIBE FUNCTION EXTENDED sort_array;
-- Evaluate function against STRING valued keys
EXPLAIN
-SELECT sort_array(array("b", "d", "c", "a")) FROM src LIMIT 1;
+SELECT sort_array(array("b", "d", "c", "a")) FROM src tablesample (1 rows);
-SELECT sort_array(array("f", "a", "g", "c", "b", "d", "e")) FROM src LIMIT 1;
-SELECT sort_array(sort_array(array("hadoop distributed file system", "enterprise databases", "hadoop map-reduce"))) FROM src LIMIT 1;
+SELECT sort_array(array("f", "a", "g", "c", "b", "d", "e")) FROM src tablesample (1 rows);
+SELECT sort_array(sort_array(array("hadoop distributed file system", "enterprise databases", "hadoop map-reduce"))) FROM src tablesample (1 rows);
-- Evaluate function against INT valued keys
-SELECT sort_array(array(2, 9, 7, 3, 5, 4, 1, 6, 8)) FROM src LIMIT 1;
+SELECT sort_array(array(2, 9, 7, 3, 5, 4, 1, 6, 8)) FROM src tablesample (1 rows);
-- Evaluate function against FLOAT valued keys
-SELECT sort_array(sort_array(array(2.333, 9, 1.325, 2.003, 0.777, -3.445, 1))) FROM src LIMIT 1;
+SELECT sort_array(sort_array(array(2.333, 9, 1.325, 2.003, 0.777, -3.445, 1))) FROM src tablesample (1 rows);
-- Test it against data in a table.
CREATE TABLE dest1 (
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_space.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_space.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_space.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_space.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION space;
DESCRIBE FUNCTION EXTENDED space;
@@ -7,7 +9,7 @@ EXPLAIN SELECT
space(1),
space(-1),
space(-100)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
length(space(10)),
@@ -15,7 +17,7 @@ SELECT
length(space(1)),
length(space(-1)),
length(space(-100))
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
space(10),
@@ -23,5 +25,5 @@ SELECT
space(1),
space(-1),
space(-100)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_split.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_split.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_split.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_split.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION split;
DESCRIBE FUNCTION EXTENDED split;
@@ -6,11 +8,11 @@ EXPLAIN SELECT
split('oneAtwoBthreeC', '[ABC]'),
split('', '.'),
split(50401020, 0)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
split('a b c', ' '),
split('oneAtwoBthreeC', '[ABC]'),
split('', '.'),
split(50401020, 0)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_struct.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_struct.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_struct.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_struct.q Thu Oct 31 16:00:36 2013
@@ -1,9 +1,11 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION struct;
DESCRIBE FUNCTION EXTENDED struct;
EXPLAIN
SELECT struct(1), struct(1, "a"), struct(1, "b", 1.5).col1, struct(1, struct("a", 1.5)).col2.col1
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT struct(1), struct(1, "a"), struct(1, "b", 1.5).col1, struct(1, struct("a", 1.5)).col2.col1
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_substr.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_substr.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_substr.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_substr.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION substr;
DESCRIBE FUNCTION EXTENDED substr;
@@ -5,7 +7,7 @@ SELECT
substr(null, 1), substr(null, 1, 1),
substr('ABC', null), substr('ABC', null, 1),
substr('ABC', 1, null)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
substr('ABC', 1, 0), substr('ABC', 1, -1), substr('ABC', 2, -100),
@@ -14,7 +16,7 @@ SELECT
substr('ABC', 100), substr('ABC', 100, 100),
substr('ABC', -100), substr('ABC', -100, 100),
substr('ABC', 2147483647), substr('ABC', 2147483647, 2147483647)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
substr('ABCDEFG', 3, 4), substr('ABCDEFG', -5, 4),
@@ -22,7 +24,7 @@ SELECT
substr('ABC', 0), substr('ABC', 1), substr('ABC', 2), substr('ABC', 3),
substr('ABC', 1, 2147483647), substr('ABC', 2, 2147483647),
substr('A', 0), substr('A', 1), substr('A', -1)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
substr('ABC', 0, 1), substr('ABC', 0, 2), substr('ABC', 0, 3), substr('ABC', 0, 4),
@@ -30,14 +32,14 @@ SELECT
substr('ABC', 2, 1), substr('ABC', 2, 2), substr('ABC', 2, 3), substr('ABC', 2, 4),
substr('ABC', 3, 1), substr('ABC', 3, 2), substr('ABC', 3, 3), substr('ABC', 3, 4),
substr('ABC', 4, 1)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT
substr('ABC', -1, 1), substr('ABC', -1, 2), substr('ABC', -1, 3), substr('ABC', -1, 4),
substr('ABC', -2, 1), substr('ABC', -2, 2), substr('ABC', -2, 3), substr('ABC', -2, 4),
substr('ABC', -3, 1), substr('ABC', -3, 2), substr('ABC', -3, 3), substr('ABC', -3, 4),
substr('ABC', -4, 1)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-- substring() is a synonim of substr(), so just perform some basic tests
SELECT
@@ -46,7 +48,7 @@ SELECT
substring('ABC', 0), substring('ABC', 1), substring('ABC', 2), substring('ABC', 3),
substring('ABC', 1, 2147483647), substring('ABC', 2, 2147483647),
substring('A', 0), substring('A', 1), substring('A', -1)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
-- test for binary substr
SELECT
@@ -63,7 +65,7 @@ SELECT
substr(ABC, -3, 1), substr(ABC, -3, 2), substr(ABC, -3, 3), substr(ABC, -3, 4),
substr(ABC, -4, 1)
FROM (
- select CAST(concat(substr(value, 1, 0), 'ABC') as BINARY) as ABC from src LIMIT 1
+ select CAST(concat(substr(value, 1, 0), 'ABC') as BINARY) as ABC from src tablesample (1 rows)
) X;
-- test UTF-8 substr
@@ -72,4 +74,4 @@ SELECT
substr("abc ç©", 5),
substr("abc ç©ç©ç© abc", 5),
substr("abc ç©ç©ç© abc", 5, 3)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_tan.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_tan.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_tan.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_tan.q Thu Oct 31 16:00:36 2013
@@ -1,16 +1,18 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION tan;
DESCRIBE FUNCTION EXTENDED tan;
SELECT tan(null)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT tan(1), tan(6), tan(-1.0)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
DESCRIBE FUNCTION tan;
DESCRIBE FUNCTION EXTENDED tan;
SELECT tan(null)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT tan(1), tan(6), tan(-1.0)
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_testlength.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_testlength.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_testlength.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_testlength.q Thu Oct 31 16:00:36 2013
@@ -1,12 +1,10 @@
+set hive.fetch.task.conversion=more;
+
EXPLAIN
CREATE TEMPORARY FUNCTION testlength AS 'org.apache.hadoop.hive.ql.udf.UDFTestLength';
CREATE TEMPORARY FUNCTION testlength AS 'org.apache.hadoop.hive.ql.udf.UDFTestLength';
-CREATE TABLE dest1(len INT);
-
-FROM src INSERT OVERWRITE TABLE dest1 SELECT testlength(src.value);
-
-SELECT dest1.* FROM dest1;
+SELECT testlength(src.value) FROM src;
DROP TEMPORARY FUNCTION testlength;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_testlength2.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_testlength2.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_testlength2.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_testlength2.q Thu Oct 31 16:00:36 2013
@@ -1,12 +1,10 @@
+set hive.fetch.task.conversion=more;
+
EXPLAIN
CREATE TEMPORARY FUNCTION testlength2 AS 'org.apache.hadoop.hive.ql.udf.UDFTestLength2';
CREATE TEMPORARY FUNCTION testlength2 AS 'org.apache.hadoop.hive.ql.udf.UDFTestLength2';
-CREATE TABLE dest1(len INT);
-
-FROM src INSERT OVERWRITE TABLE dest1 SELECT testlength2(src.value);
-
-SELECT dest1.* FROM dest1;
+SELECT testlength2(src.value) FROM src;
DROP TEMPORARY FUNCTION testlength2;