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 [3/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_to_boolean.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_to_boolean.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_to_boolean.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_to_boolean.q Thu Oct 31 16:00:36 2013
@@ -1,44 +1,46 @@
--- 'true' cases:
+set hive.fetch.task.conversion=more;
-SELECT CAST(CAST(1 AS TINYINT) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(2 AS SMALLINT) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(-4 AS INT) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(-444 AS BIGINT) AS BOOLEAN) FROM src LIMIT 1;
+-- 'true' cases:
-SELECT CAST(CAST(7.0 AS FLOAT) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(-8.0 AS DOUBLE) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(-99.0 AS DECIMAL) AS BOOLEAN) FROM src LIMIT 1;
+SELECT CAST(CAST(1 AS TINYINT) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(2 AS SMALLINT) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-4 AS INT) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-444 AS BIGINT) AS BOOLEAN) FROM src tablesample (1 rows);
-SELECT CAST(CAST('Foo' AS STRING) AS BOOLEAN) FROM src LIMIT 1;
+SELECT CAST(CAST(7.0 AS FLOAT) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-8.0 AS DOUBLE) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-99.0 AS DECIMAL) AS BOOLEAN) FROM src tablesample (1 rows);
-SELECT CAST(CAST('2011-05-06 07:08:09' as timestamp) AS BOOLEAN) FROM src LIMIT 1;
+SELECT CAST(CAST('Foo' AS STRING) AS BOOLEAN) FROM src tablesample (1 rows);
+
+SELECT CAST(CAST('2011-05-06 07:08:09' as timestamp) AS BOOLEAN) FROM src tablesample (1 rows);
-- 'false' cases:
-SELECT CAST(CAST(0 AS TINYINT) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(0 AS SMALLINT) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(0 AS INT) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(0 AS BIGINT) AS BOOLEAN) FROM src LIMIT 1;
-
-SELECT CAST(CAST(0.0 AS FLOAT) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(0.0 AS DOUBLE) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(0.0 AS DECIMAL) AS BOOLEAN) FROM src LIMIT 1;
+SELECT CAST(CAST(0 AS TINYINT) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(0 AS SMALLINT) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(0 AS INT) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(0 AS BIGINT) AS BOOLEAN) FROM src tablesample (1 rows);
+
+SELECT CAST(CAST(0.0 AS FLOAT) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(0.0 AS DOUBLE) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(0.0 AS DECIMAL) AS BOOLEAN) FROM src tablesample (1 rows);
-SELECT CAST(CAST('' AS STRING) AS BOOLEAN) FROM src LIMIT 1;
+SELECT CAST(CAST('' AS STRING) AS BOOLEAN) FROM src tablesample (1 rows);
-SELECT CAST(CAST(0 as timestamp) AS BOOLEAN) FROM src LIMIT 1;
+SELECT CAST(CAST(0 as timestamp) AS BOOLEAN) FROM src tablesample (1 rows);
-- 'NULL' cases:
-SELECT CAST(NULL AS BOOLEAN) FROM src LIMIT 1;
+SELECT CAST(NULL AS BOOLEAN) FROM src tablesample (1 rows);
-SELECT CAST(CAST(NULL AS TINYINT) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(NULL AS SMALLINT) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(NULL AS INT) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(NULL AS BIGINT) AS BOOLEAN) FROM src LIMIT 1;
-
-SELECT CAST(CAST(NULL AS FLOAT) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(NULL AS DOUBLE) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(NULL AS DECIMAL) AS BOOLEAN) FROM src LIMIT 1;
+SELECT CAST(CAST(NULL AS TINYINT) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(NULL AS SMALLINT) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(NULL AS INT) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(NULL AS BIGINT) AS BOOLEAN) FROM src tablesample (1 rows);
+
+SELECT CAST(CAST(NULL AS FLOAT) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(NULL AS DOUBLE) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(NULL AS DECIMAL) AS BOOLEAN) FROM src tablesample (1 rows);
-SELECT CAST(CAST(NULL AS STRING) AS BOOLEAN) FROM src LIMIT 1;
-SELECT CAST(CAST(NULL as timestamp) AS BOOLEAN) FROM src LIMIT 1;
+SELECT CAST(CAST(NULL AS STRING) AS BOOLEAN) FROM src tablesample (1 rows);
+SELECT CAST(CAST(NULL as timestamp) AS BOOLEAN) FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_to_byte.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_to_byte.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_to_byte.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_to_byte.q Thu Oct 31 16:00:36 2013
@@ -1,15 +1,17 @@
--- Conversion of main primitive types to Byte type:
-SELECT CAST(NULL AS TINYINT) FROM src LIMIT 1;
+set hive.fetch.task.conversion=more;
-SELECT CAST(TRUE AS TINYINT) FROM src LIMIT 1;
+-- Conversion of main primitive types to Byte type:
+SELECT CAST(NULL AS TINYINT) FROM src tablesample (1 rows);
-SELECT CAST(CAST(-18 AS SMALLINT) AS TINYINT) FROM src LIMIT 1;
-SELECT CAST(-129 AS TINYINT) FROM src LIMIT 1;
-SELECT CAST(CAST(-1025 AS BIGINT) AS TINYINT) FROM src LIMIT 1;
+SELECT CAST(TRUE AS TINYINT) FROM src tablesample (1 rows);
-SELECT CAST(CAST(-3.14 AS DOUBLE) AS TINYINT) FROM src LIMIT 1;
-SELECT CAST(CAST(-3.14 AS FLOAT) AS TINYINT) FROM src LIMIT 1;
-SELECT CAST(CAST(-3.14 AS DECIMAL) AS TINYINT) FROM src LIMIT 1;
+SELECT CAST(CAST(-18 AS SMALLINT) AS TINYINT) FROM src tablesample (1 rows);
+SELECT CAST(-129 AS TINYINT) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-1025 AS BIGINT) AS TINYINT) FROM src tablesample (1 rows);
-SELECT CAST('-38' AS TINYINT) FROM src LIMIT 1;
+SELECT CAST(CAST(-3.14 AS DOUBLE) AS TINYINT) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-3.14 AS FLOAT) AS TINYINT) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-3.14 AS DECIMAL) AS TINYINT) FROM src tablesample (1 rows);
+
+SELECT CAST('-38' AS TINYINT) FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_to_double.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_to_double.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_to_double.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_to_double.q Thu Oct 31 16:00:36 2013
@@ -1,15 +1,17 @@
--- Conversion of main primitive types to Double type:
-SELECT CAST(NULL AS DOUBLE) FROM src LIMIT 1;
+set hive.fetch.task.conversion=more;
-SELECT CAST(TRUE AS DOUBLE) FROM src LIMIT 1;
+-- Conversion of main primitive types to Double type:
+SELECT CAST(NULL AS DOUBLE) FROM src tablesample (1 rows);
-SELECT CAST(CAST(-7 AS TINYINT) AS DOUBLE) FROM src LIMIT 1;
-SELECT CAST(CAST(-18 AS SMALLINT) AS DOUBLE) FROM src LIMIT 1;
-SELECT CAST(-129 AS DOUBLE) FROM src LIMIT 1;
-SELECT CAST(CAST(-1025 AS BIGINT) AS DOUBLE) FROM src LIMIT 1;
+SELECT CAST(TRUE AS DOUBLE) FROM src tablesample (1 rows);
-SELECT CAST(CAST(-3.14 AS FLOAT) AS DOUBLE) FROM src LIMIT 1;
-SELECT CAST(CAST(-3.14 AS DECIMAL(3,2)) AS DOUBLE) FROM src LIMIT 1;
+SELECT CAST(CAST(-7 AS TINYINT) AS DOUBLE) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-18 AS SMALLINT) AS DOUBLE) FROM src tablesample (1 rows);
+SELECT CAST(-129 AS DOUBLE) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-1025 AS BIGINT) AS DOUBLE) FROM src tablesample (1 rows);
-SELECT CAST('-38.14' AS DOUBLE) FROM src LIMIT 1;
+SELECT CAST(CAST(-3.14 AS FLOAT) AS DOUBLE) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-3.14 AS DECIMAL(3,2)) AS DOUBLE) FROM src tablesample (1 rows);
+
+SELECT CAST('-38.14' AS DOUBLE) FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_to_float.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_to_float.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_to_float.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_to_float.q Thu Oct 31 16:00:36 2013
@@ -1,15 +1,17 @@
--- Conversion of main primitive types to Float type:
-SELECT CAST(NULL AS FLOAT) FROM src LIMIT 1;
+set hive.fetch.task.conversion=more;
-SELECT CAST(TRUE AS FLOAT) FROM src LIMIT 1;
+-- Conversion of main primitive types to Float type:
+SELECT CAST(NULL AS FLOAT) FROM src tablesample (1 rows);
-SELECT CAST(CAST(-7 AS TINYINT) AS FLOAT) FROM src LIMIT 1;
-SELECT CAST(CAST(-18 AS SMALLINT) AS FLOAT) FROM src LIMIT 1;
-SELECT CAST(-129 AS FLOAT) FROM src LIMIT 1;
-SELECT CAST(CAST(-1025 AS BIGINT) AS FLOAT) FROM src LIMIT 1;
+SELECT CAST(TRUE AS FLOAT) FROM src tablesample (1 rows);
-SELECT CAST(CAST(-3.14 AS DOUBLE) AS FLOAT) FROM src LIMIT 1;
-SELECT CAST(CAST(-3.14 AS DECIMAL(3,2)) AS FLOAT) FROM src LIMIT 1;
+SELECT CAST(CAST(-7 AS TINYINT) AS FLOAT) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-18 AS SMALLINT) AS FLOAT) FROM src tablesample (1 rows);
+SELECT CAST(-129 AS FLOAT) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-1025 AS BIGINT) AS FLOAT) FROM src tablesample (1 rows);
-SELECT CAST('-38.14' AS FLOAT) FROM src LIMIT 1;
+SELECT CAST(CAST(-3.14 AS DOUBLE) AS FLOAT) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-3.14 AS DECIMAL(3,2)) AS FLOAT) FROM src tablesample (1 rows);
+
+SELECT CAST('-38.14' AS FLOAT) FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_to_long.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_to_long.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_to_long.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_to_long.q Thu Oct 31 16:00:36 2013
@@ -1,15 +1,17 @@
--- Conversion of main primitive types to Long type:
-SELECT CAST(NULL AS BIGINT) FROM src LIMIT 1;
+set hive.fetch.task.conversion=more;
-SELECT CAST(TRUE AS BIGINT) FROM src LIMIT 1;
+-- Conversion of main primitive types to Long type:
+SELECT CAST(NULL AS BIGINT) FROM src tablesample (1 rows);
-SELECT CAST(CAST(-7 AS TINYINT) AS BIGINT) FROM src LIMIT 1;
-SELECT CAST(CAST(-18 AS SMALLINT) AS BIGINT) FROM src LIMIT 1;
-SELECT CAST(-129 AS BIGINT) FROM src LIMIT 1;
+SELECT CAST(TRUE AS BIGINT) FROM src tablesample (1 rows);
-SELECT CAST(CAST(-3.14 AS DOUBLE) AS BIGINT) FROM src LIMIT 1;
-SELECT CAST(CAST(-3.14 AS FLOAT) AS BIGINT) FROM src LIMIT 1;
-SELECT CAST(CAST(-3.14 AS DECIMAL) AS BIGINT) FROM src LIMIT 1;
+SELECT CAST(CAST(-7 AS TINYINT) AS BIGINT) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-18 AS SMALLINT) AS BIGINT) FROM src tablesample (1 rows);
+SELECT CAST(-129 AS BIGINT) FROM src tablesample (1 rows);
-SELECT CAST('-38' AS BIGINT) FROM src LIMIT 1;
+SELECT CAST(CAST(-3.14 AS DOUBLE) AS BIGINT) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-3.14 AS FLOAT) AS BIGINT) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-3.14 AS DECIMAL) AS BIGINT) FROM src tablesample (1 rows);
+
+SELECT CAST('-38' AS BIGINT) FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_to_short.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_to_short.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_to_short.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_to_short.q Thu Oct 31 16:00:36 2013
@@ -1,15 +1,17 @@
--- Conversion of main primitive types to Short type:
-SELECT CAST(NULL AS SMALLINT) FROM src LIMIT 1;
+set hive.fetch.task.conversion=more;
-SELECT CAST(TRUE AS SMALLINT) FROM src LIMIT 1;
+-- Conversion of main primitive types to Short type:
+SELECT CAST(NULL AS SMALLINT) FROM src tablesample (1 rows);
-SELECT CAST(CAST(-18 AS TINYINT) AS SMALLINT) FROM src LIMIT 1;
-SELECT CAST(-129 AS SMALLINT) FROM src LIMIT 1;
-SELECT CAST(CAST(-1025 AS BIGINT) AS SMALLINT) FROM src LIMIT 1;
+SELECT CAST(TRUE AS SMALLINT) FROM src tablesample (1 rows);
-SELECT CAST(CAST(-3.14 AS DOUBLE) AS SMALLINT) FROM src LIMIT 1;
-SELECT CAST(CAST(-3.14 AS FLOAT) AS SMALLINT) FROM src LIMIT 1;
-SELECT CAST(CAST(-3.14 AS DECIMAL) AS SMALLINT) FROM src LIMIT 1;
+SELECT CAST(CAST(-18 AS TINYINT) AS SMALLINT) FROM src tablesample (1 rows);
+SELECT CAST(-129 AS SMALLINT) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-1025 AS BIGINT) AS SMALLINT) FROM src tablesample (1 rows);
-SELECT CAST('-38' AS SMALLINT) FROM src LIMIT 1;
+SELECT CAST(CAST(-3.14 AS DOUBLE) AS SMALLINT) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-3.14 AS FLOAT) AS SMALLINT) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-3.14 AS DECIMAL) AS SMALLINT) FROM src tablesample (1 rows);
+
+SELECT CAST('-38' AS SMALLINT) FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_to_string.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_to_string.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_to_string.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_to_string.q Thu Oct 31 16:00:36 2013
@@ -1,16 +1,18 @@
--- Conversion of main primitive types to String type:
-SELECT CAST(NULL AS STRING) FROM src LIMIT 1;
+set hive.fetch.task.conversion=more;
-SELECT CAST(TRUE AS STRING) FROM src LIMIT 1;
+-- Conversion of main primitive types to String type:
+SELECT CAST(NULL AS STRING) FROM src tablesample (1 rows);
-SELECT CAST(CAST(1 AS TINYINT) AS STRING) FROM src LIMIT 1;
-SELECT CAST(CAST(-18 AS SMALLINT) AS STRING) FROM src LIMIT 1;
-SELECT CAST(-129 AS STRING) FROM src LIMIT 1;
-SELECT CAST(CAST(-1025 AS BIGINT) AS STRING) FROM src LIMIT 1;
+SELECT CAST(TRUE AS STRING) FROM src tablesample (1 rows);
-SELECT CAST(CAST(-3.14 AS DOUBLE) AS STRING) FROM src LIMIT 1;
-SELECT CAST(CAST(-3.14 AS FLOAT) AS STRING) FROM src LIMIT 1;
-SELECT CAST(CAST(-3.14 AS DECIMAL(3,2)) AS STRING) FROM src LIMIT 1;
+SELECT CAST(CAST(1 AS TINYINT) AS STRING) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-18 AS SMALLINT) AS STRING) FROM src tablesample (1 rows);
+SELECT CAST(-129 AS STRING) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-1025 AS BIGINT) AS STRING) FROM src tablesample (1 rows);
-SELECT CAST('Foo' AS STRING) FROM src LIMIT 1;
+SELECT CAST(CAST(-3.14 AS DOUBLE) AS STRING) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-3.14 AS FLOAT) AS STRING) FROM src tablesample (1 rows);
+SELECT CAST(CAST(-3.14 AS DECIMAL(3,2)) AS STRING) FROM src tablesample (1 rows);
+
+SELECT CAST('Foo' AS STRING) FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_to_unix_timestamp.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_to_unix_timestamp.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_to_unix_timestamp.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_to_unix_timestamp.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION to_unix_timestamp;
DESCRIBE FUNCTION EXTENDED to_unix_timestamp;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_translate.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_translate.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_translate.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_translate.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION translate;
DESCRIBE FUNCTION EXTENDED translate;
@@ -10,28 +12,28 @@ FROM src INSERT OVERWRITE TABLE table_tr
-- Run some queries on constant input parameters
SELECT translate('abcd', 'ab', '12'),
- translate('abcd', 'abc', '12') FROM src LIMIT 1;
+ translate('abcd', 'abc', '12') FROM src tablesample (1 rows);
-- Run some queries where first parameter being a table column while the other two being constants
SELECT translate(table_input.input, 'ab', '12'),
- translate(table_input.input, 'abc', '12') FROM table_input LIMIT 1;
+ translate(table_input.input, 'abc', '12') FROM table_input tablesample (1 rows);
-- Run some queries where all parameters are coming from table columns
-SELECT translate(input_string, from_string, to_string) FROM table_translate LIMIT 1;
+SELECT translate(input_string, from_string, to_string) FROM table_translate tablesample (1 rows);
-- Run some queries where some parameters are NULL
SELECT translate(NULL, 'ab', '12'),
translate('abcd', NULL, '12'),
translate('abcd', 'ab', NULL),
- translate(NULL, NULL, NULL) FROM src LIMIT 1;
+ translate(NULL, NULL, NULL) FROM src tablesample (1 rows);
-- Run some queries where the same character appears several times in the from string (2nd argument) of the UDF
SELECT translate('abcd', 'aba', '123'),
- translate('abcd', 'aba', '12') FROM src LIMIT 1;
+ translate('abcd', 'aba', '12') FROM src tablesample (1 rows);
-- Run some queries for the ignorant case when the 3rd parameter has more characters than the second one
-SELECT translate('abcd', 'abc', '1234') FROM src LIMIT 1;
+SELECT translate('abcd', 'abc', '1234') FROM src tablesample (1 rows);
-- Test proper function over UTF-8 characters
-SELECT translate('Ãbcd', 'Ã', 'Ã') FROM src LIMIT 1;
+SELECT translate('Ãbcd', 'Ã', 'Ã') FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_unhex.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_unhex.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_unhex.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_unhex.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION unhex;
DESCRIBE FUNCTION EXTENDED unhex;
@@ -9,11 +11,11 @@ SELECT
unhex('61'),
unhex('2D34'),
unhex('')
-FROM src limit 1;
+FROM src tablesample (1 rows);
-- Bad inputs
SELECT
unhex('MySQL'),
unhex('G123'),
unhex('\0')
-FROM src limit 1;
+FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_union.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_union.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_union.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_union.q Thu Oct 31 16:00:36 2013
@@ -1,11 +1,13 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION create_union;
DESCRIBE FUNCTION EXTENDED create_union;
EXPLAIN
SELECT create_union(0, key), create_union(if(key<100, 0, 1), 2.0, value),
create_union(1, "a", struct(2, "b"))
-FROM src LIMIT 2;
+FROM src tablesample (2 rows);
SELECT create_union(0, key), create_union(if(key<100, 0, 1), 2.0, value),
create_union(1, "a", struct(2, "b"))
-FROM src LIMIT 2;
+FROM src tablesample (2 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_unix_timestamp.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_unix_timestamp.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_unix_timestamp.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_unix_timestamp.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION unix_timestamp;
DESCRIBE FUNCTION EXTENDED unix_timestamp;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_weekofyear.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_weekofyear.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_weekofyear.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_weekofyear.q Thu Oct 31 16:00:36 2013
@@ -1,6 +1,8 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION weekofyear;
DESCRIBE FUNCTION EXTENDED weekofyear;
SELECT weekofyear('1980-01-01'), weekofyear('1980-01-06'), weekofyear('1980-01-07'), weekofyear('1980-12-31'),
weekofyear('1984-1-1'), weekofyear('2008-02-20 00:00:00'), weekofyear('1980-12-28 23:59:59'), weekofyear('1980-12-29 23:59:59')
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_when.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_when.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_when.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_when.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION when;
DESCRIBE FUNCTION EXTENDED when;
@@ -27,7 +29,7 @@ SELECT CASE
WHEN 25=26 THEN 27
WHEN 28=28 THEN NULL
END
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
SELECT CASE
WHEN 1=1 THEN 2
@@ -54,4 +56,4 @@ SELECT CASE
WHEN 25=26 THEN 27
WHEN 28=28 THEN NULL
END
-FROM src LIMIT 1;
+FROM src tablesample (1 rows);
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_xpath.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_xpath.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_xpath.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_xpath.q Thu Oct 31 16:00:36 2013
@@ -1,8 +1,10 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION xpath ;
DESCRIBE FUNCTION EXTENDED xpath ;
-SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/text()') FROM src LIMIT 1 ;
-SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/*/text()') FROM src LIMIT 1 ;
-SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/b/text()') FROM src LIMIT 1 ;
-SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/c/text()') FROM src LIMIT 1 ;
-SELECT xpath ('<a><b class="bb">b1</b><b>b2</b><b>b3</b><c class="bb">c1</c><c>c2</c></a>', 'a/*[@class="bb"]/text()') FROM src LIMIT 1 ;
\ No newline at end of file
+SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/text()') FROM src tablesample (1 rows) ;
+SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/*/text()') FROM src tablesample (1 rows) ;
+SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/b/text()') FROM src tablesample (1 rows) ;
+SELECT xpath ('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>', 'a/c/text()') FROM src tablesample (1 rows) ;
+SELECT xpath ('<a><b class="bb">b1</b><b>b2</b><b>b3</b><c class="bb">c1</c><c>c2</c></a>', 'a/*[@class="bb"]/text()') FROM src tablesample (1 rows) ;
\ No newline at end of file
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_boolean.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_boolean.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_boolean.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_boolean.q Thu Oct 31 16:00:36 2013
@@ -1,9 +1,11 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION xpath_boolean ;
DESCRIBE FUNCTION EXTENDED xpath_boolean ;
-SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b') FROM src LIMIT 1 ;
-SELECT xpath_boolean ('<a><b>b</b></a>', 'a/c') FROM src LIMIT 1 ;
-SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b = "b"') FROM src LIMIT 1 ;
-SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b = "c"') FROM src LIMIT 1 ;
-SELECT xpath_boolean ('<a><b>10</b></a>', 'a/b < 10') FROM src LIMIT 1 ;
-SELECT xpath_boolean ('<a><b>10</b></a>', 'a/b = 10') FROM src LIMIT 1 ;
+SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b') FROM src tablesample (1 rows) ;
+SELECT xpath_boolean ('<a><b>b</b></a>', 'a/c') FROM src tablesample (1 rows) ;
+SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b = "b"') FROM src tablesample (1 rows) ;
+SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b = "c"') FROM src tablesample (1 rows) ;
+SELECT xpath_boolean ('<a><b>10</b></a>', 'a/b < 10') FROM src tablesample (1 rows) ;
+SELECT xpath_boolean ('<a><b>10</b></a>', 'a/b = 10') FROM src tablesample (1 rows) ;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_double.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_double.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_double.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_double.q Thu Oct 31 16:00:36 2013
@@ -1,14 +1,16 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION xpath_number ;
DESCRIBE FUNCTION EXTENDED xpath_number ;
DESCRIBE FUNCTION xpath_double ;
DESCRIBE FUNCTION EXTENDED xpath_double ;
-SELECT xpath_double ('<a>this is not a number</a>', 'a') FROM src LIMIT 1 ;
-SELECT xpath_double ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1 ;
-SELECT xpath_double ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1 ;
-SELECT xpath_double ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1 ;
-SELECT xpath_double ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src LIMIT 1 ;
-SELECT xpath_double ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src LIMIT 1 ;
-SELECT xpath_double ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src LIMIT 1 ;
-SELECT xpath_double ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b[@class="odd"])') FROM src LIMIT 1 ;
\ No newline at end of file
+SELECT xpath_double ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows) ;
+SELECT xpath_double ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows) ;
+SELECT xpath_double ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows) ;
+SELECT xpath_double ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows) ;
+SELECT xpath_double ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src tablesample (1 rows) ;
+SELECT xpath_double ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src tablesample (1 rows) ;
+SELECT xpath_double ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src tablesample (1 rows) ;
+SELECT xpath_double ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b[@class="odd"])') FROM src tablesample (1 rows) ;
\ No newline at end of file
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_float.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_float.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_float.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_float.q Thu Oct 31 16:00:36 2013
@@ -1,11 +1,13 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION xpath_float ;
DESCRIBE FUNCTION EXTENDED xpath_float ;
-SELECT xpath_float ('<a>this is not a number</a>', 'a') FROM src LIMIT 1 ;
-SELECT xpath_float ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1 ;
-SELECT xpath_float ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1 ;
-SELECT xpath_float ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1 ;
-SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src LIMIT 1 ;
-SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src LIMIT 1 ;
-SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src LIMIT 1 ;
-SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b[@class="odd"])') FROM src LIMIT 1 ;
\ No newline at end of file
+SELECT xpath_float ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows) ;
+SELECT xpath_float ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows) ;
+SELECT xpath_float ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows) ;
+SELECT xpath_float ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows) ;
+SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src tablesample (1 rows) ;
+SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src tablesample (1 rows) ;
+SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src tablesample (1 rows) ;
+SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b[@class="odd"])') FROM src tablesample (1 rows) ;
\ No newline at end of file
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_int.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_int.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_int.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_int.q Thu Oct 31 16:00:36 2013
@@ -1,11 +1,13 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION xpath_int ;
DESCRIBE FUNCTION EXTENDED xpath_int ;
-SELECT xpath_int ('<a>this is not a number</a>', 'a') FROM src LIMIT 1 ;
-SELECT xpath_int ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1 ;
-SELECT xpath_int ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1 ;
-SELECT xpath_int ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1 ;
-SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src LIMIT 1 ;
-SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src LIMIT 1 ;
-SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src LIMIT 1 ;
-SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b[@class="odd"])') FROM src LIMIT 1 ;
\ No newline at end of file
+SELECT xpath_int ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows) ;
+SELECT xpath_int ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows) ;
+SELECT xpath_int ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows) ;
+SELECT xpath_int ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows) ;
+SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src tablesample (1 rows) ;
+SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src tablesample (1 rows) ;
+SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src tablesample (1 rows) ;
+SELECT xpath_int ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b[@class="odd"])') FROM src tablesample (1 rows) ;
\ No newline at end of file
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_long.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_long.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_long.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_long.q Thu Oct 31 16:00:36 2013
@@ -1,11 +1,13 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION xpath_long ;
DESCRIBE FUNCTION EXTENDED xpath_long ;
-SELECT xpath_long ('<a>this is not a number</a>', 'a') FROM src LIMIT 1 ;
-SELECT xpath_long ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1 ;
-SELECT xpath_long ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1 ;
-SELECT xpath_long ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1 ;
-SELECT xpath_long ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src LIMIT 1 ;
-SELECT xpath_long ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src LIMIT 1 ;
-SELECT xpath_long ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src LIMIT 1 ;
-SELECT xpath_long ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b[@class="odd"])') FROM src LIMIT 1 ;
+SELECT xpath_long ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows) ;
+SELECT xpath_long ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows) ;
+SELECT xpath_long ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows) ;
+SELECT xpath_long ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows) ;
+SELECT xpath_long ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src tablesample (1 rows) ;
+SELECT xpath_long ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src tablesample (1 rows) ;
+SELECT xpath_long ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src tablesample (1 rows) ;
+SELECT xpath_long ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b[@class="odd"])') FROM src tablesample (1 rows) ;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_short.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_short.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_short.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_short.q Thu Oct 31 16:00:36 2013
@@ -1,11 +1,13 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION xpath_short ;
DESCRIBE FUNCTION EXTENDED xpath_short ;
-SELECT xpath_short ('<a>this is not a number</a>', 'a') FROM src LIMIT 1 ;
-SELECT xpath_short ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1 ;
-SELECT xpath_short ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1 ;
-SELECT xpath_short ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1 ;
-SELECT xpath_short ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src LIMIT 1 ;
-SELECT xpath_short ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src LIMIT 1 ;
-SELECT xpath_short ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src LIMIT 1 ;
-SELECT xpath_short ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b[@class="odd"])') FROM src LIMIT 1 ;
\ No newline at end of file
+SELECT xpath_short ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows) ;
+SELECT xpath_short ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows) ;
+SELECT xpath_short ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows) ;
+SELECT xpath_short ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows) ;
+SELECT xpath_short ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src tablesample (1 rows) ;
+SELECT xpath_short ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src tablesample (1 rows) ;
+SELECT xpath_short ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src tablesample (1 rows) ;
+SELECT xpath_short ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b[@class="odd"])') FROM src tablesample (1 rows) ;
\ No newline at end of file
Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_string.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_string.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_string.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_xpath_string.q Thu Oct 31 16:00:36 2013
@@ -1,11 +1,13 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION xpath_string ;
DESCRIBE FUNCTION EXTENDED xpath_string ;
-SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a') FROM src LIMIT 1 ;
-SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/b') FROM src LIMIT 1 ;
-SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/c') FROM src LIMIT 1 ;
-SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/d') FROM src LIMIT 1 ;
-SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', '//b') FROM src LIMIT 1 ;
-SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[1]') FROM src LIMIT 1 ;
-SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[2]') FROM src LIMIT 1 ;
-SELECT xpath_string ('<a><b>b1</b><b id="b_2">b2</b></a>', 'a/b[@id="b_2"]') FROM src LIMIT 1 ;
+SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a') FROM src tablesample (1 rows) ;
+SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/b') FROM src tablesample (1 rows) ;
+SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/c') FROM src tablesample (1 rows) ;
+SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/d') FROM src tablesample (1 rows) ;
+SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', '//b') FROM src tablesample (1 rows) ;
+SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[1]') FROM src tablesample (1 rows) ;
+SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[2]') FROM src tablesample (1 rows) ;
+SELECT xpath_string ('<a><b>b1</b><b id="b_2">b2</b></a>', 'a/b[@id="b_2"]') FROM src tablesample (1 rows) ;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udtf_explode.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udtf_explode.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udtf_explode.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udtf_explode.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,5 @@
+set hive.fetch.task.conversion=more;
+
DESCRIBE FUNCTION explode;
DESCRIBE FUNCTION EXTENDED explode;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udtf_json_tuple.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udtf_json_tuple.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udtf_json_tuple.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udtf_json_tuple.q Thu Oct 31 16:00:36 2013
@@ -2,17 +2,17 @@ create table json_t (key string, jstring
insert overwrite table json_t
select * from (
- select '1', '{"f1": "value1", "f2": "value2", "f3": 3, "f5": 5.23}' from src limit 1
+ select '1', '{"f1": "value1", "f2": "value2", "f3": 3, "f5": 5.23}' from src tablesample (1 rows)
union all
- select '2', '{"f1": "value12", "f3": "value3", "f2": 2, "f4": 4.01}' from src limit 1
+ select '2', '{"f1": "value12", "f3": "value3", "f2": 2, "f4": 4.01}' from src tablesample (1 rows)
union all
- select '3', '{"f1": "value13", "f4": "value44", "f3": "value33", "f2": 2, "f5": 5.01}' from src limit 1
+ select '3', '{"f1": "value13", "f4": "value44", "f3": "value33", "f2": 2, "f5": 5.01}' from src tablesample (1 rows)
union all
- select '4', cast(null as string) from src limit 1
+ select '4', cast(null as string) from src tablesample (1 rows)
union all
- select '5', '{"f1": "", "f5": null}' from src limit 1
+ select '5', '{"f1": "", "f5": null}' from src tablesample (1 rows)
union all
- select '6', '[invalid JSON string]' from src limit 1
+ select '6', '[invalid JSON string]' from src tablesample (1 rows)
) s;
explain
@@ -40,7 +40,7 @@ select f2, count(*) from json_t a latera
CREATE TABLE dest1(c1 STRING) STORED AS RCFILE;
-INSERT OVERWRITE TABLE dest1 SELECT '{"a":"b\nc"}' FROM src LIMIT 1;
+INSERT OVERWRITE TABLE dest1 SELECT '{"a":"b\nc"}' FROM src tablesample (1 rows);
SELECT * FROM dest1;
Modified: hive/trunk/ql/src/test/queries/clientpositive/udtf_parse_url_tuple.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udtf_parse_url_tuple.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udtf_parse_url_tuple.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udtf_parse_url_tuple.q Thu Oct 31 16:00:36 2013
@@ -2,17 +2,17 @@ create table url_t (key string, fullurl
insert overwrite table url_t
select * from (
- select '1', 'http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1' from src limit 1
+ select '1', 'http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1' from src tablesample (1 rows)
union all
- select '2', 'https://www.socs.uts.edu.au:80/MosaicDocs-old/url-primer.html?k1=tps#chapter1' from src limit 1
+ select '2', 'https://www.socs.uts.edu.au:80/MosaicDocs-old/url-primer.html?k1=tps#chapter1' from src tablesample (1 rows)
union all
- select '3', 'ftp://sites.google.com/a/example.com/site/page' from src limit 1
+ select '3', 'ftp://sites.google.com/a/example.com/site/page' from src tablesample (1 rows)
union all
- select '4', cast(null as string) from src limit 1
+ select '4', cast(null as string) from src tablesample (1 rows)
union all
- select '5', 'htttp://' from src limit 1
+ select '5', 'htttp://' from src tablesample (1 rows)
union all
- select '6', '[invalid url string]' from src limit 1
+ select '6', '[invalid url string]' from src tablesample (1 rows)
) s;
describe function parse_url_tuple;
Modified: hive/trunk/ql/src/test/queries/clientpositive/union34.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/union34.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/union34.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/union34.q Thu Oct 31 16:00:36 2013
@@ -3,7 +3,7 @@ create table src10_2 (key string, value
create table src10_3 (key string, value string);
create table src10_4 (key string, value string);
-from (select * from src limit 10) a
+from (select * from src tablesample (10 rows)) a
insert overwrite table src10_1 select *
insert overwrite table src10_2 select *
insert overwrite table src10_3 select *
Modified: hive/trunk/ql/src/test/queries/clientpositive/varchar_cast.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/varchar_cast.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/varchar_cast.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/varchar_cast.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,4 @@
+set hive.fetch.task.conversion=more;
-- Cast from varchar to other data types
select
Modified: hive/trunk/ql/src/test/queries/clientpositive/varchar_comparison.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/varchar_comparison.q?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/varchar_comparison.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/varchar_comparison.q Thu Oct 31 16:00:36 2013
@@ -1,3 +1,4 @@
+set hive.fetch.task.conversion=more;
-- Should all be true
select
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_varchar2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_varchar2.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_varchar2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_varchar2.q.out Thu Oct 31 16:00:36 2013
@@ -14,12 +14,12 @@ POSTHOOK: query: create table alter_varc
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@alter_varchar2
PREHOOK: query: insert overwrite table alter_varchar2 partition (hr=1)
- select value from src limit 1
+ select value from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@alter_varchar2@hr=1
POSTHOOK: query: insert overwrite table alter_varchar2 partition (hr=1)
- select value from src limit 1
+ select value from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@alter_varchar2@hr=1
@@ -58,12 +58,12 @@ POSTHOOK: Input: default@alter_varchar2@
POSTHOOK: Lineage: alter_varchar2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
1 val_238 7
PREHOOK: query: insert overwrite table alter_varchar2 partition (hr=2)
- select key from src limit 1
+ select key from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@alter_varchar2@hr=2
POSTHOOK: query: insert overwrite table alter_varchar2 partition (hr=2)
- select key from src limit 1
+ select key from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@alter_varchar2@hr=2
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out Thu Oct 31 16:00:36 2013
@@ -22,11 +22,11 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table orderpayment_small (`dealid` int,`date` string,`time` string, `cityid` int, `userid` int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@orderpayment_small
-PREHOOK: query: insert overwrite table orderpayment_small select 748, '2011-03-24', '2011-03-24', 55 ,5372613 from testsrc limit 1
+PREHOOK: query: insert overwrite table orderpayment_small select 748, '2011-03-24', '2011-03-24', 55 ,5372613 from testsrc tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@testsrc
PREHOOK: Output: default@orderpayment_small
-POSTHOOK: query: insert overwrite table orderpayment_small select 748, '2011-03-24', '2011-03-24', 55 ,5372613 from testsrc limit 1
+POSTHOOK: query: insert overwrite table orderpayment_small select 748, '2011-03-24', '2011-03-24', 55 ,5372613 from testsrc tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@testsrc
POSTHOOK: Output: default@orderpayment_small
@@ -54,11 +54,11 @@ POSTHOOK: Lineage: orderpayment_small.da
POSTHOOK: Lineage: orderpayment_small.dealid SIMPLE []
POSTHOOK: Lineage: orderpayment_small.time SIMPLE []
POSTHOOK: Lineage: orderpayment_small.userid SIMPLE []
-PREHOOK: query: insert overwrite table user_small select key from testsrc limit 100
+PREHOOK: query: insert overwrite table user_small select key from testsrc tablesample (100 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@testsrc
PREHOOK: Output: default@user_small
-POSTHOOK: query: insert overwrite table user_small select key from testsrc limit 100
+POSTHOOK: query: insert overwrite table user_small select key from testsrc tablesample (100 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@testsrc
POSTHOOK: Output: default@user_small
Modified: hive/trunk/ql/src/test/results/clientpositive/binary_constant.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/binary_constant.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/binary_constant.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/binary_constant.q.out Thu Oct 31 16:00:36 2013
@@ -1,8 +1,8 @@
-PREHOOK: query: select cast(cast('a' as binary) as string) from src limit 1
+PREHOOK: query: select cast(cast('a' as binary) as string) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: select cast(cast('a' as binary) as string) from src limit 1
+POSTHOOK: query: select cast(cast('a' as binary) as string) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/cast_to_int.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/cast_to_int.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/cast_to_int.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/cast_to_int.q.out Thu Oct 31 16:00:36 2013
@@ -27,7 +27,7 @@ select
cast('127' as tinyint),
cast('1.0a' as int),
cast('-1.-1' as int)
-from src limit 1
+from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -60,7 +60,7 @@ select
cast('127' as tinyint),
cast('1.0a' as int),
cast('-1.-1' as int)
-from src limit 1
+from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/compile_processor.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/compile_processor.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/compile_processor.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/compile_processor.q.out Thu Oct 31 16:00:36 2013
@@ -2,11 +2,11 @@ PREHOOK: query: CREATE TEMPORARY FUNCTIO
PREHOOK: type: CREATEFUNCTION
POSTHOOK: query: CREATE TEMPORARY FUNCTION Pyth as 'Pyth'
POSTHOOK: type: CREATEFUNCTION
-PREHOOK: query: SELECT Pyth(3,4) FROM src limit 1
+PREHOOK: query: SELECT Pyth(3,4) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT Pyth(3,4) FROM src limit 1
+POSTHOOK: query: SELECT Pyth(3,4) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/constant_prop.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/constant_prop.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/constant_prop.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/constant_prop.q.out Thu Oct 31 16:00:36 2013
@@ -7,7 +7,7 @@ SELECT NAMED_STRUCT(
IF(ARRAY_CONTAINS(ARRAY(1, 2), 3), "F1", "B1"), 1,
IF(ARRAY_CONTAINS(MAP_KEYS(MAP("b", "x")), "b"), "F2", "B2"), 2
).F2
- FROM src LIMIT 1
+ FROM src tablesample (1 rows)
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
SELECT NAMED_STRUCT(
@@ -18,41 +18,30 @@ SELECT NAMED_STRUCT(
IF(ARRAY_CONTAINS(ARRAY(1, 2), 3), "F1", "B1"), 1,
IF(ARRAY_CONTAINS(MAP_KEYS(MAP("b", "x")), "b"), "F2", "B2"), 2
).F2
- FROM src LIMIT 1
+ FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION NAMED_STRUCT (TOK_FUNCTION IF (TOK_FUNCTION ARRAY_CONTAINS (TOK_FUNCTION ARRAY 1 2) 3) "F1" "B1") 1 (TOK_FUNCTION IF (TOK_FUNCTION ARRAY_CONTAINS (TOK_FUNCTION MAP_KEYS (TOK_FUNCTION MAP "b" "x")) "b") "F2" "B2") 2)) (TOK_SELEXPR (. (TOK_FUNCTION NAMED_STRUCT (TOK_FUNCTION IF (TOK_FUNCTION ARRAY_CONTAINS (TOK_FUNCTION ARRAY 1 2) 3) "F1" "B1") 1 (TOK_FUNCTION IF (TOK_FUNCTION ARRAY_CONTAINS (TOK_FUNCTION MAP_KEYS (TOK_FUNCTION MAP "b" "x")) "b") "F2" "B2") 2) F2))) (TOK_LIMIT 1)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION NAMED_STRUCT (TOK_FUNCTION IF (TOK_FUNCTION ARRAY_CONTAINS (TOK_FUNCTION ARRAY 1 2) 3) "F1" "B1") 1 (TOK_FUNCTION IF (TOK_FUNCTION ARRAY_CONTAINS (TOK_FUNCTION MAP_KEYS (TOK_FUNCTION MAP "b" "x")) "b") "F2" "B2") 2)) (TOK_SELEXPR (. (TOK_FUNCTION NAMED_STRUCT (TOK_FUNCTION IF (TOK_FUNCTION ARRAY_CONTAINS (TOK_FUNCTION ARRAY 1 2) 3) "F1" "B1") 1 (TOK_FUNCTION IF (TOK_FUNCTION ARRAY_CONTAINS (TOK_FUNCTION MAP_KEYS (TOK_FUNCTION MAP "b" "x")) "b") "F2" "B2") 2) F2)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: named_struct(if(array_contains(array(1,2), 3), 'F1', 'B1'),1,if(array_contains(map_keys(map('b':'x')), 'b'), 'F2', 'B2'),2)
- type: struct<b1:int,f2:int>
- expr: named_struct(if(array_contains(array(1,2), 3), 'F1', 'B1'),1,if(array_contains(map_keys(map('b':'x')), 'b'), 'F2', 'B2'),2).F2
- type: int
- outputColumnNames: _col0, _col1
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
- limit: 1
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: src
+ Row Limit Per Split: 1
+ Select Operator
+ expressions:
+ expr: named_struct(if(array_contains(array(1,2), 3), 'F1', 'B1'),1,if(array_contains(map_keys(map('b':'x')), 'b'), 'F2', 'B2'),2)
+ type: struct<b1:int,f2:int>
+ expr: named_struct(if(array_contains(array(1,2), 3), 'F1', 'B1'),1,if(array_contains(map_keys(map('b':'x')), 'b'), 'F2', 'B2'),2).F2
+ type: int
+ outputColumnNames: _col0, _col1
+ ListSink
PREHOOK: query: SELECT NAMED_STRUCT(
@@ -63,7 +52,7 @@ PREHOOK: query: SELECT NAMED_STRUCT(
IF(ARRAY_CONTAINS(ARRAY(1, 2), 3), "F1", "B1"), 1,
IF(ARRAY_CONTAINS(MAP_KEYS(MAP("b", "x")), "b"), "F2", "B2"), 2
).F2
- FROM src LIMIT 1
+ FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -75,7 +64,7 @@ POSTHOOK: query: SELECT NAMED_STRUCT(
IF(ARRAY_CONTAINS(ARRAY(1, 2), 3), "F1", "B1"), 1,
IF(ARRAY_CONTAINS(MAP_KEYS(MAP("b", "x")), "b"), "F2", "B2"), 2
).F2
- FROM src LIMIT 1
+ FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/date_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/date_1.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/date_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/date_1.q.out Thu Oct 31 16:00:36 2013
@@ -8,12 +8,12 @@ POSTHOOK: query: create table date_1 (d
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@date_1
PREHOOK: query: insert overwrite table date_1
- select cast('2011-01-01' as date) from src limit 1
+ select cast('2011-01-01' as date) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@date_1
POSTHOOK: query: insert overwrite table date_1
- select cast('2011-01-01' as date) from src limit 1
+ select cast('2011-01-01' as date) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@date_1
@@ -39,12 +39,12 @@ POSTHOOK: Input: default@date_1
POSTHOOK: Lineage: date_1.d EXPRESSION []
2011-01-01 1
PREHOOK: query: insert overwrite table date_1
- select date '2011-01-01' from src limit 1
+ select date '2011-01-01' from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@date_1
POSTHOOK: query: insert overwrite table date_1
- select date '2011-01-01' from src limit 1
+ select date '2011-01-01' from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@date_1
@@ -73,12 +73,12 @@ POSTHOOK: Lineage: date_1.d EXPRESSION [
POSTHOOK: Lineage: date_1.d SIMPLE []
2011-01-01 1
PREHOOK: query: insert overwrite table date_1
- select cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src limit 1
+ select cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@date_1
POSTHOOK: query: insert overwrite table date_1
- select cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src limit 1
+ select cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@date_1
Modified: hive/trunk/ql/src/test/results/clientpositive/date_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/date_3.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/date_3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/date_3.q.out Thu Oct 31 16:00:36 2013
@@ -20,12 +20,12 @@ POSTHOOK: type: ALTERTABLE_ADDCOLS
POSTHOOK: Input: default@date_3
POSTHOOK: Output: default@date_3
PREHOOK: query: insert overwrite table date_3
- select 1, cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src limit 1
+ select 1, cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@date_3
POSTHOOK: query: insert overwrite table date_3
- select 1, cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src limit 1
+ select 1, cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@date_3
Modified: hive/trunk/ql/src/test/results/clientpositive/date_4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/date_4.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/date_4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/date_4.q.out Thu Oct 31 16:00:36 2013
@@ -17,13 +17,13 @@ POSTHOOK: Input: default@date_4
POSTHOOK: Output: default@date_4
PREHOOK: query: -- Test date literal syntax
insert overwrite table date_4
- select date '2011-01-01' from src limit 1
+ select date '2011-01-01' from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@date_4
POSTHOOK: query: -- Test date literal syntax
insert overwrite table date_4
- select date '2011-01-01' from src limit 1
+ select date '2011-01-01' from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@date_4
Modified: hive/trunk/ql/src/test/results/clientpositive/decimal_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/decimal_1.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/decimal_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/decimal_1.q.out Thu Oct 31 16:00:36 2013
@@ -16,101 +16,101 @@ POSTHOOK: type: ALTERTABLE_SERIALIZER
POSTHOOK: Input: default@decimal_1
POSTHOOK: Output: default@decimal_1
PREHOOK: query: insert overwrite table decimal_1
- select cast('17.29' as decimal(4,2)) from src limit 1
+ select cast('17.29' as decimal(4,2)) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@decimal_1
POSTHOOK: query: insert overwrite table decimal_1
- select cast('17.29' as decimal(4,2)) from src limit 1
+ select cast('17.29' as decimal(4,2)) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@decimal_1
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
-PREHOOK: query: select cast(t as boolean) from decimal_1 limit 1
+PREHOOK: query: select cast(t as boolean) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as boolean) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as boolean) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
true
-PREHOOK: query: select cast(t as tinyint) from decimal_1 limit 1
+PREHOOK: query: select cast(t as tinyint) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as tinyint) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as tinyint) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17
-PREHOOK: query: select cast(t as smallint) from decimal_1 limit 1
+PREHOOK: query: select cast(t as smallint) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as smallint) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as smallint) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17
-PREHOOK: query: select cast(t as int) from decimal_1 limit 1
+PREHOOK: query: select cast(t as int) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as int) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as int) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17
-PREHOOK: query: select cast(t as bigint) from decimal_1 limit 1
+PREHOOK: query: select cast(t as bigint) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as bigint) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as bigint) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17
-PREHOOK: query: select cast(t as float) from decimal_1 limit 1
+PREHOOK: query: select cast(t as float) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as float) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as float) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17.29
-PREHOOK: query: select cast(t as double) from decimal_1 limit 1
+PREHOOK: query: select cast(t as double) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as double) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as double) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17.29
-PREHOOK: query: select cast(t as string) from decimal_1 limit 1
+PREHOOK: query: select cast(t as string) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as string) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as string) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_1.t EXPRESSION []
17.29
-PREHOOK: query: select cast(t as timestamp) from decimal_1 limit 1
+PREHOOK: query: select cast(t as timestamp) from decimal_1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as timestamp) from decimal_1 limit 1
+POSTHOOK: query: select cast(t as timestamp) from decimal_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/decimal_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/decimal_2.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/decimal_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/decimal_2.q.out Thu Oct 31 16:00:36 2013
@@ -16,300 +16,300 @@ POSTHOOK: type: ALTERTABLE_SERIALIZER
POSTHOOK: Input: default@decimal_2
POSTHOOK: Output: default@decimal_2
PREHOOK: query: insert overwrite table decimal_2
- select cast('17.29' as decimal(4,2)) from src limit 1
+ select cast('17.29' as decimal(4,2)) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@decimal_2
POSTHOOK: query: insert overwrite table decimal_2
- select cast('17.29' as decimal(4,2)) from src limit 1
+ select cast('17.29' as decimal(4,2)) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@decimal_2
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
-PREHOOK: query: select cast(t as boolean) from decimal_2 limit 1
+PREHOOK: query: select cast(t as boolean) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as boolean) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as boolean) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
true
-PREHOOK: query: select cast(t as tinyint) from decimal_2 limit 1
+PREHOOK: query: select cast(t as tinyint) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as tinyint) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as tinyint) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17
-PREHOOK: query: select cast(t as smallint) from decimal_2 limit 1
+PREHOOK: query: select cast(t as smallint) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as smallint) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as smallint) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17
-PREHOOK: query: select cast(t as int) from decimal_2 limit 1
+PREHOOK: query: select cast(t as int) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as int) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as int) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17
-PREHOOK: query: select cast(t as bigint) from decimal_2 limit 1
+PREHOOK: query: select cast(t as bigint) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as bigint) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as bigint) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17
-PREHOOK: query: select cast(t as float) from decimal_2 limit 1
+PREHOOK: query: select cast(t as float) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as float) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as float) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17.29
-PREHOOK: query: select cast(t as double) from decimal_2 limit 1
+PREHOOK: query: select cast(t as double) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as double) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as double) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17.29
-PREHOOK: query: select cast(t as string) from decimal_2 limit 1
+PREHOOK: query: select cast(t as string) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as string) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as string) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17.29
PREHOOK: query: insert overwrite table decimal_2
- select cast('3404045.5044003' as decimal(18,9)) from src limit 1
+ select cast('3404045.5044003' as decimal(18,9)) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@decimal_2
POSTHOOK: query: insert overwrite table decimal_2
- select cast('3404045.5044003' as decimal(18,9)) from src limit 1
+ select cast('3404045.5044003' as decimal(18,9)) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@decimal_2
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
-PREHOOK: query: select cast(t as boolean) from decimal_2 limit 1
+PREHOOK: query: select cast(t as boolean) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as boolean) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as boolean) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
true
-PREHOOK: query: select cast(t as tinyint) from decimal_2 limit 1
+PREHOOK: query: select cast(t as tinyint) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as tinyint) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as tinyint) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
13
-PREHOOK: query: select cast(t as smallint) from decimal_2 limit 1
+PREHOOK: query: select cast(t as smallint) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as smallint) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as smallint) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
-3827
-PREHOOK: query: select cast(t as int) from decimal_2 limit 1
+PREHOOK: query: select cast(t as int) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as int) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as int) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3404045
-PREHOOK: query: select cast(t as bigint) from decimal_2 limit 1
+PREHOOK: query: select cast(t as bigint) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as bigint) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as bigint) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3404045
-PREHOOK: query: select cast(t as float) from decimal_2 limit 1
+PREHOOK: query: select cast(t as float) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as float) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as float) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3404045.5
-PREHOOK: query: select cast(t as double) from decimal_2 limit 1
+PREHOOK: query: select cast(t as double) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as double) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as double) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3404045.5044003
-PREHOOK: query: select cast(t as string) from decimal_2 limit 1
+PREHOOK: query: select cast(t as string) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(t as string) from decimal_2 limit 1
+POSTHOOK: query: select cast(t as string) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3404045.5044003
-PREHOOK: query: select cast(3.14 as decimal(4,2)) from decimal_2 limit 1
+PREHOOK: query: select cast(3.14 as decimal(4,2)) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(3.14 as decimal(4,2)) from decimal_2 limit 1
+POSTHOOK: query: select cast(3.14 as decimal(4,2)) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3.14
-PREHOOK: query: select cast(cast(3.14 as float) as decimal(4,2)) from decimal_2 limit 1
+PREHOOK: query: select cast(cast(3.14 as float) as decimal(4,2)) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(cast(3.14 as float) as decimal(4,2)) from decimal_2 limit 1
+POSTHOOK: query: select cast(cast(3.14 as float) as decimal(4,2)) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3.14
-PREHOOK: query: select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal(30,8)) from decimal_2 limit 1
+PREHOOK: query: select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal(30,8)) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal(30,8)) from decimal_2 limit 1
+POSTHOOK: query: select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal(30,8)) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
1355944339.1234567
-PREHOOK: query: select cast(true as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(true as decimal) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(true as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(true as decimal) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
1
-PREHOOK: query: select cast(3Y as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(3Y as decimal) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(3Y as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(3Y as decimal) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3
-PREHOOK: query: select cast(3S as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(3S as decimal) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(3S as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(3S as decimal) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3
-PREHOOK: query: select cast(cast(3 as int) as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(cast(3 as int) as decimal) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(cast(3 as int) as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(cast(3 as int) as decimal) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3
-PREHOOK: query: select cast(3L as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(3L as decimal) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(3L as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(3L as decimal) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3
-PREHOOK: query: select cast(0.99999999999999999999 as decimal(20,19)) from decimal_2 limit 1
+PREHOOK: query: select cast(0.99999999999999999999 as decimal(20,19)) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(0.99999999999999999999 as decimal(20,19)) from decimal_2 limit 1
+POSTHOOK: query: select cast(0.99999999999999999999 as decimal(20,19)) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
1
-PREHOOK: query: select cast('0.99999999999999999999' as decimal(20,20)) from decimal_2 limit 1
+PREHOOK: query: select cast('0.99999999999999999999' as decimal(20,20)) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast('0.99999999999999999999' as decimal(20,20)) from decimal_2 limit 1
+POSTHOOK: query: select cast('0.99999999999999999999' as decimal(20,20)) from decimal_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####