[jira] [Created] (HIVE-14206) CASE boolean output is NULL when SUM predicate returns NULL

["Stathis Fotiadis (JIRA)" <ji...@apache.org>]

Stathis Fotiadis created HIVE-14206:
---------------------------------------

             Summary: CASE boolean output is NULL when SUM predicate returns NULL
                 Key: HIVE-14206
                 URL: https://issues.apache.org/jira/browse/HIVE-14206
             Project: Hive
          Issue Type: Bug
            Reporter: Stathis Fotiadis
            Priority: Critical


This query 
`
select
case when 1=sum(1) then true else false end) bool_true,
(case when 1=sum(0) then true else false end) bool_false,
(case when 1=(1+null) then true else false end) bool_null,
(case when 1=sum(1+null) then true else false end) bool_null_sum,
(case when 1=sum(1) then 'true' else 'false' end) string_true,
(case when 1=sum(0) then 'true' else 'false' end) string_false,
(case when 1=(1+null) then 'true' else 'false' end) string_null,
(case when 1=sum(1+null) then 'true' else 'false' end) string_null_sum
`

results to


bool_true	bool_false	bool_null	bool_null_sum	string_true	string_false	string_null	string_null_sum
true	false	false	NULL	true	false	false	false


First of all the is the inconsistency between (1+null) and SUM(1+null) and secondly the inconsistency between using boolean and string outpu



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)