[ https://issues.apache.org/jira/browse/HIVE-3167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13401151#comment-13401151 ]
Shengsheng Huang commented on HIVE-3167: ---------------------------------------- In current implementation "select distinct a,b,c" is silently translate to "select a,b,c group by a,b,c". So "select distinct *" is translate to "select * group by *". But * is not handled correctly when processing the GroupBy expressions. Should add some checking when translating select distinct to group by. > bad error message for select distinct * > --------------------------------------- > > Key: HIVE-3167 > URL: https://issues.apache.org/jira/browse/HIVE-3167 > Project: Hive > Issue Type: Bug > Reporter: Namit Jain > Attachments: HIVE-3167.1.patch > > > hive> select distinct * from src; > FAILED: Error in semantic analysis: Line 0:-1 Invalid function 'TOK_ALLCOLREF' > It is very difficult to understand the above error -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira