PREHOOK: query: EXPLAIN SELECT CASE src_thrift.lint[0] WHEN 0 THEN src_thrift.lint[0] + 1 WHEN 1 THEN src_thrift.lint[0] + 2 WHEN 2 THEN 100 ELSE 5 END, CASE src_thrift.lstring[0] WHEN '0' THEN 'zero' WHEN '10' THEN CONCAT(src_thrift.lstring[0], " is ten") ELSE 'default' END, (CASE src_thrift.lstring[0] WHEN '0' THEN src_thrift.lstring ELSE NULL END)[0] FROM src_thrift LIMIT 3 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT CASE src_thrift.lint[0] WHEN 0 THEN src_thrift.lint[0] + 1 WHEN 1 THEN src_thrift.lint[0] + 2 WHEN 2 THEN 100 ELSE 5 END, CASE src_thrift.lstring[0] WHEN '0' THEN 'zero' WHEN '10' THEN CONCAT(src_thrift.lstring[0], " is ten") ELSE 'default' END, (CASE src_thrift.lstring[0] WHEN '0' THEN src_thrift.lstring ELSE NULL END)[0] FROM src_thrift LIMIT 3 POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_thrift))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION CASE ([ (. (TOK_TABLE_OR_COL src_thrift) lint) 0) 0 (+ ([ (. (TOK_TABLE_OR_COL src_thrift) lint) 0) 1) 1 (+ ([ (. (TOK_TABLE_OR_COL src_thrift) lint) 0) 2) 2 100 5)) (TOK_SELEXPR (TOK_FUNCTION CASE ([ (. (TOK_TABLE_OR_COL src_thrift) lstring) 0) '0' 'zero' '10' (TOK_FUNCTION CONCAT ([ (. (TOK_TABLE_OR_COL src_thrift) lstring) 0) " is ten") 'default')) (TOK_SELEXPR ([ (TOK_FUNCTION CASE ([ (. (TOK_TABLE_OR_COL src_thrift) lstring) 0) '0' (. (TOK_TABLE_OR_COL src_thrift) lstring) TOK_NULL) 0))) (TOK_LIMIT 3))) 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_thrift TableScan alias: src_thrift Select Operator expressions: expr: CASE (lint[0]) WHEN (0) THEN ((lint[0] + 1)) WHEN (1) THEN ((lint[0] + 2)) WHEN (2) THEN (100) ELSE (5) END type: int expr: CASE (lstring[0]) WHEN ('0') THEN ('zero') WHEN ('10') THEN (concat(lstring[0], ' is ten')) ELSE ('default') END type: string expr: CASE (lstring[0]) WHEN ('0') THEN (lstring) ELSE (null) END[0] type: string outputColumnNames: _col0, _col1, _col2 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: 3 PREHOOK: query: SELECT CASE src_thrift.lint[0] WHEN 0 THEN src_thrift.lint[0] + 1 WHEN 1 THEN src_thrift.lint[0] + 2 WHEN 2 THEN 100 ELSE 5 END, CASE src_thrift.lstring[0] WHEN '0' THEN 'zero' WHEN '10' THEN CONCAT(src_thrift.lstring[0], " is ten") ELSE 'default' END, (CASE src_thrift.lstring[0] WHEN '0' THEN src_thrift.lstring ELSE NULL END)[0] FROM src_thrift LIMIT 3 PREHOOK: type: QUERY PREHOOK: Input: default@src_thrift PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-31-15_079_64523828140828624/-mr-10000 POSTHOOK: query: SELECT CASE src_thrift.lint[0] WHEN 0 THEN src_thrift.lint[0] + 1 WHEN 1 THEN src_thrift.lint[0] + 2 WHEN 2 THEN 100 ELSE 5 END, CASE src_thrift.lstring[0] WHEN '0' THEN 'zero' WHEN '10' THEN CONCAT(src_thrift.lstring[0], " is ten") ELSE 'default' END, (CASE src_thrift.lstring[0] WHEN '0' THEN src_thrift.lstring ELSE NULL END)[0] FROM src_thrift LIMIT 3 POSTHOOK: type: QUERY POSTHOOK: Input: default@src_thrift POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-31-15_079_64523828140828624/-mr-10000 1 zero 0 3 10 is ten NULL 100 default NULL