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 [10/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/results/clientpositive/udf_to_string.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_to_string.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_to_string.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_to_string.q.out Thu Oct 31 16:00:36 2013
@@ -1,91 +1,91 @@
-PREHOOK: query: -- Conversion of main primitive types to String type:
-SELECT CAST(NULL AS STRING) FROM src LIMIT 1
+PREHOOK: query: -- Conversion of main primitive types to String type:
+SELECT CAST(NULL AS STRING) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- Conversion of main primitive types to String type:
-SELECT CAST(NULL AS STRING) FROM src LIMIT 1
+POSTHOOK: query: -- Conversion of main primitive types to String type:
+SELECT CAST(NULL AS STRING) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
NULL
-PREHOOK: query: SELECT CAST(TRUE AS STRING) FROM src LIMIT 1
+PREHOOK: query: SELECT CAST(TRUE AS STRING) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT CAST(TRUE AS STRING) FROM src LIMIT 1
+POSTHOOK: query: SELECT CAST(TRUE AS STRING) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
TRUE
-PREHOOK: query: SELECT CAST(CAST(1 AS TINYINT) AS STRING) FROM src LIMIT 1
+PREHOOK: query: SELECT CAST(CAST(1 AS TINYINT) AS STRING) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT CAST(CAST(1 AS TINYINT) AS STRING) FROM src LIMIT 1
+POSTHOOK: query: SELECT CAST(CAST(1 AS TINYINT) AS STRING) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
1
-PREHOOK: query: SELECT CAST(CAST(-18 AS SMALLINT) AS STRING) FROM src LIMIT 1
+PREHOOK: query: SELECT CAST(CAST(-18 AS SMALLINT) AS STRING) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT CAST(CAST(-18 AS SMALLINT) AS STRING) FROM src LIMIT 1
+POSTHOOK: query: SELECT CAST(CAST(-18 AS SMALLINT) AS STRING) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-18
-PREHOOK: query: SELECT CAST(-129 AS STRING) FROM src LIMIT 1
+PREHOOK: query: SELECT CAST(-129 AS STRING) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT CAST(-129 AS STRING) FROM src LIMIT 1
+POSTHOOK: query: SELECT CAST(-129 AS STRING) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-129
-PREHOOK: query: SELECT CAST(CAST(-1025 AS BIGINT) AS STRING) FROM src LIMIT 1
+PREHOOK: query: SELECT CAST(CAST(-1025 AS BIGINT) AS STRING) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT CAST(CAST(-1025 AS BIGINT) AS STRING) FROM src LIMIT 1
+POSTHOOK: query: SELECT CAST(CAST(-1025 AS BIGINT) AS STRING) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-1025
-PREHOOK: query: SELECT CAST(CAST(-3.14 AS DOUBLE) AS STRING) FROM src LIMIT 1
+PREHOOK: query: SELECT CAST(CAST(-3.14 AS DOUBLE) AS STRING) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT CAST(CAST(-3.14 AS DOUBLE) AS STRING) FROM src LIMIT 1
+POSTHOOK: query: SELECT CAST(CAST(-3.14 AS DOUBLE) AS STRING) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-3.14
-PREHOOK: query: SELECT CAST(CAST(-3.14 AS FLOAT) AS STRING) FROM src LIMIT 1
+PREHOOK: query: SELECT CAST(CAST(-3.14 AS FLOAT) AS STRING) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT CAST(CAST(-3.14 AS FLOAT) AS STRING) FROM src LIMIT 1
+POSTHOOK: query: SELECT CAST(CAST(-3.14 AS FLOAT) AS STRING) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-3.14
-PREHOOK: query: SELECT CAST(CAST(-3.14 AS DECIMAL(3,2)) AS STRING) FROM src LIMIT 1
+PREHOOK: query: SELECT CAST(CAST(-3.14 AS DECIMAL(3,2)) AS STRING) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT CAST(CAST(-3.14 AS DECIMAL(3,2)) AS STRING) FROM src LIMIT 1
+POSTHOOK: query: SELECT CAST(CAST(-3.14 AS DECIMAL(3,2)) AS STRING) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-3.14
-PREHOOK: query: SELECT CAST('Foo' AS STRING) FROM src LIMIT 1
+PREHOOK: query: SELECT CAST('Foo' AS STRING) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT CAST('Foo' AS STRING) FROM src LIMIT 1
+POSTHOOK: query: SELECT CAST('Foo' 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/udf_translate.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_translate.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_translate.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_translate.q.out Thu Oct 31 16:00:36 2013
@@ -55,13 +55,13 @@ POSTHOOK: Lineage: table_translate.input
POSTHOOK: Lineage: table_translate.to_string SIMPLE []
PREHOOK: query: -- 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -72,13 +72,13 @@ POSTHOOK: Lineage: table_translate.to_st
12cd 12d
PREHOOK: query: -- 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@table_input
#### A masked pattern was here ####
POSTHOOK: query: -- 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_input
#### A masked pattern was here ####
@@ -88,12 +88,12 @@ POSTHOOK: Lineage: table_translate.input
POSTHOOK: Lineage: table_translate.to_string SIMPLE []
12cd 12d
PREHOOK: query: -- 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@table_translate
#### A masked pattern was here ####
POSTHOOK: query: -- 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_translate
#### A masked pattern was here ####
@@ -106,7 +106,7 @@ PREHOOK: query: -- Run some queries wher
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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -114,7 +114,7 @@ POSTHOOK: query: -- Run some queries whe
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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -125,13 +125,13 @@ POSTHOOK: Lineage: table_translate.to_st
NULL NULL NULL NULL
PREHOOK: query: -- 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -141,12 +141,12 @@ POSTHOOK: Lineage: table_translate.input
POSTHOOK: Lineage: table_translate.to_string SIMPLE []
12cd 12cd
PREHOOK: query: -- 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -156,12 +156,12 @@ POSTHOOK: Lineage: table_translate.input
POSTHOOK: Lineage: table_translate.to_string SIMPLE []
123d
PREHOOK: query: -- Test proper function over UTF-8 characters
-SELECT translate('Ãbcd', 'Ã', 'Ã') FROM src LIMIT 1
+SELECT translate('Ãbcd', 'Ã', 'Ã') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- Test proper function over UTF-8 characters
-SELECT translate('Ãbcd', 'Ã', 'Ã') FROM src LIMIT 1
+SELECT translate('Ãbcd', 'Ã', 'Ã') 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/udf_unhex.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_unhex.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_unhex.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_unhex.q.out Thu Oct 31 16:00:36 2013
@@ -29,7 +29,7 @@ SELECT
unhex('61'),
unhex('2D34'),
unhex('')
-FROM src limit 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -41,7 +41,7 @@ SELECT
unhex('61'),
unhex('2D34'),
unhex('')
-FROM src limit 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -51,7 +51,7 @@ SELECT
unhex('MySQL'),
unhex('G123'),
unhex('\0')
-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
unhex('MySQL'),
unhex('G123'),
unhex('\0')
-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/udf_union.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_union.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_union.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_union.q.out Thu Oct 31 16:00:36 2013
@@ -14,59 +14,48 @@ Example:
PREHOOK: query: 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)
PREHOOK: type: QUERY
POSTHOOK: query: 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)
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 create_union 0 (TOK_TABLE_OR_COL key))) (TOK_SELEXPR (TOK_FUNCTION create_union (TOK_FUNCTION if (< (TOK_TABLE_OR_COL key) 100) 0 1) 2.0 (TOK_TABLE_OR_COL value))) (TOK_SELEXPR (TOK_FUNCTION create_union 1 "a" (TOK_FUNCTION struct 2 "b")))) (TOK_LIMIT 2)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 2))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION create_union 0 (TOK_TABLE_OR_COL key))) (TOK_SELEXPR (TOK_FUNCTION create_union (TOK_FUNCTION if (< (TOK_TABLE_OR_COL key) 100) 0 1) 2.0 (TOK_TABLE_OR_COL value))) (TOK_SELEXPR (TOK_FUNCTION create_union 1 "a" (TOK_FUNCTION struct 2 "b"))))))
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: create_union(0,key)
- type: uniontype<string>
- expr: create_union(if((key < 100), 0, 1),2.0,value)
- type: uniontype<double,string>
- expr: create_union(1,'a',struct(2,'b'))
- type: uniontype<string,struct<col1:int,col2:string>>
- outputColumnNames: _col0, _col1, _col2
- 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: 2
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: src
+ Row Limit Per Split: 2
+ Select Operator
+ expressions:
+ expr: create_union(0,key)
+ type: uniontype<string>
+ expr: create_union(if((key < 100), 0, 1),2.0,value)
+ type: uniontype<double,string>
+ expr: create_union(1,'a',struct(2,'b'))
+ type: uniontype<string,struct<col1:int,col2:string>>
+ outputColumnNames: _col0, _col1, _col2
+ ListSink
PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_weekofyear.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_weekofyear.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_weekofyear.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_weekofyear.q.out Thu Oct 31 16:00:36 2013
@@ -15,13 +15,13 @@ Examples:
1
PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_when.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_when.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_when.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_when.q.out Thu Oct 31 16:00:36 2013
@@ -34,7 +34,7 @@ SELECT CASE
WHEN 25=26 THEN 27
WHEN 28=28 THEN NULL
END
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
SELECT CASE
@@ -62,49 +62,38 @@ SELECT CASE
WHEN 25=26 THEN 27
WHEN 28=28 THEN NULL
END
-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 WHEN (= 1 1) 2 (= 1 3) 4 5)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 6 7) 8 9)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 10 11) 12 (= 13 13) 14)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 15 16) 17 (= 18 19) 20)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 21 22) TOK_NULL (= 23 23) 24)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 25 26) 27 (= 28 28) TOK_NULL))) (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 WHEN (= 1 1) 2 (= 1 3) 4 5)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 6 7) 8 9)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 10 11) 12 (= 13 13) 14)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 15 16) 17 (= 18 19) 20)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 21 22) TOK_NULL (= 23 23) 24)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 25 26) 27 (= 28 28) TOK_NULL)))))
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: CASE WHEN ((1 = 1)) THEN (2) WHEN ((1 = 3)) THEN (4) ELSE (5) END
- type: int
- expr: CASE WHEN ((6 = 7)) THEN (8) ELSE (9) END
- type: int
- expr: CASE WHEN ((10 = 11)) THEN (12) WHEN ((13 = 13)) THEN (14) END
- type: int
- expr: CASE WHEN ((15 = 16)) THEN (17) WHEN ((18 = 19)) THEN (20) END
- type: int
- expr: CASE WHEN ((21 = 22)) THEN (null) WHEN ((23 = 23)) THEN (24) END
- type: int
- expr: CASE WHEN ((25 = 26)) THEN (27) WHEN ((28 = 28)) THEN (null) END
- type: int
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- 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: CASE WHEN ((1 = 1)) THEN (2) WHEN ((1 = 3)) THEN (4) ELSE (5) END
+ type: int
+ expr: CASE WHEN ((6 = 7)) THEN (8) ELSE (9) END
+ type: int
+ expr: CASE WHEN ((10 = 11)) THEN (12) WHEN ((13 = 13)) THEN (14) END
+ type: int
+ expr: CASE WHEN ((15 = 16)) THEN (17) WHEN ((18 = 19)) THEN (20) END
+ type: int
+ expr: CASE WHEN ((21 = 22)) THEN (null) WHEN ((23 = 23)) THEN (24) END
+ type: int
+ expr: CASE WHEN ((25 = 26)) THEN (27) WHEN ((28 = 28)) THEN (null) END
+ type: int
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ ListSink
PREHOOK: query: SELECT CASE
@@ -132,7 +121,7 @@ PREHOOK: query: SELECT CASE
WHEN 25=26 THEN 27
WHEN 28=28 THEN NULL
END
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -161,7 +150,7 @@ POSTHOOK: query: SELECT CASE
WHEN 25=26 THEN 27
WHEN 28=28 THEN NULL
END
-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/udf_xpath.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_xpath.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_xpath.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_xpath.q.out Thu Oct 31 16:00:36 2013
@@ -15,47 +15,47 @@ Example:
["b1","b2","b3"]
> 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
["c1","c2"]
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
[]
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
["b1","b2","b3","c1","c2"]
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
["b1","b2","b3"]
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
["c1","c2"]
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_xpath_boolean.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_xpath_boolean.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_xpath_boolean.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_xpath_boolean.q.out Thu Oct 31 16:00:36 2013
@@ -13,56 +13,56 @@ Example:
true
> SELECT xpath_boolean('<a><b>1</b></a>','a/b = 2') FROM src LIMIT 1;
false
-PREHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
true
-PREHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/c') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/c') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/c') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/c') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
false
-PREHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b = "b"') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b = "b"') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b = "b"') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b = "b"') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
true
-PREHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b = "c"') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b = "c"') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b = "c"') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_boolean ('<a><b>b</b></a>', 'a/b = "c"') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
false
-PREHOOK: query: SELECT xpath_boolean ('<a><b>10</b></a>', 'a/b < 10') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_boolean ('<a><b>10</b></a>', 'a/b < 10') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_boolean ('<a><b>10</b></a>', 'a/b < 10') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_boolean ('<a><b>10</b></a>', 'a/b < 10') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
false
-PREHOOK: query: SELECT xpath_boolean ('<a><b>10</b></a>', 'a/b = 10') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_boolean ('<a><b>10</b></a>', 'a/b = 10') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_boolean ('<a><b>10</b></a>', 'a/b = 10') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_boolean ('<a><b>10</b></a>', 'a/b = 10') 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/udf_xpath_double.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_xpath_double.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_xpath_double.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_xpath_double.q.out Thu Oct 31 16:00:36 2013
@@ -26,74 +26,74 @@ Synonyms: xpath_number
Example:
> SELECT xpath_double('<a><b>1</b><b>2</b></a>','sum(a/b)') FROM src LIMIT 1;
3.0
-PREHOOK: query: SELECT xpath_double ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_double ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_double ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_double ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
NaN
-PREHOOK: query: SELECT xpath_double ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_double ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_double ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_double ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
NaN
-PREHOOK: query: SELECT xpath_double ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_double ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_double ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_double ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
8.0E19
-PREHOOK: query: SELECT xpath_double ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_double ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_double ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_double ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0.0
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
1.0
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
15.0
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
7.0
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_xpath_float.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_xpath_float.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_xpath_float.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_xpath_float.q.out Thu Oct 31 16:00:36 2013
@@ -11,74 +11,74 @@ xpath_float(xml, xpath) - Returns a floa
Example:
> SELECT xpath_float('<a><b>1</b><b>2</b></a>','sum(a/b)') FROM src LIMIT 1;
3.0
-PREHOOK: query: SELECT xpath_float ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_float ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_float ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_float ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
NaN
-PREHOOK: query: SELECT xpath_float ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_float ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_float ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_float ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
NaN
-PREHOOK: query: SELECT xpath_float ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_float ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_float ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_float ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
8.0E19
-PREHOOK: query: SELECT xpath_float ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_float ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_float ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_float ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0.0
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
1.0
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
15.0
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
7.0
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_xpath_int.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_xpath_int.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_xpath_int.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_xpath_int.q.out Thu Oct 31 16:00:36 2013
@@ -11,74 +11,74 @@ xpath_int(xml, xpath) - Returns an integ
Example:
> SELECT xpath_int('<a><b>1</b><b>2</b></a>','sum(a/b)') FROM src LIMIT 1;
3
-PREHOOK: query: SELECT xpath_int ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_int ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_int ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_int ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0
-PREHOOK: query: SELECT xpath_int ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_int ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_int ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_int ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0
-PREHOOK: query: SELECT xpath_int ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_int ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_int ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_int ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
2147483647
-PREHOOK: query: SELECT xpath_int ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_int ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_int ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_int ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
1
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
15
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
7
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_xpath_long.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_xpath_long.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_xpath_long.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_xpath_long.q.out Thu Oct 31 16:00:36 2013
@@ -11,74 +11,74 @@ xpath_long(xml, xpath) - Returns a long
Example:
> SELECT xpath_long('<a><b>1</b><b>2</b></a>','sum(a/b)') FROM src LIMIT 1;
3
-PREHOOK: query: SELECT xpath_long ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_long ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_long ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_long ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0
-PREHOOK: query: SELECT xpath_long ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_long ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_long ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_long ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0
-PREHOOK: query: SELECT xpath_long ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_long ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_long ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_long ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
9223372036854775807
-PREHOOK: query: SELECT xpath_long ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_long ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_long ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_long ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
1
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
15
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
7
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_xpath_short.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_xpath_short.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_xpath_short.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_xpath_short.q.out Thu Oct 31 16:00:36 2013
@@ -11,74 +11,74 @@ xpath_short(xml, xpath) - Returns a shor
Example:
> SELECT xpath_short('<a><b>1</b><b>2</b></a>','sum(a/b)') FROM src LIMIT 1;
3
-PREHOOK: query: SELECT xpath_short ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_short ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_short ('<a>this is not a number</a>', 'a') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_short ('<a>this is not a number</a>', 'a') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0
-PREHOOK: query: SELECT xpath_short ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_short ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_short ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_short ('<a>this 2 is not a number</a>', 'a') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0
-PREHOOK: query: SELECT xpath_short ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_short ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_short ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_short ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-1
-PREHOOK: query: SELECT xpath_short ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_short ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_short ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_short ('<a>try a boolean</a>', 'a = 10') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
1
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
15
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
7
-PREHOOK: query: 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
+PREHOOK: query: 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)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: 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
+POSTHOOK: query: 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)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_xpath_string.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_xpath_string.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_xpath_string.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_xpath_string.q.out Thu Oct 31 16:00:36 2013
@@ -17,74 +17,74 @@ Example:
'b2'
> SELECT xpath_string('<a><b>b1</b><b>b2</b></a>','a') FROM src LIMIT 1;
'b1b2'
-PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
bbcc
-PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/b') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/b') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/b') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/b') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
bb
-PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/c') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/c') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/c') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/c') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
cc
-PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/d') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/d') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/d') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a/d') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', '//b') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', '//b') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', '//b') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', '//b') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
b1
-PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[1]') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[1]') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[1]') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[1]') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
b1
-PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[2]') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[2]') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[2]') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b>b2</b></a>', 'a/b[2]') FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
b2
-PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b id="b_2">b2</b></a>', 'a/b[@id="b_2"]') FROM src LIMIT 1
+PREHOOK: query: SELECT xpath_string ('<a><b>b1</b><b id="b_2">b2</b></a>', 'a/b[@id="b_2"]') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b id="b_2">b2</b></a>', 'a/b[@id="b_2"]') FROM src LIMIT 1
+POSTHOOK: query: SELECT xpath_string ('<a><b>b1</b><b id="b_2">b2</b></a>', 'a/b[@id="b_2"]') 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/udtf_json_tuple.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udtf_json_tuple.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udtf_json_tuple.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udtf_json_tuple.q.out Thu Oct 31 16:00:36 2013
@@ -5,34 +5,34 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@json_t
PREHOOK: query: 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
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@json_t
POSTHOOK: query: 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
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
@@ -588,11 +588,11 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: json_t.jstring EXPRESSION []
POSTHOOK: Lineage: json_t.key EXPRESSION []
-PREHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT '{"a":"b\nc"}' FROM src LIMIT 1
+PREHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT '{"a":"b\nc"}' FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@dest1
-POSTHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT '{"a":"b\nc"}' FROM src LIMIT 1
+POSTHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT '{"a":"b\nc"}' FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
Modified: hive/trunk/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out Thu Oct 31 16:00:36 2013
@@ -5,34 +5,34 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@url_t
PREHOOK: query: 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
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@url_t
POSTHOOK: query: 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
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/union34.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union34.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union34.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union34.q.out Thu Oct 31 16:00:36 2013
@@ -18,7 +18,7 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table src10_4 (key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@src10_4
-PREHOOK: query: from (select * from src limit 10) a
+PREHOOK: query: 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 *
@@ -29,7 +29,7 @@ PREHOOK: Output: default@src10_1
PREHOOK: Output: default@src10_2
PREHOOK: Output: default@src10_3
PREHOOK: Output: default@src10_4
-POSTHOOK: query: from (select * from src limit 10) a
+POSTHOOK: query: 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 *