[
https://issues.apache.org/jira/browse/HIVE-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14282786#comment-14282786
]
Pengcheng Xiong commented on HIVE-3199:
---------------------------------------
[~shane.huang], w.r.t. the JIRA HIVE-9194, shall we close this issue? Thanks.
> support select distinct *
> -------------------------
>
> Key: HIVE-3199
> URL: https://issues.apache.org/jira/browse/HIVE-3199
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Affects Versions: 0.9.0
> Reporter: Shane Huang
> Attachments: HIVE-3199.for0.9.0.patch
>
>
> Error is reported when running query "select distinct * from t".
> It is a common feature that is better to be supported.
> Did some investigation about this issue. In current implementation "select
> distinct a,b,c from t" is translated to "select a,b,c from t group by a,b,c".
> So select distinct * is translated literally to "select * from group by *".
> But * is not handled properly when processing groupby expressions.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
