Hi Liu, How to implement to support for distinct selection on two or more columns?
Regards Jian 2010/2/26 Liu (JIRA) <j...@apache.org> > > [ > https://issues.apache.org/jira/browse/HIVE-474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12838683#action_12838683] > > Liu commented on HIVE-474: > -------------------------- > > We have implemented this feature using union type, as metioned as "A2" by > Zheng. > > > 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 > > > > 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. > > -- Hadoop Forum: http://bbs.hadoopor.com