PREHOOK: query: DESCRIBE FUNCTION nvl
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION nvl
POSTHOOK: type: DESCFUNCTION
nvl(value,default_value) - Returns default value if value is null else returns value
PREHOOK: query: DESCRIBE FUNCTION EXTENDED nvl
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED nvl
POSTHOOK: type: DESCFUNCTION
nvl(value,default_value) - Returns default value if value is null else returns value
Example:
  > SELECT nvl(null,'bla') FROM src LIMIT 1;
  bla
PREHOOK: query: EXPLAIN
SELECT NVL( 1 , 2 ) AS COL1,
       NVL( NULL, 5 ) AS COL2
FROM src tablesample (1 rows)
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
SELECT NVL( 1 , 2 ) AS COL1,
       NVL( NULL, 5 ) AS COL2
FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
  Stage-0 is a root stage

STAGE PLANS:
  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        TableScan
          alias: src
          Row Limit Per Split: 1
          Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: COMPLETE
          Select Operator
            expressions: 1 (type: int), if null is null returns5 (type: int)
            outputColumnNames: _col0, _col1
            Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE Column stats: COMPLETE
            ListSink

PREHOOK: query: SELECT NVL( 1 , 2 ) AS COL1,
       NVL( NULL, 5 ) AS COL2
FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT NVL( 1 , 2 ) AS COL1,
       NVL( NULL, 5 ) AS COL2
FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
1	5