ql/src/test/queries/clientpositive/udf_case_thrift.q

--! qt:dataset:src_thrift
set hive.fetch.task.conversion=more;

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 tablesample (3 rows);

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 tablesample (3 rows);