PREHOOK: query: DESCRIBE FUNCTION hex
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION hex
POSTHOOK: type: DESCFUNCTION
hex(n or str) - Convert the argument to hexadecimal 
PREHOOK: query: DESCRIBE FUNCTION EXTENDED hex
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED hex
POSTHOOK: type: DESCFUNCTION
hex(n or str) - Convert the argument to hexadecimal 
If the argument is a string, returns two hex digits for each character in the string.
If the argument is a number, returns the hexadecimal representation.
Example:
  > SELECT hex(17) FROM src LIMIT 1;
  'H1'
  > SELECT hex('Facebook') FROM src LIMIT 1;
  '46616365626F6F6B'
PREHOOK: query: -- If the argument is a string, hex should return a string containing two hex
-- digits for every character in the input.
SELECT
  hex('Facebook'),
  hex('\0'),
  hex('qwertyuiopasdfghjkl')
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/871424994/10000
POSTHOOK: query: -- If the argument is a string, hex should return a string containing two hex
-- digits for every character in the input.
SELECT
  hex('Facebook'),
  hex('\0'),
  hex('qwertyuiopasdfghjkl')
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/871424994/10000
46616365626F6F6B	00	71776572747975696F706173646667686A6B6C
PREHOOK: query: -- If the argument is a number, hex should convert it to hexadecimal.
SELECT
  hex(1),
  hex(0),
  hex(4207849477)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1308427474/10000
POSTHOOK: query: -- If the argument is a number, hex should convert it to hexadecimal.
SELECT
  hex(1),
  hex(0),
  hex(4207849477)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1308427474/10000
1	0	FACEB005
PREHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
SELECT hex(-5) FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2089947529/10000
POSTHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
SELECT hex(-5) FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2089947529/10000
FFFFFFFFFFFFFFFB