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 22:54:39 UTC
svn commit: r897026 [2/4] - in /hadoop/hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rtrim.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rtrim.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rtrim.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rtrim.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION rtrim;
+DESCRIBE FUNCTION EXTENDED rtrim;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_second.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_second.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_second.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_second.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,9 @@
+DESCRIBE FUNCTION second;
+DESCRIBE FUNCTION EXTENDED second;
+
+EXPLAIN
+SELECT second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
+FROM src WHERE key = 86;
+
+SELECT second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
+FROM src WHERE key = 86;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_smallint.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_smallint.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_smallint.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_smallint.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION smallint;
+DESCRIBE FUNCTION EXTENDED smallint;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_sqrt.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_sqrt.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_sqrt.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_sqrt.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION sqrt;
+DESCRIBE FUNCTION EXTENDED sqrt;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_std.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_std.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_std.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_std.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION std;
+DESCRIBE FUNCTION EXTENDED std;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION stddev;
+DESCRIBE FUNCTION EXTENDED stddev;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev_pop.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev_pop.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev_pop.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev_pop.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION udf_stddev_pop;
+DESCRIBE FUNCTION EXTENDED udf_stddev_pop;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev_samp.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev_samp.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev_samp.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev_samp.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,4 @@
+DESCRIBE FUNCTION stddev_samp;
+DESCRIBE FUNCTION EXTENDED stddev_samp;
+DESCRIBE FUNCTION stddev_samp;
+DESCRIBE FUNCTION EXTENDED stddev_samp;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_string.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_string.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_string.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_string.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION string;
+DESCRIBE FUNCTION EXTENDED string;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_substring.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_substring.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_substring.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_substring.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,3 @@
+-- Synonym. See udf_substr.q
+DESCRIBE FUNCTION substring;
+DESCRIBE FUNCTION EXTENDED substring;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_subtract.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_subtract.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_subtract.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_subtract.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION -;
+DESCRIBE FUNCTION EXTENDED -;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_sum.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_sum.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_sum.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_sum.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,6 @@
+DESCRIBE FUNCTION sum;
+DESCRIBE FUNCTION EXTENDED sum;
+
+DESCRIBE FUNCTION sum;
+DESCRIBE FUNCTION EXTENDED sum;
+
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_tinyint.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_tinyint.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_tinyint.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_tinyint.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION tinyint;
+DESCRIBE FUNCTION EXTENDED tinyint;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_to_date.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_to_date.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_to_date.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_to_date.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION to_date;
+DESCRIBE FUNCTION EXTENDED to_date;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_trim.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_trim.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_trim.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_trim.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION trim;
+DESCRIBE FUNCTION EXTENDED trim;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ucase.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ucase.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ucase.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ucase.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION ucase;
+DESCRIBE FUNCTION EXTENDED ucase;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_upper.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_upper.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_upper.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_upper.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION upper;
+DESCRIBE FUNCTION EXTENDED upper;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_var_pop.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_var_pop.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_var_pop.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_var_pop.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION var_pop;
+DESCRIBE FUNCTION EXTENDED var_pop;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_var_samp.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_var_samp.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_var_samp.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_var_samp.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,4 @@
+DESCRIBE FUNCTION var_samp;
+DESCRIBE FUNCTION EXTENDED var_samp;
+DESCRIBE FUNCTION var_samp;
+DESCRIBE FUNCTION EXTENDED var_samp;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_variance.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_variance.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_variance.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_variance.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+DESCRIBE FUNCTION variance;
+DESCRIBE FUNCTION EXTENDED variance;
+
+DESCRIBE FUNCTION var_pop;
+DESCRIBE FUNCTION EXTENDED var_pop;
+DESCRIBE FUNCTION variance;
+DESCRIBE FUNCTION EXTENDED variance;
+
+DESCRIBE FUNCTION var_pop;
+DESCRIBE FUNCTION EXTENDED var_pop;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_when.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_when.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_when.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_when.q Thu Jan 7 21:54:33 2010
@@ -1,3 +1,6 @@
+DESCRIBE FUNCTION when;
+DESCRIBE FUNCTION EXTENDED when;
+
EXPLAIN
SELECT CASE
WHEN 1=1 THEN 2
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udtf_explode.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udtf_explode.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udtf_explode.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udtf_explode.q Thu Jan 7 21:54:33 2010
@@ -1,9 +0,0 @@
-DESCRIBE FUNCTION explode;
-DESCRIBE FUNCTION EXTENDED explode;
-
-EXPLAIN EXTENDED SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3;
-EXPLAIN EXTENDED SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol;
-
-SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3;
-SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3;
-SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol;
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=897026&r1=897025&r2=897026&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 Thu Jan 7 21:54:33 2010
@@ -1,1098 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION concat
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION concat
-POSTHOOK: type: DESCFUNCTION
-concat(str1, str2, ... strN) - returns the concatenation of str1, str2, ... strN
-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 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
-PREHOOK: query: DESCRIBE FUNCTION find_in_set
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION find_in_set
-POSTHOOK: type: DESCFUNCTION
-find_in_set(str,str_array) - Returns the first occurrence of str in str_array where str_array is a comma-delimited string. Returns null if either argument is null. Returns 0 if the first argument has any commas.
-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 repeat
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION repeat
-POSTHOOK: type: DESCFUNCTION
-repeat(str, n) - repeat str n times
-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
-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 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 size
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION size
-POSTHOOK: type: DESCFUNCTION
-size(a) - Returns the size of a
-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 floor
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION floor
-POSTHOOK: type: DESCFUNCTION
-floor(x) - Find the largest integer not greater than x
-PREHOOK: query: DESCRIBE FUNCTION sqrt
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION sqrt
-POSTHOOK: type: DESCFUNCTION
-sqrt(x) - returns the square root of x
-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
-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
-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
-PREHOOK: query: DESCRIBE FUNCTION abs
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION abs
-POSTHOOK: type: DESCFUNCTION
-abs(x) - returns the absolute value of x
-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 ln
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION ln
-POSTHOOK: type: DESCFUNCTION
-ln(x) - Returns the natural logarithm of x
-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
-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 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
-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 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
-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
-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
-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
-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
-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
-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 bin
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION bin
-POSTHOOK: type: DESCFUNCTION
-bin(n) - returns n in binary
-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 unhex
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION unhex
-POSTHOOK: type: DESCFUNCTION
-unhex(str) - Converts hexadecimal argument to string
-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
-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 ucase
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION ucase
-POSTHOOK: type: DESCFUNCTION
-ucase(str) - Returns str with all characters changed to uppercase
-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
-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
-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
-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
-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 reverse
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION reverse
-POSTHOOK: type: DESCFUNCTION
-reverse(str) - reverse str
-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 rlike
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION rlike
-POSTHOOK: type: DESCFUNCTION
-str rlike regexp - Returns true if str matches regexp and false otherwise
-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
-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
-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
-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 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 positive
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION positive
-POSTHOOK: type: DESCFUNCTION
-positive a - Returns a
-PREHOOK: query: DESCRIBE FUNCTION negative
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION negative
-POSTHOOK: type: DESCFUNCTION
-negative a - Returns -a
-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
-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
-PREHOOK: query: DESCRIBE FUNCTION month
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION month
-POSTHOOK: type: DESCFUNCTION
-month(date) - Returns the month of date
-PREHOOK: query: DESCRIBE FUNCTION year
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION year
-POSTHOOK: type: DESCFUNCTION
-year(date) - Returns the year of date
-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
-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
-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
-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.
-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.
-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
-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 +
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION +
-POSTHOOK: type: DESCFUNCTION
-a + b - Returns a+b
-PREHOOK: query: DESCRIBE FUNCTION -
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION -
-POSTHOOK: type: DESCFUNCTION
-a - b - Returns the difference a-b
-PREHOOK: query: DESCRIBE FUNCTION *
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION *
-POSTHOOK: type: DESCFUNCTION
-a * b - Multiplies a by b
-PREHOOK: query: DESCRIBE FUNCTION /
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION /
-POSTHOOK: type: DESCFUNCTION
-a / b - Divide a by b
-PREHOOK: query: DESCRIBE FUNCTION %
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION %
-POSTHOOK: type: DESCFUNCTION
-a % b - Returns the remainder when dividing a by b
-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 &
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION &
-POSTHOOK: type: DESCFUNCTION
-a & b - Bitwise and
-PREHOOK: query: DESCRIBE FUNCTION |
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION |
-POSTHOOK: type: DESCFUNCTION
-a | b - Bitwise or
-PREHOOK: query: DESCRIBE FUNCTION ^
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION ^
-POSTHOOK: type: DESCFUNCTION
-a ^ b - Bitwise exclusive or
-PREHOOK: query: DESCRIBE FUNCTION ~
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION ~
-POSTHOOK: type: DESCFUNCTION
-~ n - Bitwise not
-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
-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
-PREHOOK: query: DESCRIBE FUNCTION <
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION <
-POSTHOOK: type: DESCFUNCTION
-a < b - Returns TRUE if a is less than b
-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
-PREHOOK: query: DESCRIBE FUNCTION >
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION >
-POSTHOOK: type: DESCFUNCTION
-a > b - Returns TRUE if a is greater than b
-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
-PREHOOK: query: DESCRIBE FUNCTION and
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION and
-POSTHOOK: type: DESCFUNCTION
-a and b - Logical and
-PREHOOK: query: DESCRIBE FUNCTION or
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION or
-POSTHOOK: type: DESCFUNCTION
-a or b - Logical or
-PREHOOK: query: DESCRIBE FUNCTION not
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION not
-POSTHOOK: type: DESCFUNCTION
-not a - Logical not
-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 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 concat
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED concat
-POSTHOOK: type: DESCFUNCTION
-concat(str1, str2, ... strN) - returns the concatenation of str1, str2, ... strN
-Returns NULL if any argument is NULL.
-Example:
- > SELECT concat('abc', 'def') FROM src LIMIT 1;
- 'abcdef'
-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: 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:
- > SELECT substring('Facebook', 5) FROM src LIMIT 1;
- 'book'
- > SELECT substring('Facebook', -5) FROM src LIMIT 1;
- 'ebook'
- > SELECT substring('Facebook', 5, 1) FROM src LIMIT 1;
- 'b'
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED find_in_set
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED find_in_set
-POSTHOOK: type: DESCFUNCTION
-find_in_set(str,str_array) - Returns the first occurrence of str in str_array where str_array is a comma-delimited string. Returns null if either argument is null. Returns 0 if the first argument has any commas.
-Example:
- > SELECT find_in_set('ab','abc,b,ab,c,def') FROM src LIMIT 1;
- 3
- > SELECT * FROM src1 WHERE NOT find_in_set(key,'311,128,345,956')=0;
- 311 val_311
- 128
-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: 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: 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
-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 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: 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: 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: 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
-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
-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
-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
-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
-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
-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: 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
-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
-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: 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
-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: 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
-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
-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
-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
-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
-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
-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: 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'
-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: 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: 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'
-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: 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'
-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'
-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'
-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'
-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'
-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: 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: 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: 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
-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
-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'
-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'
-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: 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: DESCRIBE FUNCTION EXTENDED positive
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED positive
-POSTHOOK: type: DESCFUNCTION
-positive 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: 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
-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
-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
-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
-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'
-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.
-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'
-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'
-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'
-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
-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
- &#064; : Current object/element
- () : Script expression
- ?() : Filter (script) expression.
- [,] : Union operator
- [start:end:step] : array slice operator
-
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED +
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED +
-POSTHOOK: type: DESCFUNCTION
-a + b - Returns a+b
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED -
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED -
-POSTHOOK: type: DESCFUNCTION
-a - b - Returns the difference a-b
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED *
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED *
-POSTHOOK: type: DESCFUNCTION
-a * b - Multiplies a by b
-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
-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
-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: 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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED or
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED or
-POSTHOOK: type: DESCFUNCTION
-a or b - Logical or
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED not
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED not
-POSTHOOK: type: DESCFUNCTION
-not a - Logical not
-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 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/show_functions.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/show_functions.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/show_functions.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/show_functions.q.out Thu Jan 7 21:54:33 2010
@@ -3,6 +3,7 @@
POSTHOOK: query: SHOW FUNCTIONS
POSTHOOK: type: SHOWFUNCTIONS
!
+!=
%
&
*
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_avg.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_avg.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_avg.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_avg.q.out Thu Jan 7 21:54:33 2010
@@ -1,20 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION avg
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION avg
-POSTHOOK: type: DESCFUNCTION
-avg(x) - Returns the mean of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED avg
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED avg
-POSTHOOK: type: DESCFUNCTION
-avg(x) - Returns the mean of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION avg
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION avg
-POSTHOOK: type: DESCFUNCTION
-avg(x) - Returns the mean of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED avg
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED avg
-POSTHOOK: type: DESCFUNCTION
-avg(x) - Returns the mean of a set of numbers
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_count.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_count.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_count.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_count.q.out Thu Jan 7 21:54:33 2010
@@ -1,20 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION count
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION count
-POSTHOOK: type: DESCFUNCTION
-count(x) - Returns the count
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED count
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED count
-POSTHOOK: type: DESCFUNCTION
-count(x) - Returns the count
-PREHOOK: query: DESCRIBE FUNCTION count
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION count
-POSTHOOK: type: DESCFUNCTION
-count(x) - Returns the count
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED count
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED count
-POSTHOOK: type: DESCFUNCTION
-count(x) - Returns the count
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_max.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_max.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_max.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_max.q.out Thu Jan 7 21:54:33 2010
@@ -1,20 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION max
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION max
-POSTHOOK: type: DESCFUNCTION
-max(expr) - Returns the maximum value of expr
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED max
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED max
-POSTHOOK: type: DESCFUNCTION
-max(expr) - Returns the maximum value of expr
-PREHOOK: query: DESCRIBE FUNCTION max
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION max
-POSTHOOK: type: DESCFUNCTION
-max(expr) - Returns the maximum value of expr
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED max
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED max
-POSTHOOK: type: DESCFUNCTION
-max(expr) - Returns the maximum value of expr
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_min.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_min.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_min.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_min.q.out Thu Jan 7 21:54:33 2010
@@ -1,20 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION min
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION min
-POSTHOOK: type: DESCFUNCTION
-min(expr) - Returns the minimum value of expr
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED min
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED min
-POSTHOOK: type: DESCFUNCTION
-min(expr) - Returns the minimum value of expr
-PREHOOK: query: DESCRIBE FUNCTION min
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION min
-POSTHOOK: type: DESCFUNCTION
-min(expr) - Returns the minimum value of expr
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED min
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED min
-POSTHOOK: type: DESCFUNCTION
-min(expr) - Returns the minimum value of expr
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_std.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_std.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_std.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_std.q.out Thu Jan 7 21:54:33 2010
@@ -1,60 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION std
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION std
-POSTHOOK: type: DESCFUNCTION
-std(x) - Returns the standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED std
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED std
-POSTHOOK: type: DESCFUNCTION
-std(x) - Returns the standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION stddev
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION stddev
-POSTHOOK: type: DESCFUNCTION
-stddev(x) - Returns the standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED stddev
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED stddev
-POSTHOOK: type: DESCFUNCTION
-stddev(x) - Returns the standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION stddev_pop
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION stddev_pop
-POSTHOOK: type: DESCFUNCTION
-stddev_pop(x) - Returns the standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED stddev_pop
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED stddev_pop
-POSTHOOK: type: DESCFUNCTION
-stddev_pop(x) - Returns the standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION std
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION std
-POSTHOOK: type: DESCFUNCTION
-std(x) - Returns the standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED std
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED std
-POSTHOOK: type: DESCFUNCTION
-std(x) - Returns the standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION stddev
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION stddev
-POSTHOOK: type: DESCFUNCTION
-stddev(x) - Returns the standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED stddev
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED stddev
-POSTHOOK: type: DESCFUNCTION
-stddev(x) - Returns the standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION stddev_pop
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION stddev_pop
-POSTHOOK: type: DESCFUNCTION
-stddev_pop(x) - Returns the standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED stddev_pop
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED stddev_pop
-POSTHOOK: type: DESCFUNCTION
-stddev_pop(x) - Returns the standard deviation of a set of numbers
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_stddev_samp.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_stddev_samp.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_stddev_samp.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_stddev_samp.q.out Thu Jan 7 21:54:33 2010
@@ -1,20 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION stddev_samp
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION stddev_samp
-POSTHOOK: type: DESCFUNCTION
-stddev_samp(x) - Returns the sample standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED stddev_samp
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED stddev_samp
-POSTHOOK: type: DESCFUNCTION
-stddev_samp(x) - Returns the sample standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION stddev_samp
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION stddev_samp
-POSTHOOK: type: DESCFUNCTION
-stddev_samp(x) - Returns the sample standard deviation of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED stddev_samp
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED stddev_samp
-POSTHOOK: type: DESCFUNCTION
-stddev_samp(x) - Returns the sample standard deviation of a set of numbers
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_sum.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_sum.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_sum.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_sum.q.out Thu Jan 7 21:54:33 2010
@@ -1,20 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION sum
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION sum
-POSTHOOK: type: DESCFUNCTION
-sum(x) - Returns the sum of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED sum
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED sum
-POSTHOOK: type: DESCFUNCTION
-sum(x) - Returns the sum of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION sum
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION sum
-POSTHOOK: type: DESCFUNCTION
-sum(x) - Returns the sum of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED sum
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED sum
-POSTHOOK: type: DESCFUNCTION
-sum(x) - Returns the sum of a set of numbers
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_var_samp.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_var_samp.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_var_samp.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_var_samp.q.out Thu Jan 7 21:54:33 2010
@@ -1,20 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION var_samp
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION var_samp
-POSTHOOK: type: DESCFUNCTION
-var_samp(x) - Returns the sample variance of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED var_samp
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED var_samp
-POSTHOOK: type: DESCFUNCTION
-var_samp(x) - Returns the sample variance of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION var_samp
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION var_samp
-POSTHOOK: type: DESCFUNCTION
-var_samp(x) - Returns the sample variance of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED var_samp
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED var_samp
-POSTHOOK: type: DESCFUNCTION
-var_samp(x) - Returns the sample variance of a set of numbers
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_variance.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_variance.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_variance.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_variance.q.out Thu Jan 7 21:54:33 2010
@@ -1,40 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION variance
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION variance
-POSTHOOK: type: DESCFUNCTION
-variance(x) - Returns the variance of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED variance
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED variance
-POSTHOOK: type: DESCFUNCTION
-variance(x) - Returns the variance of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION var_pop
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION var_pop
-POSTHOOK: type: DESCFUNCTION
-var_pop(x) - Returns the variance of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED var_pop
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED var_pop
-POSTHOOK: type: DESCFUNCTION
-var_pop(x) - Returns the variance of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION variance
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION variance
-POSTHOOK: type: DESCFUNCTION
-variance(x) - Returns the variance of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED variance
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED variance
-POSTHOOK: type: DESCFUNCTION
-variance(x) - Returns the variance of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION var_pop
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION var_pop
-POSTHOOK: type: DESCFUNCTION
-var_pop(x) - Returns the variance of a set of numbers
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED var_pop
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED var_pop
-POSTHOOK: type: DESCFUNCTION
-var_pop(x) - Returns the variance of a set of numbers
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_add.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_add.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_add.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_add.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION +
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION +
+POSTHOOK: type: DESCFUNCTION
+a + b - Returns a+b
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED +
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED +
+POSTHOOK: type: DESCFUNCTION
+a + b - Returns a+b
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_array.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_array.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_array.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_array.q.out Thu Jan 7 21:54:33 2010
@@ -1,13 +1,11 @@
-PREHOOK: query: -- Parsing bug requires us to quote array
-DESCRIBE FUNCTION 'array'
+PREHOOK: query: DESCRIBE FUNCTION array
PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: -- Parsing bug requires us to quote array
-DESCRIBE FUNCTION 'array'
+POSTHOOK: query: DESCRIBE FUNCTION array
POSTHOOK: type: DESCFUNCTION
array(n0, n1...) - Creates an array with the given elements
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED 'array'
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED array
PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED 'array'
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED array
POSTHOOK: type: DESCFUNCTION
array(n0, n1...) - Creates an array with the given elements
PREHOOK: query: EXPLAIN SELECT array(), array()[1], array(1, 2, 3), array(1, 2, 3)[2], array(1,"a", 2, 3), array(1,"a", 2, 3)[2],
@@ -64,10 +62,10 @@
array(array(1), array(2), array(3), array(4))[1][0] FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1972672782/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1915910537/10000
POSTHOOK: query: SELECT array(), array()[1], array(1, 2, 3), array(1, 2, 3)[2], array(1,"a", 2, 3), array(1,"a", 2, 3)[2],
array(array(1), array(2), array(3), array(4))[1][0] FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1972672782/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1915910537/10000
[] NULL [1,2,3] 3 ["1","a","2","3"] 2 2
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_avg.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_avg.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_avg.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_avg.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION avg
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION avg
+POSTHOOK: type: DESCFUNCTION
+avg(x) - Returns the mean of a set of numbers
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED avg
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED avg
+POSTHOOK: type: DESCFUNCTION
+avg(x) - Returns the mean of a set of numbers
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bigint.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bigint.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bigint.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bigint.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION bigint
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION bigint
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'bigint'
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED bigint
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED bigint
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'bigint'
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_and.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_and.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_and.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_and.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION &
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION &
+POSTHOOK: type: DESCFUNCTION
+a & b - Bitwise and
+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
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_not.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_not.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_not.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_not.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION ~
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ~
+POSTHOOK: type: DESCFUNCTION
+~ n - Bitwise not
+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
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_or.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_or.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_or.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_or.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION |
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION |
+POSTHOOK: type: DESCFUNCTION
+a | b - Bitwise or
+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
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_xor.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_xor.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_xor.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_xor.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION ^
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ^
+POSTHOOK: type: DESCFUNCTION
+a ^ b - Bitwise exclusive or
+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
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_boolean.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_boolean.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_boolean.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_boolean.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION boolean
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION boolean
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'boolean'
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED boolean
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED boolean
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'boolean'
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out Thu Jan 7 21:54:33 2010
@@ -1,15 +1,13 @@
-PREHOOK: query: -- Parsing bug requires us to quote case
-DESCRIBE FUNCTION 'case'
+PREHOOK: query: DESCRIBE FUNCTION case
PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: -- Parsing bug requires us to quote case
-DESCRIBE FUNCTION 'case'
+POSTHOOK: query: DESCRIBE FUNCTION case
POSTHOOK: type: DESCFUNCTION
-There is no documentation for function case
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED 'case'
+There is no documentation for function 'case'
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED case
PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED 'case'
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED case
POSTHOOK: type: DESCFUNCTION
-There is no documentation for function case
+There is no documentation for function 'case'
PREHOOK: query: EXPLAIN
SELECT CASE 1
WHEN 1 THEN 2
@@ -136,7 +134,7 @@
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/908511377/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/24130903/10000
POSTHOOK: query: SELECT CASE 1
WHEN 1 THEN 2
WHEN 3 THEN 4
@@ -165,5 +163,5 @@
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/908511377/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/24130903/10000
2 5 15 NULL 20 24
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ceil.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ceil.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ceil.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ceil.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,16 @@
+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
+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
+Synonyms: ceiling
+Example:
+ > SELECT ceil(-0.1) FROM src LIMIT 1;
+ 0
+ > SELECT ceil(5) FROM src LIMIT 1;
+ 5
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ceiling.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ceiling.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ceiling.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ceiling.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,16 @@
+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
+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
+Synonyms: ceil
+Example:
+ > SELECT ceiling(-0.1) FROM src LIMIT 1;
+ 0
+ > SELECT ceiling(5) FROM src LIMIT 1;
+ 5
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_count.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_count.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_count.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_count.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION count
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION count
+POSTHOOK: type: DESCFUNCTION
+count(x) - Returns the count
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED count
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED count
+POSTHOOK: type: DESCFUNCTION
+count(x) - Returns the count
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_date_add.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_date_add.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_date_add.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_date_add.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,14 @@
+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.
+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'
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_date_sub.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_date_sub.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_date_sub.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_date_sub.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,14 @@
+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.
+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'
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_datediff.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_datediff.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_datediff.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_datediff.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,14 @@
+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
+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
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_day.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_day.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_day.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_day.q.out Thu Jan 7 21:54:33 2010
@@ -0,0 +1,15 @@
+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
+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
+Synonyms: dayofmonth
+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