/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/udf_when.q.out

PREHOOK: query: DESCRIBE FUNCTION when
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION when
POSTHOOK: type: DESCFUNCTION
There is no documentation for function 'when'
PREHOOK: query: DESCRIBE FUNCTION EXTENDED when
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED when
POSTHOOK: type: DESCFUNCTION
There is no documentation for function 'when'
PREHOOK: query: EXPLAIN
SELECT CASE
        WHEN 1=1 THEN 2
        WHEN 1=3 THEN 4
        ELSE 5
       END,
       CASE
        WHEN 6=7 THEN 8
        ELSE 9
       END,
       CASE
        WHEN 10=11 THEN 12
        WHEN 13=13 THEN 14
       END,
       CASE
        WHEN 15=16 THEN 17
        WHEN 18=19 THEN 20
       END,
       CASE
        WHEN 21=22 THEN NULL
        WHEN 23=23 THEN 24
       END,
       CASE
        WHEN 25=26 THEN 27
        WHEN 28=28 THEN NULL
       END
FROM src LIMIT 1
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
SELECT CASE
        WHEN 1=1 THEN 2
        WHEN 1=3 THEN 4
        ELSE 5
       END,
       CASE
        WHEN 6=7 THEN 8
        ELSE 9
       END,
       CASE
        WHEN 10=11 THEN 12
        WHEN 13=13 THEN 14
       END,
       CASE
        WHEN 15=16 THEN 17
        WHEN 18=19 THEN 20
       END,
       CASE
        WHEN 21=22 THEN NULL
        WHEN 23=23 THEN 24
       END,
       CASE
        WHEN 25=26 THEN 27
        WHEN 28=28 THEN NULL
       END
FROM src LIMIT 1
POSTHOOK: type: QUERY
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 WHEN (= 1 1) 2 (= 1 3) 4 5)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 6 7) 8 9)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 10 11) 12 (= 13 13) 14)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 15 16) 17 (= 18 19) 20)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 21 22) TOK_NULL (= 23 23) 24)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 25 26) 27 (= 28 28) TOK_NULL))) (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: CASE WHEN ((1 = 1)) THEN (2) WHEN ((1 = 3)) THEN (4) ELSE (5) END
                    type: int
                    expr: CASE WHEN ((6 = 7)) THEN (8) ELSE (9) END
                    type: int
                    expr: CASE WHEN ((10 = 11)) THEN (12) WHEN ((13 = 13)) THEN (14) END
                    type: int
                    expr: CASE WHEN ((15 = 16)) THEN (17) WHEN ((18 = 19)) THEN (20) END
                    type: int
                    expr: CASE WHEN ((21 = 22)) THEN (null) WHEN ((23 = 23)) THEN (24) END
                    type: int
                    expr: CASE WHEN ((25 = 26)) THEN (27) WHEN ((28 = 28)) THEN (null) END
                    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


PREHOOK: query: SELECT CASE
        WHEN 1=1 THEN 2
        WHEN 1=3 THEN 4
        ELSE 5
       END,
       CASE
        WHEN 6=7 THEN 8
        ELSE 9
       END,
       CASE
        WHEN 10=11 THEN 12
        WHEN 13=13 THEN 14
       END,
       CASE
        WHEN 15=16 THEN 17
        WHEN 18=19 THEN 20
       END,
       CASE
        WHEN 21=22 THEN NULL
        WHEN 23=23 THEN 24
       END,
       CASE
        WHEN 25=26 THEN 27
        WHEN 28=28 THEN NULL
       END
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-43-24_591_7859730196061630515/-mr-10000
POSTHOOK: query: SELECT CASE
        WHEN 1=1 THEN 2
        WHEN 1=3 THEN 4
        ELSE 5
       END,
       CASE
        WHEN 6=7 THEN 8
        ELSE 9
       END,
       CASE
        WHEN 10=11 THEN 12
        WHEN 13=13 THEN 14
       END,
       CASE
        WHEN 15=16 THEN 17
        WHEN 18=19 THEN 20
       END,
       CASE
        WHEN 21=22 THEN NULL
        WHEN 23=23 THEN 24
       END,
       CASE
        WHEN 25=26 THEN 27
        WHEN 28=28 THEN NULL
       END
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-43-24_591_7859730196061630515/-mr-10000
2	9	14	NULL	24	NULL