You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2010/01/07 04:02:01 UTC
svn commit: r896744 [2/3] - in /hadoop/hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/udf/
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/
ql/src/test/queries/clientpositive/ ql/src/test/results/clie...
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=896744&r1=896743&r2=896744&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 Thu Jan 7 03:01:26 2010
@@ -1,3 +1,19 @@
+PREHOOK: query: DESCRIBE FUNCTION conv
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION conv
+POSTHOOK: type: DESCFUNCTION
+conv(num, from_base, to_base) - convert num from from_base to to_base
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED conv
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED conv
+POSTHOOK: type: DESCFUNCTION
+conv(num, from_base, to_base) - convert num from from_base to to_base
+If to_base is negative, treat num as a signed integer,otherwise, treat it as an unsigned integer.
+Example:
+ > SELECT conv('100', 2, 10) FROM src LIMIT 1;
+ '4'
+ > SELECT conv(-10, 16, -10) FROM src LIMIT 1;
+ '16'
PREHOOK: query: -- conv must work on both strings and integers up to 64-bit precision
-- Some simple conversions to test different bases
@@ -9,7 +25,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1394785532/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/502953018/10000
POSTHOOK: query: -- conv must work on both strings and integers up to 64-bit precision
-- Some simple conversions to test different bases
@@ -21,7 +37,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1394785532/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/502953018/10000
3HL 22 33 116ED2B2FB4
PREHOOK: query: -- Test negative numbers. If to_base is positive, the number should be handled
-- as a two's complement (64-bit)
@@ -33,7 +49,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/297144160/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1045444731/10000
POSTHOOK: query: -- Test negative numbers. If to_base is positive, the number should be handled
-- as a two's complement (64-bit)
SELECT
@@ -44,7 +60,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/297144160/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1045444731/10000
-641 B FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFF1
PREHOOK: query: -- Test overflow. If a number is two large, the result should be -1 (if signed)
-- or MAX_LONG (if unsigned)
@@ -56,7 +72,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/311355603/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/901682273/10000
POSTHOOK: query: -- Test overflow. If a number is two large, the result should be -1 (if signed)
-- or MAX_LONG (if unsigned)
SELECT
@@ -67,7 +83,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/311355603/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/901682273/10000
FFFFFFFFFFFFFFFF -1 FFFFFFFFFFFFFFFF -1
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
@@ -80,7 +96,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1893103412/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1068643579/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.
@@ -92,7 +108,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1893103412/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1068643579/10000
5 NULL NULL NULL
PREHOOK: query: -- Perform the same tests with number arguments.
@@ -103,7 +119,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/374689536/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/877878753/10000
POSTHOOK: query: -- Perform the same tests with number arguments.
SELECT
@@ -113,7 +129,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/374689536/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/877878753/10000
3HL 22 33
PREHOOK: query: SELECT
conv(-641, 10, -10),
@@ -123,7 +139,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/117827629/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1990388663/10000
POSTHOOK: query: SELECT
conv(-641, 10, -10),
conv(1011, 2, -16),
@@ -132,7 +148,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/117827629/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1990388663/10000
-641 B FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFF1
PREHOOK: query: SELECT
conv(9223372036854775807, 36, 16),
@@ -142,7 +158,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/638334947/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1540368732/10000
POSTHOOK: query: SELECT
conv(9223372036854775807, 36, 16),
conv(9223372036854775807, 36, -16),
@@ -151,7 +167,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/638334947/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1540368732/10000
FFFFFFFFFFFFFFFF -1 FFFFFFFFFFFFFFFF -1
PREHOOK: query: SELECT
conv(123455, 3, 10),
@@ -161,7 +177,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/315464649/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1788821246/10000
POSTHOOK: query: SELECT
conv(123455, 3, 10),
conv(131, 1, 5),
@@ -170,5 +186,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/315464649/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1788821246/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=896744&r1=896743&r2=896744&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 Thu Jan 7 03:01:26 2010
@@ -1,22 +1,35 @@
+PREHOOK: query: DESCRIBE FUNCTION cos
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION cos
+POSTHOOK: type: DESCFUNCTION
+cos(x) - returns the cosine of x (x is in radians)
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED cos
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED cos
+POSTHOOK: type: DESCFUNCTION
+cos(x) - returns the cosine of x (x is in radians)
+Example:
+ > SELECT cos(0) FROM src LIMIT 1;
+ 1
PREHOOK: query: SELECT cos(null)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1521763480/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2017515612/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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2017515612/10000
NULL
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1873387849/10000
POSTHOOK: query: SELECT cos(0.98), cos(1.57), cos(-0.5)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1918624552/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1873387849/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=896744&r1=896743&r2=896744&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 Thu Jan 7 03:01:26 2010
@@ -1,18 +1,31 @@
+PREHOOK: query: DESCRIBE FUNCTION div
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION div
+POSTHOOK: type: DESCFUNCTION
+a div b - Divide a by b rounded to the long integer
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED div
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED div
+POSTHOOK: type: DESCFUNCTION
+a div b - Divide a by b rounded to the long integer
+Example:
+ > SELECT 3 div 2 FROM src LIMIT 1;
+ 1
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/173284244/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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/173284244/10000
1.5
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1585227313/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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1585227313/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=896744&r1=896743&r2=896744&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 Thu Jan 7 03:01:26 2010
@@ -1,3 +1,16 @@
+PREHOOK: query: DESCRIBE FUNCTION elt
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION elt
+POSTHOOK: type: DESCFUNCTION
+elt(n, str1, str2, ...) - returns the n-th string
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED elt
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED elt
+POSTHOOK: type: DESCFUNCTION
+elt(n, str1, str2, ...) - returns the n-th string
+Example:
+ > SELECT elt(1, 'face', 'book') FROM src LIMIT 1;
+ 'face'
PREHOOK: query: EXPLAIN
SELECT elt(2, 'abc', 'defg'),
elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
@@ -92,7 +105,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1564252056/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1020024876/10000
POSTHOOK: query: SELECT elt(2, 'abc', 'defg'),
elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
elt('1', 'abc', 'defg'),
@@ -107,5 +120,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1564252056/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1020024876/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=896744&r1=896743&r2=896744&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 Thu Jan 7 03:01:26 2010
@@ -1,3 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION hash
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION hash
+POSTHOOK: type: DESCFUNCTION
+hash(a1, a2, ...) - Returns a hash value of the arguments
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED hash
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED hash
+POSTHOOK: type: DESCFUNCTION
+hash(a1, a2, ...) - Returns a hash value of the arguments
PREHOOK: query: EXPLAIN
SELECT hash(CAST(1 AS TINYINT)), hash(CAST(2 AS SMALLINT)),
hash(3), hash(CAST('123456789012' AS BIGINT)),
@@ -74,7 +84,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/875530574/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/697748715/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)),
@@ -83,5 +93,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/875530574/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/697748715/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=896744&r1=896743&r2=896744&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 Thu Jan 7 03:01:26 2010
@@ -1,3 +1,20 @@
+PREHOOK: query: DESCRIBE FUNCTION hex
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION hex
+POSTHOOK: type: DESCFUNCTION
+hex(n or str) - Convert the argument to hexadecimal
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED hex
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED hex
+POSTHOOK: type: DESCFUNCTION
+hex(n or str) - Convert the argument to hexadecimal
+If the argument is a string, returns two hex digits for each character in the string.
+If the argument is a number, returns the hexadecimal representation.
+Example:
+ > SELECT hex(17) FROM src LIMIT 1;
+ 'H1'
+ > SELECT hex('Facebook') FROM src LIMIT 1;
+ '46616365626F6F6B'
PREHOOK: query: -- If the argument is a string, hex should return a string containing two hex
-- digits for every character in the input.
SELECT
@@ -7,7 +24,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1894329188/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/871424994/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
@@ -17,7 +34,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1894329188/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/871424994/10000
46616365626F6F6B 00 71776572747975696F706173646667686A6B6C
PREHOOK: query: -- If the argument is a number, hex should convert it to hexadecimal.
SELECT
@@ -27,7 +44,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1277538639/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1308427474/10000
POSTHOOK: query: -- If the argument is a number, hex should convert it to hexadecimal.
SELECT
hex(1),
@@ -36,16 +53,16 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1277538639/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1308427474/10000
1 0 FACEB005
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2089947529/10000
POSTHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
SELECT hex(-5) FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2119469168/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2089947529/10000
FFFFFFFFFFFFFFFB
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=896744&r1=896743&r2=896744&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 Thu Jan 7 03:01:26 2010
@@ -1,3 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION if
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION if
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function if
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED if
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED if
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function if
PREHOOK: query: EXPLAIN
SELECT IF(TRUE, 1, 2) AS COL1,
IF(FALSE, CAST(NULL AS STRING), CAST(1 AS STRING)) AS COL2,
@@ -67,7 +77,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1333420658/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1635207375/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,
@@ -77,7 +87,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1333420658/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1635207375/10000
1 1 1 1 NULL 2
PREHOOK: query: -- Type conversions
EXPLAIN
@@ -140,7 +150,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2081932428/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1478265880/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,
@@ -148,5 +158,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2081932428/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1478265880/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=896744&r1=896743&r2=896744&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 Thu Jan 7 03:01:26 2010
@@ -1,3 +1,16 @@
+PREHOOK: query: DESCRIBE FUNCTION instr
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION instr
+POSTHOOK: type: DESCFUNCTION
+instr(str, substr) - Returns the index of the first occurance of substr in str
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED instr
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED instr
+POSTHOOK: type: DESCFUNCTION
+instr(str, substr) - Returns the index of the first occurance of substr in str
+Example:
+ > SELECT instr('Facebook', 'boo') FROM src LIMIT 1;
+ 5
PREHOOK: query: EXPLAIN
SELECT instr('abcd', 'abc'),
instr('abcabc', 'ccc'),
@@ -102,7 +115,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1088179989/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1069925328/10000
POSTHOOK: query: SELECT instr('abcd', 'abc'),
instr('abcabc', 'ccc'),
instr(123, '23'),
@@ -119,5 +132,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1088179989/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1069925328/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=896744&r1=896743&r2=896744&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 Thu Jan 7 03:01:26 2010
@@ -1,3 +1,23 @@
+PREHOOK: query: DESCRIBE FUNCTION isnull
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION isnull
+POSTHOOK: type: DESCFUNCTION
+isnull a - Returns true if a is NULL and false otherwise
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED isnull
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED isnull
+POSTHOOK: type: DESCFUNCTION
+isnull a - Returns true if a is NULL and false otherwise
+PREHOOK: query: DESCRIBE FUNCTION isnotnull
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION isnotnull
+POSTHOOK: type: DESCFUNCTION
+isnotnull a - Returns true if a is not NULL and false otherwise
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED isnotnull
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED isnotnull
+POSTHOOK: type: DESCFUNCTION
+isnotnull a - Returns true if a is not NULL and false otherwise
PREHOOK: query: EXPLAIN
SELECT NULL IS NULL,
1 IS NOT NULL,
@@ -63,7 +83,7 @@
WHERE true IS NOT NULL LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1106726580/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1963364824/10000
POSTHOOK: query: SELECT NULL IS NULL,
1 IS NOT NULL,
'my string' IS NOT NULL
@@ -71,7 +91,7 @@
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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1963364824/10000
true true true
PREHOOK: query: EXPLAIN
FROM src_thrift
@@ -141,7 +161,7 @@
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/609638755/10000
POSTHOOK: query: FROM src_thrift
SELECT src_thrift.lint IS NOT NULL,
src_thrift.lintstring IS NOT NULL,
@@ -150,5 +170,5 @@
AND NOT (src_thrift.mstringstring IS NULL) LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_thrift
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1995556677/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/609638755/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=896744&r1=896743&r2=896744&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 Thu Jan 7 03:01:26 2010
@@ -1,3 +1,28 @@
+PREHOOK: query: DESCRIBE FUNCTION get_json_object
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION get_json_object
+POSTHOOK: type: DESCFUNCTION
+get_json_object(json_txt, path) - Extract a json object from path
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED get_json_object
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED get_json_object
+POSTHOOK: type: DESCFUNCTION
+get_json_object(json_txt, path) - Extract a json object from path
+Extract json object from a json string based on json path specified, and return json string of the extracted json object. It will return null if the input json string is invalid.
+A limited version of JSONPath supported:
+ $ : Root object
+ . : Child operator
+ [] : Subscript operator for array
+ * : Wildcard for []
+Syntax not supported that's worth noticing:
+ '' : Zero length string as key
+ .. : Recursive descent
+ @ : Current object/element
+ () : Script expression
+ ?() : Filter (script) expression.
+ [,] : Union operator
+ [start:end:step] : array slice operator
+
PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
@@ -51,72 +76,72 @@
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/483712443/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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/483712443/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"}
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1962032537/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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1962032537/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"}}
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2019032273/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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2019032273/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"}]
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2005938063/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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2005938063/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"}]
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/132584872/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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/132584872/10000
reference ["reference","fiction","fiction"] ["0-553-21311-3","0-395-19395-8"] [{"name":"bob","age":25},{"name":"jack","age":26}]
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1371238792/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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1371238792/10000
25 [25,26]
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1801151655/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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1801151655/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"]
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1780114809/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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1780114809/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=896744&r1=896743&r2=896744&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 Thu Jan 7 03:01:26 2010
@@ -1,3 +1,16 @@
+PREHOOK: query: DESCRIBE FUNCTION length
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION length
+POSTHOOK: type: DESCFUNCTION
+length(str) - Returns the length of str
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED length
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED length
+POSTHOOK: type: DESCFUNCTION
+length(str) - Returns the length of str
+Example:
+ > SELECT length('Facebook') FROM src LIMIT 1;
+ 8
PREHOOK: query: CREATE TABLE dest1(len INT)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE dest1(len INT)
@@ -42,10 +55,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive5/hive5/build/ql/tmp/777850344/10000
+ destination: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1622212784/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1274386623/10002
+ file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/92165457/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -88,11 +101,11 @@
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2077609609/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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2077609609/10000
7
0
7
@@ -173,11 +186,11 @@
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/394449121/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
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/394449121/10000
2
PREHOOK: query: DROP TABLE dest1
PREHOOK: type: DROPTABLE
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=896744&r1=896743&r2=896744&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 Thu Jan 7 03:01:26 2010
@@ -1,3 +1,16 @@
+PREHOOK: query: DESCRIBE FUNCTION like
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION like
+POSTHOOK: type: DESCFUNCTION
+like(str, pattern) - Checks if str matches pattern
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED like
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED like
+POSTHOOK: type: DESCFUNCTION
+like(str, pattern) - Checks if str matches pattern
+Example:
+ > SELECT a.* FROM srcpart a WHERE a.hr like '%2' LIMIT 1;
+ 27 val_27 2008-04-08 12
PREHOOK: query: EXPLAIN
SELECT '_%_' LIKE '%\_\%\_%', '__' LIKE '%\_\%\_%', '%%_%_' LIKE '%\_\%\_%', '%_%_%' LIKE '%\%\_\%',
'_%_' LIKE '\%\_%', '%__' LIKE '__\%%', '_%' LIKE '\_\%\_\%%', '_%' LIKE '\_\%_%',
@@ -77,12 +90,12 @@
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
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1557896001/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
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/148481666/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1557896001/10000
true false true true false false false false true false false false
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_locate.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_locate.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_locate.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_locate.q.out Thu Jan 7 03:01:26 2010
@@ -1,3 +1,16 @@
+PREHOOK: query: DESCRIBE FUNCTION locate
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION locate
+POSTHOOK: type: DESCFUNCTION
+locate(substr, str[, pos]) - Returns the position of the first occurance of substr in str after position pos
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED locate
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED locate
+POSTHOOK: type: DESCFUNCTION
+locate(substr, str[, pos]) - Returns the position of the first occurance of substr in str after position pos
+Example:
+ > SELECT locate('bar', 'foobarbar', 5) FROM src LIMIT 1;
+ 7
PREHOOK: query: EXPLAIN
SELECT locate('abc', 'abcd'),
locate('ccc', 'abcabc'),
@@ -122,7 +135,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/572327680/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/155745966/10000
POSTHOOK: query: SELECT locate('abc', 'abcd'),
locate('ccc', 'abcabc'),
locate('23', 123),
@@ -143,5 +156,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/572327680/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/155745966/10000
1 0 2 2 4 4 0 0 2 3 4 2 3 NULL NULL 0 0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lower.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lower.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lower.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lower.q.out Thu Jan 7 03:01:26 2010
@@ -1,3 +1,16 @@
+PREHOOK: query: DESCRIBE FUNCTION lower
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION lower
+POSTHOOK: type: DESCFUNCTION
+lower(str) - Returns str with all characters changed to lowercase
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED lower
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED lower
+POSTHOOK: type: DESCFUNCTION
+lower(str) - Returns str with all characters changed to lowercase
+Example:
+ > SELECT lower('Facebook') FROM src LIMIT 1;
+ 'facebook'
PREHOOK: query: EXPLAIN
SELECT lower('AbC 123'), upper('AbC 123') FROM src WHERE key = 86
PREHOOK: type: QUERY
@@ -48,9 +61,9 @@
PREHOOK: query: SELECT lower('AbC 123'), upper('AbC 123') FROM src WHERE key = 86
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/655858125/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1887044838/10000
POSTHOOK: query: SELECT lower('AbC 123'), upper('AbC 123') FROM src WHERE key = 86
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/655858125/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1887044838/10000
abc 123 ABC 123
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad_rpad.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad_rpad.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad_rpad.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad_rpad.q.out Thu Jan 7 03:01:26 2010
@@ -1,3 +1,33 @@
+PREHOOK: query: DESCRIBE FUNCTION lpad
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION lpad
+POSTHOOK: type: DESCFUNCTION
+lpad(str, len, pad) - Returns str, left-padded with pad to a length of len
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED lpad
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED lpad
+POSTHOOK: type: DESCFUNCTION
+lpad(str, len, pad) - Returns str, left-padded with pad to a length of len
+If str is longer than len, the return value is shortened to len characters.
+Example:
+ > SELECT lpad('hi', 5, '??') FROM src LIMIT 1;
+ '???hi' > SELECT lpad('hi', 1, '??') FROM src LIMIT 1;
+ 'h'
+PREHOOK: query: DESCRIBE FUNCTION rpad
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION rpad
+POSTHOOK: type: DESCFUNCTION
+rpad(str, len, pad) - Returns str, right-padded with pad to a length of len
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED rpad
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED rpad
+POSTHOOK: type: DESCFUNCTION
+rpad(str, len, pad) - Returns str, right-padded with pad to a length of len
+If str is longer than len, the return value is shortened to len characters.
+Example:
+ > SELECT rpad('hi', 5, '??') FROM src LIMIT 1;
+ 'hi???' > SELECT rpad('hi', 1, '??') FROM src LIMIT 1;
+ 'h'
PREHOOK: query: EXPLAIN SELECT
lpad('hi', 1, '?'),
lpad('hi', 5, '.'),
@@ -53,7 +83,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/369345424/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/361452356/10000
POSTHOOK: query: SELECT
lpad('hi', 1, '?'),
lpad('hi', 5, '.'),
@@ -61,7 +91,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/369345424/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/361452356/10000
h ...hi 1231hi
PREHOOK: query: EXPLAIN SELECT
rpad('hi', 1, '?'),
@@ -118,7 +148,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/975123871/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1704470803/10000
POSTHOOK: query: SELECT
rpad('hi', 1, '?'),
rpad('hi', 5, '.'),
@@ -126,5 +156,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/975123871/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1704470803/10000
h hi... hi1231
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_map.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_map.q.out Thu Jan 7 03:01:26 2010
@@ -1,3 +1,15 @@
+PREHOOK: query: -- Parsing bug requires us to quote map
+DESCRIBE FUNCTION 'map'
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: -- Parsing bug requires us to quote map
+DESCRIBE FUNCTION 'map'
+POSTHOOK: type: DESCFUNCTION
+map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED 'map'
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED 'map'
+POSTHOOK: type: DESCFUNCTION
+map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
PREHOOK: query: EXPLAIN SELECT map(), map(1, "a", 2, "b", 3, "c"), map(1, 2, "a", "b"),
map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src LIMIT 1
PREHOOK: type: QUERY
@@ -50,10 +62,10 @@
map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/pyang/trunk-HIVE-554/VENDOR.hive/trunk/build/ql/tmp/802535376/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1878909043/10000
POSTHOOK: query: SELECT map(), map(1, "a", 2, "b", 3, "c"), map(1, 2, "a", "b"),
map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/pyang/trunk-HIVE-554/VENDOR.hive/trunk/build/ql/tmp/802535376/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1878909043/10000
{} {1:"a",2:"b",3:"c"} {"1":"2","a":"b"} b b a
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out Thu Jan 7 03:01:26 2010
@@ -1,54 +1,64 @@
+PREHOOK: query: DESCRIBE FUNCTION negative
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION negative
+POSTHOOK: type: DESCFUNCTION
+negative a - Returns -a
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED negative
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED negative
+POSTHOOK: type: DESCFUNCTION
+negative a - Returns -a
PREHOOK: query: select - null from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/928832343/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1255375616/10000
POSTHOOK: query: select - null from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/928832343/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1255375616/10000
NULL
PREHOOK: query: select - cast(null as int) from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/1834056910/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/925422494/10000
POSTHOOK: query: select - cast(null as int) from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/1834056910/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/925422494/10000
NULL
PREHOOK: query: select - cast(null as smallint) from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/677639104/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/75605941/10000
POSTHOOK: query: select - cast(null as smallint) from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/677639104/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/75605941/10000
NULL
PREHOOK: query: select - cast(null as bigint) from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/1891198169/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/914031656/10000
POSTHOOK: query: select - cast(null as bigint) from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/1891198169/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/914031656/10000
NULL
PREHOOK: query: select - cast(null as double) from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/856616351/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/551335924/10000
POSTHOOK: query: select - cast(null as double) from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/856616351/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/551335924/10000
NULL
PREHOOK: query: select - cast(null as float) from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/277516197/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/708448995/10000
POSTHOOK: query: select - cast(null as float) from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/277516197/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/708448995/10000
NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_parse_url.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_parse_url.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_parse_url.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_parse_url.q.out Thu Jan 7 03:01:26 2010
@@ -1,3 +1,22 @@
+PREHOOK: query: DESCRIBE FUNCTION parse_url
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION parse_url
+POSTHOOK: type: DESCFUNCTION
+parse_url(url, partToExtract[, key]) - extracts a part from a URL
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED parse_url
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED parse_url
+POSTHOOK: type: DESCFUNCTION
+parse_url(url, partToExtract[, key]) - extracts a part from a URL
+Parts: HOST, PATH, QUERY, REF, PROTOCOL, AUTHORITY, FILE, USERINFO
+key specifies which query to extract
+Example:
+ > SELECT parse_url('http://facebook.com/path/p1.php?query=1', 'HOST') FROM src LIMIT 1;
+ 'facebook.com'
+ > SELECT parse_url('http://facebook.com/path/p1.php?query=1', 'QUERY') FROM src LIMIT 1;
+ 'query=1'
+ > SELECT parse_url('http://facebook.com/path/p1.php?query=1', 'QUERY', 'query') FROM src LIMIT 1;
+ '1'
PREHOOK: query: EXPLAIN
SELECT parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'HOST'),
parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'PATH'),
@@ -99,7 +118,7 @@
FROM src WHERE key = 86
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1215092102/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/482859701/10000
POSTHOOK: query: SELECT parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'HOST'),
parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'PATH'),
parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'QUERY') ,
@@ -114,5 +133,5 @@
FROM src WHERE key = 86
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1215092102/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/482859701/10000
facebook.com /path1/p.php k1=v1&k2=v2 Ref1 v2 v1 NULL /path1/p.php?k1=v1&k2=v2 http NULL facebook.com
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_pmod.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_pmod.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_pmod.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_pmod.q.out Thu Jan 7 03:01:26 2010
@@ -1,33 +1,43 @@
+PREHOOK: query: DESCRIBE FUNCTION pmod
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION pmod
+POSTHOOK: type: DESCFUNCTION
+a pmod b - Compute the positive modulo
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED pmod
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED pmod
+POSTHOOK: type: DESCFUNCTION
+a pmod b - Compute the positive modulo
PREHOOK: query: SELECT pmod(null, null)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1384517913/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1159318893/10000
POSTHOOK: query: SELECT pmod(null, null)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1384517913/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1159318893/10000
NULL
PREHOOK: query: SELECT pmod(-100,9), pmod(-50,101), pmod(-1000,29)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1606180544/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1059038526/10000
POSTHOOK: query: SELECT pmod(-100,9), pmod(-50,101), pmod(-1000,29)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1606180544/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1059038526/10000
8 51 15
PREHOOK: query: SELECT pmod(100,19), pmod(50,125), pmod(300,15)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1250421811/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2064781823/10000
POSTHOOK: query: SELECT pmod(100,19), pmod(50,125), pmod(300,15)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1250421811/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2064781823/10000
5 50 0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_repeat.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_repeat.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_repeat.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_repeat.q.out Thu Jan 7 03:01:26 2010
@@ -1,3 +1,16 @@
+PREHOOK: query: DESCRIBE FUNCTION repeat
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION repeat
+POSTHOOK: type: DESCFUNCTION
+repeat(str, n) - repeat str n times
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED repeat
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED repeat
+POSTHOOK: type: DESCFUNCTION
+repeat(str, n) - repeat str n times
+Example:
+ > SELECT repeat('123', 2) FROM src LIMIT 1;
+ '123123'
PREHOOK: query: EXPLAIN SELECT
repeat("Facebook", 3),
repeat("", 4),
@@ -58,7 +71,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/208533019/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1513627133/10000
POSTHOOK: query: SELECT
repeat("Facebook", 3),
repeat("", 4),
@@ -67,5 +80,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/208533019/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1513627133/10000
FacebookFacebookFacebook
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_reverse.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_reverse.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_reverse.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_reverse.q.out Thu Jan 7 03:01:26 2010
@@ -1,3 +1,16 @@
+PREHOOK: query: DESCRIBE FUNCTION reverse
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION reverse
+POSTHOOK: type: DESCFUNCTION
+reverse(str) - reverse str
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED reverse
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED reverse
+POSTHOOK: type: DESCFUNCTION
+reverse(str) - reverse str
+Example:
+ > SELECT reverse('Facebook') FROM src LIMIT 1;
+ 'koobecaF'
PREHOOK: query: CREATE TABLE dest1(len STRING)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE dest1(len STRING)
@@ -42,10 +55,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive5/hive5/build/ql/tmp/1305154928/10000
+ destination: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/520090506/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/925020569/10002
+ file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/468564432/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -88,11 +101,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/516796328/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/255390900/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/516796328/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/255390900/10000
832_lav
113_lav
@@ -142,11 +155,11 @@
PREHOOK: query: SELECT count(1) FROM dest1 WHERE reverse(dest1.name) = _UTF-8 0xE993AEE982B5
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/465925440/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1130378645/10000
POSTHOOK: query: SELECT count(1) FROM dest1 WHERE reverse(dest1.name) = _UTF-8 0xE993AEE982B5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/465925440/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1130378645/10000
1
PREHOOK: query: DROP TABLE dest1
PREHOOK: type: DROPTABLE
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_round.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_round.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_round.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_round.q.out Thu Jan 7 03:01:26 2010
@@ -1,13 +1,26 @@
+PREHOOK: query: DESCRIBE FUNCTION round
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION round
+POSTHOOK: type: DESCFUNCTION
+round(x[, d]) - round x to d decimal places
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED round
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED round
+POSTHOOK: type: DESCFUNCTION
+round(x[, d]) - round x to d decimal places
+Example:
+ > SELECT round(12.3456, 1) FROM src LIMIT 1;
+ 12.3'
PREHOOK: query: SELECT round(null), round(null, 0), round(125, null)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1931880581/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1736987523/10000
POSTHOOK: query: SELECT round(null), round(null, 0), round(125, null)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1931880581/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1736987523/10000
NULL NULL NULL
PREHOOK: query: SELECT
round(55555), round(55555, 0), round(55555, 1), round(55555, 2), round(55555, 3),
@@ -16,7 +29,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1954748857/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1549949974/10000
POSTHOOK: query: SELECT
round(55555), round(55555, 0), round(55555, 1), round(55555, 2), round(55555, 3),
round(55555, -1), round(55555, -2), round(55555, -3), round(55555, -4),
@@ -24,7 +37,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1954748857/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1549949974/10000
55555 55555.0 55555.0 55555.0 55555.0 55560.0 55600.0 56000.0 60000.0 100000.0 0.0 0.0 0.0
PREHOOK: query: SELECT
round(125.315), round(125.315, 0),
@@ -36,7 +49,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/372474214/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/148858111/10000
POSTHOOK: query: SELECT
round(125.315), round(125.315, 0),
round(125.315, 1), round(125.315, 2), round(125.315, 3), round(125.315, 4),
@@ -47,7 +60,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/372474214/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/148858111/10000
125 125.0 125.3 125.32 125.315 125.315 130.0 100.0 0.0 0.0 -125 -125.0 -125.3 -125.32 -125.315 -125.315 -130.0 -100.0 0.0 0.0
PREHOOK: query: SELECT
round(3.141592653589793, -15), round(3.141592653589793, -16),
@@ -70,7 +83,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/412153419/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/624837434/10000
POSTHOOK: query: SELECT
round(3.141592653589793, -15), round(3.141592653589793, -16),
round(3.141592653589793, -13), round(3.141592653589793, -14),
@@ -92,16 +105,16 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/412153419/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/624837434/10000
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 3.0 3.1 3.14 3.142 3.1416 3.14159 3.141593 3.1415927 3.14159265 3.141592654 3.1415926536 3.14159265359 3.14159265359 3.1415926535898 3.1415926535898 3.14159265358979 3.141592653589793 3.141592653589793
PREHOOK: query: SELECT round(1809242.3151111344, 9), round(-1809242.3151111344, 9)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/667136403/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/599098185/10000
POSTHOOK: query: SELECT round(1809242.3151111344, 9), round(-1809242.3151111344, 9)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/667136403/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/599098185/10000
1809242.315111134 -1809242.315111134
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sin.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sin.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sin.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sin.q.out Thu Jan 7 03:01:26 2010
@@ -1,22 +1,35 @@
+PREHOOK: query: DESCRIBE FUNCTION sin
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION sin
+POSTHOOK: type: DESCFUNCTION
+sin(x) - returns the sine of x (x is in radians)
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED sin
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED sin
+POSTHOOK: type: DESCFUNCTION
+sin(x) - returns the sine of x (x is in radians)
+Example:
+ > SELECT sin(0) FROM src LIMIT 1;
+ 0
PREHOOK: query: SELECT sin(null)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1281720904/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1659199524/10000
POSTHOOK: query: SELECT sin(null)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1281720904/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1659199524/10000
NULL
PREHOOK: query: SELECT sin(0.98), sin(1.57), sin(-0.5)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/820458381/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1109863230/10000
POSTHOOK: query: SELECT sin(0.98), sin(1.57), sin(-0.5)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/820458381/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1109863230/10000
0.8304973704919705 0.9999996829318346 -0.479425538604203
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_size.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_size.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_size.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_size.q.out Thu Jan 7 03:01:26 2010
@@ -1,3 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION size
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION size
+POSTHOOK: type: DESCFUNCTION
+size(a) - Returns the size of a
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED size
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED size
+POSTHOOK: type: DESCFUNCTION
+size(a) - Returns the size of a
PREHOOK: query: EXPLAIN
FROM src_thrift
SELECT size(src_thrift.lint),
@@ -71,7 +81,7 @@
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/1116336737/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/961043186/10000
POSTHOOK: query: FROM src_thrift
SELECT size(src_thrift.lint),
size(src_thrift.lintstring),
@@ -81,5 +91,5 @@
AND NOT (src_thrift.mstringstring IS NULL) LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_thrift
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1116336737/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/961043186/10000
3 1 1 -1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_space.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_space.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_space.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_space.q.out Thu Jan 7 03:01:26 2010
@@ -1,3 +1,16 @@
+PREHOOK: query: DESCRIBE FUNCTION space
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION space
+POSTHOOK: type: DESCFUNCTION
+space(n) - returns n spaces
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED space
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED space
+POSTHOOK: type: DESCFUNCTION
+space(n) - returns n spaces
+Example:
+ > SELECT space(2) FROM src LIMIT 1;
+ ' '
PREHOOK: query: EXPLAIN SELECT
space(10),
space(0),
@@ -63,7 +76,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/228561399/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1208254968/10000
POSTHOOK: query: SELECT
length(space(10)),
length(space(0)),
@@ -73,7 +86,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/228561399/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1208254968/10000
10 0 1 0 0
PREHOOK: query: SELECT
space(10),
@@ -84,7 +97,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/201745127/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/888230107/10000
POSTHOOK: query: SELECT
space(10),
space(0),
@@ -94,5 +107,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/201745127/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/888230107/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_split.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_split.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_split.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_split.q.out Thu Jan 7 03:01:26 2010
@@ -1,3 +1,16 @@
+PREHOOK: query: DESCRIBE FUNCTION split
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION split
+POSTHOOK: type: DESCFUNCTION
+split(str, regex) - Splits str around occurances that match regex
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED split
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED split
+POSTHOOK: type: DESCFUNCTION
+split(str, regex) - Splits str around occurances that match regex
+Example:
+ > SELECT split('oneAtwoBthreeC', '[ABC]') FROM src LIMIT 1;
+ ["one", "two", "three"]
PREHOOK: query: EXPLAIN SELECT
split('a b c', ' '),
split('oneAtwoBthreeC', '[ABC]'),
@@ -58,7 +71,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/415947738/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1731015690/10000
POSTHOOK: query: SELECT
split('a b c', ' '),
split('oneAtwoBthreeC', '[ABC]'),
@@ -67,5 +80,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/415947738/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1731015690/10000
["a","b","c"] ["one","two","three"] [] ["5","4","1","2"]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substr.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substr.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substr.q.out Thu Jan 7 03:01:26 2010
@@ -1,3 +1,21 @@
+PREHOOK: query: DESCRIBE FUNCTION substr
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION substr
+POSTHOOK: type: DESCFUNCTION
+substr(str, pos[, len]) - returns the substring of str that starts at pos and is of length len
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED substr
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED substr
+POSTHOOK: type: DESCFUNCTION
+substr(str, pos[, len]) - returns the substring of str that starts at pos and is of length len
+pos is a 1-based index. If pos<0 the starting position is determined by counting backwards from the end of str.
+Example:
+ > SELECT substr('Facebook', 5) FROM src LIMIT 1;
+ 'book'
+ > SELECT substr('Facebook', -5) FROM src LIMIT 1;
+ 'ebook'
+ > SELECT substr('Facebook', 5, 1) FROM src LIMIT 1;
+ 'b'
PREHOOK: query: SELECT
substr(null, 1), substr(null, 1, 1),
substr('ABC', null), substr('ABC', null, 1),
@@ -5,7 +23,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1163670295/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/385391222/10000
POSTHOOK: query: SELECT
substr(null, 1), substr(null, 1, 1),
substr('ABC', null), substr('ABC', null, 1),
@@ -13,7 +31,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1163670295/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/385391222/10000
NULL NULL NULL NULL NULL
PREHOOK: query: SELECT
substr('ABC', 1, 0), substr('ABC', 1, -1), substr('ABC', 2, -100),
@@ -25,7 +43,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1047004193/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1555439693/10000
POSTHOOK: query: SELECT
substr('ABC', 1, 0), substr('ABC', 1, -1), substr('ABC', 2, -100),
substr('ABC', 4), substr('ABC', 4, 100),
@@ -36,7 +54,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1047004193/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1555439693/10000
PREHOOK: query: SELECT
substr('ABCDEFG', 3, 4), substr('ABCDEFG', -5, 4),
@@ -47,7 +65,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/633389211/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1351450825/10000
POSTHOOK: query: SELECT
substr('ABCDEFG', 3, 4), substr('ABCDEFG', -5, 4),
substr('ABCDEFG', 3), substr('ABCDEFG', -5),
@@ -57,7 +75,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/633389211/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1351450825/10000
CDEF CDEF CDEFG CDEFG ABC ABC BC C ABC BC A A A
PREHOOK: query: SELECT
substr('ABC', 0, 1), substr('ABC', 0, 2), substr('ABC', 0, 3), substr('ABC', 0, 4),
@@ -68,7 +86,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1247257569/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1909380959/10000
POSTHOOK: query: SELECT
substr('ABC', 0, 1), substr('ABC', 0, 2), substr('ABC', 0, 3), substr('ABC', 0, 4),
substr('ABC', 1, 1), substr('ABC', 1, 2), substr('ABC', 1, 3), substr('ABC', 1, 4),
@@ -78,7 +96,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1247257569/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1909380959/10000
A AB ABC ABC A AB ABC ABC B BC BC BC C C C C
PREHOOK: query: SELECT
substr('ABC', -1, 1), substr('ABC', -1, 2), substr('ABC', -1, 3), substr('ABC', -1, 4),
@@ -88,7 +106,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1569190573/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/606649550/10000
POSTHOOK: query: SELECT
substr('ABC', -1, 1), substr('ABC', -1, 2), substr('ABC', -1, 3), substr('ABC', -1, 4),
substr('ABC', -2, 1), substr('ABC', -2, 2), substr('ABC', -2, 3), substr('ABC', -2, 4),
@@ -97,7 +115,7 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1569190573/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/606649550/10000
C C C C B BC BC BC A AB ABC ABC
PREHOOK: query: -- substring() is a synonim of substr(), so just perform some basic tests
SELECT
@@ -109,7 +127,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1899515229/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1053388822/10000
POSTHOOK: query: -- substring() is a synonim of substr(), so just perform some basic tests
SELECT
substring('ABCDEFG', 3, 4), substring('ABCDEFG', -5, 4),
@@ -120,5 +138,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1899515229/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1053388822/10000
CDEF CDEF CDEFG CDEFG ABC ABC BC C ABC BC A A A
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_unhex.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_unhex.q.out?rev=896744&r1=896743&r2=896744&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_unhex.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_unhex.q.out Thu Jan 7 03:01:26 2010
@@ -1,3 +1,30 @@
+PREHOOK: query: DESCRIBE FUNCTION unhex
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION unhex
+POSTHOOK: type: DESCFUNCTION
+unhex(str) - Converts hexadecimal argument to string
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED unhex
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED unhex
+POSTHOOK: type: DESCFUNCTION
+unhex(str) - Converts hexadecimal argument to string
+Performs the inverse operation of HEX(str). That is, it interprets
+each pair of hexadecimal digits in the argument as a number and
+converts it to the character represented by the number. The
+resulting characters are returned as a binary string.
+
+Example:
+> SELECT UNHEX('4D7953514C') from src limit 1;
+'MySQL'
+> SELECT UNHEX(HEX('string')) from src limit 1;
+'string'
+> SELECT HEX(UNHEX('1267')) from src limit 1;
+'1267'
+
+The characters in the argument string must be legal hexadecimal
+digits: '0' .. '9', 'A' .. 'F', 'a' .. 'f'. If UNHEX() encounters
+any nonhexadecimal digits in the argument, it returns NULL. Also,
+if there are an odd number of characters a leading 0 is appended.
PREHOOK: query: -- Good inputs
SELECT
@@ -9,7 +36,7 @@
FROM src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/791570897/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1211131149/10000
POSTHOOK: query: -- Good inputs
SELECT
@@ -21,7 +48,7 @@
FROM src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/791570897/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1211131149/10000
MySQL 1267 a -4
PREHOOK: query: -- Bad inputs
SELECT
@@ -31,7 +58,7 @@
FROM src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1722929824/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1374300168/10000
POSTHOOK: query: -- Bad inputs
SELECT
unhex('MySQL'),
@@ -40,5 +67,5 @@
FROM src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1722929824/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1374300168/10000
NULL NULL NULL