[jira] [Created] (TAJO-934) Multiple DISTINCT returns null grouping key value.

["Hyoungjun Kim (JIRA)" <ji...@apache.org>]

Hyoungjun Kim created TAJO-934:
----------------------------------

             Summary: Multiple DISTINCT returns null grouping key value.
                 Key: TAJO-934
                 URL: https://issues.apache.org/jira/browse/TAJO-934
             Project: Tajo
          Issue Type: Bug
            Reporter: Hyoungjun Kim
            Assignee: Hyoungjun Kim
            Priority: Minor


{noformat}
default> select count * from table1;
col1, col2, col3
-------------------------
a, b-1, null
a, b-2, null
a, b-2, null
a, b-3, null
a, b-3, null
a, b-3, null

default> select col1,
count(distinct col2) as cnt1,
count(distinct case when col3 is not null then col2 else null end) as cnt2
from table1
group by col1;

col1,cnt1,cnt2
-------------------------------
a,  2,  1
null,  1,  1
{noformat}

This query should return the below result.
{noformat}
col1,cnt1,cnt2
-------------------------------
a, 3, 1
{noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)