You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2013/11/05 08:01:58 UTC
svn commit: r1538880 [43/46] - in /hive/branches/tez: ./ ant/
ant/src/org/apache/hadoop/hive/ant/ beeline/
beeline/src/java/org/apache/hive/beeline/ beeline/src/main/
beeline/src/test/org/apache/hive/beeline/src/test/ cli/ common/
common/src/java/conf/...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_when.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_when.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_when.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_when.q.out Tue Nov 5 07:01:32 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/branches/tez/ql/src/test/results/clientpositive/udf_xpath.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath.q.out Tue Nov 5 07:01:32 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/branches/tez/ql/src/test/results/clientpositive/udf_xpath_boolean.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_boolean.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_boolean.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_boolean.q.out Tue Nov 5 07:01:32 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/branches/tez/ql/src/test/results/clientpositive/udf_xpath_double.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_double.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_double.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_double.q.out Tue Nov 5 07:01:32 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/branches/tez/ql/src/test/results/clientpositive/udf_xpath_float.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_float.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_float.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_float.q.out Tue Nov 5 07:01:32 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/branches/tez/ql/src/test/results/clientpositive/udf_xpath_int.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_int.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_int.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_int.q.out Tue Nov 5 07:01:32 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/branches/tez/ql/src/test/results/clientpositive/udf_xpath_long.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_long.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_long.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_long.q.out Tue Nov 5 07:01:32 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/branches/tez/ql/src/test/results/clientpositive/udf_xpath_short.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_short.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_short.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_short.q.out Tue Nov 5 07:01:32 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/branches/tez/ql/src/test/results/clientpositive/udf_xpath_string.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_string.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_string.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_xpath_string.q.out Tue Nov 5 07:01:32 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/branches/tez/ql/src/test/results/clientpositive/udtf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udtf_explode.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udtf_explode.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udtf_explode.q.out Tue Nov 5 07:01:32 2013
@@ -70,7 +70,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src
numFiles 1
- numPartitions 0
numRows 0
rawDataSize 0
serialization.ddl struct src { string key, string value}
@@ -89,7 +88,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src
numFiles 1
- numPartitions 0
numRows 0
rawDataSize 0
serialization.ddl struct src { string key, string value}
@@ -157,7 +155,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src
numFiles 1
- numPartitions 0
numRows 0
rawDataSize 0
serialization.ddl struct src { string key, string value}
@@ -176,7 +173,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src
numFiles 1
- numPartitions 0
numRows 0
rawDataSize 0
serialization.ddl struct src { string key, string value}
@@ -435,7 +431,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src
numFiles 1
- numPartitions 0
numRows 0
rawDataSize 0
serialization.ddl struct src { string key, string value}
@@ -454,7 +449,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src
numFiles 1
- numPartitions 0
numRows 0
rawDataSize 0
serialization.ddl struct src { string key, string value}
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udtf_json_tuple.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udtf_json_tuple.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udtf_json_tuple.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udtf_json_tuple.q.out Tue Nov 5 07:01:32 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/branches/tez/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out Tue Nov 5 07:01:32 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/branches/tez/ql/src/test/results/clientpositive/udtf_posexplode.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udtf_posexplode.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udtf_posexplode.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udtf_posexplode.q.out Tue Nov 5 07:01:32 2013
@@ -13,10 +13,10 @@ deductions MAP<STRING, FLOAT>,
address STRUCT<street:STRING, city:STRING, state:STRING, zip:INT>)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@employees
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/posexplode_data.txt' INTO TABLE employees
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/posexplode_data.txt' INTO TABLE employees
PREHOOK: type: LOAD
PREHOOK: Output: default@employees
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/posexplode_data.txt' INTO TABLE employees
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/posexplode_data.txt' INTO TABLE employees
POSTHOOK: type: LOAD
POSTHOOK: Output: default@employees
PREHOOK: query: SELECT
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union.q.out Tue Nov 5 07:01:32 2013
@@ -6,7 +6,7 @@ FROM (
UNION ALL
FROM src SELECT src.* WHERE src.key > 100
) unioninput
-INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/union.out' SELECT unioninput.*
+INSERT OVERWRITE DIRECTORY 'target/warehouse/union.out' SELECT unioninput.*
PREHOOK: type: QUERY
POSTHOOK: query: -- union case: both subqueries are map jobs on same input, followed by filesink
@@ -16,10 +16,10 @@ FROM (
UNION ALL
FROM src SELECT src.* WHERE src.key > 100
) unioninput
-INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/union.out' SELECT unioninput.*
+INSERT OVERWRITE DIRECTORY 'target/warehouse/union.out' SELECT unioninput.*
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL src) key) 100)))) (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME src)))) (TOK_WHERE (> (. (TOK_TABLE_OR_COL src) key) 100))))) unioninput)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR '../build/ql/test/data/warehouse/union.out')) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME unioninput))))))
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL src) key) 100)))) (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME src)))) (TOK_WHERE (> (. (TOK_TABLE_OR_COL src) key) 100))))) unioninput)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR 'target/warehouse/union.out')) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME unioninput))))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -106,7 +106,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: ../build/ql/test/data/warehouse/union.out
+ destination: target/warehouse/union.out
Stage: Stage-2
Map Reduce
@@ -146,19 +146,19 @@ PREHOOK: query: FROM (
UNION ALL
FROM src SELECT src.* WHERE src.key > 100
) unioninput
-INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/union.out' SELECT unioninput.*
+INSERT OVERWRITE DIRECTORY 'target/warehouse/union.out' SELECT unioninput.*
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: ../build/ql/test/data/warehouse/union.out
+PREHOOK: Output: target/warehouse/union.out
POSTHOOK: query: FROM (
FROM src select src.key, src.value WHERE src.key < 100
UNION ALL
FROM src SELECT src.* WHERE src.key > 100
) unioninput
-INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/union.out' SELECT unioninput.*
+INSERT OVERWRITE DIRECTORY 'target/warehouse/union.out' SELECT unioninput.*
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: ../build/ql/test/data/warehouse/union.out
+POSTHOOK: Output: target/warehouse/union.out
238val_238
86val_86
311val_311
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union22.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union22.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union22.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union22.q.out Tue Nov 5 07:01:32 2013
@@ -136,15 +136,10 @@ STAGE PLANS:
columns.types string:string:string:string:string:string
#### A masked pattern was here ####
name default.dst_union22_delta
- numFiles 1
- numPartitions 1
- numRows 500
partition_columns ds
- rawDataSize 16936
serialization.ddl struct dst_union22_delta { string k0, string k1, string k2, string k3, string k4, string k5}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 17436
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22_delta
@@ -277,15 +272,10 @@ STAGE PLANS:
columns.types string:string:string:string
#### A masked pattern was here ####
name default.dst_union22
- numFiles 1
- numPartitions 1
- numRows 500
partition_columns ds
- rawDataSize 11124
serialization.ddl struct dst_union22 { string k1, string k2, string k3, string k4}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 11624
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22
@@ -322,15 +312,10 @@ STAGE PLANS:
columns.types string:string:string:string:string:string
#### A masked pattern was here ####
name default.dst_union22_delta
- numFiles 1
- numPartitions 1
- numRows 500
partition_columns ds
- rawDataSize 16936
serialization.ddl struct dst_union22_delta { string k0, string k1, string k2, string k3, string k4, string k5}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 17436
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22_delta
@@ -372,15 +357,10 @@ STAGE PLANS:
columns.types string:string:string:string
#### A masked pattern was here ####
name default.dst_union22
- numFiles 1
- numPartitions 1
- numRows 500
partition_columns ds
- rawDataSize 11124
serialization.ddl struct dst_union22 { string k1, string k2, string k3, string k4}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 11624
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22
@@ -435,15 +415,10 @@ STAGE PLANS:
columns.types string:string:string:string
#### A masked pattern was here ####
name default.dst_union22
- numFiles 1
- numPartitions 1
- numRows 500
partition_columns ds
- rawDataSize 11124
serialization.ddl struct dst_union22 { string k1, string k2, string k3, string k4}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 11624
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22
@@ -505,15 +480,10 @@ STAGE PLANS:
columns.types string:string:string:string:string:string
#### A masked pattern was here ####
name default.dst_union22_delta
- numFiles 1
- numPartitions 1
- numRows 500
partition_columns ds
- rawDataSize 16936
serialization.ddl struct dst_union22_delta { string k0, string k1, string k2, string k3, string k4, string k5}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 17436
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22_delta
@@ -538,15 +508,10 @@ STAGE PLANS:
columns.types string:string:string:string
#### A masked pattern was here ####
name default.dst_union22
- numFiles 1
- numPartitions 1
- numRows 500
partition_columns ds
- rawDataSize 11124
serialization.ddl struct dst_union22 { string k1, string k2, string k3, string k4}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 11624
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22
@@ -651,15 +616,10 @@ STAGE PLANS:
columns.types string:string:string:string
#### A masked pattern was here ####
name default.dst_union22
- numFiles 1
- numPartitions 1
- numRows 500
partition_columns ds
- rawDataSize 11124
serialization.ddl struct dst_union22 { string k1, string k2, string k3, string k4}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 11624
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22
@@ -696,15 +656,10 @@ STAGE PLANS:
columns.types string:string:string:string:string:string
#### A masked pattern was here ####
name default.dst_union22_delta
- numFiles 1
- numPartitions 1
- numRows 500
partition_columns ds
- rawDataSize 16936
serialization.ddl struct dst_union22_delta { string k0, string k1, string k2, string k3, string k4, string k5}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 17436
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22_delta
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union24.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union24.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union24.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union24.q.out Tue Nov 5 07:01:32 2013
@@ -112,7 +112,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src5
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src5 { string key, i64 count}
@@ -131,7 +130,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src5
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src5 { string key, i64 count}
@@ -353,7 +351,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src2
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src2 { string key, i64 count}
@@ -372,7 +369,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src2
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src2 { string key, i64 count}
@@ -395,7 +391,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src3
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src3 { string key, i64 count}
@@ -414,7 +409,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src3
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src3 { string key, i64 count}
@@ -437,7 +431,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src4
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src4 { string key, i64 count}
@@ -456,7 +449,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src4
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src4 { string key, i64 count}
@@ -646,7 +638,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src4
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src4 { string key, i64 count}
@@ -665,7 +656,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src4
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src4 { string key, i64 count}
@@ -688,7 +678,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src5
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src5 { string key, i64 count}
@@ -707,7 +696,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src5
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src5 { string key, i64 count}
@@ -892,7 +880,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src2
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src2 { string key, i64 count}
@@ -911,7 +898,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src2
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src2 { string key, i64 count}
@@ -934,7 +920,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src3
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src3 { string key, i64 count}
@@ -953,7 +938,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src3
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src3 { string key, i64 count}
@@ -1130,7 +1114,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src4
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src4 { string key, i64 count}
@@ -1149,7 +1132,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src4
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src4 { string key, i64 count}
@@ -1172,7 +1154,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src5
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src5 { string key, i64 count}
@@ -1191,7 +1172,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src5
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src5 { string key, i64 count}
@@ -1462,7 +1442,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src2
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src2 { string key, i64 count}
@@ -1481,7 +1460,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src2
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src2 { string key, i64 count}
@@ -1504,7 +1482,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src3
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src3 { string key, i64 count}
@@ -1523,7 +1500,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.src3
numFiles 1
- numPartitions 0
numRows 309
rawDataSize 1482
serialization.ddl struct src3 { string key, i64 count}
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union34.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union34.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union34.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union34.q.out Tue Nov 5 07:01:32 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 *
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_date.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_date.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_date.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_date.q.out Tue Nov 5 07:01:32 2013
@@ -40,16 +40,16 @@ POSTHOOK: query: create table union_date
)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@union_date_2
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_1
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_1
PREHOOK: type: LOAD
PREHOOK: Output: default@union_date_1
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_1
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@union_date_1
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_2
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_2
PREHOOK: type: LOAD
PREHOOK: Output: default@union_date_2
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_2
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_2
POSTHOOK: type: LOAD
POSTHOOK: Output: default@union_date_2
PREHOOK: query: select * from (
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_ppr.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_ppr.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_ppr.q.out Tue Nov 5 07:01:32 2013
@@ -169,15 +169,10 @@ STAGE PLANS:
columns.types string:string
#### A masked pattern was here ####
name default.srcpart
- numFiles 4
- numPartitions 4
- numRows 0
partition_columns ds/hr
- rawDataSize 0
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 23248
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
@@ -215,15 +210,10 @@ STAGE PLANS:
columns.types string:string
#### A masked pattern was here ####
name default.srcpart
- numFiles 4
- numPartitions 4
- numRows 0
partition_columns ds/hr
- rawDataSize 0
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 23248
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_1.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_1.q.out Tue Nov 5 07:01:32 2013
@@ -28,10 +28,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_10.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_10.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_10.q.out Tue Nov 5 07:01:32 2013
@@ -36,10 +36,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_11.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_11.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_11.q.out Tue Nov 5 07:01:32 2013
@@ -36,10 +36,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_12.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_12.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_12.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_12.q.out Tue Nov 5 07:01:32 2013
@@ -34,10 +34,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_13.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_13.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_13.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_13.q.out Tue Nov 5 07:01:32 2013
@@ -34,10 +34,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain