PREHOOK: query: DESCRIBE FUNCTION decode
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION decode
POSTHOOK: type: DESCFUNCTION
decode(bin, str) - Decode the first argument using the second argument character set
PREHOOK: query: DESC FUNCTION EXTENDED decode
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESC FUNCTION EXTENDED decode
POSTHOOK: type: DESCFUNCTION
decode(bin, str) - Decode the first argument using the second argument character set
Possible options for the character set are 'US_ASCII', 'ISO-8859-1',
'UTF-8', 'UTF-16BE', 'UTF-16LE', and 'UTF-16'. If either argument
is null, the result will also be null
PREHOOK: query: explain select decode(binary('TestDecode1'), 'UTF-8')
PREHOOK: type: QUERY
POSTHOOK: query: explain select decode(binary('TestDecode1'), 'UTF-8')
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
  Stage-0 is a root stage

STAGE PLANS:
  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        TableScan
          alias: _dummy_table
          Row Limit Per Split: 1
          Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
          Select Operator
            expressions: 'TestDecode1' (type: string)
            outputColumnNames: _col0
            Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
            ListSink

PREHOOK: query: select
decode(binary('TestDecode1'), 'UTF-8'),
decode(binary('TestDecode2'), cast('UTF-8' as varchar(10))),
decode(binary('TestDecode3'), cast('UTF-8' as char(5))),
decode(cast(null as binary), 'UTF-8')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
decode(binary('TestDecode1'), 'UTF-8'),
decode(binary('TestDecode2'), cast('UTF-8' as varchar(10))),
decode(binary('TestDecode3'), cast('UTF-8' as char(5))),
decode(cast(null as binary), 'UTF-8')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
TestDecode1	TestDecode2	TestDecode3	NULL