/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/udf_when.q
text | 57 lines | 55 code | 2 blank | 0 comment | 0 complexity | 96a90fe8a7ffd2b87b2b4c71b2f540b7 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- DESCRIBE FUNCTION when;
- DESCRIBE FUNCTION EXTENDED when;
- 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;
- 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;