[
https://issues.apache.org/jira/browse/HIVE-474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12920924#action_12920924
]
Amareshwari Sriramadasu commented on HIVE-474:
----------------------------------------------
I'm trying to understand the real problem we are solving here. As first step, I
did the changes in SemanticAnalyzer to allow distinct selection for multiple
columns and executed the query:
{code}
select count(key), count(value), count(distinct key), count(distinct value),
count(distinct key, value) from src;
{code}
It returns corrects results with the current implementation itself.
Can you explain the problem with current implementation?
> Support for distinct selection on two or more columns
> -----------------------------------------------------
>
> Key: HIVE-474
> URL: https://issues.apache.org/jira/browse/HIVE-474
> Project: Hadoop Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Alexis Rondeau
> Assignee: Amareshwari Sriramadasu
> Attachments: hive-474.0.4.2rc.patch
>
>
> The ability to select distinct several, individual columns as by example:
> select count(distinct user), count(distinct session) from actions;
> Currently returns the following failure:
> FAILED: Error in semantic analysis: line 2:7 DISTINCT on Different Columns
> not Supported user
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
