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 [5/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/apac...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_function.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_function.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_function.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_function.q.out Tue Sep 29 01:25:15 2009
@@ -1,174 +1,426 @@
-query: DESCRIBE FUNCTION concat
+PREHOOK: query: DESCRIBE FUNCTION concat
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION concat
+POSTHOOK: type: DESCFUNCTION
concat(str1, str2) - returns the concatenation of str1 and str2
-query: DESCRIBE FUNCTION substr
+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
-query: DESCRIBE FUNCTION substring
+PREHOOK: query: DESCRIBE FUNCTION substring
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION substring
+POSTHOOK: type: DESCFUNCTION
substring(str, pos[, len]) - returns the substring of str that starts at pos and is of length len
-query: DESCRIBE FUNCTION space
+PREHOOK: query: DESCRIBE FUNCTION space
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION space
+POSTHOOK: type: DESCFUNCTION
space(n) - returns n spaces
-query: DESCRIBE FUNCTION repeat
+PREHOOK: query: DESCRIBE FUNCTION repeat
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION repeat
+POSTHOOK: type: DESCFUNCTION
repeat(str, n) - repeat str n times
-query: DESCRIBE FUNCTION ascii
+PREHOOK: query: DESCRIBE FUNCTION ascii
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ascii
+POSTHOOK: type: DESCFUNCTION
ascii(str) - returns the numeric value of the first character of str
-query: DESCRIBE FUNCTION lpad
+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
-query: DESCRIBE FUNCTION rpad
+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
-query: DESCRIBE FUNCTION size
+PREHOOK: query: DESCRIBE FUNCTION size
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION size
+POSTHOOK: type: DESCFUNCTION
size(a) - Returns the size of a
-query: DESCRIBE FUNCTION round
+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
-query: DESCRIBE FUNCTION floor
+PREHOOK: query: DESCRIBE FUNCTION floor
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION floor
+POSTHOOK: type: DESCFUNCTION
floor(x) - Find the largest integer not greater than x
-query: DESCRIBE FUNCTION sqrt
+PREHOOK: query: DESCRIBE FUNCTION sqrt
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION sqrt
+POSTHOOK: type: DESCFUNCTION
sqrt(x) - returns the square root of x
-query: DESCRIBE FUNCTION ceil
+PREHOOK: query: DESCRIBE FUNCTION ceil
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ceil
+POSTHOOK: type: DESCFUNCTION
ceil(x) - Find the smallest integer not smaller than x
-query: DESCRIBE FUNCTION ceiling
+PREHOOK: query: DESCRIBE FUNCTION ceiling
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ceiling
+POSTHOOK: type: DESCFUNCTION
ceiling(x) - Find the smallest integer not smaller than x
-query: DESCRIBE FUNCTION rand
+PREHOOK: query: DESCRIBE FUNCTION rand
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION rand
+POSTHOOK: type: DESCFUNCTION
rand([seed]) - Returns a pseudorandom number between 0 and 1
-query: DESCRIBE FUNCTION abs
+PREHOOK: query: DESCRIBE FUNCTION abs
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION abs
+POSTHOOK: type: DESCFUNCTION
abs(x) - returns the absolute value of x
-query: DESCRIBE FUNCTION pmod
+PREHOOK: query: DESCRIBE FUNCTION pmod
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION pmod
+POSTHOOK: type: DESCFUNCTION
a pmod b - Compute the positive modulo
-query: DESCRIBE FUNCTION ln
+PREHOOK: query: DESCRIBE FUNCTION ln
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ln
+POSTHOOK: type: DESCFUNCTION
ln(x) - Returns the natural logarithm of x
-query: DESCRIBE FUNCTION log2
+PREHOOK: query: DESCRIBE FUNCTION log2
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION log2
+POSTHOOK: type: DESCFUNCTION
log2(x) - Returns the logarithm of x with base 2
-query: DESCRIBE FUNCTION sin
+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)
-query: DESCRIBE FUNCTION asin
+PREHOOK: query: DESCRIBE FUNCTION asin
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION asin
+POSTHOOK: type: DESCFUNCTION
asin(x) - returns the arc sine of x if -1<=x<=1 or NULL otherwise
-query: DESCRIBE FUNCTION cos
+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)
-query: DESCRIBE FUNCTION acos
+PREHOOK: query: DESCRIBE FUNCTION acos
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION acos
+POSTHOOK: type: DESCFUNCTION
acos(x) - returns the arc cosine of x if -1<=x<=1 or NULL otherwise
-query: DESCRIBE FUNCTION log10
+PREHOOK: query: DESCRIBE FUNCTION log10
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION log10
+POSTHOOK: type: DESCFUNCTION
log10(x) - Returns the logarithm of x with base 10
-query: DESCRIBE FUNCTION log
+PREHOOK: query: DESCRIBE FUNCTION log
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION log
+POSTHOOK: type: DESCFUNCTION
log([b], x) - Returns the logarithm of x with base b
-query: DESCRIBE FUNCTION exp
+PREHOOK: query: DESCRIBE FUNCTION exp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION exp
+POSTHOOK: type: DESCFUNCTION
exp(x) - Returns e to the power of x
-query: DESCRIBE FUNCTION power
+PREHOOK: query: DESCRIBE FUNCTION power
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION power
+POSTHOOK: type: DESCFUNCTION
power(x1, x2) - raise x1 to the power of x2
-query: DESCRIBE FUNCTION pow
+PREHOOK: query: DESCRIBE FUNCTION pow
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION pow
+POSTHOOK: type: DESCFUNCTION
pow(x1, x2) - raise x1 to the power of x2
-query: DESCRIBE FUNCTION conv
+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
-query: DESCRIBE FUNCTION bin
+PREHOOK: query: DESCRIBE FUNCTION bin
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION bin
+POSTHOOK: type: DESCFUNCTION
bin(n) - returns n in binary
-query: DESCRIBE FUNCTION hex
+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
-query: DESCRIBE FUNCTION unhex
+PREHOOK: query: DESCRIBE FUNCTION unhex
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION unhex
+POSTHOOK: type: DESCFUNCTION
unhex(str) - Converts hexadecimal argument to string
-query: DESCRIBE FUNCTION upper
+PREHOOK: query: DESCRIBE FUNCTION upper
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION upper
+POSTHOOK: type: DESCFUNCTION
upper(str) - Returns str with all characters changed to uppercase
-query: DESCRIBE FUNCTION lower
+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
-query: DESCRIBE FUNCTION ucase
+PREHOOK: query: DESCRIBE FUNCTION ucase
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ucase
+POSTHOOK: type: DESCFUNCTION
ucase(str) - Returns str with all characters changed to uppercase
-query: DESCRIBE FUNCTION lcase
+PREHOOK: query: DESCRIBE FUNCTION lcase
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION lcase
+POSTHOOK: type: DESCFUNCTION
lcase(str) - Returns str with all characters changed to lowercase
-query: DESCRIBE FUNCTION trim
+PREHOOK: query: DESCRIBE FUNCTION trim
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION trim
+POSTHOOK: type: DESCFUNCTION
trim(str) - Removes the leading and trailing space characters from str
-query: DESCRIBE FUNCTION ltrim
+PREHOOK: query: DESCRIBE FUNCTION ltrim
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ltrim
+POSTHOOK: type: DESCFUNCTION
ltrim(str) - Removes the leading space characters from str
-query: DESCRIBE FUNCTION rtrim
+PREHOOK: query: DESCRIBE FUNCTION rtrim
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION rtrim
+POSTHOOK: type: DESCFUNCTION
rtrim(str) - Removes the trailing space characters from str
-query: DESCRIBE FUNCTION length
+PREHOOK: query: DESCRIBE FUNCTION length
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION length
+POSTHOOK: type: DESCFUNCTION
length(str) - Returns the length of str
-query: DESCRIBE FUNCTION reverse
+PREHOOK: query: DESCRIBE FUNCTION reverse
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION reverse
+POSTHOOK: type: DESCFUNCTION
reverse(str) - reverse str
-query: DESCRIBE FUNCTION like
+PREHOOK: query: DESCRIBE FUNCTION like
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION like
+POSTHOOK: type: DESCFUNCTION
like(str, pattern) - Checks if str matches pattern
-query: DESCRIBE FUNCTION rlike
+PREHOOK: query: DESCRIBE FUNCTION rlike
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION rlike
+POSTHOOK: type: DESCFUNCTION
str rlike regexp - Returns true if str matches regexp and false otherwise
-query: DESCRIBE FUNCTION regexp
+PREHOOK: query: DESCRIBE FUNCTION regexp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION regexp
+POSTHOOK: type: DESCFUNCTION
str regexp regexp - Returns true if str matches regexp and false otherwise
-query: DESCRIBE FUNCTION regexp_replace
+PREHOOK: query: DESCRIBE FUNCTION regexp_replace
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION regexp_replace
+POSTHOOK: type: DESCFUNCTION
regexp_replace(str, regexp, rep) - replace all substrings of str that match regexp with rep
-query: DESCRIBE FUNCTION regexp_extract
+PREHOOK: query: DESCRIBE FUNCTION regexp_extract
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION regexp_extract
+POSTHOOK: type: DESCFUNCTION
regexp_extract(str, regexp[, idx]) - extracts a group that matches regexp
-query: DESCRIBE FUNCTION parse_url
+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
-query: DESCRIBE FUNCTION split
+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
-query: DESCRIBE FUNCTION positive
+PREHOOK: query: DESCRIBE FUNCTION positive
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION positive
+POSTHOOK: type: DESCFUNCTION
positive a - Returns a
-query: DESCRIBE FUNCTION negative
+PREHOOK: query: DESCRIBE FUNCTION negative
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION negative
+POSTHOOK: type: DESCFUNCTION
negative a - Returns -a
-query: DESCRIBE FUNCTION day
+PREHOOK: query: DESCRIBE FUNCTION day
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION day
+POSTHOOK: type: DESCFUNCTION
day(date) - Returns the date of the month of date
-query: DESCRIBE FUNCTION dayofmonth
+PREHOOK: query: DESCRIBE FUNCTION dayofmonth
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION dayofmonth
+POSTHOOK: type: DESCFUNCTION
dayofmonth(date) - Returns the date of the month of date
-query: DESCRIBE FUNCTION month
+PREHOOK: query: DESCRIBE FUNCTION month
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION month
+POSTHOOK: type: DESCFUNCTION
month(date) - Returns the month of date
-query: DESCRIBE FUNCTION year
+PREHOOK: query: DESCRIBE FUNCTION year
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION year
+POSTHOOK: type: DESCFUNCTION
year(date) - Returns the year of date
-query: DESCRIBE FUNCTION from_unixtime
+PREHOOK: query: DESCRIBE FUNCTION from_unixtime
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION from_unixtime
+POSTHOOK: type: DESCFUNCTION
from_unixtime(unix_time, format) - returns unix_time in the specified format
-query: DESCRIBE FUNCTION unix_timestamp
+PREHOOK: query: DESCRIBE FUNCTION unix_timestamp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION unix_timestamp
+POSTHOOK: type: DESCFUNCTION
unix_timestamp([date[, pattern]]) - Returns the UNIX timestamp
-query: DESCRIBE FUNCTION to_date
+PREHOOK: query: DESCRIBE FUNCTION to_date
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION to_date
+POSTHOOK: type: DESCFUNCTION
to_date(expr) - Extracts the date part of the date or datetime expression expr
-query: DESCRIBE FUNCTION date_add
+PREHOOK: query: DESCRIBE FUNCTION date_add
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION date_add
+POSTHOOK: type: DESCFUNCTION
date_add(start_date, num_days) - Returns the date that is num_days after start_date.
-query: DESCRIBE FUNCTION date_sub
+PREHOOK: query: DESCRIBE FUNCTION date_sub
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION date_sub
+POSTHOOK: type: DESCFUNCTION
date_sub(start_date, num_days) - Returns the date that is num_days before start_date.
-query: DESCRIBE FUNCTION datediff
+PREHOOK: query: DESCRIBE FUNCTION datediff
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION datediff
+POSTHOOK: type: DESCFUNCTION
datediff(date1, date2) - Returns the number of days between date1 and date2
-query: DESCRIBE FUNCTION get_json_object
+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
-query: DESCRIBE FUNCTION +
+PREHOOK: query: DESCRIBE FUNCTION +
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION +
+POSTHOOK: type: DESCFUNCTION
a + b - Returns a+b
-query: DESCRIBE FUNCTION -
+PREHOOK: query: DESCRIBE FUNCTION -
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION -
+POSTHOOK: type: DESCFUNCTION
a - b - Returns the difference a-b
-query: DESCRIBE FUNCTION *
+PREHOOK: query: DESCRIBE FUNCTION *
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION *
+POSTHOOK: type: DESCFUNCTION
a * b - Multiplies a by b
-query: DESCRIBE FUNCTION /
+PREHOOK: query: DESCRIBE FUNCTION /
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION /
+POSTHOOK: type: DESCFUNCTION
a / b - Divide a by b
-query: DESCRIBE FUNCTION %
+PREHOOK: query: DESCRIBE FUNCTION %
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION %
+POSTHOOK: type: DESCFUNCTION
a % b - Returns the remainder when dividing a by b
-query: DESCRIBE FUNCTION div
+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
-query: DESCRIBE FUNCTION &
+PREHOOK: query: DESCRIBE FUNCTION &
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION &
+POSTHOOK: type: DESCFUNCTION
a & b - Bitwise and
-query: DESCRIBE FUNCTION |
+PREHOOK: query: DESCRIBE FUNCTION |
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION |
+POSTHOOK: type: DESCFUNCTION
a | b - Bitwise or
-query: DESCRIBE FUNCTION ^
+PREHOOK: query: DESCRIBE FUNCTION ^
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ^
+POSTHOOK: type: DESCFUNCTION
a ^ b - Bitwise exclusive or
-query: DESCRIBE FUNCTION ~
+PREHOOK: query: DESCRIBE FUNCTION ~
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ~
+POSTHOOK: type: DESCFUNCTION
~ n - Bitwise not
-query: DESCRIBE FUNCTION =
+PREHOOK: query: DESCRIBE FUNCTION =
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION =
+POSTHOOK: type: DESCFUNCTION
a = b - Returns TRUE if a equals b and false otherwise
-query: DESCRIBE FUNCTION <>
+PREHOOK: query: DESCRIBE FUNCTION <>
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION <>
+POSTHOOK: type: DESCFUNCTION
a <> b - Returns TRUE if a is not equal to b
-query: DESCRIBE FUNCTION <
+PREHOOK: query: DESCRIBE FUNCTION <
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION <
+POSTHOOK: type: DESCFUNCTION
a < b - Returns TRUE if a is less than b
-query: DESCRIBE FUNCTION <=
+PREHOOK: query: DESCRIBE FUNCTION <=
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION <=
+POSTHOOK: type: DESCFUNCTION
a <= b - Returns TRUE if b is not greater than a
-query: DESCRIBE FUNCTION >
+PREHOOK: query: DESCRIBE FUNCTION >
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION >
+POSTHOOK: type: DESCFUNCTION
a > b - Returns TRUE if a is greater than b
-query: DESCRIBE FUNCTION >=
+PREHOOK: query: DESCRIBE FUNCTION >=
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION >=
+POSTHOOK: type: DESCFUNCTION
a >= b - Returns TRUE if b is not smaller than a
-query: DESCRIBE FUNCTION and
+PREHOOK: query: DESCRIBE FUNCTION and
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION and
+POSTHOOK: type: DESCFUNCTION
a and b - Logical and
-query: DESCRIBE FUNCTION or
+PREHOOK: query: DESCRIBE FUNCTION or
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION or
+POSTHOOK: type: DESCFUNCTION
a or b - Logical or
-query: DESCRIBE FUNCTION not
+PREHOOK: query: DESCRIBE FUNCTION not
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION not
+POSTHOOK: type: DESCFUNCTION
not a - Logical not
-query: DESCRIBE FUNCTION isnull
+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
-query: DESCRIBE FUNCTION isnotnull
+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
-query: DESCRIBE FUNCTION EXTENDED concat
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED concat
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED concat
+POSTHOOK: type: DESCFUNCTION
concat(str1, str2) - returns the concatenation of str1 and str2
Returns NULL if any argument is NULL.
Example:
> SELECT concat('abc', 'def') FROM src LIMIT 1;
'abcdef'
-query: DESCRIBE FUNCTION EXTENDED substr
+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:
@@ -178,7 +430,10 @@
'ebook'
> SELECT substr('Facebook', 5, 1) FROM src LIMIT 1;
'b'
-query: DESCRIBE FUNCTION EXTENDED substring
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED substring
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED substring
+POSTHOOK: type: DESCFUNCTION
substring(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:
@@ -188,141 +443,219 @@
'ebook'
> SELECT substring('Facebook', 5, 1) FROM src LIMIT 1;
'b'
-query: DESCRIBE FUNCTION EXTENDED space
+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;
' '
-query: DESCRIBE FUNCTION EXTENDED repeat
+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'
-query: DESCRIBE FUNCTION EXTENDED ascii
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED ascii
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED ascii
+POSTHOOK: type: DESCFUNCTION
ascii(str) - returns the numeric value of the first character of str
Returns 0 if str is empty or NULL if str is NULL
Example:
> SELECT ascii('222') FROM src LIMIT 1; 50
> SELECT ascii(2) FROM src LIMIT 1;
50
-query: DESCRIBE FUNCTION EXTENDED lpad
+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'
-query: DESCRIBE FUNCTION EXTENDED rpad
+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'
-query: DESCRIBE FUNCTION EXTENDED size
+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
-query: DESCRIBE FUNCTION EXTENDED round
+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'
-query: DESCRIBE FUNCTION EXTENDED floor
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED floor
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED floor
+POSTHOOK: type: DESCFUNCTION
floor(x) - Find the largest integer not greater than x
Example:
> SELECT floor(-0.1) FROM src LIMIT 1;
-1
> SELECT floor(5) FROM src LIMIT 1;
5
-query: DESCRIBE FUNCTION EXTENDED sqrt
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED sqrt
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED sqrt
+POSTHOOK: type: DESCFUNCTION
sqrt(x) - returns the square root of x
Example:
> SELECT sqrt(4) FROM src LIMIT 1;
2
-query: DESCRIBE FUNCTION EXTENDED ceil
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED ceil
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED ceil
+POSTHOOK: type: DESCFUNCTION
ceil(x) - Find the smallest integer not smaller than x
Example:
> SELECT ceil(-0.1) FROM src LIMIT 1;
0
> SELECT ceil(5) FROM src LIMIT 1;
5
-query: DESCRIBE FUNCTION EXTENDED ceiling
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED ceiling
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED ceiling
+POSTHOOK: type: DESCFUNCTION
ceiling(x) - Find the smallest integer not smaller than x
Example:
> SELECT ceiling(-0.1) FROM src LIMIT 1;
0
> SELECT ceiling(5) FROM src LIMIT 1;
5
-query: DESCRIBE FUNCTION EXTENDED rand
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED rand
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED rand
+POSTHOOK: type: DESCFUNCTION
rand([seed]) - Returns a pseudorandom number between 0 and 1
-query: DESCRIBE FUNCTION EXTENDED abs
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED abs
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED abs
+POSTHOOK: type: DESCFUNCTION
abs(x) - returns the absolute value of x
Example:
> SELECT abs(0) FROM src LIMIT 1;
0
> SELECT abs(-5) FROM src LIMIT 1;
5
-query: DESCRIBE FUNCTION EXTENDED pmod
+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
-query: DESCRIBE FUNCTION EXTENDED ln
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED ln
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED ln
+POSTHOOK: type: DESCFUNCTION
ln(x) - Returns the natural logarithm of x
Example:
> SELECT ln(1) FROM src LIMIT 1;
0
-query: DESCRIBE FUNCTION EXTENDED log2
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED log2
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED log2
+POSTHOOK: type: DESCFUNCTION
log2(x) - Returns the logarithm of x with base 2
Example:
> SELECT log2(2) FROM src LIMIT 1;
1
-query: DESCRIBE FUNCTION EXTENDED sin
+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
-query: DESCRIBE FUNCTION EXTENDED asin
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED asin
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED asin
+POSTHOOK: type: DESCFUNCTION
asin(x) - returns the arc sine of x if -1<=x<=1 or NULL otherwise
Example:
> SELECT asin(0) FROM src LIMIT 1;
0
> SELECT asin(2) FROM src LIMIT 1;
NULL
-query: DESCRIBE FUNCTION EXTENDED cos
+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
-query: DESCRIBE FUNCTION EXTENDED acos
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED acos
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED acos
+POSTHOOK: type: DESCFUNCTION
acos(x) - returns the arc cosine of x if -1<=x<=1 or NULL otherwise
Example:
> SELECT acos(1) FROM src LIMIT 1;
0
> SELECT acos(2) FROM src LIMIT 1;
NULL
-query: DESCRIBE FUNCTION EXTENDED log10
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED log10
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED log10
+POSTHOOK: type: DESCFUNCTION
log10(x) - Returns the logarithm of x with base 10
Example:
> SELECT log10(10) FROM src LIMIT 1;
1
-query: DESCRIBE FUNCTION EXTENDED log
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED log
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED log
+POSTHOOK: type: DESCFUNCTION
log([b], x) - Returns the logarithm of x with base b
Example:
> SELECT log(13, 13) FROM src LIMIT 1;
1
-query: DESCRIBE FUNCTION EXTENDED exp
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED exp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED exp
+POSTHOOK: type: DESCFUNCTION
exp(x) - Returns e to the power of x
Example:
> SELECT exp(0) FROM src LIMIT 1;
1
-query: DESCRIBE FUNCTION EXTENDED power
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED power
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED power
+POSTHOOK: type: DESCFUNCTION
power(x1, x2) - raise x1 to the power of x2
Example:
> SELECT power(2, 3) FROM src LIMIT 1;
8
-query: DESCRIBE FUNCTION EXTENDED pow
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED pow
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED pow
+POSTHOOK: type: DESCFUNCTION
pow(x1, x2) - raise x1 to the power of x2
Example:
> SELECT pow(2, 3) FROM src LIMIT 1;
8
-query: DESCRIBE FUNCTION EXTENDED conv
+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:
@@ -330,13 +663,19 @@
'4'
> SELECT conv(-10, 16, -10) FROM src LIMIT 1;
'16'
-query: DESCRIBE FUNCTION EXTENDED bin
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED bin
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED bin
+POSTHOOK: type: DESCFUNCTION
bin(n) - returns n in binary
n is a BIGINT. Returns NULL if n is NULL.
Example:
> SELECT bin(13) FROM src LIMIT 1
'1101'
-query: DESCRIBE FUNCTION EXTENDED hex
+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.
@@ -345,7 +684,10 @@
'H1'
> SELECT hex('Facebook') FROM src LIMIT 1;
'46616365626F6F6B'
-query: DESCRIBE FUNCTION EXTENDED unhex
+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
@@ -364,77 +706,122 @@
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.
-query: DESCRIBE FUNCTION EXTENDED upper
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED upper
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED upper
+POSTHOOK: type: DESCFUNCTION
upper(str) - Returns str with all characters changed to uppercase
Example:
> SELECT upper('Facebook') FROM src LIMIT 1;
'FACEBOOK'
-query: DESCRIBE FUNCTION EXTENDED lower
+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'
-query: DESCRIBE FUNCTION EXTENDED ucase
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED ucase
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED ucase
+POSTHOOK: type: DESCFUNCTION
ucase(str) - Returns str with all characters changed to uppercase
Example:
> SELECT ucase('Facebook') FROM src LIMIT 1;
'FACEBOOK'
-query: DESCRIBE FUNCTION EXTENDED lcase
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED lcase
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED lcase
+POSTHOOK: type: DESCFUNCTION
lcase(str) - Returns str with all characters changed to lowercase
Example:
> SELECT lcase('Facebook') FROM src LIMIT 1;
'facebook'
-query: DESCRIBE FUNCTION EXTENDED trim
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED trim
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED trim
+POSTHOOK: type: DESCFUNCTION
trim(str) - Removes the leading and trailing space characters from str
Example:
> SELECT trim(' facebook ') FROM src LIMIT 1;
'facebook'
-query: DESCRIBE FUNCTION EXTENDED ltrim
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED ltrim
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED ltrim
+POSTHOOK: type: DESCFUNCTION
ltrim(str) - Removes the leading space characters from str
Example:
> SELECT ltrim(' facebook') FROM src LIMIT 1;
'facebook'
-query: DESCRIBE FUNCTION EXTENDED rtrim
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED rtrim
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED rtrim
+POSTHOOK: type: DESCFUNCTION
rtrim(str) - Removes the trailing space characters from str
Example:
> SELECT rtrim('facebook ') FROM src LIMIT 1;
'facebook'
-query: DESCRIBE FUNCTION EXTENDED length
+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
-query: DESCRIBE FUNCTION EXTENDED reverse
+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'
-query: DESCRIBE FUNCTION EXTENDED like
+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
-query: DESCRIBE FUNCTION EXTENDED rlike
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED rlike
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED rlike
+POSTHOOK: type: DESCFUNCTION
str rlike regexp - Returns true if str matches regexp and false otherwise
Example:
> SELECT 'fb' rlike '.*' FROM src LIMIT 1;
true
-query: DESCRIBE FUNCTION EXTENDED regexp
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED regexp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED regexp
+POSTHOOK: type: DESCFUNCTION
str regexp regexp - Returns true if str matches regexp and false otherwise
Example:
> SELECT 'fb' regexp '.*' FROM src LIMIT 1;
true
-query: DESCRIBE FUNCTION EXTENDED regexp_replace
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED regexp_replace
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED regexp_replace
+POSTHOOK: type: DESCFUNCTION
regexp_replace(str, regexp, rep) - replace all substrings of str that match regexp with rep
Example:
> SELECT regexp_replace('100-200', '(\d+)', 'num') FROM src LIMIT 1;
'num-num'
-query: DESCRIBE FUNCTION EXTENDED regexp_extract
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED regexp_extract
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED regexp_extract
+POSTHOOK: type: DESCFUNCTION
regexp_extract(str, regexp[, idx]) - extracts a group that matches regexp
Example:
> SELECT regexp_extract('100-200', '(\d+)-(\d+)', 1) FROM src LIMIT 1;
'100'
-query: DESCRIBE FUNCTION EXTENDED parse_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
@@ -445,70 +832,112 @@
'query=1'
> SELECT parse_url('http://facebook.com/path/p1.php?query=1', 'QUERY', 'query') FROM src LIMIT 1;
'1'
-query: DESCRIBE FUNCTION EXTENDED split
+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"]
-query: DESCRIBE FUNCTION EXTENDED positive
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED positive
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED positive
+POSTHOOK: type: DESCFUNCTION
positive a - Returns a
-query: DESCRIBE FUNCTION EXTENDED negative
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED negative
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED negative
+POSTHOOK: type: DESCFUNCTION
negative a - Returns -a
-query: DESCRIBE FUNCTION EXTENDED day
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED day
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED day
+POSTHOOK: type: DESCFUNCTION
day(date) - Returns the date of the month of date
date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
Example:
> SELECT day('2009-30-07', 1) FROM src LIMIT 1;
30
-query: DESCRIBE FUNCTION EXTENDED dayofmonth
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED dayofmonth
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED dayofmonth
+POSTHOOK: type: DESCFUNCTION
dayofmonth(date) - Returns the date of the month of date
date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
Example:
> SELECT dayofmonth('2009-30-07', 1) FROM src LIMIT 1;
30
-query: DESCRIBE FUNCTION EXTENDED month
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED month
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED month
+POSTHOOK: type: DESCFUNCTION
month(date) - Returns the month of date
Example:
> SELECT month('2009-30-07') FROM src LIMIT 1;
7
-query: DESCRIBE FUNCTION EXTENDED year
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED year
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED year
+POSTHOOK: type: DESCFUNCTION
year(date) - Returns the year of date
date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
Example:
> SELECT year('2009-30-07', 1) FROM src LIMIT 1;
2009
-query: DESCRIBE FUNCTION EXTENDED from_unixtime
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED from_unixtime
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED from_unixtime
+POSTHOOK: type: DESCFUNCTION
from_unixtime(unix_time, format) - returns unix_time in the specified format
Example:
> SELECT from_unixtime(0, 'yyyy-MM-dd HH:mm:ss') FROM src LIMIT 1;
'1970-01-01 00:00:00'
-query: DESCRIBE FUNCTION EXTENDED unix_timestamp
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED unix_timestamp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED unix_timestamp
+POSTHOOK: type: DESCFUNCTION
unix_timestamp([date[, pattern]]) - Returns the UNIX timestamp
Converts the current or specified time to number of seconds since 1970-01-01.
-query: DESCRIBE FUNCTION EXTENDED to_date
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED to_date
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED to_date
+POSTHOOK: type: DESCFUNCTION
to_date(expr) - Extracts the date part of the date or datetime expression expr
Example:
> SELECT to_date('2009-30-07 04:17:52') FROM src LIMIT 1;
'2009-30-07'
-query: DESCRIBE FUNCTION EXTENDED date_add
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED date_add
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED date_add
+POSTHOOK: type: DESCFUNCTION
date_add(start_date, num_days) - Returns the date that is num_days after start_date.
start_date is a string in the format 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'. num_days is a number. The time part of start_date is ignored.
Example:
> SELECT date_add('2009-30-07', 1) FROM src LIMIT 1;
'2009-31-07'
-query: DESCRIBE FUNCTION EXTENDED date_sub
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED date_sub
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED date_sub
+POSTHOOK: type: DESCFUNCTION
date_sub(start_date, num_days) - Returns the date that is num_days before start_date.
start_date is a string in the format 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'. num_days is a number. The time part of start_date is ignored.
Example:
> SELECT date_sub('2009-30-07', 1) FROM src LIMIT 1;
'2009-29-07'
-query: DESCRIBE FUNCTION EXTENDED datediff
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED datediff
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED datediff
+POSTHOOK: type: DESCFUNCTION
datediff(date1, date2) - Returns the number of days between date1 and date2
date1 and date2 are strings in the format 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'. The time parts are ignored.If date1 is earlier than date2, the result is negative.
Example:
> SELECT datediff('2009-30-07', '2009-31-07') FROM src LIMIT 1;
1
-query: DESCRIBE FUNCTION EXTENDED get_json_object
+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:
@@ -525,66 +954,129 @@
[,] : Union operator
[start:end:step] : array slice operator
-query: DESCRIBE FUNCTION EXTENDED +
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED +
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED +
+POSTHOOK: type: DESCFUNCTION
a + b - Returns a+b
-query: DESCRIBE FUNCTION EXTENDED -
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED -
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED -
+POSTHOOK: type: DESCFUNCTION
a - b - Returns the difference a-b
-query: DESCRIBE FUNCTION EXTENDED *
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED *
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED *
+POSTHOOK: type: DESCFUNCTION
a * b - Multiplies a by b
-query: DESCRIBE FUNCTION EXTENDED /
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED /
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED /
+POSTHOOK: type: DESCFUNCTION
a / b - Divide a by b
Example:
> SELECT 3 / 2 FROM src LIMIT 1;
1.5
-query: DESCRIBE FUNCTION EXTENDED %
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED %
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED %
+POSTHOOK: type: DESCFUNCTION
a % b - Returns the remainder when dividing a by b
-query: DESCRIBE FUNCTION EXTENDED div
+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
-query: DESCRIBE FUNCTION EXTENDED &
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED &
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED &
+POSTHOOK: type: DESCFUNCTION
a & b - Bitwise and
Example:
> SELECT 3 & 5 FROM src LIMIT 1;
1
-query: DESCRIBE FUNCTION EXTENDED |
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED |
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED |
+POSTHOOK: type: DESCFUNCTION
a | b - Bitwise or
Example:
> SELECT 3 | 5 FROM src LIMIT 1;
7
-query: DESCRIBE FUNCTION EXTENDED ^
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED ^
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED ^
+POSTHOOK: type: DESCFUNCTION
a ^ b - Bitwise exclusive or
Example:
> SELECT 3 ^ 5 FROM src LIMIT 1;
2
-query: DESCRIBE FUNCTION EXTENDED ~
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED ~
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED ~
+POSTHOOK: type: DESCFUNCTION
~ n - Bitwise not
Example:
> SELECT ~ 0 FROM src LIMIT 1;
-1
-query: DESCRIBE FUNCTION EXTENDED =
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED =
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED =
+POSTHOOK: type: DESCFUNCTION
a = b - Returns TRUE if a equals b and false otherwise
-query: DESCRIBE FUNCTION EXTENDED <>
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED <>
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED <>
+POSTHOOK: type: DESCFUNCTION
a <> b - Returns TRUE if a is not equal to b
-query: DESCRIBE FUNCTION EXTENDED <
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED <
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED <
+POSTHOOK: type: DESCFUNCTION
a < b - Returns TRUE if a is less than b
-query: DESCRIBE FUNCTION EXTENDED <=
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED <=
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED <=
+POSTHOOK: type: DESCFUNCTION
a <= b - Returns TRUE if b is not greater than a
-query: DESCRIBE FUNCTION EXTENDED >
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED >
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED >
+POSTHOOK: type: DESCFUNCTION
a > b - Returns TRUE if a is greater than b
-query: DESCRIBE FUNCTION EXTENDED >=
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED >=
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED >=
+POSTHOOK: type: DESCFUNCTION
a >= b - Returns TRUE if b is not smaller than a
-query: DESCRIBE FUNCTION EXTENDED and
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED and
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED and
+POSTHOOK: type: DESCFUNCTION
a and b - Logical and
Example:
> SELECT * FROM srcpart WHERE src.hr=12 and src.hr='2008-04-08' LIMIT 1;
27 val_27 2008-04-08 12
-query: DESCRIBE FUNCTION EXTENDED or
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED or
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED or
+POSTHOOK: type: DESCFUNCTION
a or b - Logical or
-query: DESCRIBE FUNCTION EXTENDED not
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED not
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED not
+POSTHOOK: type: DESCFUNCTION
not a - Logical not
-query: DESCRIBE FUNCTION EXTENDED isnull
+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
-query: DESCRIBE FUNCTION EXTENDED isnotnull
+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
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_xpath.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_xpath.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_xpath.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_xpath.q.out Tue Sep 29 01:25:15 2009
@@ -1,20 +1,44 @@
-query: -- Describe a list structure in a thrift table
+PREHOOK: query: -- Describe a list structure in a thrift table
describe src_thrift.lint
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: -- Describe a list structure in a thrift table
+describe src_thrift.lint
+POSTHOOK: type: DESCTABLE
lint array<int> from deserializer
-query: -- Describe the element of a list
+PREHOOK: query: -- Describe the element of a list
+describe src_thrift.lint.$elem$
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: -- Describe the element of a list
describe src_thrift.lint.$elem$
+POSTHOOK: type: DESCTABLE
$elem$ int from deserializer
-query: -- Describe the key of a map
+PREHOOK: query: -- Describe the key of a map
+describe src_thrift.mStringString.$key$
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: -- Describe the key of a map
describe src_thrift.mStringString.$key$
+POSTHOOK: type: DESCTABLE
$key$ string from deserializer
-query: -- Describe the value of a map
+PREHOOK: query: -- Describe the value of a map
describe src_thrift.mStringString.$value$
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: -- Describe the value of a map
+describe src_thrift.mStringString.$value$
+POSTHOOK: type: DESCTABLE
$value$ string from deserializer
-query: -- Describe a complex element of a list
+PREHOOK: query: -- Describe a complex element of a list
+describe src_thrift.lintString.$elem$
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: -- Describe a complex element of a list
describe src_thrift.lintString.$elem$
+POSTHOOK: type: DESCTABLE
myint int from deserializer
mystring string from deserializer
underscore_int int from deserializer
-query: -- Describe a member of an element of a list
+PREHOOK: query: -- Describe a member of an element of a list
+describe src_thrift.lintString.$elem$.myint
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: -- Describe a member of an element of a list
describe src_thrift.lintString.$elem$.myint
+POSTHOOK: type: DESCTABLE
myint int from deserializer
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/drop_udf.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/drop_udf.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/drop_udf.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/drop_udf.q.out Tue Sep 29 01:25:15 2009
@@ -1,6 +1,13 @@
-query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
-query: EXPLAIN
+PREHOOK: query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
+PREHOOK: type: CREATEFUNCTION
+POSTHOOK: query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate'
+POSTHOOK: type: CREATEFUNCTION
+PREHOOK: query: EXPLAIN
DROP TEMPORARY FUNCTION test_translate
+PREHOOK: type: DROPFUNCTION
+POSTHOOK: query: EXPLAIN
+DROP TEMPORARY FUNCTION test_translate
+POSTHOOK: type: DROPFUNCTION
ABSTRACT SYNTAX TREE:
(TOK_DROPFUNCTION test_translate)
@@ -11,4 +18,7 @@
Stage: Stage-0
-query: DROP TEMPORARY FUNCTION test_translate
+PREHOOK: query: DROP TEMPORARY FUNCTION test_translate
+PREHOOK: type: DROPFUNCTION
+POSTHOOK: query: DROP TEMPORARY FUNCTION test_translate
+POSTHOOK: type: DROPFUNCTION
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out Tue Sep 29 01:25:15 2009
@@ -1,7 +1,13 @@
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
CREATE TABLE dest1(key INT, value STRING) STORED AS
INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: EXPLAIN
+CREATE TABLE dest1(key INT, value STRING) STORED AS
+ INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
+ OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
+POSTHOOK: type: CREATETABLE
ABSTRACT SYNTAX TREE:
(TOK_CREATETABLE dest1 TOK_LIKETABLE (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEFILEFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat' 'org.apache.hadoop.mapred.SequenceFileOutputFormat'))
@@ -21,21 +27,41 @@
isExternal: false
-query: CREATE TABLE dest1(key INT, value STRING) STORED AS
+PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS
INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
-query: DESCRIBE EXTENDED dest1
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS
+ INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
+ OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: DESCRIBE EXTENDED dest1
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE EXTENDED dest1
+POSTHOOK: type: DESCTABLE
key int
value string
-Detailed Table Information Table(tableName:dest1,dbName:default,owner:zshao,createTime:1243543756,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:key,type:int,comment:null), FieldSchema(name:value,type:string,comment:null)],location:file:/data/users/zshao/tools/495-trunk-apache-hive/build/ql/test/data/warehouse/dest1,inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{})
-query: FROM src
+Detailed Table Information Table(tableName:dest1, dbName:default, owner:njain, createTime:1253779880, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/dest1, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{})
+PREHOOK: query: FROM src
+INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@dest1
+POSTHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
-Input: default/src
-Output: default/dest1
-query: SELECT dest1.* FROM dest1
-Input: default/dest1
-Output: file:/data/users/zshao/tools/495-trunk-apache-hive/build/ql/tmp/1703595747/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+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/862471397/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/862471397/10000
0 val_0
4 val_4
8 val_8
@@ -46,4 +72,8 @@
2 val_2
5 val_5
9 val_9
-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/fileformat_text.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out Tue Sep 29 01:25:15 2009
@@ -1,7 +1,13 @@
-query: EXPLAIN
+PREHOOK: query: EXPLAIN
CREATE TABLE dest1(key INT, value STRING) STORED AS
INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: EXPLAIN
+CREATE TABLE dest1(key INT, value STRING) STORED AS
+ INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat'
+ OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
+POSTHOOK: type: CREATETABLE
ABSTRACT SYNTAX TREE:
(TOK_CREATETABLE dest1 TOK_LIKETABLE (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEFILEFORMAT 'org.apache.hadoop.mapred.TextInputFormat' 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'))
@@ -21,21 +27,41 @@
isExternal: false
-query: CREATE TABLE dest1(key INT, value STRING) STORED AS
+PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS
INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
-query: DESCRIBE EXTENDED dest1
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS
+ INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat'
+ OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: DESCRIBE EXTENDED dest1
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: DESCRIBE EXTENDED dest1
+POSTHOOK: type: DESCTABLE
key int
value string
-Detailed Table Information Table(tableName:dest1,dbName:default,owner:zshao,createTime:1243543761,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:key,type:int,comment:null), FieldSchema(name:value,type:string,comment:null)],location:file:/data/users/zshao/tools/495-trunk-apache-hive/build/ql/test/data/warehouse/dest1,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{})
-query: FROM src
+Detailed Table Information Table(tableName:dest1, dbName:default, owner:njain, createTime:1253779886, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/dest1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{})
+PREHOOK: query: FROM src
+INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@dest1
+POSTHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
-Input: default/src
-Output: default/dest1
-query: SELECT dest1.* FROM dest1
-Input: default/dest1
-Output: file:/data/users/zshao/tools/495-trunk-apache-hive/build/ql/tmp/969578239/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+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/1843819480/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/1843819480/10000
0 val_0
4 val_4
8 val_8
@@ -46,4 +72,8 @@
2 val_2
5 val_5
9 val_9
-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/groupby1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1.q.out Tue Sep 29 01:25:15 2009
@@ -1,6 +1,14 @@
-query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
-query: EXPLAIN
+PREHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest_g1
+PREHOOK: query: EXPLAIN
FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest_g1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src) key))))
@@ -54,7 +62,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- invalidscheme:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1292130777/10002
+ invalidscheme:/data/users/njain/hive5/hive5/.ptest_3/build/ql/tmp/1275589613/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -110,12 +118,22 @@
name: dest_g1
-query: FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
-Input: default/src
-Output: default/dest_g1
-query: SELECT dest_g1.* FROM dest_g1
-Input: default/dest_g1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/216605822/10000
+PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@dest_g1
+POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@dest_g1
+PREHOOK: query: SELECT dest_g1.* FROM dest_g1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest_g1
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/.ptest_3/build/ql/tmp/1595205675/10000
+POSTHOOK: query: SELECT dest_g1.* FROM dest_g1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest_g1
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/.ptest_3/build/ql/tmp/1595205675/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out Tue Sep 29 01:25:15 2009
@@ -1,14 +1,45 @@
-query: drop table dest1
-query: drop table dest2
-query: drop table INPUT
-query: CREATE TABLE dest1(key INT, val1 INT, val2 INT)
-query: CREATE TABLE dest2(key INT, val1 INT, val2 INT)
-query: CREATE TABLE INPUT(key INT, value STRING) STORED AS TEXTFILE
-query: LOAD DATA LOCAL INPATH '../data/files/kv5.txt' INTO TABLE INPUT
-query: EXPLAIN
+PREHOOK: query: drop table dest1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table dest1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table dest2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table dest2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table INPUT
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table INPUT
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE dest1(key INT, val1 INT, val2 INT)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest1(key INT, val1 INT, val2 INT)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: CREATE TABLE dest2(key INT, val1 INT, val2 INT)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest2(key INT, val1 INT, val2 INT)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest2
+PREHOOK: query: CREATE TABLE INPUT(key INT, value STRING) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE INPUT(key INT, value STRING) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@INPUT
+PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv5.txt' INTO TABLE INPUT
+PREHOOK: type: LOAD
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv5.txt' INTO TABLE INPUT
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@input
+PREHOOK: query: EXPLAIN
FROM INPUT
INSERT OVERWRITE TABLE dest1 SELECT INPUT.key, count(substr(INPUT.value,5)), count(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
INSERT OVERWRITE TABLE dest2 SELECT INPUT.key, sum(substr(INPUT.value,5)), sum(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+FROM INPUT
+INSERT OVERWRITE TABLE dest1 SELECT INPUT.key, count(substr(INPUT.value,5)), count(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
+INSERT OVERWRITE TABLE dest2 SELECT INPUT.key, sum(substr(INPUT.value,5)), sum(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF INPUT)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL INPUT) key)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL INPUT) value) 5))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL INPUT) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL INPUT) key))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL INPUT) key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL INPUT) value) 5))) (TOK_SELEXPR (TOK_FUNCTIONDI sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL INPUT) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL INPUT) key))))
@@ -74,7 +105,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/458423382/10004
+ file:/data/users/njain/hive5/hive5/build/ql/tmp/1745933773/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -139,7 +170,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/458423382/10005
+ file:/data/users/njain/hive5/hive5/build/ql/tmp/1745933773/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -202,15 +233,28 @@
name: dest2
-query: FROM INPUT
+PREHOOK: query: FROM INPUT
+INSERT OVERWRITE TABLE dest1 SELECT INPUT.key, count(substr(INPUT.value,5)), count(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
+INSERT OVERWRITE TABLE dest2 SELECT INPUT.key, sum(substr(INPUT.value,5)), sum(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@input
+PREHOOK: Output: default@dest1
+PREHOOK: Output: default@dest2
+POSTHOOK: query: FROM INPUT
INSERT OVERWRITE TABLE dest1 SELECT INPUT.key, count(substr(INPUT.value,5)), count(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
INSERT OVERWRITE TABLE dest2 SELECT INPUT.key, sum(substr(INPUT.value,5)), sum(distinct substr(INPUT.value,5)) GROUP BY INPUT.key
-Input: default/input
-Output: default/dest1
-Output: default/dest2
-query: SELECT * from dest1
-Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1557071213/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@input
+POSTHOOK: Output: default@dest1
+POSTHOOK: Output: default@dest2
+PREHOOK: query: SELECT * from dest1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest1
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/810841334/10000
+POSTHOOK: query: SELECT * from dest1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest1
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/810841334/10000
27 1 1
66 1 1
86 1 1
@@ -231,9 +275,14 @@
401 1 1
409 1 1
484 1 1
-query: SELECT * from dest2
-Input: default/dest2
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1527114002/10000
+PREHOOK: query: SELECT * from dest2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest2
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/566919289/10000
+POSTHOOK: query: SELECT * from dest2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest2
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/566919289/10000
27 27 27
66 66 66
86 86 86
@@ -254,6 +303,18 @@
401 401 401
409 409 409
484 484 484
-query: drop table INPUT
-query: drop table dest1
-query: drop table dest2
+PREHOOK: query: drop table INPUT
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table INPUT
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Output: default@input
+PREHOOK: query: drop table dest1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table dest1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: drop table dest2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table dest2
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Output: default@dest2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby11.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby11.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby11.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby11.q.out Tue Sep 29 01:25:15 2009
@@ -1,13 +1,35 @@
-query: drop table dest1
-query: drop table dest2
-query: CREATE TABLE dest1(key STRING, val1 INT, val2 INT) partitioned by (ds string)
-query: CREATE TABLE dest2(key STRING, val1 INT, val2 INT) partitioned by (ds string)
-query: EXPLAIN
+PREHOOK: query: drop table dest1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table dest1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table dest2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table dest2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE dest1(key STRING, val1 INT, val2 INT) partitioned by (ds string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest1(key STRING, val1 INT, val2 INT) partitioned by (ds string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: CREATE TABLE dest2(key STRING, val1 INT, val2 INT) partitioned by (ds string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest2(key STRING, val1 INT, val2 INT) partitioned by (ds string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest2
+PREHOOK: query: EXPLAIN
FROM src
INSERT OVERWRITE TABLE dest1 partition(ds='111')
SELECT src.value, count(src.key), count(distinct src.key) GROUP BY src.value
INSERT OVERWRITE TABLE dest2 partition(ds='111')
SELECT substr(src.value, 5), count(src.key), count(distinct src.key) GROUP BY substr(src.value, 5)
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+FROM src
+INSERT OVERWRITE TABLE dest1 partition(ds='111')
+ SELECT src.value, count(src.key), count(distinct src.key) GROUP BY src.value
+INSERT OVERWRITE TABLE dest2 partition(ds='111')
+ SELECT substr(src.value, 5), count(src.key), count(distinct src.key) GROUP BY substr(src.value, 5)
+POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1 (TOK_PARTSPEC (TOK_PARTVAL ds '111')))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value)) (TOK_SELEXPR (TOK_FUNCTION count (. (TOK_TABLE_OR_COL src) key))) (TOK_SELEXPR (TOK_FUNCTIONDI count (. (TOK_TABLE_OR_COL src) key)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src) value))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2 (TOK_PARTSPEC (TOK_PARTVAL ds '111')))) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5)) (TOK_SELEXPR (TOK_FUNCTION count (. (TOK_TABLE_OR_COL src) key))) (TOK_SELEXPR (TOK_FUNCTIONDI count (. (TOK_TABLE_OR_COL src) key)))) (TOK_GROUPBY (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))))
@@ -75,7 +97,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/353987509/10004
+ file:/data/users/njain/hive5/hive5/build/ql/tmp/799679609/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -142,7 +164,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/353987509/10005
+ file:/data/users/njain/hive5/hive5/build/ql/tmp/799679609/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -207,17 +229,32 @@
name: dest2
-query: FROM src
+PREHOOK: query: FROM src
+INSERT OVERWRITE TABLE dest1 partition(ds='111')
+ SELECT src.value, count(src.key), count(distinct src.key) GROUP BY src.value
+INSERT OVERWRITE TABLE dest2 partition(ds='111')
+ SELECT substr(src.value, 5), count(src.key), count(distinct src.key) GROUP BY substr(src.value, 5)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@dest1@ds=111
+PREHOOK: Output: default@dest2@ds=111
+POSTHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 partition(ds='111')
SELECT src.value, count(src.key), count(distinct src.key) GROUP BY src.value
INSERT OVERWRITE TABLE dest2 partition(ds='111')
SELECT substr(src.value, 5), count(src.key), count(distinct src.key) GROUP BY substr(src.value, 5)
-Input: default/src
-Output: default/dest1/ds=111
-Output: default/dest2/ds=111
-query: SELECT * from dest1
-Input: default/dest1/ds=111
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1308166623/10000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@dest1@ds=111
+POSTHOOK: Output: default@dest2@ds=111
+PREHOOK: query: SELECT * from dest1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest1@ds=111
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1044642512/10000
+POSTHOOK: query: SELECT * from dest1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest1@ds=111
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1044642512/10000
val_0 3 1 111
val_10 1 1 111
val_100 2 1 111
@@ -527,9 +564,14 @@
val_96 1 1 111
val_97 2 1 111
val_98 2 1 111
-query: SELECT * from dest2
-Input: default/dest2/ds=111
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/208593605/10000
+PREHOOK: query: SELECT * from dest2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest2@ds=111
+PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1431820508/10000
+POSTHOOK: query: SELECT * from dest2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest2@ds=111
+POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1431820508/10000
0 3 1 111
10 1 1 111
100 2 1 111
@@ -839,5 +881,13 @@
96 1 1 111
97 2 1 111
98 2 1 111
-query: drop table dest1
-query: drop table dest2
+PREHOOK: query: drop table dest1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table dest1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: drop table dest2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table dest2
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Output: default@dest2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out Tue Sep 29 01:25:15 2009
@@ -1,6 +1,14 @@
-query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
-query: EXPLAIN
+PREHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: EXPLAIN
FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
+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_TABLE_OR_COL src) key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src) key)) (TOK_LIMIT 5)))
@@ -70,7 +78,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1173614638/10002
+ file:/data/users/njain/hive5/hive5/build/ql/tmp/1010104085/10002
Reduce Output Operator
sort order:
tag: -1
@@ -109,12 +117,22 @@
name: dest1
-query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
-Input: default/src
-Output: default/dest1
-query: SELECT dest1.* FROM dest1
-Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/197588214/10000
+PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@dest1
+POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+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/776994640/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/776994640/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out Tue Sep 29 01:25:15 2009
@@ -1,6 +1,14 @@
-query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
-query: EXPLAIN
+PREHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: EXPLAIN
FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+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_TABLE_OR_COL src) key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src) key))))
@@ -85,12 +93,22 @@
name: dest1
-query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
-Input: default/src
-Output: default/dest1
-query: SELECT dest1.* FROM dest1
-Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1144777415/10000
+PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@dest1
+POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+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/759116141/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/759116141/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_nomap.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_nomap.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_nomap.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_nomap.q.out Tue Sep 29 01:25:15 2009
@@ -1,6 +1,14 @@
-query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
-query: EXPLAIN
+PREHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: EXPLAIN
FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+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_TABLE_OR_COL src) key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src) key))))
@@ -85,12 +93,22 @@
name: dest1
-query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
-Input: default/src
-Output: default/dest1
-query: SELECT dest1.* FROM dest1
-Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/200206031/10000
+PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@dest1
+POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+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/2053916777/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/2053916777/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out?rev=819792&r1=819791&r2=819792&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out Tue Sep 29 01:25:15 2009
@@ -1,6 +1,14 @@
-query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
-query: EXPLAIN
+PREHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: EXPLAIN
FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+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_TABLE_OR_COL src) key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src) key))))
@@ -62,7 +70,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1847926486/10002
+ file:/data/users/njain/hive5/hive5/build/ql/tmp/1252089764/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -118,12 +126,22 @@
name: dest1
-query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
-Input: default/src
-Output: default/dest1
-query: SELECT dest1.* FROM dest1
-Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1826125083/10000
+PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@dest1
+POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+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/1734846725/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/1734846725/10000
0 0.0
10 10.0
100 200.0