Saving all output to "!!{outputDirectory}!!/udf_if.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/udf_if.q
>>>  DESCRIBE FUNCTION if;
'tab_name'
'There is no documentation for function 'if''
1 row selected 
>>>  DESCRIBE FUNCTION EXTENDED if;
'tab_name'
'There is no documentation for function 'if''
1 row selected 
>>>  
>>>  EXPLAIN 
SELECT IF(TRUE, 1, 2) AS COL1, 
IF(FALSE, CAST(NULL AS STRING), CAST(1 AS STRING)) AS COL2, 
IF(1=1, IF(2=2, 1, 2), IF(3=3, 3, 4)) AS COL3, 
IF(2=2, 1, NULL) AS COL4, 
IF(2=2, NULL, 1) AS COL5, 
IF(IF(TRUE, NULL, FALSE), 1, 2) AS COL6 
FROM src LIMIT 1;
'Explain'
'ABSTRACT SYNTAX TREE:'
'  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION IF TRUE 1 2) COL1) (TOK_SELEXPR (TOK_FUNCTION IF FALSE (TOK_FUNCTION TOK_STRING TOK_NULL) (TOK_FUNCTION TOK_STRING 1)) COL2) (TOK_SELEXPR (TOK_FUNCTION IF (= 1 1) (TOK_FUNCTION IF (= 2 2) 1 2) (TOK_FUNCTION IF (= 3 3) 3 4)) COL3) (TOK_SELEXPR (TOK_FUNCTION IF (= 2 2) 1 TOK_NULL) COL4) (TOK_SELEXPR (TOK_FUNCTION IF (= 2 2) TOK_NULL 1) COL5) (TOK_SELEXPR (TOK_FUNCTION IF (TOK_FUNCTION IF TRUE TOK_NULL FALSE) 1 2) COL6)) (TOK_LIMIT 1)))'
''
'STAGE DEPENDENCIES:'
'  Stage-1 is a root stage'
'  Stage-0 is a root stage'
''
'STAGE PLANS:'
'  Stage: Stage-1'
'    Map Reduce'
'      Alias -> Map Operator Tree:'
'        src '
'          TableScan'
'            alias: src'
'            Select Operator'
'              expressions:'
'                    expr: if(true, 1, 2)'
'                    type: int'
'                    expr: if(false, UDFToString(null), UDFToString(1))'
'                    type: string'
'                    expr: if((1 = 1), if((2 = 2), 1, 2), if((3 = 3), 3, 4))'
'                    type: int'
'                    expr: if((2 = 2), 1, null)'
'                    type: int'
'                    expr: if((2 = 2), null, 1)'
'                    type: int'
'                    expr: if(if(true, null, false), 1, 2)'
'                    type: int'
'              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5'
'              Limit'
'                File Output Operator'
'                  compressed: false'
'                  GlobalTableId: 0'
'                  table:'
'                      input format: org.apache.hadoop.mapred.TextInputFormat'
'                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
''
'  Stage: Stage-0'
'    Fetch Operator'
'      limit: 1'
''
''
42 rows selected 
>>>  
>>>  
>>>  SELECT IF(TRUE, 1, 2) AS COL1, 
IF(FALSE, CAST(NULL AS STRING), CAST(1 AS STRING)) AS COL2, 
IF(1=1, IF(2=2, 1, 2), IF(3=3, 3, 4)) AS COL3, 
IF(2=2, 1, NULL) AS COL4, 
IF(2=2, NULL, 1) AS COL5, 
IF(IF(TRUE, NULL, FALSE), 1, 2) AS COL6 
FROM src LIMIT 1;
'col1','col2','col3','col4','col5','col6'
'1','1','1','1','','2'
1 row selected 
>>>  
>>>  -- Type conversions
>>>  EXPLAIN 
SELECT IF(TRUE, CAST(128 AS SMALLINT), CAST(1 AS TINYINT)) AS COL1, 
IF(FALSE, 1, 1.1) AS COL2, 
IF(FALSE, 1, 'ABC') AS COL3, 
IF(FALSE, 'ABC', 12.3) AS COL4 
FROM src LIMIT 1;
'Explain'
'ABSTRACT SYNTAX TREE:'
'  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION IF TRUE (TOK_FUNCTION TOK_SMALLINT 128) (TOK_FUNCTION TOK_TINYINT 1)) COL1) (TOK_SELEXPR (TOK_FUNCTION IF FALSE 1 1.1) COL2) (TOK_SELEXPR (TOK_FUNCTION IF FALSE 1 'ABC') COL3) (TOK_SELEXPR (TOK_FUNCTION IF FALSE 'ABC' 12.3) COL4)) (TOK_LIMIT 1)))'
''
'STAGE DEPENDENCIES:'
'  Stage-1 is a root stage'
'  Stage-0 is a root stage'
''
'STAGE PLANS:'
'  Stage: Stage-1'
'    Map Reduce'
'      Alias -> Map Operator Tree:'
'        src '
'          TableScan'
'            alias: src'
'            Select Operator'
'              expressions:'
'                    expr: if(true, UDFToShort(128), UDFToByte(1))'
'                    type: smallint'
'                    expr: if(false, 1, 1.1)'
'                    type: double'
'                    expr: if(false, 1, 'ABC')'
'                    type: string'
'                    expr: if(false, 'ABC', 12.3)'
'                    type: string'
'              outputColumnNames: _col0, _col1, _col2, _col3'
'              Limit'
'                File Output Operator'
'                  compressed: false'
'                  GlobalTableId: 0'
'                  table:'
'                      input format: org.apache.hadoop.mapred.TextInputFormat'
'                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
''
'  Stage: Stage-0'
'    Fetch Operator'
'      limit: 1'
''
''
38 rows selected 
>>>  
>>>  SELECT IF(TRUE, CAST(128 AS SMALLINT), CAST(1 AS TINYINT)) AS COL1, 
IF(FALSE, 1, 1.1) AS COL2, 
IF(FALSE, 1, 'ABC') AS COL3, 
IF(FALSE, 'ABC', 12.3) AS COL4 
FROM src LIMIT 1;
'col1','col2','col3','col4'
'128','1.1','ABC','12.3'
1 row selected 
>>>  !record