blob: 9225085bc83634d6f5ef75f21db0fdd54dc277c0 [file] [log] [blame]
PREHOOK: query: DESCRIBE FUNCTION hex
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION hex
POSTHOOK: type: DESCFUNCTION
hex(n, bin, or str) - Convert the argument to hexadecimal
PREHOOK: query: DESCRIBE FUNCTION EXTENDED hex
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED hex
POSTHOOK: type: DESCFUNCTION
hex(n, bin, 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 or binary, returns the hexadecimal representation.
Example:
> SELECT hex(17) FROM src LIMIT 1;
'H1'
> SELECT hex('Facebook') FROM src LIMIT 1;
'46616365626F6F6B'
Function class:org.apache.hadoop.hive.ql.udf.UDFHex
Function type:BUILTIN
PREHOOK: query: SELECT
hex('Facebook'),
hex('\0'),
hex('qwertyuiopasdfghjkl')
FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT
hex('Facebook'),
hex('\0'),
hex('qwertyuiopasdfghjkl')
FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
46616365626F6F6B 00 71776572747975696F706173646667686A6B6C
PREHOOK: query: SELECT
hex(1),
hex(0),
hex(4207849477)
FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT
hex(1),
hex(0),
hex(4207849477)
FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
1 0 FACEB005
PREHOOK: query: SELECT hex(-5) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT hex(-5) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
FFFFFFFFFFFFFFFB