You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by rm...@apache.org on 2009/09/29 03:25:30 UTC
svn commit: r819792 [19/24] - in /hadoop/hive/trunk: ./
common/src/java/org/apache/hadoop/hive/conf/
contrib/src/test/results/clientnegative/
contrib/src/test/results/clientpositive/ data/conf/
ql/src/java/org/apache/hadoop/hive/ql/ ql/src/java/org/apa...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_10_trims.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_10_trims.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_10_trims.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_10_trims.q.out Tue Sep 29 01:25:15 2009
@@ -1,9 +1,20 @@
-query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
-query: EXPLAIN
+PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: EXPLAIN
INSERT OVERWRITE TABLE dest1
SELECT trim(trim(trim(trim(trim(trim(trim(trim(trim(trim( ' abc '))))))))))
FROM src
WHERE src.key = 86
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+INSERT OVERWRITE TABLE dest1
+SELECT trim(trim(trim(trim(trim(trim(trim(trim(trim(trim( ' abc '))))))))))
+FROM src
+WHERE src.key = 86
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION trim (TOK_FUNCTION trim (TOK_FUNCTION trim (TOK_FUNCTION trim (TOK_FUNCTION trim (TOK_FUNCTION trim (TOK_FUNCTION trim (TOK_FUNCTION trim (TOK_FUNCTION trim (TOK_FUNCTION trim ' abc ')))))))))))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL src) key) 86))))
@@ -47,10 +58,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/286400075/10000
+ destination: file:/data/users/njain/hive5/hive5/build/ql/tmp/1184021016/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1387246464/10002
+ file:/data/users/njain/hive5/hive5/build/ql/tmp/612040254/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -82,9 +93,17 @@
name: dest1
-query: INSERT OVERWRITE TABLE dest1
+PREHOOK: query: INSERT OVERWRITE TABLE dest1
+SELECT trim(trim(trim(trim(trim(trim(trim(trim(trim(trim( ' abc '))))))))))
+FROM src
+WHERE src.key = 86
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@dest1
+POSTHOOK: query: INSERT OVERWRITE TABLE dest1
SELECT trim(trim(trim(trim(trim(trim(trim(trim(trim(trim( ' abc '))))))))))
FROM src
WHERE src.key = 86
-Input: default/src
-Output: default/dest1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@dest1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_abs.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_abs.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_abs.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_abs.q.out Tue Sep 29 01:25:15 2009
@@ -1,10 +1,19 @@
-query: EXPLAIN SELECT
+PREHOOK: query: EXPLAIN SELECT
abs(0),
abs(-1),
abs(123),
abs(-9223372036854775807),
abs(9223372036854775807)
FROM src LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT
+ abs(0),
+ abs(-1),
+ abs(123),
+ abs(-9223372036854775807),
+ abs(9223372036854775807)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION abs 0)) (TOK_SELEXPR (TOK_FUNCTION abs (- 1))) (TOK_SELEXPR (TOK_FUNCTION abs 123)) (TOK_SELEXPR (TOK_FUNCTION abs (- 9223372036854775807))) (TOK_SELEXPR (TOK_FUNCTION abs 9223372036854775807))) (TOK_LIMIT 1)))
@@ -45,21 +54,39 @@
limit: 1
-query: SELECT
+PREHOOK: query: SELECT
+ abs(0),
+ abs(-1),
+ abs(123),
+ abs(-9223372036854775807),
+ abs(9223372036854775807)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2094182155/10000
+POSTHOOK: query: SELECT
abs(0),
abs(-1),
abs(123),
abs(-9223372036854775807),
abs(9223372036854775807)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/977308324/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2094182155/10000
0 1 123 9223372036854775807 9223372036854775807
-query: EXPLAIN SELECT
+PREHOOK: query: EXPLAIN SELECT
+ abs(0.0),
+ abs(-3.14159265),
+ abs(3.14159265)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT
abs(0.0),
abs(-3.14159265),
abs(3.14159265)
FROM src LIMIT 1
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION abs 0.0)) (TOK_SELEXPR (TOK_FUNCTION abs (- 3.14159265))) (TOK_SELEXPR (TOK_FUNCTION abs 3.14159265))) (TOK_LIMIT 1)))
@@ -96,11 +123,20 @@
limit: 1
-query: SELECT
+PREHOOK: query: SELECT
+ abs(0.0),
+ abs(-3.14159265),
+ abs(3.14159265)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/108724608/10000
+POSTHOOK: query: SELECT
abs(0.0),
abs(-3.14159265),
abs(3.14159265)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/119274499/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/108724608/10000
0.0 3.14159265 3.14159265
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_acos.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_acos.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_acos.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_acos.q.out Tue Sep 29 01:25:15 2009
@@ -1,20 +1,44 @@
-query: SELECT acos(null)
+PREHOOK: query: SELECT acos(null)
FROM src LIMIT 1
-Input: default/src
-Output: file:/home/kmangla/hive/build/ql/tmp/952728720/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1457812629/10000
+POSTHOOK: query: SELECT acos(null)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1457812629/10000
NULL
-query: SELECT acos(0)
+PREHOOK: query: SELECT acos(0)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1180311283/10000
+POSTHOOK: query: SELECT acos(0)
FROM src LIMIT 1
-Input: default/src
-Output: file:/home/kmangla/hive/build/ql/tmp/1631791047/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1180311283/10000
1.5707963267948966
-query: SELECT acos(-0.5), asin(0.66)
+PREHOOK: query: SELECT acos(-0.5), asin(0.66)
FROM src LIMIT 1
-Input: default/src
-Output: file:/home/kmangla/hive/build/ql/tmp/1922816852/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/804897720/10000
+POSTHOOK: query: SELECT acos(-0.5), asin(0.66)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/804897720/10000
2.0943951023931957 0.7208187608700897
-query: SELECT acos(2)
+PREHOOK: query: SELECT acos(2)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/615514597/10000
+POSTHOOK: query: SELECT acos(2)
FROM src LIMIT 1
-Input: default/src
-Output: file:/home/kmangla/hive/build/ql/tmp/296909393/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/615514597/10000
NaN
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ascii.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ascii.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ascii.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ascii.q.out Tue Sep 29 01:25:15 2009
@@ -1,8 +1,15 @@
-query: EXPLAIN SELECT
+PREHOOK: query: EXPLAIN SELECT
ascii('Facebook'),
ascii(''),
ascii('!')
FROM src LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT
+ ascii('Facebook'),
+ ascii(''),
+ ascii('!')
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION ascii 'Facebook')) (TOK_SELEXPR (TOK_FUNCTION ascii '')) (TOK_SELEXPR (TOK_FUNCTION ascii '!'))) (TOK_LIMIT 1)))
@@ -39,11 +46,20 @@
limit: 1
-query: SELECT
+PREHOOK: query: SELECT
+ ascii('Facebook'),
+ ascii(''),
+ ascii('!')
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/772117818/10000
+POSTHOOK: query: SELECT
ascii('Facebook'),
ascii(''),
ascii('!')
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/317294381/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/772117818/10000
70 0 33
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_asin.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_asin.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_asin.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_asin.q.out Tue Sep 29 01:25:15 2009
@@ -1,20 +1,44 @@
-query: SELECT asin(null)
+PREHOOK: query: SELECT asin(null)
FROM src LIMIT 1
-Input: default/src
-Output: file:/home/kmangla/hive/build/ql/tmp/991103884/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/335338053/10000
+POSTHOOK: query: SELECT asin(null)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/335338053/10000
NULL
-query: SELECT asin(0)
+PREHOOK: query: SELECT asin(0)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1930989265/10000
+POSTHOOK: query: SELECT asin(0)
FROM src LIMIT 1
-Input: default/src
-Output: file:/home/kmangla/hive/build/ql/tmp/1020681434/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1930989265/10000
0.0
-query: SELECT asin(-0.5), asin(0.66)
+PREHOOK: query: SELECT asin(-0.5), asin(0.66)
FROM src LIMIT 1
-Input: default/src
-Output: file:/home/kmangla/hive/build/ql/tmp/702113357/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1036919646/10000
+POSTHOOK: query: SELECT asin(-0.5), asin(0.66)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1036919646/10000
-0.5235987755982989 0.7208187608700897
-query: SELECT asin(2)
+PREHOOK: query: SELECT asin(2)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1231279693/10000
+POSTHOOK: query: SELECT asin(2)
FROM src LIMIT 1
-Input: default/src
-Output: file:/home/kmangla/hive/build/ql/tmp/985907824/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1231279693/10000
NaN
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bin.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bin.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bin.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bin.q.out Tue Sep 29 01:25:15 2009
@@ -1,13 +1,28 @@
-query: SELECT
+PREHOOK: query: SELECT
bin(1),
bin(0),
bin(99992421)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/1248344323/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/359409613/10000
+POSTHOOK: query: SELECT
+ bin(1),
+ bin(0),
+ bin(99992421)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/359409613/10000
1 0 101111101011100001101100101
-query: -- Negative numbers should be treated as two's complement (64 bit).
+PREHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
+SELECT bin(-5) FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/991182455/10000
+POSTHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
SELECT bin(-5) FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/1854602523/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/991182455/10000
1111111111111111111111111111111111111111111111111111111111111011
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out Tue Sep 29 01:25:15 2009
@@ -1,4 +1,4 @@
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT CASE 1
WHEN 1 THEN 2
WHEN 3 THEN 4
@@ -25,6 +25,35 @@
WHEN 21 THEN 24
END
FROM src LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT CASE 1
+ WHEN 1 THEN 2
+ WHEN 3 THEN 4
+ ELSE 5
+ END,
+ CASE 2
+ WHEN 1 THEN 2
+ ELSE 5
+ END,
+ CASE 14
+ WHEN 12 THEN 13
+ WHEN 14 THEN 15
+ END,
+ CASE 16
+ WHEN 12 THEN 13
+ WHEN 14 THEN 15
+ END,
+ CASE 17
+ WHEN 18 THEN NULL
+ WHEN 17 THEN 20
+ END,
+ CASE 21
+ WHEN 22 THEN 23
+ WHEN 21 THEN 24
+ END
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION CASE 1 1 2 3 4 5)) (TOK_SELEXPR (TOK_FUNCTION CASE 2 1 2 5)) (TOK_SELEXPR (TOK_FUNCTION CASE 14 12 13 14 15)) (TOK_SELEXPR (TOK_FUNCTION CASE 16 12 13 14 15)) (TOK_SELEXPR (TOK_FUNCTION CASE 17 18 TOK_NULL 17 20)) (TOK_SELEXPR (TOK_FUNCTION CASE 21 22 23 21 24))) (TOK_LIMIT 1)))
@@ -67,7 +96,36 @@
limit: 1
-query: SELECT CASE 1
+PREHOOK: query: SELECT CASE 1
+ WHEN 1 THEN 2
+ WHEN 3 THEN 4
+ ELSE 5
+ END,
+ CASE 2
+ WHEN 1 THEN 2
+ ELSE 5
+ END,
+ CASE 14
+ WHEN 12 THEN 13
+ WHEN 14 THEN 15
+ END,
+ CASE 16
+ WHEN 12 THEN 13
+ WHEN 14 THEN 15
+ END,
+ CASE 17
+ WHEN 18 THEN NULL
+ WHEN 17 THEN 20
+ END,
+ CASE 21
+ WHEN 22 THEN 23
+ WHEN 21 THEN 24
+ END
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/606727511/10000
+POSTHOOK: query: SELECT CASE 1
WHEN 1 THEN 2
WHEN 3 THEN 4
ELSE 5
@@ -93,6 +151,7 @@
WHEN 21 THEN 24
END
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1655100692/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/606727511/10000
2 5 15 NULL 20 24
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out Tue Sep 29 01:25:15 2009
@@ -1,4 +1,4 @@
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT CASE a.key
WHEN '1' THEN 2
WHEN '3' THEN 4
@@ -7,6 +7,17 @@
FROM src a JOIN src b
ON a.key = b.key
ORDER BY key LIMIT 10
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT CASE a.key
+ WHEN '1' THEN 2
+ WHEN '3' THEN 4
+ ELSE 5
+ END as key
+FROM src a JOIN src b
+ON a.key = b.key
+ORDER BY key LIMIT 10
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF src a) (TOK_TABREF src b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION CASE (. (TOK_TABLE_OR_COL a) key) '1' 2 '3' 4 5) key)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key))) (TOK_LIMIT 10)))
@@ -69,7 +80,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1921754702/10002
+ file:/data/users/njain/hive5/hive5/build/ql/tmp/483718410/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -94,7 +105,18 @@
limit: 10
-query: SELECT CASE a.key
+PREHOOK: query: SELECT CASE a.key
+ WHEN '1' THEN 2
+ WHEN '3' THEN 4
+ ELSE 5
+ END as key
+FROM src a JOIN src b
+ON a.key = b.key
+ORDER BY key LIMIT 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1574907719/10000
+POSTHOOK: query: SELECT CASE a.key
WHEN '1' THEN 2
WHEN '3' THEN 4
ELSE 5
@@ -102,8 +124,9 @@
FROM src a JOIN src b
ON a.key = b.key
ORDER BY key LIMIT 10
-Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/8014055/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1574907719/10000
5
5
5
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_thrift.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_thrift.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_thrift.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_thrift.q.out Tue Sep 29 01:25:15 2009
@@ -1,4 +1,4 @@
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT CASE src_thrift.lint[0]
WHEN 0 THEN src_thrift.lint[0] + 1
WHEN 1 THEN src_thrift.lint[0] + 2
@@ -15,6 +15,25 @@
ELSE NULL
END)[0]
FROM src_thrift LIMIT 3
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT CASE src_thrift.lint[0]
+ WHEN 0 THEN src_thrift.lint[0] + 1
+ WHEN 1 THEN src_thrift.lint[0] + 2
+ WHEN 2 THEN 100
+ ELSE 5
+ END,
+ CASE src_thrift.lstring[0]
+ WHEN '0' THEN 'zero'
+ WHEN '10' THEN CONCAT(src_thrift.lstring[0], " is ten")
+ ELSE 'default'
+ END,
+ (CASE src_thrift.lstring[0]
+ WHEN '0' THEN src_thrift.lstring
+ ELSE NULL
+ END)[0]
+FROM src_thrift LIMIT 3
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION CASE ([ (. (TOK_TABLE_OR_COL src_thrift) lint) 0) 0 (+ ([ (. (TOK_TABLE_OR_COL src_thrift) lint) 0) 1) 1 (+ ([ (. (TOK_TABLE_OR_COL src_thrift) lint) 0) 2) 2 100 5)) (TOK_SELEXPR (TOK_FUNCTION CASE ([ (. (TOK_TABLE_OR_COL src_thrift) lstring) 0) '0' 'zero' '10' (TOK_FUNCTION CONCAT ([ (. (TOK_TABLE_OR_COL src_thrift) lstring) 0) " is ten") 'default')) (TOK_SELEXPR ([ (TOK_FUNCTION CASE ([ (. (TOK_TABLE_OR_COL src_thrift) lstring) 0) '0' (. (TOK_TABLE_OR_COL src_thrift) lstring) TOK_NULL) 0))) (TOK_LIMIT 3)))
@@ -51,7 +70,26 @@
limit: 3
-query: SELECT CASE src_thrift.lint[0]
+PREHOOK: query: SELECT CASE src_thrift.lint[0]
+ WHEN 0 THEN src_thrift.lint[0] + 1
+ WHEN 1 THEN src_thrift.lint[0] + 2
+ WHEN 2 THEN 100
+ ELSE 5
+ END,
+ CASE src_thrift.lstring[0]
+ WHEN '0' THEN 'zero'
+ WHEN '10' THEN CONCAT(src_thrift.lstring[0], " is ten")
+ ELSE 'default'
+ END,
+ (CASE src_thrift.lstring[0]
+ WHEN '0' THEN src_thrift.lstring
+ ELSE NULL
+ END)[0]
+FROM src_thrift LIMIT 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_thrift
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1533247370/10000
+POSTHOOK: query: SELECT CASE src_thrift.lint[0]
WHEN 0 THEN src_thrift.lint[0] + 1
WHEN 1 THEN src_thrift.lint[0] + 2
WHEN 2 THEN 100
@@ -67,8 +105,9 @@
ELSE NULL
END)[0]
FROM src_thrift LIMIT 3
-Input: default/src_thrift
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/87841953/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_thrift
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1533247370/10000
1 zero 0
3 10 is ten NULL
100 default NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_coalesce.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_coalesce.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_coalesce.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_coalesce.q.out Tue Sep 29 01:25:15 2009
@@ -1,4 +1,4 @@
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT COALESCE(1),
COALESCE(1, 2),
COALESCE(NULL, 2),
@@ -18,6 +18,28 @@
COALESCE(2.0, NULL, 3.0),
COALESCE(IF(TRUE, NULL, 0), NULL)
FROM src LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT COALESCE(1),
+ COALESCE(1, 2),
+ COALESCE(NULL, 2),
+ COALESCE(1, NULL),
+ COALESCE(NULL, NULL, 3),
+ COALESCE(4, NULL, NULL, NULL),
+ COALESCE('1'),
+ COALESCE('1', '2'),
+ COALESCE(NULL, '2'),
+ COALESCE('1', NULL),
+ COALESCE(NULL, NULL, '3'),
+ COALESCE('4', NULL, NULL, NULL),
+ COALESCE(1.0),
+ COALESCE(1.0, 2.0),
+ COALESCE(NULL, 2.0),
+ COALESCE(NULL, 2.0, 3.0),
+ COALESCE(2.0, NULL, 3.0),
+ COALESCE(IF(TRUE, NULL, 0), NULL)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION COALESCE 1)) (TOK_SELEXPR (TOK_FUNCTION COALESCE 1 2)) (TOK_SELEXPR (TOK_FUNCTION COALESCE TOK_NULL 2)) (TOK_SELEXPR (TOK_FUNCTION COALESCE 1 TOK_NULL)) (TOK_SELEXPR (TOK_FUNCTION COALESCE TOK_NULL TOK_NULL 3)) (TOK_SELEXPR (TOK_FUNCTION COALESCE 4 TOK_NULL TOK_NULL TOK_NULL)) (TOK_SELEXPR (TOK_FUNCTION COALESCE '1')) (TOK_SELEXPR (TOK_FUNCTION COALESCE '1' '2')) (TOK_SELEXPR (TOK_FUNCTION COALESCE TOK_NULL '2')) (TOK_SELEXPR (TOK_FUNCTION COALESCE '1' TOK_NULL)) (TOK_SELEXPR (TOK_FUNCTION COALESCE TOK_NULL TOK_NULL '3')) (TOK_SELEXPR (TOK_FUNCTION COALESCE '4' TOK_NULL TOK_NULL TOK_NULL)) (TOK_SELEXPR (TOK_FUNCTION COALESCE 1.0)) (TOK_SELEXPR (TOK_FUNCTION COALESCE 1.0 2.0)) (TOK_SELEXPR (TOK_FUNCTION COALESCE TOK_NULL 2.0)) (TOK_SELEXPR (TOK_FUNCTION COALESCE TOK_NULL 2.0 3.0)) (TOK_SELEXPR (TOK_FUNCTION COALESCE 2.0 TOK_NULL 3.0)) (TOK_SELEX
PR (TOK_FUNCTION COALESCE (TOK_FUNCTION IF TRUE TOK_NULL 0) TOK_NULL))) (TOK_LIMIT 1)))
@@ -84,7 +106,29 @@
limit: 1
-query: SELECT COALESCE(1),
+PREHOOK: query: SELECT COALESCE(1),
+ COALESCE(1, 2),
+ COALESCE(NULL, 2),
+ COALESCE(1, NULL),
+ COALESCE(NULL, NULL, 3),
+ COALESCE(4, NULL, NULL, NULL),
+ COALESCE('1'),
+ COALESCE('1', '2'),
+ COALESCE(NULL, '2'),
+ COALESCE('1', NULL),
+ COALESCE(NULL, NULL, '3'),
+ COALESCE('4', NULL, NULL, NULL),
+ COALESCE(1.0),
+ COALESCE(1.0, 2.0),
+ COALESCE(NULL, 2.0),
+ COALESCE(NULL, 2.0, 3.0),
+ COALESCE(2.0, NULL, 3.0),
+ COALESCE(IF(TRUE, NULL, 0), NULL)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1848821474/10000
+POSTHOOK: query: SELECT COALESCE(1),
COALESCE(1, 2),
COALESCE(NULL, 2),
COALESCE(1, NULL),
@@ -103,14 +147,22 @@
COALESCE(2.0, NULL, 3.0),
COALESCE(IF(TRUE, NULL, 0), NULL)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/928019024/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1848821474/10000
1 1 2 1 3 4 1 1 2 1 3 4 1.0 1.0 2.0 2.0 2.0 NULL
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT COALESCE(src_thrift.lint[1], 999),
COALESCE(src_thrift.lintstring[0].mystring, '999'),
COALESCE(src_thrift.mstringstring['key_2'], '999')
FROM src_thrift
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT COALESCE(src_thrift.lint[1], 999),
+ COALESCE(src_thrift.lintstring[0].mystring, '999'),
+ COALESCE(src_thrift.mstringstring['key_2'], '999')
+FROM src_thrift
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION COALESCE ([ (. (TOK_TABLE_OR_COL src_thrift) lint) 1) 999)) (TOK_SELEXPR (TOK_FUNCTION COALESCE (. ([ (. (TOK_TABLE_OR_COL src_thrift) lintstring) 0) mystring) '999')) (TOK_SELEXPR (TOK_FUNCTION COALESCE ([ (. (TOK_TABLE_OR_COL src_thrift) mstringstring) 'key_2') '999')))))
@@ -146,12 +198,20 @@
limit: -1
-query: SELECT COALESCE(src_thrift.lint[1], 999),
+PREHOOK: query: SELECT COALESCE(src_thrift.lint[1], 999),
+ COALESCE(src_thrift.lintstring[0].mystring, '999'),
+ COALESCE(src_thrift.mstringstring['key_2'], '999')
+FROM src_thrift
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_thrift
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1800031969/10000
+POSTHOOK: query: SELECT COALESCE(src_thrift.lint[1], 999),
COALESCE(src_thrift.lintstring[0].mystring, '999'),
COALESCE(src_thrift.mstringstring['key_2'], '999')
FROM src_thrift
-Input: default/src_thrift
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/826777318/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_thrift
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1800031969/10000
0 0 999
2 1 999
4 8 value_2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_conv.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_conv.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_conv.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_conv.q.out Tue Sep 29 01:25:15 2009
@@ -1,4 +1,4 @@
-query: -- conv must work on both strings and integers up to 64-bit precision
+PREHOOK: query: -- conv must work on both strings and integers up to 64-bit precision
-- Some simple conversions to test different bases
SELECT
@@ -7,10 +7,34 @@
conv('110011', 2, 16),
conv('facebook', 36, 16)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/623411735/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1394785532/10000
+POSTHOOK: query: -- conv must work on both strings and integers up to 64-bit precision
+
+-- Some simple conversions to test different bases
+SELECT
+ conv('4521', 10, 36),
+ conv('22', 10, 10),
+ conv('110011', 2, 16),
+ conv('facebook', 36, 16)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1394785532/10000
3HL 22 33 116ED2B2FB4
-query: -- Test negative numbers. If to_base is positive, the number should be handled
+PREHOOK: query: -- Test negative numbers. If to_base is positive, the number should be handled
+-- as a two's complement (64-bit)
+SELECT
+ conv('-641', 10, -10),
+ conv('1011', 2, -16),
+ conv('-1', 10, 16),
+ conv('-15', 10, 16)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/297144160/10000
+POSTHOOK: query: -- Test negative numbers. If to_base is positive, the number should be handled
-- as a two's complement (64-bit)
SELECT
conv('-641', 10, -10),
@@ -18,10 +42,11 @@
conv('-1', 10, 16),
conv('-15', 10, 16)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/1206714471/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/297144160/10000
-641 B FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFF1
-query: -- Test overflow. If a number is two large, the result should be -1 (if signed)
+PREHOOK: query: -- Test overflow. If a number is two large, the result should be -1 (if signed)
-- or MAX_LONG (if unsigned)
SELECT
conv('9223372036854775807', 36, 16),
@@ -29,10 +54,22 @@
conv('-9223372036854775807', 36, 16),
conv('-9223372036854775807', 36, -16)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/1160875939/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/311355603/10000
+POSTHOOK: query: -- Test overflow. If a number is two large, the result should be -1 (if signed)
+-- or MAX_LONG (if unsigned)
+SELECT
+ conv('9223372036854775807', 36, 16),
+ conv('9223372036854775807', 36, -16),
+ conv('-9223372036854775807', 36, 16),
+ conv('-9223372036854775807', 36, -16)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/311355603/10000
FFFFFFFFFFFFFFFF -1 FFFFFFFFFFFFFFFF -1
-query: -- Test with invalid input. If one of the bases is invalid, the result should
+PREHOOK: query: -- Test with invalid input. If one of the bases is invalid, the result should
-- be NULL. If there is an invalid digit in the number, the longest valid
-- prefix should be converted.
SELECT
@@ -41,43 +78,97 @@
conv('515', 5, 100),
conv('10', -2, 2)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/21887943/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1893103412/10000
+POSTHOOK: query: -- Test with invalid input. If one of the bases is invalid, the result should
+-- be NULL. If there is an invalid digit in the number, the longest valid
+-- prefix should be converted.
+SELECT
+ conv('123455', 3, 10),
+ conv('131', 1, 5),
+ conv('515', 5, 100),
+ conv('10', -2, 2)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1893103412/10000
5 NULL NULL NULL
-query: -- Perform the same tests with number arguments.
+PREHOOK: query: -- Perform the same tests with number arguments.
SELECT
conv(4521, 10, 36),
conv(22, 10, 10),
conv(110011, 2, 16)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/860089866/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/374689536/10000
+POSTHOOK: query: -- Perform the same tests with number arguments.
+
+SELECT
+ conv(4521, 10, 36),
+ conv(22, 10, 10),
+ conv(110011, 2, 16)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/374689536/10000
3HL 22 33
-query: SELECT
+PREHOOK: query: SELECT
conv(-641, 10, -10),
conv(1011, 2, -16),
conv(-1, 10, 16),
conv(-15, 10, 16)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/2001834317/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/117827629/10000
+POSTHOOK: query: SELECT
+ conv(-641, 10, -10),
+ conv(1011, 2, -16),
+ conv(-1, 10, 16),
+ conv(-15, 10, 16)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/117827629/10000
-641 B FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFF1
-query: SELECT
+PREHOOK: query: SELECT
+ conv(9223372036854775807, 36, 16),
+ conv(9223372036854775807, 36, -16),
+ conv(-9223372036854775807, 36, 16),
+ conv(-9223372036854775807, 36, -16)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/638334947/10000
+POSTHOOK: query: SELECT
conv(9223372036854775807, 36, 16),
conv(9223372036854775807, 36, -16),
conv(-9223372036854775807, 36, 16),
conv(-9223372036854775807, 36, -16)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/1609692602/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/638334947/10000
FFFFFFFFFFFFFFFF -1 FFFFFFFFFFFFFFFF -1
-query: SELECT
+PREHOOK: query: SELECT
+ conv(123455, 3, 10),
+ conv(131, 1, 5),
+ conv(515, 5, 100),
+ conv('10', -2, 2)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/315464649/10000
+POSTHOOK: query: SELECT
conv(123455, 3, 10),
conv(131, 1, 5),
conv(515, 5, 100),
conv('10', -2, 2)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/1197566112/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/315464649/10000
5 NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_cos.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_cos.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_cos.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_cos.q.out Tue Sep 29 01:25:15 2009
@@ -1,10 +1,22 @@
-query: SELECT cos(null)
+PREHOOK: query: SELECT cos(null)
FROM src LIMIT 1
-Input: default/src
-Output: file:/home/kmangla/hive/build/ql/tmp/1815431857/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1521763480/10000
+POSTHOOK: query: SELECT cos(null)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1521763480/10000
NULL
-query: SELECT cos(0.98), cos(1.57), cos(-0.5)
+PREHOOK: query: SELECT cos(0.98), cos(1.57), cos(-0.5)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1918624552/10000
+POSTHOOK: query: SELECT cos(0.98), cos(1.57), cos(-0.5)
FROM src LIMIT 1
-Input: default/src
-Output: file:/home/kmangla/hive/build/ql/tmp/1350046602/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1918624552/10000
0.5570225467662173 7.963267107332633E-4 0.8775825618903728
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divider.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divider.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divider.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divider.q.out Tue Sep 29 01:25:15 2009
@@ -1,8 +1,18 @@
-query: SELECT 3 / 2 FROM SRC LIMIT 1
-Input: default/src
-Output: file:/data/users/nzhang/work/774/774-trunk-apache-hive/build/ql/tmp/1383988370/10000
+PREHOOK: query: SELECT 3 / 2 FROM SRC LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/399492793/10000
+POSTHOOK: query: SELECT 3 / 2 FROM SRC LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/399492793/10000
1.5
-query: SELECT 3 DIV 2 FROM SRC LIMIT 1
-Input: default/src
-Output: file:/data/users/nzhang/work/774/774-trunk-apache-hive/build/ql/tmp/1562639283/10000
+PREHOOK: query: SELECT 3 DIV 2 FROM SRC LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1110831247/10000
+POSTHOOK: query: SELECT 3 DIV 2 FROM SRC LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1110831247/10000
1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_elt.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_elt.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_elt.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_elt.q.out Tue Sep 29 01:25:15 2009
@@ -1,4 +1,4 @@
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT elt(2, 'abc', 'defg'),
elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
elt('1', 'abc', 'defg'),
@@ -11,6 +11,21 @@
elt(0, 'abc', 'defg'),
elt(3, 'abc', 'defg')
FROM src LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT elt(2, 'abc', 'defg'),
+ elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
+ elt('1', 'abc', 'defg'),
+ elt(2, 'aa', CAST('2' AS TINYINT)),
+ elt(2, 'aa', CAST('12345' AS SMALLINT)),
+ elt(2, 'aa', CAST('123456789012' AS BIGINT)),
+ elt(2, 'aa', CAST(1.25 AS FLOAT)),
+ elt(2, 'aa', CAST(16.0 AS DOUBLE)),
+ elt(null, 'abc', 'defg'),
+ elt(0, 'abc', 'defg'),
+ elt(3, 'abc', 'defg')
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION elt 2 'abc' 'defg')) (TOK_SELEXPR (TOK_FUNCTION elt 3 'aa' 'bb' 'cc' 'dd' 'ee' 'ff' 'gg')) (TOK_SELEXPR (TOK_FUNCTION elt '1' 'abc' 'defg')) (TOK_SELEXPR (TOK_FUNCTION elt 2 'aa' (TOK_FUNCTION TOK_TINYINT '2'))) (TOK_SELEXPR (TOK_FUNCTION elt 2 'aa' (TOK_FUNCTION TOK_SMALLINT '12345'))) (TOK_SELEXPR (TOK_FUNCTION elt 2 'aa' (TOK_FUNCTION TOK_BIGINT '123456789012'))) (TOK_SELEXPR (TOK_FUNCTION elt 2 'aa' (TOK_FUNCTION TOK_FLOAT 1.25))) (TOK_SELEXPR (TOK_FUNCTION elt 2 'aa' (TOK_FUNCTION TOK_DOUBLE 16.0))) (TOK_SELEXPR (TOK_FUNCTION elt TOK_NULL 'abc' 'defg')) (TOK_SELEXPR (TOK_FUNCTION elt 0 'abc' 'defg')) (TOK_SELEXPR (TOK_FUNCTION elt 3 'abc' 'defg'))) (TOK_LIMIT 1)))
@@ -63,7 +78,22 @@
limit: 1
-query: SELECT elt(2, 'abc', 'defg'),
+PREHOOK: query: SELECT elt(2, 'abc', 'defg'),
+ elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
+ elt('1', 'abc', 'defg'),
+ elt(2, 'aa', CAST('2' AS TINYINT)),
+ elt(2, 'aa', CAST('12345' AS SMALLINT)),
+ elt(2, 'aa', CAST('123456789012' AS BIGINT)),
+ elt(2, 'aa', CAST(1.25 AS FLOAT)),
+ elt(2, 'aa', CAST(16.0 AS DOUBLE)),
+ elt(null, 'abc', 'defg'),
+ elt(0, 'abc', 'defg'),
+ elt(3, 'abc', 'defg')
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1564252056/10000
+POSTHOOK: query: SELECT elt(2, 'abc', 'defg'),
elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
elt('1', 'abc', 'defg'),
elt(2, 'aa', CAST('2' AS TINYINT)),
@@ -75,6 +105,7 @@
elt(0, 'abc', 'defg'),
elt(3, 'abc', 'defg')
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/298713096/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1564252056/10000
defg cc abc 2 12345 123456789012 1.25 16.0 NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hash.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hash.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hash.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hash.q.out Tue Sep 29 01:25:15 2009
@@ -1,10 +1,19 @@
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT hash(CAST(1 AS TINYINT)), hash(CAST(2 AS SMALLINT)),
hash(3), hash(CAST('123456789012' AS BIGINT)),
hash(CAST(1.25 AS FLOAT)), hash(CAST(16.0 AS DOUBLE)),
hash('400'), hash('abc'), hash(TRUE), hash(FALSE),
hash(1, 2, 3)
FROM src LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT hash(CAST(1 AS TINYINT)), hash(CAST(2 AS SMALLINT)),
+ hash(3), hash(CAST('123456789012' AS BIGINT)),
+ hash(CAST(1.25 AS FLOAT)), hash(CAST(16.0 AS DOUBLE)),
+ hash('400'), hash('abc'), hash(TRUE), hash(FALSE),
+ hash(1, 2, 3)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_TINYINT 1))) (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_SMALLINT 2))) (TOK_SELEXPR (TOK_FUNCTION hash 3)) (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_BIGINT '123456789012'))) (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_FLOAT 1.25))) (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_DOUBLE 16.0))) (TOK_SELEXPR (TOK_FUNCTION hash '400')) (TOK_SELEXPR (TOK_FUNCTION hash 'abc')) (TOK_SELEXPR (TOK_FUNCTION hash TRUE)) (TOK_SELEXPR (TOK_FUNCTION hash FALSE)) (TOK_SELEXPR (TOK_FUNCTION hash 1 2 3))) (TOK_LIMIT 1)))
@@ -57,12 +66,22 @@
limit: 1
-query: SELECT hash(CAST(1 AS TINYINT)), hash(CAST(2 AS SMALLINT)),
+PREHOOK: query: SELECT hash(CAST(1 AS TINYINT)), hash(CAST(2 AS SMALLINT)),
+ hash(3), hash(CAST('123456789012' AS BIGINT)),
+ hash(CAST(1.25 AS FLOAT)), hash(CAST(16.0 AS DOUBLE)),
+ hash('400'), hash('abc'), hash(TRUE), hash(FALSE),
+ hash(1, 2, 3)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/875530574/10000
+POSTHOOK: query: SELECT hash(CAST(1 AS TINYINT)), hash(CAST(2 AS SMALLINT)),
hash(3), hash(CAST('123456789012' AS BIGINT)),
hash(CAST(1.25 AS FLOAT)), hash(CAST(16.0 AS DOUBLE)),
hash('400'), hash('abc'), hash(TRUE), hash(FALSE),
hash(1, 2, 3)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/378731640/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/875530574/10000
1 2 3 -1097262584 1067450368 1076887552 51508 96354 1 0 1026
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hex.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hex.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hex.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hex.q.out Tue Sep 29 01:25:15 2009
@@ -1,24 +1,51 @@
-query: -- If the argument is a string, hex should return a string containing two hex
+PREHOOK: query: -- If the argument is a string, hex should return a string containing two hex
-- digits for every character in the input.
SELECT
hex('Facebook'),
hex('\0'),
hex('qwertyuiopasdfghjkl')
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/375294624/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1894329188/10000
+POSTHOOK: query: -- If the argument is a string, hex should return a string containing two hex
+-- digits for every character in the input.
+SELECT
+ hex('Facebook'),
+ hex('\0'),
+ hex('qwertyuiopasdfghjkl')
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1894329188/10000
46616365626F6F6B 00 71776572747975696F706173646667686A6B6C
-query: -- If the argument is a number, hex should convert it to hexadecimal.
+PREHOOK: query: -- If the argument is a number, hex should convert it to hexadecimal.
SELECT
hex(1),
hex(0),
hex(4207849477)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/1068245471/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1277538639/10000
+POSTHOOK: query: -- If the argument is a number, hex should convert it to hexadecimal.
+SELECT
+ hex(1),
+ hex(0),
+ hex(4207849477)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1277538639/10000
1 0 FACEB005
-query: -- Negative numbers should be treated as two's complement (64 bit).
+PREHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
+SELECT hex(-5) FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2119469168/10000
+POSTHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
SELECT hex(-5) FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/1738127711/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2119469168/10000
FFFFFFFFFFFFFFFB
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour_minute_second.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour_minute_second.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour_minute_second.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour_minute_second.q.out Tue Sep 29 01:25:15 2009
@@ -1,10 +1,22 @@
-query: DESCRIBE FUNCTION hour
+PREHOOK: query: DESCRIBE FUNCTION hour
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION hour
+POSTHOOK: type: DESCFUNCTION
hour(date) - Returns the hour of date
-query: DESCRIBE FUNCTION minute
+PREHOOK: query: DESCRIBE FUNCTION minute
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION minute
+POSTHOOK: type: DESCFUNCTION
minute(date) - Returns the minute of date
-query: DESCRIBE FUNCTION second
+PREHOOK: query: DESCRIBE FUNCTION second
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION second
+POSTHOOK: type: DESCFUNCTION
second(date) - Returns the second of date
-query: DESCRIBE FUNCTION EXTENDED hour
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED hour
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED hour
+POSTHOOK: type: DESCFUNCTION
hour(date) - Returns the hour of date
date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'.
Example:
@@ -12,7 +24,10 @@
12
> SELECT hour('12:58:59') FROM src LIMIT 1;
12
-query: DESCRIBE FUNCTION EXTENDED minute
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED minute
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED minute
+POSTHOOK: type: DESCFUNCTION
minute(date) - Returns the minute of date
date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'.
Example:
@@ -20,7 +35,10 @@
58
> SELECT minute('12:58:59') FROM src LIMIT 1;
58
-query: DESCRIBE FUNCTION EXTENDED second
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED second
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED second
+POSTHOOK: type: DESCFUNCTION
second(date) - Returns the second of date
date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'.
Example:
@@ -28,11 +46,18 @@
59
> SELECT second('12:58:59') FROM src LIMIT 1;
59
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07'),
minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07'),
second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
FROM src WHERE key = 86
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07'),
+ minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07'),
+ second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
+FROM src WHERE key = 86
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION hour '2009-08-07 13:14:15')) (TOK_SELEXPR (TOK_FUNCTION hour '13:14:15')) (TOK_SELEXPR (TOK_FUNCTION hour '2009-08-07')) (TOK_SELEXPR (TOK_FUNCTION minute '2009-08-07 13:14:15')) (TOK_SELEXPR (TOK_FUNCTION minute '13:14:15')) (TOK_SELEXPR (TOK_FUNCTION minute '2009-08-07')) (TOK_SELEXPR (TOK_FUNCTION second '2009-08-07 13:14:15')) (TOK_SELEXPR (TOK_FUNCTION second '13:14:15')) (TOK_SELEXPR (TOK_FUNCTION second '2009-08-07'))) (TOK_WHERE (= (TOK_TABLE_OR_COL key) 86))))
@@ -88,10 +113,18 @@
limit: -1
-query: SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07'),
+PREHOOK: query: SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07'),
+ minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07'),
+ second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
+FROM src WHERE key = 86
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/785767007/10000
+POSTHOOK: query: SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07'),
minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07'),
second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
FROM src WHERE key = 86
-Input: default/src
-Output: file:/data/users/zshao/tools/fb_hadoop/trunk/VENDOR.hive/trunk/build/ql/tmp/388087227/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/785767007/10000
13 13 NULL 14 14 NULL 15 15 NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out Tue Sep 29 01:25:15 2009
@@ -1,4 +1,4 @@
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT IF(TRUE, 1, 2) AS COL1,
IF(FALSE, CAST(NULL AS STRING), CAST(1 AS STRING)) AS COL2,
IF(1=1, IF(2=2, 1, 2), IF(3=3, 3, 4)) AS COL3,
@@ -6,6 +6,16 @@
IF(2=2, NULL, 1) AS COL5,
IF(IF(TRUE, NULL, FALSE), 1, 2) AS COL6
FROM src LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT IF(TRUE, 1, 2) AS COL1,
+ IF(FALSE, CAST(NULL AS STRING), CAST(1 AS STRING)) AS COL2,
+ IF(1=1, IF(2=2, 1, 2), IF(3=3, 3, 4)) AS COL3,
+ IF(2=2, 1, NULL) AS COL4,
+ IF(2=2, NULL, 1) AS COL5,
+ IF(IF(TRUE, NULL, FALSE), 1, 2) AS COL6
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION IF TRUE 1 2) COL1) (TOK_SELEXPR (TOK_FUNCTION IF FALSE (TOK_FUNCTION TOK_STRING TOK_NULL) (TOK_FUNCTION TOK_STRING 1)) COL2) (TOK_SELEXPR (TOK_FUNCTION IF (= 1 1) (TOK_FUNCTION IF (= 2 2) 1 2) (TOK_FUNCTION IF (= 3 3) 3 4)) COL3) (TOK_SELEXPR (TOK_FUNCTION IF (= 2 2) 1 TOK_NULL) COL4) (TOK_SELEXPR (TOK_FUNCTION IF (= 2 2) TOK_NULL 1) COL5) (TOK_SELEXPR (TOK_FUNCTION IF (TOK_FUNCTION IF TRUE TOK_NULL FALSE) 1 2) COL6)) (TOK_LIMIT 1)))
@@ -48,23 +58,43 @@
limit: 1
-query: SELECT IF(TRUE, 1, 2) AS COL1,
+PREHOOK: query: SELECT IF(TRUE, 1, 2) AS COL1,
IF(FALSE, CAST(NULL AS STRING), CAST(1 AS STRING)) AS COL2,
IF(1=1, IF(2=2, 1, 2), IF(3=3, 3, 4)) AS COL3,
IF(2=2, 1, NULL) AS COL4,
IF(2=2, NULL, 1) AS COL5,
IF(IF(TRUE, NULL, FALSE), 1, 2) AS COL6
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1117188098/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1333420658/10000
+POSTHOOK: query: SELECT IF(TRUE, 1, 2) AS COL1,
+ IF(FALSE, CAST(NULL AS STRING), CAST(1 AS STRING)) AS COL2,
+ IF(1=1, IF(2=2, 1, 2), IF(3=3, 3, 4)) AS COL3,
+ IF(2=2, 1, NULL) AS COL4,
+ IF(2=2, NULL, 1) AS COL5,
+ IF(IF(TRUE, NULL, FALSE), 1, 2) AS COL6
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1333420658/10000
1 1 1 1 NULL 2
-query: -- Type conversions
+PREHOOK: query: -- Type conversions
EXPLAIN
SELECT IF(TRUE, CAST(128 AS SMALLINT), CAST(1 AS TINYINT)) AS COL1,
IF(FALSE, 1, 1.1) AS COL2,
IF(FALSE, 1, 'ABC') AS COL3,
IF(FALSE, 'ABC', 12.3) AS COL4
FROM src LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: -- Type conversions
+EXPLAIN
+SELECT IF(TRUE, CAST(128 AS SMALLINT), CAST(1 AS TINYINT)) AS COL1,
+ IF(FALSE, 1, 1.1) AS COL2,
+ IF(FALSE, 1, 'ABC') AS COL3,
+ IF(FALSE, 'ABC', 12.3) AS COL4
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION IF TRUE (TOK_FUNCTION TOK_SMALLINT 128) (TOK_FUNCTION TOK_TINYINT 1)) COL1) (TOK_SELEXPR (TOK_FUNCTION IF FALSE 1 1.1) COL2) (TOK_SELEXPR (TOK_FUNCTION IF FALSE 1 'ABC') COL3) (TOK_SELEXPR (TOK_FUNCTION IF FALSE 'ABC' 12.3) COL4)) (TOK_LIMIT 1)))
@@ -103,11 +133,20 @@
limit: 1
-query: SELECT IF(TRUE, CAST(128 AS SMALLINT), CAST(1 AS TINYINT)) AS COL1,
+PREHOOK: query: SELECT IF(TRUE, CAST(128 AS SMALLINT), CAST(1 AS TINYINT)) AS COL1,
+ IF(FALSE, 1, 1.1) AS COL2,
+ IF(FALSE, 1, 'ABC') AS COL3,
+ IF(FALSE, 'ABC', 12.3) AS COL4
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2081932428/10000
+POSTHOOK: query: SELECT IF(TRUE, CAST(128 AS SMALLINT), CAST(1 AS TINYINT)) AS COL1,
IF(FALSE, 1, 1.1) AS COL2,
IF(FALSE, 1, 'ABC') AS COL3,
IF(FALSE, 'ABC', 12.3) AS COL4
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/97050959/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2081932428/10000
128 1.1 ABC 12.3
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_instr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_instr.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_instr.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_instr.q.out Tue Sep 29 01:25:15 2009
@@ -1,4 +1,4 @@
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT instr('abcd', 'abc'),
instr('abcabc', 'ccc'),
instr(123, '23'),
@@ -13,6 +13,23 @@
instr(null, 'abc'),
instr('abcd', null)
FROM src LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT instr('abcd', 'abc'),
+ instr('abcabc', 'ccc'),
+ instr(123, '23'),
+ instr(123, 23),
+ instr(TRUE, 1),
+ instr(FALSE, 1),
+ instr('12345', CAST('2' AS TINYINT)),
+ instr(CAST('12345' AS SMALLINT), '34'),
+ instr(CAST('123456789012' AS BIGINT), '456'),
+ instr(CAST(1.25 AS FLOAT), '.25'),
+ instr(CAST(16.0 AS DOUBLE), '.0'),
+ instr(null, 'abc'),
+ instr('abcd', null)
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION instr 'abcd' 'abc')) (TOK_SELEXPR (TOK_FUNCTION instr 'abcabc' 'ccc')) (TOK_SELEXPR (TOK_FUNCTION instr 123 '23')) (TOK_SELEXPR (TOK_FUNCTION instr 123 23)) (TOK_SELEXPR (TOK_FUNCTION instr TRUE 1)) (TOK_SELEXPR (TOK_FUNCTION instr FALSE 1)) (TOK_SELEXPR (TOK_FUNCTION instr '12345' (TOK_FUNCTION TOK_TINYINT '2'))) (TOK_SELEXPR (TOK_FUNCTION instr (TOK_FUNCTION TOK_SMALLINT '12345') '34')) (TOK_SELEXPR (TOK_FUNCTION instr (TOK_FUNCTION TOK_BIGINT '123456789012') '456')) (TOK_SELEXPR (TOK_FUNCTION instr (TOK_FUNCTION TOK_FLOAT 1.25) '.25')) (TOK_SELEXPR (TOK_FUNCTION instr (TOK_FUNCTION TOK_DOUBLE 16.0) '.0')) (TOK_SELEXPR (TOK_FUNCTION instr TOK_NULL 'abc')) (TOK_SELEXPR (TOK_FUNCTION instr 'abcd' TOK_NULL))) (TOK_LIMIT 1)))
@@ -69,7 +86,24 @@
limit: 1
-query: SELECT instr('abcd', 'abc'),
+PREHOOK: query: SELECT instr('abcd', 'abc'),
+ instr('abcabc', 'ccc'),
+ instr(123, '23'),
+ instr(123, 23),
+ instr(TRUE, 1),
+ instr(FALSE, 1),
+ instr('12345', CAST('2' AS TINYINT)),
+ instr(CAST('12345' AS SMALLINT), '34'),
+ instr(CAST('123456789012' AS BIGINT), '456'),
+ instr(CAST(1.25 AS FLOAT), '.25'),
+ instr(CAST(16.0 AS DOUBLE), '.0'),
+ instr(null, 'abc'),
+ instr('abcd', null)
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1088179989/10000
+POSTHOOK: query: SELECT instr('abcd', 'abc'),
instr('abcabc', 'ccc'),
instr(123, '23'),
instr(123, 23),
@@ -83,6 +117,7 @@
instr(null, 'abc'),
instr('abcd', null)
FROM src LIMIT 1
-Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1911960579/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1088179989/10000
1 0 2 2 0 0 2 3 4 2 3 NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out Tue Sep 29 01:25:15 2009
@@ -1,9 +1,17 @@
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT NULL IS NULL,
1 IS NOT NULL,
'my string' IS NOT NULL
FROM src
WHERE true IS NOT NULL LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT NULL IS NULL,
+ 1 IS NOT NULL,
+ 'my string' IS NOT NULL
+FROM src
+WHERE true IS NOT NULL LIMIT 1
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION TOK_ISNULL TOK_NULL)) (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL 1)) (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL 'my string'))) (TOK_WHERE (TOK_FUNCTION TOK_ISNOTNULL true)) (TOK_LIMIT 1)))
@@ -48,21 +56,39 @@
limit: 1
-query: SELECT NULL IS NULL,
+PREHOOK: query: SELECT NULL IS NULL,
1 IS NOT NULL,
'my string' IS NOT NULL
FROM src
WHERE true IS NOT NULL LIMIT 1
-Input: default/src
-Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/2138330121/10000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1106726580/10000
+POSTHOOK: query: SELECT NULL IS NULL,
+ 1 IS NOT NULL,
+ 'my string' IS NOT NULL
+FROM src
+WHERE true IS NOT NULL LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1106726580/10000
true true true
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
+FROM src_thrift
+SELECT src_thrift.lint IS NOT NULL,
+ src_thrift.lintstring IS NOT NULL,
+ src_thrift.mstringstring IS NOT NULL
+WHERE src_thrift.lint IS NOT NULL
+ AND NOT (src_thrift.mstringstring IS NULL) LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
FROM src_thrift
SELECT src_thrift.lint IS NOT NULL,
src_thrift.lintstring IS NOT NULL,
src_thrift.mstringstring IS NOT NULL
WHERE src_thrift.lint IS NOT NULL
AND NOT (src_thrift.mstringstring IS NULL) LIMIT 1
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) lint))) (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) lintstring))) (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) mstringstring)))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) lint)) (NOT (TOK_FUNCTION TOK_ISNULL (. (TOK_TABLE_OR_COL src_thrift) mstringstring))))) (TOK_LIMIT 1)))
@@ -107,12 +133,22 @@
limit: 1
-query: FROM src_thrift
+PREHOOK: query: FROM src_thrift
+SELECT src_thrift.lint IS NOT NULL,
+ src_thrift.lintstring IS NOT NULL,
+ src_thrift.mstringstring IS NOT NULL
+WHERE src_thrift.lint IS NOT NULL
+ AND NOT (src_thrift.mstringstring IS NULL) LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_thrift
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1995556677/10000
+POSTHOOK: query: FROM src_thrift
SELECT src_thrift.lint IS NOT NULL,
src_thrift.lintstring IS NOT NULL,
src_thrift.mstringstring IS NOT NULL
WHERE src_thrift.lint IS NOT NULL
AND NOT (src_thrift.mstringstring IS NULL) LIMIT 1
-Input: default/src_thrift
-Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/262628946/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_thrift
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1995556677/10000
true true true
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_json.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_json.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_json.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_json.q.out Tue Sep 29 01:25:15 2009
@@ -1,9 +1,22 @@
-query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
-query: FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86
-Input: default/src
-Output: default/dest1
-query: EXPLAIN
+PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@dest1
+POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@dest1
+PREHOOK: query: EXPLAIN
SELECT get_json_object(src_json.json, '$.owner') FROM src_json
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT get_json_object(src_json.json, '$.owner') FROM src_json
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src_json)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION get_json_object (. (TOK_TABLE_OR_COL src_json) json) '$.owner')))))
@@ -35,35 +48,75 @@
limit: -1
-query: SELECT get_json_object(src_json.json, '$') FROM src_json
-Input: default/src_json
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1640975469/10000
+PREHOOK: query: SELECT get_json_object(src_json.json, '$') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1368089221/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1368089221/10000
{"store":{"fruit":[{"weight":8,"type":"apple"},{"weight":9,"type":"pear"}],"book":[{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95},{"author":"Herman Melville","category":"fiction","title":"Moby Dick","price":8.99,"isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","category":"fiction","title":"The Lord of the Rings","price":22.99,"reader":[{"name":"bob","age":25},{"name":"jack","age":26}],"isbn":"0-395-19395-8"}],"basket":[[1,2,{"b":"y","a":"x"}],[3,4],[5,6]],"bicycle":{"price":19.95,"color":"red"}},"email":"amy@only_for_json_udf_test.net","owner":"amy"}
-query: SELECT get_json_object(src_json.json, '$.owner'), get_json_object(src_json.json, '$.store') FROM src_json
-Input: default/src_json
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1729246433/10000
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.owner'), get_json_object(src_json.json, '$.store') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/726130120/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.owner'), get_json_object(src_json.json, '$.store') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/726130120/10000
amy {"fruit":[{"weight":8,"type":"apple"},{"weight":9,"type":"pear"}],"book":[{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95},{"author":"Herman Melville","category":"fiction","title":"Moby Dick","price":8.99,"isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","category":"fiction","title":"The Lord of the Rings","price":22.99,"reader":[{"name":"bob","age":25},{"name":"jack","age":26}],"isbn":"0-395-19395-8"}],"basket":[[1,2,{"b":"y","a":"x"}],[3,4],[5,6]],"bicycle":{"price":19.95,"color":"red"}}
-query: SELECT get_json_object(src_json.json, '$.store.bicycle'), get_json_object(src_json.json, '$.store.book') FROM src_json
-Input: default/src_json
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/371903655/10000
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.bicycle'), get_json_object(src_json.json, '$.store.book') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/794700282/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.bicycle'), get_json_object(src_json.json, '$.store.book') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/794700282/10000
{"price":19.95,"color":"red"} [{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95},{"author":"Herman Melville","category":"fiction","title":"Moby Dick","price":8.99,"isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","category":"fiction","title":"The Lord of the Rings","price":22.99,"reader":[{"name":"bob","age":25},{"name":"jack","age":26}],"isbn":"0-395-19395-8"}]
-query: SELECT get_json_object(src_json.json, '$.store.book[0]'), get_json_object(src_json.json, '$.store.book[*]') FROM src_json
-Input: default/src_json
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/238965518/10000
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[0]'), get_json_object(src_json.json, '$.store.book[*]') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1885237550/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[0]'), get_json_object(src_json.json, '$.store.book[*]') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1885237550/10000
{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95} [{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95},{"author":"Herman Melville","category":"fiction","title":"Moby Dick","price":8.99,"isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","category":"fiction","title":"The Lord of the Rings","price":22.99,"reader":[{"name":"bob","age":25},{"name":"jack","age":26}],"isbn":"0-395-19395-8"}]
-query: SELECT get_json_object(src_json.json, '$.store.book[0].category'), get_json_object(src_json.json, '$.store.book[*].category'), get_json_object(src_json.json, '$.store.book[*].isbn'), get_json_object(src_json.json, '$.store.book[*].reader') FROM src_json
-Input: default/src_json
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1747766822/10000
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[0].category'), get_json_object(src_json.json, '$.store.book[*].category'), get_json_object(src_json.json, '$.store.book[*].isbn'), get_json_object(src_json.json, '$.store.book[*].reader') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/988296584/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[0].category'), get_json_object(src_json.json, '$.store.book[*].category'), get_json_object(src_json.json, '$.store.book[*].isbn'), get_json_object(src_json.json, '$.store.book[*].reader') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/988296584/10000
reference ["reference","fiction","fiction"] ["0-553-21311-3","0-395-19395-8"] [{"name":"bob","age":25},{"name":"jack","age":26}]
-query: SELECT get_json_object(src_json.json, '$.store.book[*].reader[0].age'), get_json_object(src_json.json, '$.store.book[*].reader[*].age') FROM src_json
-Input: default/src_json
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1807289940/10000
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[*].reader[0].age'), get_json_object(src_json.json, '$.store.book[*].reader[*].age') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1571323043/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[*].reader[0].age'), get_json_object(src_json.json, '$.store.book[*].reader[*].age') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1571323043/10000
25 [25,26]
-query: SELECT get_json_object(src_json.json, '$.store.basket[0][1]'), get_json_object(src_json.json, '$.store.basket[*]'), get_json_object(src_json.json, '$.store.basket[*][0]'), get_json_object(src_json.json, '$.store.basket[0][*]'), get_json_object(src_json.json, '$.store.basket[*][*]'), get_json_object(src_json.json, '$.store.basket[0][2].b'), get_json_object(src_json.json, '$.store.basket[0][*].b') FROM src_json
-Input: default/src_json
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1034799624/10000
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.basket[0][1]'), get_json_object(src_json.json, '$.store.basket[*]'), get_json_object(src_json.json, '$.store.basket[*][0]'), get_json_object(src_json.json, '$.store.basket[0][*]'), get_json_object(src_json.json, '$.store.basket[*][*]'), get_json_object(src_json.json, '$.store.basket[0][2].b'), get_json_object(src_json.json, '$.store.basket[0][*].b') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/86832583/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.basket[0][1]'), get_json_object(src_json.json, '$.store.basket[*]'), get_json_object(src_json.json, '$.store.basket[*][0]'), get_json_object(src_json.json, '$.store.basket[0][*]'), get_json_object(src_json.json, '$.store.basket[*][*]'), get_json_object(src_json.json, '$.store.basket[0][2].b'), get_json_object(src_json.json, '$.store.basket[0][*].b') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/86832583/10000
2 [[1,2,{"b":"y","a":"x"}],[3,4],[5,6]] 1 [1,2,{"b":"y","a":"x"}] [1,2,{"b":"y","a":"x"},3,4,5,6] y ["y"]
-query: SELECT get_json_object(src_json.json, '$.non_exist_key'), get_json_object(src_json.json, '$..no_recursive'), get_json_object(src_json.json, '$.store.book[10]'), get_json_object(src_json.json, '$.store.book[0].non_exist_key'), get_json_object(src_json.json, '$.store.basket[*].non_exist_key'), get_json_object(src_json.json, '$.store.basket[0][*].non_exist_key') FROM src_json
-Input: default/src_json
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/875672224/10000
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.non_exist_key'), get_json_object(src_json.json, '$..no_recursive'), get_json_object(src_json.json, '$.store.book[10]'), get_json_object(src_json.json, '$.store.book[0].non_exist_key'), get_json_object(src_json.json, '$.store.basket[*].non_exist_key'), get_json_object(src_json.json, '$.store.basket[0][*].non_exist_key') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1655279596/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.non_exist_key'), get_json_object(src_json.json, '$..no_recursive'), get_json_object(src_json.json, '$.store.book[10]'), get_json_object(src_json.json, '$.store.book[0].non_exist_key'), get_json_object(src_json.json, '$.store.basket[*].non_exist_key'), get_json_object(src_json.json, '$.store.basket[0][*].non_exist_key') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1655279596/10000
NULL NULL NULL NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out Tue Sep 29 01:25:15 2009
@@ -1,5 +1,12 @@
-query: CREATE TABLE dest1(len INT)
-query: EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1 SELECT length(src1.value)
+PREHOOK: query: CREATE TABLE dest1(len INT)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest1(len INT)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1 SELECT length(src1.value)
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1 SELECT length(src1.value)
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src1)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION length (. (TOK_TABLE_OR_COL src1) value))))))
@@ -35,10 +42,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2113573167/10000
+ destination: file:/data/users/njain/hive5/hive5/build/ql/tmp/777850344/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1544905742/10002
+ file:/data/users/njain/hive5/hive5/build/ql/tmp/1274386623/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -70,12 +77,22 @@
name: dest1
-query: FROM src1 INSERT OVERWRITE TABLE dest1 SELECT length(src1.value)
-Input: default/src1
-Output: default/dest1
-query: SELECT dest1.* FROM dest1
-Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/966501876/10000
+PREHOOK: query: FROM src1 INSERT OVERWRITE TABLE dest1 SELECT length(src1.value)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src1
+PREHOOK: Output: default@dest1
+POSTHOOK: query: FROM src1 INSERT OVERWRITE TABLE dest1 SELECT length(src1.value)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src1
+POSTHOOK: Output: default@dest1
+PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest1
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/775750892/10000
+POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest1
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/775750892/10000
7
0
7
@@ -101,11 +118,27 @@
0
0
0
-query: DROP TABLE dest1
-query: -- Test with non-ascii characters.
+PREHOOK: query: DROP TABLE dest1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE dest1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: -- Test with non-ascii characters.
CREATE TABLE dest1(name STRING) STORED AS TEXTFILE
-query: LOAD DATA LOCAL INPATH '../data/files/kv4.txt' INTO TABLE dest1
-query: EXPLAIN SELECT length(dest1.name) FROM dest1
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: -- Test with non-ascii characters.
+CREATE TABLE dest1(name STRING) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv4.txt' INTO TABLE dest1
+PREHOOK: type: LOAD
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv4.txt' INTO TABLE dest1
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@dest1
+PREHOOK: query: EXPLAIN SELECT length(dest1.name) FROM dest1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT length(dest1.name) FROM dest1
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF dest1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION length (. (TOK_TABLE_OR_COL dest1) name))))))
@@ -137,8 +170,17 @@
limit: -1
-query: SELECT length(dest1.name) FROM dest1
-Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1105559783/10000
+PREHOOK: query: SELECT length(dest1.name) FROM dest1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest1
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1564729330/10000
+POSTHOOK: query: SELECT length(dest1.name) FROM dest1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest1
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1564729330/10000
2
-query: DROP TABLE dest1
+PREHOOK: query: DROP TABLE dest1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE dest1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Output: default@dest1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_like.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_like.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_like.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_like.q.out Tue Sep 29 01:25:15 2009
@@ -1,8 +1,15 @@
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT '_%_' LIKE '%\_\%\_%', '__' LIKE '%\_\%\_%', '%%_%_' LIKE '%\_\%\_%', '%_%_%' LIKE '%\%\_\%',
'_%_' LIKE '\%\_%', '%__' LIKE '__\%%', '_%' LIKE '\_\%\_\%%', '_%' LIKE '\_\%_%',
'%_' LIKE '\%\_', 'ab' LIKE '\%\_', 'ab' LIKE '_a%', 'ab' LIKE 'a'
FROM src WHERE src.key = 86
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT '_%_' LIKE '%\_\%\_%', '__' LIKE '%\_\%\_%', '%%_%_' LIKE '%\_\%\_%', '%_%_%' LIKE '%\%\_\%',
+ '_%_' LIKE '\%\_%', '%__' LIKE '__\%%', '_%' LIKE '\_\%\_\%%', '_%' LIKE '\_\%_%',
+ '%_' LIKE '\%\_', 'ab' LIKE '\%\_', 'ab' LIKE '_a%', 'ab' LIKE 'a'
+FROM src WHERE src.key = 86
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (LIKE '_%_' '%\_\%\_%')) (TOK_SELEXPR (LIKE '__' '%\_\%\_%')) (TOK_SELEXPR (LIKE '%%_%_' '%\_\%\_%')) (TOK_SELEXPR (LIKE '%_%_%' '%\%\_\%')) (TOK_SELEXPR (LIKE '_%_' '\%\_%')) (TOK_SELEXPR (LIKE '%__' '__\%%')) (TOK_SELEXPR (LIKE '_%' '\_\%\_\%%')) (TOK_SELEXPR (LIKE '_%' '\_\%_%')) (TOK_SELEXPR (LIKE '%_' '\%\_')) (TOK_SELEXPR (LIKE 'ab' '\%\_')) (TOK_SELEXPR (LIKE 'ab' '_a%')) (TOK_SELEXPR (LIKE 'ab' 'a'))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL src) key) 86))))
@@ -64,10 +71,18 @@
limit: -1
-query: SELECT '_%_' LIKE '%\_\%\_%', '__' LIKE '%\_\%\_%', '%%_%_' LIKE '%\_\%\_%', '%_%_%' LIKE '%\%\_\%',
+PREHOOK: query: SELECT '_%_' LIKE '%\_\%\_%', '__' LIKE '%\_\%\_%', '%%_%_' LIKE '%\_\%\_%', '%_%_%' LIKE '%\%\_\%',
+ '_%_' LIKE '\%\_%', '%__' LIKE '__\%%', '_%' LIKE '\_\%\_\%%', '_%' LIKE '\_\%_%',
+ '%_' LIKE '\%\_', 'ab' LIKE '\%\_', 'ab' LIKE '_a%', 'ab' LIKE 'a'
+FROM src WHERE src.key = 86
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/148481666/10000
+POSTHOOK: query: SELECT '_%_' LIKE '%\_\%\_%', '__' LIKE '%\_\%\_%', '%%_%_' LIKE '%\_\%\_%', '%_%_%' LIKE '%\%\_\%',
'_%_' LIKE '\%\_%', '%__' LIKE '__\%%', '_%' LIKE '\_\%\_\%%', '_%' LIKE '\_\%_%',
'%_' LIKE '\%\_', 'ab' LIKE '\%\_', 'ab' LIKE '_a%', 'ab' LIKE 'a'
FROM src WHERE src.key = 86
-Input: default/src
-Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/1633414177/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/148481666/10000
true false true true false false false false true false false false