You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ai...@apache.org on 2016/12/15 14:40:48 UTC
[2/3] hive git commit: HIVE-15383: Add additional info to 'desc
function extended' output (Aihua Xu, reviewed by Yongzhi Chen)
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_if.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_if.q.out b/ql/src/test/results/clientpositive/udf_if.q.out
index 1114b69..5364509 100644
--- a/ql/src/test/results/clientpositive/udf_if.q.out
+++ b/ql/src/test/results/clientpositive/udf_if.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED if
POSTHOOK: type: DESCFUNCTION
IF(expr1,expr2,expr3) - If expr1 is TRUE (expr1 <> 0 and expr1 <> NULL) then IF() returns expr2; otherwise it returns expr3. IF() returns a numeric or string value, depending on the context in which it is used.
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFIf
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT IF(TRUE, 1, 2) AS COL1,
IF(FALSE, CAST(NULL AS STRING), CAST(1 AS STRING)) AS COL2,
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_initcap.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_initcap.q.out b/ql/src/test/results/clientpositive/udf_initcap.q.out
index 179e544..1abd004 100644
--- a/ql/src/test/results/clientpositive/udf_initcap.q.out
+++ b/ql/src/test/results/clientpositive/udf_initcap.q.out
@@ -11,3 +11,5 @@ initcap(str) - Returns str, with the first letter of each word in uppercase, all
Example:
> SELECT initcap('tHe soap') FROM src LIMIT 1;
'The Soap'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFInitCap
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_instr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_instr.q.out b/ql/src/test/results/clientpositive/udf_instr.q.out
index 50e65a1..e5d6a34 100644
--- a/ql/src/test/results/clientpositive/udf_instr.q.out
+++ b/ql/src/test/results/clientpositive/udf_instr.q.out
@@ -11,6 +11,8 @@ instr(str, substr) - Returns the index of the first occurance of substr in str
Example:
> SELECT instr('Facebook', 'boo') FROM src LIMIT 1;
5
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFInstr
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT instr('abcd', 'abc'),
instr('abcabc', 'ccc'),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_int.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_int.q.out b/ql/src/test/results/clientpositive/udf_int.q.out
index 2a268c1..c954e58 100644
--- a/ql/src/test/results/clientpositive/udf_int.q.out
+++ b/ql/src/test/results/clientpositive/udf_int.q.out
@@ -8,3 +8,5 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED int
POSTHOOK: type: DESCFUNCTION
There is no documentation for function 'int'
+Function class:org.apache.hadoop.hive.ql.udf.UDFToInteger
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_isnotnull.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_isnotnull.q.out b/ql/src/test/results/clientpositive/udf_isnotnull.q.out
index a8162aa..156f94b 100644
--- a/ql/src/test/results/clientpositive/udf_isnotnull.q.out
+++ b/ql/src/test/results/clientpositive/udf_isnotnull.q.out
@@ -8,3 +8,5 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED isnotnull
POSTHOOK: type: DESCFUNCTION
isnotnull a - Returns true if a is not NULL and false otherwise
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPNotNull
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_isnull.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_isnull.q.out b/ql/src/test/results/clientpositive/udf_isnull.q.out
index f450b35..082c181 100644
--- a/ql/src/test/results/clientpositive/udf_isnull.q.out
+++ b/ql/src/test/results/clientpositive/udf_isnull.q.out
@@ -8,3 +8,5 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED isnull
POSTHOOK: type: DESCFUNCTION
isnull a - Returns true if a is NULL and false otherwise
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPNull
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out b/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out
index 9253d6c..fff6937 100644
--- a/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out
+++ b/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED isnull
POSTHOOK: type: DESCFUNCTION
isnull a - Returns true if a is NULL and false otherwise
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPNull
+Function type:BUILTIN
PREHOOK: query: DESCRIBE FUNCTION isnotnull
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION isnotnull
@@ -18,6 +20,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED isnotnull
POSTHOOK: type: DESCFUNCTION
isnotnull a - Returns true if a is not NULL and false otherwise
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPNotNull
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT NULL IS NULL,
1 IS NOT NULL,
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_java_method.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_java_method.q.out b/ql/src/test/results/clientpositive/udf_java_method.q.out
index 1f232fc..0f42524 100644
--- a/ql/src/test/results/clientpositive/udf_java_method.q.out
+++ b/ql/src/test/results/clientpositive/udf_java_method.q.out
@@ -11,6 +11,8 @@ java_method(class,method[,arg1[,arg2..]]) calls method with reflection
Synonyms: reflect
Use this UDF to call Java methods by matching the argument signature
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFReflect
+Function type:BUILTIN
PREHOOK: query: -- java_method() is a synonym for reflect()
EXPLAIN EXTENDED
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_last_day.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_last_day.q.out b/ql/src/test/results/clientpositive/udf_last_day.q.out
index d1070cb..1cbc390 100644
--- a/ql/src/test/results/clientpositive/udf_last_day.q.out
+++ b/ql/src/test/results/clientpositive/udf_last_day.q.out
@@ -12,6 +12,8 @@ date is a string in the format 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'. The time p
Example:
> SELECT last_day('2009-01-12') FROM src LIMIT 1;
'2009-01-31'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFLastDay
+Function type:BUILTIN
PREHOOK: query: explain select last_day('2015-02-05')
PREHOOK: type: QUERY
POSTHOOK: query: explain select last_day('2015-02-05')
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_lcase.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_lcase.q.out b/ql/src/test/results/clientpositive/udf_lcase.q.out
index 57882f8..5aa7af4 100644
--- a/ql/src/test/results/clientpositive/udf_lcase.q.out
+++ b/ql/src/test/results/clientpositive/udf_lcase.q.out
@@ -12,3 +12,5 @@ Synonyms: lower
Example:
> SELECT lcase('Facebook') FROM src LIMIT 1;
'facebook'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFLower
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_least.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_least.q.out b/ql/src/test/results/clientpositive/udf_least.q.out
index d6e1a23..606a372 100644
--- a/ql/src/test/results/clientpositive/udf_least.q.out
+++ b/ql/src/test/results/clientpositive/udf_least.q.out
@@ -11,6 +11,8 @@ least(v1, v2, ...) - Returns the least value in a list of values
Example:
> SELECT least(2, 3, 1) FROM src LIMIT 1;
1
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFLeast
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT LEAST('a', 'b', 'c'),
LEAST('C', 'a', 'B'),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_length.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_length.q.out b/ql/src/test/results/clientpositive/udf_length.q.out
index 0dc39ea..461e129 100644
--- a/ql/src/test/results/clientpositive/udf_length.q.out
+++ b/ql/src/test/results/clientpositive/udf_length.q.out
@@ -11,6 +11,8 @@ length(str | binary) - Returns the length of str or number of bytes in binary da
Example:
> SELECT length('Facebook') FROM src LIMIT 1;
8
+Function class:org.apache.hadoop.hive.ql.udf.UDFLength
+Function type:BUILTIN
PREHOOK: query: CREATE TABLE dest1(len INT)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_lessthan.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_lessthan.q.out b/ql/src/test/results/clientpositive/udf_lessthan.q.out
index 630d502..635b2d9 100644
--- a/ql/src/test/results/clientpositive/udf_lessthan.q.out
+++ b/ql/src/test/results/clientpositive/udf_lessthan.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED <
POSTHOOK: type: DESCFUNCTION
a < b - Returns TRUE if a is less than b
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPLessThan
+Function type:BUILTIN
PREHOOK: query: SELECT true<false, false<true, false<false, true<true FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out b/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out
index 18dd790..b0db7be 100644
--- a/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out
+++ b/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED <=
POSTHOOK: type: DESCFUNCTION
a <= b - Returns TRUE if a is not greater than b
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPEqualOrLessThan
+Function type:BUILTIN
PREHOOK: query: SELECT true<=false, false<=true, false<=false, true<=true FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_levenshtein.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_levenshtein.q.out b/ql/src/test/results/clientpositive/udf_levenshtein.q.out
index 21b713a..fd1fd28 100644
--- a/ql/src/test/results/clientpositive/udf_levenshtein.q.out
+++ b/ql/src/test/results/clientpositive/udf_levenshtein.q.out
@@ -11,6 +11,8 @@ levenshtein(str1, str2) - This function calculates the Levenshtein distance betw
Levenshtein distance is a string metric for measuring the difference between two sequences. Informally, the Levenshtein distance between two words is the minimum number of single-character edits (i.e. insertions, deletions or substitutions) required to change one word into the other. It is named after Vladimir Levenshtein, who considered this distance in 1965.Example:
> SELECT levenshtein('kitten', 'sitting');
3
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFLevenshtein
+Function type:BUILTIN
PREHOOK: query: explain select levenshtein('Test String1', 'Test String2')
PREHOOK: type: QUERY
POSTHOOK: query: explain select levenshtein('Test String1', 'Test String2')
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_like.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_like.q.out b/ql/src/test/results/clientpositive/udf_like.q.out
index 8ffcf9b..64c17bd 100644
--- a/ql/src/test/results/clientpositive/udf_like.q.out
+++ b/ql/src/test/results/clientpositive/udf_like.q.out
@@ -11,6 +11,8 @@ 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
+Function class:org.apache.hadoop.hive.ql.udf.UDFLike
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT '_%_' LIKE '%\_\%\_%', '__' LIKE '%\_\%\_%', '%%_%_' LIKE '%\_\%\_%', '%_%_%' LIKE '%\%\_\%',
'_%_' LIKE '\%\_%', '%__' LIKE '__\%%', '_%' LIKE '\_\%\_\%%', '_%' LIKE '\_\%_%',
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_ln.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_ln.q.out b/ql/src/test/results/clientpositive/udf_ln.q.out
index ea1a16a..42fd621 100644
--- a/ql/src/test/results/clientpositive/udf_ln.q.out
+++ b/ql/src/test/results/clientpositive/udf_ln.q.out
@@ -11,3 +11,5 @@ ln(x) - Returns the natural logarithm of x
Example:
> SELECT ln(1) FROM src LIMIT 1;
0
+Function class:org.apache.hadoop.hive.ql.udf.UDFLn
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_locate.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_locate.q.out b/ql/src/test/results/clientpositive/udf_locate.q.out
index 00136dc..8688074 100644
--- a/ql/src/test/results/clientpositive/udf_locate.q.out
+++ b/ql/src/test/results/clientpositive/udf_locate.q.out
@@ -11,6 +11,8 @@ locate(substr, str[, pos]) - Returns the position of the first occurance of subs
Example:
> SELECT locate('bar', 'foobarbar', 5) FROM src LIMIT 1;
7
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFLocate
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT locate('abc', 'abcd'),
locate('ccc', 'abcabc'),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_log.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_log.q.out b/ql/src/test/results/clientpositive/udf_log.q.out
index 1576401..7b2f3e5 100644
--- a/ql/src/test/results/clientpositive/udf_log.q.out
+++ b/ql/src/test/results/clientpositive/udf_log.q.out
@@ -11,3 +11,5 @@ log([b], x) - Returns the logarithm of x with base b
Example:
> SELECT log(13, 13) FROM src LIMIT 1;
1
+Function class:org.apache.hadoop.hive.ql.udf.UDFLog
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_log10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_log10.q.out b/ql/src/test/results/clientpositive/udf_log10.q.out
index b53f0ae..46d4504 100644
--- a/ql/src/test/results/clientpositive/udf_log10.q.out
+++ b/ql/src/test/results/clientpositive/udf_log10.q.out
@@ -11,3 +11,5 @@ log10(x) - Returns the logarithm of x with base 10
Example:
> SELECT log10(10) FROM src LIMIT 1;
1
+Function class:org.apache.hadoop.hive.ql.udf.UDFLog10
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_log2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_log2.q.out b/ql/src/test/results/clientpositive/udf_log2.q.out
index e810bee..4e9ca0f 100644
--- a/ql/src/test/results/clientpositive/udf_log2.q.out
+++ b/ql/src/test/results/clientpositive/udf_log2.q.out
@@ -11,3 +11,5 @@ log2(x) - Returns the logarithm of x with base 2
Example:
> SELECT log2(2) FROM src LIMIT 1;
1
+Function class:org.apache.hadoop.hive.ql.udf.UDFLog2
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_logged_in_user.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_logged_in_user.q.out b/ql/src/test/results/clientpositive/udf_logged_in_user.q.out
index ffb19ca..da8b894 100644
--- a/ql/src/test/results/clientpositive/udf_logged_in_user.q.out
+++ b/ql/src/test/results/clientpositive/udf_logged_in_user.q.out
@@ -9,6 +9,8 @@ POSTHOOK: query: DESCRIBE FUNCTION EXTENDED logged_in_user
POSTHOOK: type: DESCFUNCTION
logged_in_user() - Returns logged in user name
SessionState GetUserName - the username provided at session initialization
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFLoggedInUser
+Function type:BUILTIN
PREHOOK: query: select logged_in_user()
FROM src tablesample (1 rows)
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_lower.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_lower.q.out b/ql/src/test/results/clientpositive/udf_lower.q.out
index 6832dab..e816594 100644
--- a/ql/src/test/results/clientpositive/udf_lower.q.out
+++ b/ql/src/test/results/clientpositive/udf_lower.q.out
@@ -12,6 +12,8 @@ Synonyms: lcase
Example:
> SELECT lower('Facebook') FROM src LIMIT 1;
'facebook'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFLower
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT lower('AbC 123'), upper('AbC 123') FROM src WHERE key = 86
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_lpad.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_lpad.q.out b/ql/src/test/results/clientpositive/udf_lpad.q.out
index 1f7c06a..7d7cc92 100644
--- a/ql/src/test/results/clientpositive/udf_lpad.q.out
+++ b/ql/src/test/results/clientpositive/udf_lpad.q.out
@@ -13,6 +13,8 @@ Example:
> SELECT lpad('hi', 5, '??') FROM src LIMIT 1;
'???hi' > SELECT lpad('hi', 1, '??') FROM src LIMIT 1;
'h'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFLpad
+Function type:BUILTIN
PREHOOK: query: EXPLAIN SELECT
lpad('hi', 1, '?'),
lpad('hi', 5, '.'),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_ltrim.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_ltrim.q.out b/ql/src/test/results/clientpositive/udf_ltrim.q.out
index 207ad96..4295bd4 100644
--- a/ql/src/test/results/clientpositive/udf_ltrim.q.out
+++ b/ql/src/test/results/clientpositive/udf_ltrim.q.out
@@ -11,3 +11,5 @@ ltrim(str) - Removes the leading space characters from str
Example:
> SELECT ltrim(' facebook') FROM src LIMIT 1;
'facebook'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFLTrim
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_map.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_map.q.out b/ql/src/test/results/clientpositive/udf_map.q.out
index 8ea4f11..ba6195a 100644
--- a/ql/src/test/results/clientpositive/udf_map.q.out
+++ b/ql/src/test/results/clientpositive/udf_map.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED map
POSTHOOK: type: DESCFUNCTION
map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFMap
+Function type:BUILTIN
PREHOOK: query: EXPLAIN SELECT map(), map(1, "a", 2, "b", 3, "c"), map(1, 2, "a", "b"),
map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src tablesample (1 rows)
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_map_keys.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_map_keys.q.out b/ql/src/test/results/clientpositive/udf_map_keys.q.out
index 49beca3..d8f90fd 100644
--- a/ql/src/test/results/clientpositive/udf_map_keys.q.out
+++ b/ql/src/test/results/clientpositive/udf_map_keys.q.out
@@ -18,6 +18,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED map_keys
POSTHOOK: type: DESCFUNCTION
map_keys(map) - Returns an unordered array containing the keys of the input map.
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFMapKeys
+Function type:BUILTIN
PREHOOK: query: -- Evaluate function against INT valued keys
SELECT map_keys(map(1, "a", 2, "b", 3, "c")) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_map_values.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_map_values.q.out b/ql/src/test/results/clientpositive/udf_map_values.q.out
index 8e502b5..905b237 100644
--- a/ql/src/test/results/clientpositive/udf_map_values.q.out
+++ b/ql/src/test/results/clientpositive/udf_map_values.q.out
@@ -18,6 +18,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED map_values
POSTHOOK: type: DESCFUNCTION
map_values(map) - Returns an unordered array containing the values of the input map.
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFMapValues
+Function type:BUILTIN
PREHOOK: query: -- Evaluate function against STRING valued values
SELECT map_values(map(1, "a", 2, "b", 3, "c")) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_mask.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_mask.q.out b/ql/src/test/results/clientpositive/udf_mask.q.out
index ac0e273..118bb75 100644
--- a/ql/src/test/results/clientpositive/udf_mask.q.out
+++ b/ql/src/test/results/clientpositive/udf_mask.q.out
@@ -24,6 +24,8 @@ Examples:
monthValue - value to replace month field in a date with. Specify -1 to retain original value. Valid values: 0-11. Default value: 0
yearValue - value to replace year field in a date with. Specify -1 to retain original value. Default value: 0
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFMask
+Function type:BUILTIN
PREHOOK: query: explain select mask('TestString-123', 'X', 'x', '0', '1')
PREHOOK: type: QUERY
POSTHOOK: query: explain select mask('TestString-123', 'X', 'x', '0', '1')
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_mask_first_n.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_mask_first_n.q.out b/ql/src/test/results/clientpositive/udf_mask_first_n.q.out
index 988cf70..d46e3e1 100644
--- a/ql/src/test/results/clientpositive/udf_mask_first_n.q.out
+++ b/ql/src/test/results/clientpositive/udf_mask_first_n.q.out
@@ -21,6 +21,8 @@ Examples:
otherChar - character to replace all other characters with. Specify -1 to retain original character. Default value: -1
numberChar - character to replace digits in a number with. Valid values: 0-9. Default value: '1'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFMaskFirstN
+Function type:BUILTIN
PREHOOK: query: explain select mask_first_n('TestString-123', 4, 'X', 'x', '0', '1')
PREHOOK: type: QUERY
POSTHOOK: query: explain select mask_first_n('TestString-123', 4, 'X', 'x', '0', '1')
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_mask_hash.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_mask_hash.q.out b/ql/src/test/results/clientpositive/udf_mask_hash.q.out
index 9fc34bb..200f817 100644
--- a/ql/src/test/results/clientpositive/udf_mask_hash.q.out
+++ b/ql/src/test/results/clientpositive/udf_mask_hash.q.out
@@ -12,6 +12,8 @@ Examples:
mask_hash(value)
Arguments:
value - value to mask. Supported types: STRING, VARCHAR, CHAR
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFMaskHash
+Function type:BUILTIN
PREHOOK: query: explain select mask_hash('TestString-123')
PREHOOK: type: QUERY
POSTHOOK: query: explain select mask_hash('TestString-123')
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_mask_last_n.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_mask_last_n.q.out b/ql/src/test/results/clientpositive/udf_mask_last_n.q.out
index ae75d51..a71562d 100644
--- a/ql/src/test/results/clientpositive/udf_mask_last_n.q.out
+++ b/ql/src/test/results/clientpositive/udf_mask_last_n.q.out
@@ -21,6 +21,8 @@ Examples:
otherChar - character to replace all other characters with. Specify -1 to retain original character. Default value: -1
numberChar - character to replace digits in a number with. Valid values: 0-9. Default value: '1'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFMaskLastN
+Function type:BUILTIN
PREHOOK: query: explain select mask_last_n('TestString-123', 4, 'X', 'x', '0', '1')
PREHOOK: type: QUERY
POSTHOOK: query: explain select mask_last_n('TestString-123', 4, 'X', 'x', '0', '1')
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_mask_show_first_n.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_mask_show_first_n.q.out b/ql/src/test/results/clientpositive/udf_mask_show_first_n.q.out
index d8ada97..8e491b2 100644
--- a/ql/src/test/results/clientpositive/udf_mask_show_first_n.q.out
+++ b/ql/src/test/results/clientpositive/udf_mask_show_first_n.q.out
@@ -21,6 +21,8 @@ Examples:
otherChar - character to replace all other characters with. Specify -1 to retain original character. Default value: -1
numberChar - character to replace digits in a number with. Valid values: 0-9. Default value: '1'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFMaskShowFirstN
+Function type:BUILTIN
PREHOOK: query: explain select mask_show_first_n('TestString-123', 4, 'X', 'x', '0', '1')
PREHOOK: type: QUERY
POSTHOOK: query: explain select mask_show_first_n('TestString-123', 4, 'X', 'x', '0', '1')
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_mask_show_last_n.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_mask_show_last_n.q.out b/ql/src/test/results/clientpositive/udf_mask_show_last_n.q.out
index 3bf2e62..b4f30a0 100644
--- a/ql/src/test/results/clientpositive/udf_mask_show_last_n.q.out
+++ b/ql/src/test/results/clientpositive/udf_mask_show_last_n.q.out
@@ -21,6 +21,8 @@ Examples:
otherChar - character to replace all other characters with. Specify -1 to retain original character. Default value: -1
numberChar - character to replace digits in a number with. Valid values: 0-9. Default value: '1'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFMaskShowLastN
+Function type:BUILTIN
PREHOOK: query: explain select mask_show_last_n('TestString-123', 4, 'X', 'x', '0', '1')
PREHOOK: type: QUERY
POSTHOOK: query: explain select mask_show_last_n('TestString-123', 4, 'X', 'x', '0', '1')
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_max.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_max.q.out b/ql/src/test/results/clientpositive/udf_max.q.out
index 8535752..9671bf1 100644
--- a/ql/src/test/results/clientpositive/udf_max.q.out
+++ b/ql/src/test/results/clientpositive/udf_max.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED max
POSTHOOK: type: DESCFUNCTION
max(expr) - Returns the maximum value of expr
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDAFMax
+Function type:BUILTIN
PREHOOK: query: SELECT max(struct(CAST(key as INT), value)),
max(struct(key, value))
FROM src
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_md5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_md5.q.out b/ql/src/test/results/clientpositive/udf_md5.q.out
index 7f8961b..0b3e38e 100644
--- a/ql/src/test/results/clientpositive/udf_md5.q.out
+++ b/ql/src/test/results/clientpositive/udf_md5.q.out
@@ -14,6 +14,8 @@ Example:
'902fbdd2b1df0c4f70b4a5d23525e932'
> SELECT md5(binary('ABC'));
'902fbdd2b1df0c4f70b4a5d23525e932'
+Function class:org.apache.hadoop.hive.ql.udf.UDFMd5
+Function type:BUILTIN
PREHOOK: query: explain select md5('ABC')
PREHOOK: type: QUERY
POSTHOOK: query: explain select md5('ABC')
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_min.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_min.q.out b/ql/src/test/results/clientpositive/udf_min.q.out
index ca8158e..8d3d0a0 100644
--- a/ql/src/test/results/clientpositive/udf_min.q.out
+++ b/ql/src/test/results/clientpositive/udf_min.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED min
POSTHOOK: type: DESCFUNCTION
min(expr) - Returns the minimum value of expr
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDAFMin
+Function type:BUILTIN
PREHOOK: query: SELECT min(struct(CAST(key as INT), value)),
min(struct(key, value))
FROM src
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_minute.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_minute.q.out b/ql/src/test/results/clientpositive/udf_minute.q.out
index 04998a6..f7141d2 100644
--- a/ql/src/test/results/clientpositive/udf_minute.q.out
+++ b/ql/src/test/results/clientpositive/udf_minute.q.out
@@ -16,6 +16,8 @@ param can be one of:
58
> SELECT minute('12:58:59') FROM src LIMIT 1;
58
+Function class:org.apache.hadoop.hive.ql.udf.UDFMinute
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07')
FROM src WHERE key = 86
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_modulo.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_modulo.q.out b/ql/src/test/results/clientpositive/udf_modulo.q.out
index 57a06b0..084dc45 100644
--- a/ql/src/test/results/clientpositive/udf_modulo.q.out
+++ b/ql/src/test/results/clientpositive/udf_modulo.q.out
@@ -8,3 +8,5 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED %
POSTHOOK: type: DESCFUNCTION
a % b - Returns the remainder when dividing a by b
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPMod
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_month.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_month.q.out b/ql/src/test/results/clientpositive/udf_month.q.out
index 7b81bb8..c07c98f 100644
--- a/ql/src/test/results/clientpositive/udf_month.q.out
+++ b/ql/src/test/results/clientpositive/udf_month.q.out
@@ -16,3 +16,5 @@ param can be one of:
58
> SELECT minute('12:58:59') FROM src LIMIT 1;
58
+Function class:org.apache.hadoop.hive.ql.udf.UDFMinute
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_months_between.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_months_between.q.out b/ql/src/test/results/clientpositive/udf_months_between.q.out
index c8beeed..913cd35 100644
--- a/ql/src/test/results/clientpositive/udf_months_between.q.out
+++ b/ql/src/test/results/clientpositive/udf_months_between.q.out
@@ -13,6 +13,8 @@ date1 and date2 type can be date, timestamp or string in the format 'yyyy-MM-dd'
Example:
> SELECT months_between('1997-02-28 10:30:00', '1996-10-30');
3.94959677
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFMonthsBetween
+Function type:BUILTIN
PREHOOK: query: --test string format
explain select months_between('1995-02-02', '1995-01-01')
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_named_struct.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_named_struct.q.out b/ql/src/test/results/clientpositive/udf_named_struct.q.out
index 278336e..a15126a 100644
--- a/ql/src/test/results/clientpositive/udf_named_struct.q.out
+++ b/ql/src/test/results/clientpositive/udf_named_struct.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED named_struct
POSTHOOK: type: DESCFUNCTION
named_struct(name1, val1, name2, val2, ...) - Creates a struct with the given field names and values
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFNamedStruct
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT named_struct("foo", 1, "bar", 2),
named_struct("foo", 1, "bar", 2).foo FROM src tablesample (1 rows)
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_negative.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_negative.q.out b/ql/src/test/results/clientpositive/udf_negative.q.out
index 7863688..e26dbf8 100644
--- a/ql/src/test/results/clientpositive/udf_negative.q.out
+++ b/ql/src/test/results/clientpositive/udf_negative.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED negative
POSTHOOK: type: DESCFUNCTION
negative a - Returns -a
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPNegative
+Function type:BUILTIN
PREHOOK: query: -- synonym
DESCRIBE FUNCTION -
PREHOOK: type: DESCFUNCTION
@@ -20,6 +22,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED -
POSTHOOK: type: DESCFUNCTION
a - b - Returns the difference a-b
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPMinus
+Function type:BUILTIN
PREHOOK: query: select - null from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_next_day.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_next_day.q.out b/ql/src/test/results/clientpositive/udf_next_day.q.out
index 37f5640..d67c645 100644
--- a/ql/src/test/results/clientpositive/udf_next_day.q.out
+++ b/ql/src/test/results/clientpositive/udf_next_day.q.out
@@ -11,6 +11,8 @@ next_day(start_date, day_of_week) - Returns the first date which is later than s
start_date is a string in the format 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'. day_of_week is day of the week (e.g. Mo, tue, FRIDAY).Example:
> SELECT next_day('2015-01-14', 'TU') FROM src LIMIT 1;
'2015-01-20'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFNextDay
+Function type:BUILTIN
PREHOOK: query: EXPLAIN SELECT next_day('2014-01-14', 'MO')
FROM src tablesample (1 rows)
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_not.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_not.q.out b/ql/src/test/results/clientpositive/udf_not.q.out
index b80d7b6..134640e 100644
--- a/ql/src/test/results/clientpositive/udf_not.q.out
+++ b/ql/src/test/results/clientpositive/udf_not.q.out
@@ -9,6 +9,8 @@ POSTHOOK: query: DESCRIBE FUNCTION EXTENDED not
POSTHOOK: type: DESCFUNCTION
not a - Logical not
Synonyms: !
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPNot
+Function type:BUILTIN
PREHOOK: query: -- synonym
DESCRIBE FUNCTION !
PREHOOK: type: DESCFUNCTION
@@ -22,3 +24,5 @@ POSTHOOK: query: DESCRIBE FUNCTION EXTENDED !
POSTHOOK: type: DESCFUNCTION
! a - Logical not
Synonyms: not
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPNot
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_notequal.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_notequal.q.out b/ql/src/test/results/clientpositive/udf_notequal.q.out
index 25162da..390390f 100644
--- a/ql/src/test/results/clientpositive/udf_notequal.q.out
+++ b/ql/src/test/results/clientpositive/udf_notequal.q.out
@@ -9,6 +9,8 @@ POSTHOOK: query: DESCRIBE FUNCTION EXTENDED <>
POSTHOOK: type: DESCFUNCTION
a <> b - Returns TRUE if a is not equal to b
Synonyms: !=
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPNotEqual
+Function type:BUILTIN
PREHOOK: query: DESCRIBE FUNCTION !=
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION !=
@@ -20,6 +22,8 @@ POSTHOOK: query: DESCRIBE FUNCTION EXTENDED !=
POSTHOOK: type: DESCFUNCTION
a != b - Returns TRUE if a is not equal to b
Synonyms: <>
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPNotEqual
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT key, value
FROM src
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_nullif.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_nullif.q.out b/ql/src/test/results/clientpositive/udf_nullif.q.out
index 95bd0c2..12cfbec 100644
--- a/ql/src/test/results/clientpositive/udf_nullif.q.out
+++ b/ql/src/test/results/clientpositive/udf_nullif.q.out
@@ -10,6 +10,8 @@ POSTHOOK: type: DESCFUNCTION
nullif(a1, a2) - shorthand for: case when a1 = a2 then null else a1
Example:
SELECT nullif(1,1),nullif(1,2)
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFNullif
+Function type:BUILTIN
PREHOOK: query: explain select nullif(1,2)
PREHOOK: type: QUERY
POSTHOOK: query: explain select nullif(1,2)
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_nvl.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_nvl.q.out b/ql/src/test/results/clientpositive/udf_nvl.q.out
index 50ca083..583df01 100644
--- a/ql/src/test/results/clientpositive/udf_nvl.q.out
+++ b/ql/src/test/results/clientpositive/udf_nvl.q.out
@@ -11,6 +11,8 @@ nvl(value,default_value) - Returns default value if value is null else returns v
Example:
> SELECT nvl(null,'bla') FROM src LIMIT 1;
bla
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFNvl
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT NVL( 1 , 2 ) AS COL1,
NVL( NULL, 5 ) AS COL2
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_or.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_or.q.out b/ql/src/test/results/clientpositive/udf_or.q.out
index cd3e2da..7e415c3 100644
--- a/ql/src/test/results/clientpositive/udf_or.q.out
+++ b/ql/src/test/results/clientpositive/udf_or.q.out
@@ -8,3 +8,5 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED or
POSTHOOK: type: DESCFUNCTION
a1 or a2 or ... or an - Logical or
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPOr
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_parse_url.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_parse_url.q.out b/ql/src/test/results/clientpositive/udf_parse_url.q.out
index dece0af..0ea8584 100644
--- a/ql/src/test/results/clientpositive/udf_parse_url.q.out
+++ b/ql/src/test/results/clientpositive/udf_parse_url.q.out
@@ -17,6 +17,8 @@ Example:
'query=1'
> SELECT parse_url('http://facebook.com/path/p1.php?query=1', 'QUERY', 'query') FROM src LIMIT 1;
'1'
+Function class:org.apache.hadoop.hive.ql.udf.UDFParseUrl
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'HOST'),
parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'PATH'),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_percentile.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_percentile.q.out b/ql/src/test/results/clientpositive/udf_percentile.q.out
index c699a95..3f8890b 100644
--- a/ql/src/test/results/clientpositive/udf_percentile.q.out
+++ b/ql/src/test/results/clientpositive/udf_percentile.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED percentile
POSTHOOK: type: DESCFUNCTION
percentile(expr, pc) - Returns the percentile(s) of expr at pc (range: [0,1]).pc can be a double or double array
+Function class:org.apache.hadoop.hive.ql.udf.UDAFPercentile
+Function type:BUILTIN
PREHOOK: query: -- SORT_QUERY_RESULTS
SELECT CAST(key AS INT) DIV 10,
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_pmod.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_pmod.q.out b/ql/src/test/results/clientpositive/udf_pmod.q.out
index 0c77243..ca714ea 100644
--- a/ql/src/test/results/clientpositive/udf_pmod.q.out
+++ b/ql/src/test/results/clientpositive/udf_pmod.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED pmod
POSTHOOK: type: DESCFUNCTION
a pmod b - Compute the positive modulo
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFPosMod
+Function type:BUILTIN
PREHOOK: query: SELECT pmod(null, null)
FROM src tablesample (1 rows)
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_positive.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_positive.q.out b/ql/src/test/results/clientpositive/udf_positive.q.out
index 4524950..09c0c1f 100644
--- a/ql/src/test/results/clientpositive/udf_positive.q.out
+++ b/ql/src/test/results/clientpositive/udf_positive.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED positive
POSTHOOK: type: DESCFUNCTION
positive a - Returns a
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPPositive
+Function type:BUILTIN
PREHOOK: query: -- synonym
DESCRIBE FUNCTION +
PREHOOK: type: DESCFUNCTION
@@ -20,3 +22,5 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED +
POSTHOOK: type: DESCFUNCTION
a + b - Returns a+b
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPPlus
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_pow.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_pow.q.out b/ql/src/test/results/clientpositive/udf_pow.q.out
index 30a3c54..d2da8b1 100644
--- a/ql/src/test/results/clientpositive/udf_pow.q.out
+++ b/ql/src/test/results/clientpositive/udf_pow.q.out
@@ -12,3 +12,5 @@ Synonyms: power
Example:
> SELECT pow(2, 3) FROM src LIMIT 1;
8
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFPower
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_power.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_power.q.out b/ql/src/test/results/clientpositive/udf_power.q.out
index ae14546..ab60e9b 100644
--- a/ql/src/test/results/clientpositive/udf_power.q.out
+++ b/ql/src/test/results/clientpositive/udf_power.q.out
@@ -12,3 +12,5 @@ Synonyms: pow
Example:
> SELECT power(2, 3) FROM src LIMIT 1;
8
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFPower
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_printf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_printf.q.out b/ql/src/test/results/clientpositive/udf_printf.q.out
index cf07189..47bc071 100644
--- a/ql/src/test/results/clientpositive/udf_printf.q.out
+++ b/ql/src/test/results/clientpositive/udf_printf.q.out
@@ -21,6 +21,8 @@ printf(String format, Obj... args) - function that can format strings according
Example:
> SELECT printf("Hello World %d %s", 100, "days")FROM src LIMIT 1;
"Hello World 100 days"
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFPrintf
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT printf("Hello World %d %s", 100, "days") FROM src tablesample (1 rows)
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_quarter.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_quarter.q.out b/ql/src/test/results/clientpositive/udf_quarter.q.out
index fdfba11..47304e3 100644
--- a/ql/src/test/results/clientpositive/udf_quarter.q.out
+++ b/ql/src/test/results/clientpositive/udf_quarter.q.out
@@ -10,6 +10,8 @@ POSTHOOK: type: DESCFUNCTION
quarter(date/timestamp/string) - Returns the quarter of the year for date, in the range 1 to 4.
Example: > SELECT quarter('2015-04-08');
2
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFQuarter
+Function type:BUILTIN
PREHOOK: query: explain select quarter('2015-04-24')
PREHOOK: type: QUERY
POSTHOOK: query: explain select quarter('2015-04-24')
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_radians.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_radians.q.out b/ql/src/test/results/clientpositive/udf_radians.q.out
index 30bf241..14bd78c 100644
--- a/ql/src/test/results/clientpositive/udf_radians.q.out
+++ b/ql/src/test/results/clientpositive/udf_radians.q.out
@@ -54,6 +54,8 @@ Example:
> SELECT radians(90) FROM src LIMIT 1;
1.5707963267949mo
+Function class:org.apache.hadoop.hive.ql.udf.UDFRadians
+Function type:BUILTIN
PREHOOK: query: explain
select radians(57.2958) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
@@ -110,3 +112,5 @@ Example:
> SELECT radians(90) FROM src LIMIT 1;
1.5707963267949mo
+Function class:org.apache.hadoop.hive.ql.udf.UDFRadians
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_rand.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_rand.q.out b/ql/src/test/results/clientpositive/udf_rand.q.out
index c46ffc2..b1e1646 100644
--- a/ql/src/test/results/clientpositive/udf_rand.q.out
+++ b/ql/src/test/results/clientpositive/udf_rand.q.out
@@ -8,3 +8,5 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED rand
POSTHOOK: type: DESCFUNCTION
rand([seed]) - Returns a pseudorandom number between 0 and 1
+Function class:org.apache.hadoop.hive.ql.udf.UDFRand
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_reflect.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_reflect.q.out b/ql/src/test/results/clientpositive/udf_reflect.q.out
index cb81302..a9863f7 100644
--- a/ql/src/test/results/clientpositive/udf_reflect.q.out
+++ b/ql/src/test/results/clientpositive/udf_reflect.q.out
@@ -11,6 +11,8 @@ reflect(class,method[,arg1[,arg2..]]) calls method with reflection
Synonyms: java_method
Use this UDF to call Java methods by matching the argument signature
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFReflect
+Function type:BUILTIN
PREHOOK: query: EXPLAIN EXTENDED
SELECT reflect("java.lang.String", "valueOf", 1),
reflect("java.lang.String", "isEmpty"),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_reflect2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_reflect2.q.out b/ql/src/test/results/clientpositive/udf_reflect2.q.out
index a862990..a1074f8 100644
--- a/ql/src/test/results/clientpositive/udf_reflect2.q.out
+++ b/ql/src/test/results/clientpositive/udf_reflect2.q.out
@@ -10,6 +10,8 @@ POSTHOOK: type: DESCFUNCTION
reflect2(arg0,method[,arg1[,arg2..]]) calls method of arg0 with reflection
Use this UDF to call Java methods by matching the argument signature
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFReflect2
+Function type:BUILTIN
PREHOOK: query: EXPLAIN EXTENDED
SELECT key,
reflect2(key, "byteValue"),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_regexp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_regexp.q.out b/ql/src/test/results/clientpositive/udf_regexp.q.out
index e27f46a..1cbce0a 100644
--- a/ql/src/test/results/clientpositive/udf_regexp.q.out
+++ b/ql/src/test/results/clientpositive/udf_regexp.q.out
@@ -12,6 +12,8 @@ Synonyms: rlike
Example:
> SELECT 'fb' regexp '.*' FROM src LIMIT 1;
true
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFRegExp
+Function type:BUILTIN
PREHOOK: query: SELECT 'fofo' REGEXP '^fo', 'fo\no' REGEXP '^fo\no$', 'Bn' REGEXP '^Ba*n', 'afofo' REGEXP 'fo',
'afofo' REGEXP '^fo', 'Baan' REGEXP '^Ba?n', 'axe' REGEXP 'pi|apa', 'pip' REGEXP '^(pi)*$'
FROM src tablesample (1 rows)
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_regexp_extract.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_regexp_extract.q.out b/ql/src/test/results/clientpositive/udf_regexp_extract.q.out
index 0a666de..3b85e26 100644
--- a/ql/src/test/results/clientpositive/udf_regexp_extract.q.out
+++ b/ql/src/test/results/clientpositive/udf_regexp_extract.q.out
@@ -11,3 +11,5 @@ 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'
+Function class:org.apache.hadoop.hive.ql.udf.UDFRegExpExtract
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_regexp_replace.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_regexp_replace.q.out b/ql/src/test/results/clientpositive/udf_regexp_replace.q.out
index e9d37f3..8f55a1d 100644
--- a/ql/src/test/results/clientpositive/udf_regexp_replace.q.out
+++ b/ql/src/test/results/clientpositive/udf_regexp_replace.q.out
@@ -11,3 +11,5 @@ regexp_replace(str, regexp, rep) - replace all substrings of str that match rege
Example:
> SELECT regexp_replace('100-200', '(\d+)', 'num') FROM src LIMIT 1;
'num-num'
+Function class:org.apache.hadoop.hive.ql.udf.UDFRegExpReplace
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_repeat.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_repeat.q.out b/ql/src/test/results/clientpositive/udf_repeat.q.out
index 1e76cc2..2c061e7 100644
--- a/ql/src/test/results/clientpositive/udf_repeat.q.out
+++ b/ql/src/test/results/clientpositive/udf_repeat.q.out
@@ -11,6 +11,8 @@ repeat(str, n) - repeat str n times
Example:
> SELECT repeat('123', 2) FROM src LIMIT 1;
'123123'
+Function class:org.apache.hadoop.hive.ql.udf.UDFRepeat
+Function type:BUILTIN
PREHOOK: query: EXPLAIN SELECT
repeat("Facebook", 3),
repeat("", 4),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_replace.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_replace.q.out b/ql/src/test/results/clientpositive/udf_replace.q.out
index 10bce89..18fc024 100644
--- a/ql/src/test/results/clientpositive/udf_replace.q.out
+++ b/ql/src/test/results/clientpositive/udf_replace.q.out
@@ -11,6 +11,8 @@ replace(str, search, rep) - replace all substrings of 'str' that match 'search'
Example:
> SELECT replace('Hack and Hue', 'H', 'BL') FROM src LIMIT 1;
'BLack and BLue'
+Function class:org.apache.hadoop.hive.ql.udf.UDFReplace
+Function type:BUILTIN
PREHOOK: query: select replace('', '', ''),
replace(null, '', ''),
replace('', null, ''),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_reverse.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_reverse.q.out b/ql/src/test/results/clientpositive/udf_reverse.q.out
index 4fee27f..9d0f869 100644
--- a/ql/src/test/results/clientpositive/udf_reverse.q.out
+++ b/ql/src/test/results/clientpositive/udf_reverse.q.out
@@ -11,6 +11,8 @@ reverse(str) - reverse str
Example:
> SELECT reverse('Facebook') FROM src LIMIT 1;
'koobecaF'
+Function class:org.apache.hadoop.hive.ql.udf.UDFReverse
+Function type:BUILTIN
PREHOOK: query: CREATE TABLE dest1(len STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_rlike.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_rlike.q.out b/ql/src/test/results/clientpositive/udf_rlike.q.out
index 270fa94..bfb16ab 100644
--- a/ql/src/test/results/clientpositive/udf_rlike.q.out
+++ b/ql/src/test/results/clientpositive/udf_rlike.q.out
@@ -12,3 +12,5 @@ Synonyms: regexp
Example:
> SELECT 'fb' rlike '.*' FROM src LIMIT 1;
true
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFRegExp
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_round.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_round.q.out b/ql/src/test/results/clientpositive/udf_round.q.out
index c80f821..456e6ea 100644
--- a/ql/src/test/results/clientpositive/udf_round.q.out
+++ b/ql/src/test/results/clientpositive/udf_round.q.out
@@ -11,6 +11,8 @@ round(x[, d]) - round x to d decimal places
Example:
> SELECT round(12.3456, 1) FROM src LIMIT 1;
12.3'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFRound
+Function type:BUILTIN
PREHOOK: query: SELECT round(null), round(null, 0), round(125, null),
round(1.0/0.0, 0), round(power(-1.0,0.5), 0)
FROM src tablesample (1 rows)
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_rpad.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_rpad.q.out b/ql/src/test/results/clientpositive/udf_rpad.q.out
index 2cf5a93..bf77b7f 100644
--- a/ql/src/test/results/clientpositive/udf_rpad.q.out
+++ b/ql/src/test/results/clientpositive/udf_rpad.q.out
@@ -13,6 +13,8 @@ Example:
> SELECT rpad('hi', 5, '??') FROM src LIMIT 1;
'hi???' > SELECT rpad('hi', 1, '??') FROM src LIMIT 1;
'h'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFRpad
+Function type:BUILTIN
PREHOOK: query: EXPLAIN SELECT
rpad('hi', 1, '?'),
rpad('hi', 5, '.'),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_rtrim.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_rtrim.q.out b/ql/src/test/results/clientpositive/udf_rtrim.q.out
index 035c7ae..7b6ae7f 100644
--- a/ql/src/test/results/clientpositive/udf_rtrim.q.out
+++ b/ql/src/test/results/clientpositive/udf_rtrim.q.out
@@ -11,3 +11,5 @@ rtrim(str) - Removes the trailing space characters from str
Example:
> SELECT rtrim('facebook ') FROM src LIMIT 1;
'facebook'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFRTrim
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_second.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_second.q.out b/ql/src/test/results/clientpositive/udf_second.q.out
index 4ee919a..c1f3504 100644
--- a/ql/src/test/results/clientpositive/udf_second.q.out
+++ b/ql/src/test/results/clientpositive/udf_second.q.out
@@ -16,6 +16,8 @@ param can be one of:
59
> SELECT second('12:58:59') FROM src LIMIT 1;
59
+Function class:org.apache.hadoop.hive.ql.udf.UDFSecond
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
FROM src WHERE key = 86
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_sha1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_sha1.q.out b/ql/src/test/results/clientpositive/udf_sha1.q.out
index 6fe3e40..373d238 100644
--- a/ql/src/test/results/clientpositive/udf_sha1.q.out
+++ b/ql/src/test/results/clientpositive/udf_sha1.q.out
@@ -14,6 +14,8 @@ Example:
'3c01bdbb26f358bab27f267924aa2c9a03fcfdb8'
> SELECT sha(binary('ABC'));
'3c01bdbb26f358bab27f267924aa2c9a03fcfdb8'
+Function class:org.apache.hadoop.hive.ql.udf.UDFSha1
+Function type:BUILTIN
PREHOOK: query: explain select sha1('ABC')
PREHOOK: type: QUERY
POSTHOOK: query: explain select sha1('ABC')
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_sha2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_sha2.q.out b/ql/src/test/results/clientpositive/udf_sha2.q.out
index 041e0f4..6553339 100644
--- a/ql/src/test/results/clientpositive/udf_sha2.q.out
+++ b/ql/src/test/results/clientpositive/udf_sha2.q.out
@@ -11,6 +11,8 @@ sha2(string/binary, len) - Calculates the SHA-2 family of hash functions (SHA-22
The first argument is the string or binary to be hashed. The second argument indicates the desired bit length of the result, which must have a value of 224, 256, 384, 512, or 0 (which is equivalent to 256). SHA-224 is supported starting from Java 8. If either argument is NULL or the hash length is not one of the permitted values, the return value is NULL.
Example: > SELECT sha2('ABC', 256);
'b5d4045c3f466fa91fe2cc6abe79232a1a57cdf104f7a26e716e0a1e2789df78'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFSha2
+Function type:BUILTIN
PREHOOK: query: explain select sha2('ABC', 256)
PREHOOK: type: QUERY
POSTHOOK: query: explain select sha2('ABC', 256)
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_sign.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_sign.q.out b/ql/src/test/results/clientpositive/udf_sign.q.out
index cefb9fa..fe84402 100644
--- a/ql/src/test/results/clientpositive/udf_sign.q.out
+++ b/ql/src/test/results/clientpositive/udf_sign.q.out
@@ -62,6 +62,8 @@ sign(x) - returns the sign of x )
Example:
> SELECT sign(40) FROM src LIMIT 1;
1
+Function class:org.apache.hadoop.hive.ql.udf.UDFSign
+Function type:BUILTIN
PREHOOK: query: explain
select sign(0) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
@@ -126,3 +128,5 @@ sign(x) - returns the sign of x )
Example:
> SELECT sign(40) FROM src LIMIT 1;
1
+Function class:org.apache.hadoop.hive.ql.udf.UDFSign
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_sin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_sin.q.out b/ql/src/test/results/clientpositive/udf_sin.q.out
index 47e7cee..d39f940 100644
--- a/ql/src/test/results/clientpositive/udf_sin.q.out
+++ b/ql/src/test/results/clientpositive/udf_sin.q.out
@@ -11,6 +11,8 @@ sin(x) - returns the sine of x (x is in radians)
Example:
> SELECT sin(0) FROM src LIMIT 1;
0
+Function class:org.apache.hadoop.hive.ql.udf.UDFSin
+Function type:BUILTIN
PREHOOK: query: SELECT sin(null)
FROM src tablesample (1 rows)
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_size.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_size.q.out b/ql/src/test/results/clientpositive/udf_size.q.out
index 428f642..c8c81c4 100644
--- a/ql/src/test/results/clientpositive/udf_size.q.out
+++ b/ql/src/test/results/clientpositive/udf_size.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED size
POSTHOOK: type: DESCFUNCTION
size(a) - Returns the size of a
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFSize
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
FROM src_thrift
SELECT size(src_thrift.lint),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_smallint.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_smallint.q.out b/ql/src/test/results/clientpositive/udf_smallint.q.out
index 1b9a219..01d4682 100644
--- a/ql/src/test/results/clientpositive/udf_smallint.q.out
+++ b/ql/src/test/results/clientpositive/udf_smallint.q.out
@@ -8,3 +8,5 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED smallint
POSTHOOK: type: DESCFUNCTION
There is no documentation for function 'smallint'
+Function class:org.apache.hadoop.hive.ql.udf.UDFToShort
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_sort_array.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_sort_array.q.out b/ql/src/test/results/clientpositive/udf_sort_array.q.out
index 2b67108..31affff 100644
--- a/ql/src/test/results/clientpositive/udf_sort_array.q.out
+++ b/ql/src/test/results/clientpositive/udf_sort_array.q.out
@@ -21,6 +21,8 @@ sort_array(array(obj1, obj2,...)) - Sorts the input array in ascending order acc
Example:
> SELECT sort_array(array('b', 'd', 'c', 'a')) FROM src LIMIT 1;
'a', 'b', 'c', 'd'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFSortArray
+Function type:BUILTIN
PREHOOK: query: -- Evaluate function against STRING valued keys
EXPLAIN
SELECT sort_array(array("b", "d", "c", "a")) FROM src tablesample (1 rows)
@@ -119,7 +121,7 @@ SELECT sort_array(array(map("b", 2, "a", 9, "c", 7), map("c", 3, "b", 5, "a", 1)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-[{"a":1,"b":5,"c":3},{"a":1,"b":8,"c":6},{"a":9,"b":2,"c":7}]
+[{"b":5,"a":1,"c":3},{"b":8,"a":1,"c":6},{"b":2,"a":9,"c":7}]
PREHOOK: query: -- Test it against data in a table.
CREATE TABLE dest1 (
tinyints ARRAY<TINYINT>,
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_sort_array_by.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_sort_array_by.q.out b/ql/src/test/results/clientpositive/udf_sort_array_by.q.out
index 7778d1e..a2b14ff 100644
--- a/ql/src/test/results/clientpositive/udf_sort_array_by.q.out
+++ b/ql/src/test/results/clientpositive/udf_sort_array_by.q.out
@@ -21,6 +21,8 @@ sort_array_by(array(obj1, obj2,...),'f1','f2',...,['ASC','DESC']) - Sorts the in
Example:
> SELECT sort_array_by(array(struct('g',100),struct('b',200)),'col1','ASC') FROM src LIMIT 1;
array(struct('b',200),struct('g',100))
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFSortArrayByField
+Function type:BUILTIN
PREHOOK: query: DROP TABLE IF EXISTS sort_array_by_table
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE IF EXISTS sort_array_by_table
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_soundex.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_soundex.q.out b/ql/src/test/results/clientpositive/udf_soundex.q.out
index 79de9fa..db5ec3e 100644
--- a/ql/src/test/results/clientpositive/udf_soundex.q.out
+++ b/ql/src/test/results/clientpositive/udf_soundex.q.out
@@ -12,6 +12,8 @@ The soundex code consist of the first letter of the name followed by three digit
Example:
> SELECT soundex('Miller');
M460
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFSoundex
+Function type:BUILTIN
PREHOOK: query: explain select soundex('Miller')
PREHOOK: type: QUERY
POSTHOOK: query: explain select soundex('Miller')
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_space.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_space.q.out b/ql/src/test/results/clientpositive/udf_space.q.out
index 502b65a..a06da3f 100644
--- a/ql/src/test/results/clientpositive/udf_space.q.out
+++ b/ql/src/test/results/clientpositive/udf_space.q.out
@@ -11,6 +11,8 @@ space(n) - returns n spaces
Example:
> SELECT space(2) FROM src LIMIT 1;
' '
+Function class:org.apache.hadoop.hive.ql.udf.UDFSpace
+Function type:BUILTIN
PREHOOK: query: EXPLAIN SELECT
space(10),
space(0),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_split.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_split.q.out b/ql/src/test/results/clientpositive/udf_split.q.out
index 0dc9ff3..d62cc61 100644
--- a/ql/src/test/results/clientpositive/udf_split.q.out
+++ b/ql/src/test/results/clientpositive/udf_split.q.out
@@ -11,6 +11,8 @@ split(str, regex) - Splits str around occurances that match regex
Example:
> SELECT split('oneAtwoBthreeC', '[ABC]') FROM src LIMIT 1;
["one", "two", "three"]
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFSplit
+Function type:BUILTIN
PREHOOK: query: EXPLAIN SELECT
split('a b c', ' '),
split('oneAtwoBthreeC', '[ABC]'),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_sqrt.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_sqrt.q.out b/ql/src/test/results/clientpositive/udf_sqrt.q.out
index 9062cc6..9798884 100644
--- a/ql/src/test/results/clientpositive/udf_sqrt.q.out
+++ b/ql/src/test/results/clientpositive/udf_sqrt.q.out
@@ -11,3 +11,5 @@ sqrt(x) - returns the square root of x
Example:
> SELECT sqrt(4) FROM src LIMIT 1;
2
+Function class:org.apache.hadoop.hive.ql.udf.UDFSqrt
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_std.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_std.q.out b/ql/src/test/results/clientpositive/udf_std.q.out
index 901e4ec..ba22fc2 100644
--- a/ql/src/test/results/clientpositive/udf_std.q.out
+++ b/ql/src/test/results/clientpositive/udf_std.q.out
@@ -9,3 +9,5 @@ POSTHOOK: query: DESCRIBE FUNCTION EXTENDED std
POSTHOOK: type: DESCFUNCTION
std(x) - Returns the standard deviation of a set of numbers
Synonyms: stddev, stddev_pop
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDAFStd
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_stddev.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_stddev.q.out b/ql/src/test/results/clientpositive/udf_stddev.q.out
index 96e6172..5a9697a 100644
--- a/ql/src/test/results/clientpositive/udf_stddev.q.out
+++ b/ql/src/test/results/clientpositive/udf_stddev.q.out
@@ -9,3 +9,5 @@ POSTHOOK: query: DESCRIBE FUNCTION EXTENDED stddev
POSTHOOK: type: DESCFUNCTION
stddev(x) - Returns the standard deviation of a set of numbers
Synonyms: std, stddev_pop
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDAFStd
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_stddev_samp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_stddev_samp.q.out b/ql/src/test/results/clientpositive/udf_stddev_samp.q.out
index 6619ea1..c6b7adf 100644
--- a/ql/src/test/results/clientpositive/udf_stddev_samp.q.out
+++ b/ql/src/test/results/clientpositive/udf_stddev_samp.q.out
@@ -8,6 +8,8 @@ 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
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDAFStdSample
+Function type:BUILTIN
PREHOOK: query: DESCRIBE FUNCTION stddev_samp
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION stddev_samp
@@ -18,3 +20,5 @@ 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
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDAFStdSample
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_string.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_string.q.out b/ql/src/test/results/clientpositive/udf_string.q.out
index 1c4d7c4..71b9b29 100644
--- a/ql/src/test/results/clientpositive/udf_string.q.out
+++ b/ql/src/test/results/clientpositive/udf_string.q.out
@@ -8,3 +8,5 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED string
POSTHOOK: type: DESCFUNCTION
There is no documentation for function 'string'
+Function class:org.apache.hadoop.hive.ql.udf.UDFToString
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_struct.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_struct.q.out b/ql/src/test/results/clientpositive/udf_struct.q.out
index 0d2d71d..ec1a6f9 100644
--- a/ql/src/test/results/clientpositive/udf_struct.q.out
+++ b/ql/src/test/results/clientpositive/udf_struct.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED struct
POSTHOOK: type: DESCFUNCTION
struct(col1, col2, col3, ...) - Creates a struct with the given field values
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFStruct
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT struct(1), struct(1, "a"), struct(1, "b", 1.5).col1, struct(1, struct("a", 1.5)).col2.col1
FROM src tablesample (1 rows)
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_substr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_substr.q.out b/ql/src/test/results/clientpositive/udf_substr.q.out
index ab64289..10bb66c 100644
--- a/ql/src/test/results/clientpositive/udf_substr.q.out
+++ b/ql/src/test/results/clientpositive/udf_substr.q.out
@@ -17,6 +17,8 @@ Example:
'ebook'
> SELECT substr('Facebook', 5, 1) FROM src LIMIT 1;
'b'
+Function class:org.apache.hadoop.hive.ql.udf.UDFSubstr
+Function type:BUILTIN
PREHOOK: query: SELECT
substr(null, 1), substr(null, 1, 1),
substr('ABC', null), substr('ABC', null, 1),
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_substring.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_substring.q.out b/ql/src/test/results/clientpositive/udf_substring.q.out
index 0f76298..cd7dce6 100644
--- a/ql/src/test/results/clientpositive/udf_substring.q.out
+++ b/ql/src/test/results/clientpositive/udf_substring.q.out
@@ -19,3 +19,5 @@ Example:
'ebook'
> SELECT substring('Facebook', 5, 1) FROM src LIMIT 1;
'b'
+Function class:org.apache.hadoop.hive.ql.udf.UDFSubstr
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_substring_index.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_substring_index.q.out b/ql/src/test/results/clientpositive/udf_substring_index.q.out
index 29dc988..a519d8e 100644
--- a/ql/src/test/results/clientpositive/udf_substring_index.q.out
+++ b/ql/src/test/results/clientpositive/udf_substring_index.q.out
@@ -12,6 +12,8 @@ If count is positive, everything to the left of the final delimiter (counting fr
Example:
> SELECT substring_index('www.apache.org', '.', 2);
'www.apache'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFSubstringIndex
+Function type:BUILTIN
PREHOOK: query: explain select substring_index('www.apache.org', '.', 2)
PREHOOK: type: QUERY
POSTHOOK: query: explain select substring_index('www.apache.org', '.', 2)
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_subtract.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_subtract.q.out b/ql/src/test/results/clientpositive/udf_subtract.q.out
index a396c98..f1cac38 100644
--- a/ql/src/test/results/clientpositive/udf_subtract.q.out
+++ b/ql/src/test/results/clientpositive/udf_subtract.q.out
@@ -8,3 +8,5 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED -
POSTHOOK: type: DESCFUNCTION
a - b - Returns the difference a-b
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPMinus
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_sum.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_sum.q.out b/ql/src/test/results/clientpositive/udf_sum.q.out
index 2f4e3da..ba04642 100644
--- a/ql/src/test/results/clientpositive/udf_sum.q.out
+++ b/ql/src/test/results/clientpositive/udf_sum.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED sum
POSTHOOK: type: DESCFUNCTION
sum(x) - Returns the sum of a set of numbers
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDAFSum
+Function type:BUILTIN
PREHOOK: query: DESCRIBE FUNCTION sum
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION sum
@@ -18,3 +20,5 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED sum
POSTHOOK: type: DESCFUNCTION
sum(x) - Returns the sum of a set of numbers
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDAFSum
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_tan.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_tan.q.out b/ql/src/test/results/clientpositive/udf_tan.q.out
index 42fef20..27d5671 100644
--- a/ql/src/test/results/clientpositive/udf_tan.q.out
+++ b/ql/src/test/results/clientpositive/udf_tan.q.out
@@ -11,6 +11,8 @@ tan(x) - returns the tangent of x (x is in radians)
Example:
> SELECT tan(0) FROM src LIMIT 1;
1
+Function class:org.apache.hadoop.hive.ql.udf.UDFTan
+Function type:BUILTIN
PREHOOK: query: SELECT tan(null)
FROM src tablesample (1 rows)
PREHOOK: type: QUERY
@@ -46,6 +48,8 @@ tan(x) - returns the tangent of x (x is in radians)
Example:
> SELECT tan(0) FROM src LIMIT 1;
1
+Function class:org.apache.hadoop.hive.ql.udf.UDFTan
+Function type:BUILTIN
PREHOOK: query: SELECT tan(null)
FROM src tablesample (1 rows)
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_tinyint.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_tinyint.q.out b/ql/src/test/results/clientpositive/udf_tinyint.q.out
index 007a5d1..50373c7 100644
--- a/ql/src/test/results/clientpositive/udf_tinyint.q.out
+++ b/ql/src/test/results/clientpositive/udf_tinyint.q.out
@@ -8,3 +8,5 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED tinyint
POSTHOOK: type: DESCFUNCTION
There is no documentation for function 'tinyint'
+Function class:org.apache.hadoop.hive.ql.udf.UDFToByte
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_to_date.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_to_date.q.out b/ql/src/test/results/clientpositive/udf_to_date.q.out
index 85676f3..043d084 100644
--- a/ql/src/test/results/clientpositive/udf_to_date.q.out
+++ b/ql/src/test/results/clientpositive/udf_to_date.q.out
@@ -11,3 +11,5 @@ to_date(expr) - Extracts the date part of the date or datetime expression expr
Example:
> SELECT to_date('2009-07-30 04:17:52') FROM src LIMIT 1;
'2009-07-30'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFDate
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out b/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out
index 3d31664..4fd0f41 100644
--- a/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out
+++ b/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out
@@ -9,6 +9,8 @@ POSTHOOK: query: DESCRIBE FUNCTION EXTENDED to_unix_timestamp
POSTHOOK: type: DESCFUNCTION
to_unix_timestamp(date[, pattern]) - Returns the UNIX timestamp
Converts the specified time to number of seconds since 1970-01-01.
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFToUnixTimeStamp
+Function type:BUILTIN
PREHOOK: query: create table oneline(key int, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out b/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out
index 1730f8c..d302c76 100644
--- a/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out
+++ b/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out
@@ -8,6 +8,8 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESC FUNCTION EXTENDED to_utc_timestamp
POSTHOOK: type: DESCFUNCTION
to_utc_timestamp(timestamp, string timezone) - Assumes given timestamp is in given timezone and converts to UTC (as of Hive 0.8.0)
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFToUtcTimestamp
+Function type:BUILTIN
PREHOOK: query: explain select to_utc_timestamp('2012-02-11 10:30:00', 'PST')
PREHOOK: type: QUERY
POSTHOOK: query: explain select to_utc_timestamp('2012-02-11 10:30:00', 'PST')
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_translate.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_translate.q.out b/ql/src/test/results/clientpositive/udf_translate.q.out
index 96f04ab..f7c0a18 100644
--- a/ql/src/test/results/clientpositive/udf_translate.q.out
+++ b/ql/src/test/results/clientpositive/udf_translate.q.out
@@ -20,6 +20,8 @@ If the same character is present multiple times in the input string, the first o
For example,
translate('abcdef', 'ada', '192') returns '1bc9ef' replaces 'a' with '1' and 'd' with '9' ignoring the second occurence of 'a' in the from string mapping it to '2'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFTranslate
+Function type:BUILTIN
PREHOOK: query: -- Create some tables to serve some input data
CREATE TABLE table_input(input STRING)
PREHOOK: type: CREATETABLE
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_trim.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_trim.q.out b/ql/src/test/results/clientpositive/udf_trim.q.out
index 4cc2a60..d2d9a9b 100644
--- a/ql/src/test/results/clientpositive/udf_trim.q.out
+++ b/ql/src/test/results/clientpositive/udf_trim.q.out
@@ -11,3 +11,5 @@ trim(str) - Removes the leading and trailing space characters from str
Example:
> SELECT trim(' facebook ') FROM src LIMIT 1;
'facebook'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFTrim
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_trunc.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_trunc.q.out b/ql/src/test/results/clientpositive/udf_trunc.q.out
index 034caab..36b9a13 100644
--- a/ql/src/test/results/clientpositive/udf_trunc.q.out
+++ b/ql/src/test/results/clientpositive/udf_trunc.q.out
@@ -26,6 +26,8 @@ OK
> SELECT trunc(1234567891.1234567891);
OK
1234567891
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFTrunc
+Function type:BUILTIN
PREHOOK: query: --test string with 'MM' as format
EXPLAIN
SELECT
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_ucase.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_ucase.q.out b/ql/src/test/results/clientpositive/udf_ucase.q.out
index fb4abac..c6895a8 100644
--- a/ql/src/test/results/clientpositive/udf_ucase.q.out
+++ b/ql/src/test/results/clientpositive/udf_ucase.q.out
@@ -12,3 +12,5 @@ Synonyms: upper
Example:
> SELECT ucase('Facebook') FROM src LIMIT 1;
'FACEBOOK'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFUpper
+Function type:BUILTIN
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_unhex.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_unhex.q.out b/ql/src/test/results/clientpositive/udf_unhex.q.out
index 1573f15..86e2c1b 100644
--- a/ql/src/test/results/clientpositive/udf_unhex.q.out
+++ b/ql/src/test/results/clientpositive/udf_unhex.q.out
@@ -21,6 +21,8 @@ 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.
+Function class:org.apache.hadoop.hive.ql.udf.UDFUnhex
+Function type:BUILTIN
PREHOOK: query: -- Good inputs
SELECT
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_union.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_union.q.out b/ql/src/test/results/clientpositive/udf_union.q.out
index 0b007da..d67c2a2 100644
--- a/ql/src/test/results/clientpositive/udf_union.q.out
+++ b/ql/src/test/results/clientpositive/udf_union.q.out
@@ -11,6 +11,8 @@ create_union(tag, obj1, obj2, obj3, ...) - Creates a union with the object for g
Example:
> SELECT create_union(1, 1, "one") FROM src LIMIT 1;
one
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFUnion
+Function type:BUILTIN
PREHOOK: query: EXPLAIN
SELECT create_union(0, key), create_union(if(key<100, 0, 1), 2.0, value),
create_union(1, "a", struct(2, "b"))
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_unix_timestamp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_unix_timestamp.q.out b/ql/src/test/results/clientpositive/udf_unix_timestamp.q.out
index a1543d9..fc0de7d 100644
--- a/ql/src/test/results/clientpositive/udf_unix_timestamp.q.out
+++ b/ql/src/test/results/clientpositive/udf_unix_timestamp.q.out
@@ -9,6 +9,8 @@ POSTHOOK: query: DESCRIBE FUNCTION EXTENDED unix_timestamp
POSTHOOK: type: DESCFUNCTION
unix_timestamp(date[, pattern]) - Converts the time to a number
Converts the specified time to number of seconds since 1970-01-01. The unix_timestamp(void) overload is deprecated, use current_timestamp.
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFUnixTimeStamp
+Function type:BUILTIN
PREHOOK: query: create table oneline(key int, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
http://git-wip-us.apache.org/repos/asf/hive/blob/cb7918c6/ql/src/test/results/clientpositive/udf_upper.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_upper.q.out b/ql/src/test/results/clientpositive/udf_upper.q.out
index a8c492a..8061dfb 100644
--- a/ql/src/test/results/clientpositive/udf_upper.q.out
+++ b/ql/src/test/results/clientpositive/udf_upper.q.out
@@ -12,3 +12,5 @@ Synonyms: ucase
Example:
> SELECT upper('Facebook') FROM src LIMIT 1;
'FACEBOOK'
+Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFUpper
+Function type:BUILTIN