[ 
https://issues.apache.org/jira/browse/HIVE-12889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15106994#comment-15106994
 ] 

Aihua Xu commented on HIVE-12889:
---------------------------------

Uploaded the first patch: in this patch, 

1. Enabling the parser to properly parse such query "count(distinct) over 
(partition by c1)";
2. ORDER BY and windowing frame won't work with the functions of distinct due 
to performance concern and implementation requirement.
3. We insert the distinct fields into the order by list, so during counting, we 
only need to compare the current row against the previous remembered row.

> Support COUNT(DISTINCT) for partitioning query.
> -----------------------------------------------
>
>                 Key: HIVE-12889
>                 URL: https://issues.apache.org/jira/browse/HIVE-12889
>             Project: Hive
>          Issue Type: Sub-task
>          Components: PTF-Windowing
>    Affects Versions: 2.1.0
>            Reporter: Aihua Xu
>            Assignee: Aihua Xu
>         Attachments: HIVE-12889.patch
>
>
> We need to support avg(distinct), count(distinct), sum(distinct) for the 
> parent jira HIVE-9534. Separate the work for count(distinct) in this subtask.



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

Reply via email to