Shengsheng Huang created HIVE-3199: -------------------------------------- Summary: 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: Shengsheng Huang
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 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