You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Alexey Diomin (JIRA)" <ji...@apache.org> on 2011/03/24 15:49:05 UTC

[jira] [Created] (HIVE-2075) error in function count(distinct col)

error in function  count(distinct col)
--------------------------------------

                 Key: HIVE-2075
                 URL: https://issues.apache.org/jira/browse/HIVE-2075
             Project: Hive
          Issue Type: Bug
          Components: Query Processor, Serializers/Deserializers
    Affects Versions: 0.7.0
            Reporter: Alexey Diomin


select 
     N.cl1, 
     count(distinct N.cl2) as cl2count,
     N.cl3
from raw N
group by 
     N.cl1,
     N.cl2,
     N.cl3

not working on 0.7 (on 0.6 work correct), but count(distinct N.cl2) work correct

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-2075) error in function count(distinct col)

Posted by "Alexey Diomin (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alexey Diomin updated HIVE-2075:
--------------------------------

    Description: 
select 
     N.cl1, 
     count(distinct N.cl2) as cl2count,
     N.cl3
from raw N
group by 
     N.cl1,
     N.cl2,
     N.cl3

not working on 0.7 (on 0.6 work correct), but count(N.cl2) work correct

  was:
select 
     N.cl1, 
     count(distinct N.cl2) as cl2count,
     N.cl3
from raw N
group by 
     N.cl1,
     N.cl2,
     N.cl3

not working on 0.7 (on 0.6 work correct), but count(distinct N.cl2) work correct


> error in function  count(distinct col)
> --------------------------------------
>
>                 Key: HIVE-2075
>                 URL: https://issues.apache.org/jira/browse/HIVE-2075
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor, Serializers/Deserializers
>    Affects Versions: 0.7.0
>            Reporter: Alexey Diomin
>
> select 
>      N.cl1, 
>      count(distinct N.cl2) as cl2count,
>      N.cl3
> from raw N
> group by 
>      N.cl1,
>      N.cl2,
>      N.cl3
> not working on 0.7 (on 0.6 work correct), but count(N.cl2) work correct

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira