Re: [jira] Commented: (HIVE-474) Support for distinct selection on two or more columns

[jian yi <ey...@gmail.com>]

Hi Liu,

How to implement to support for distinct selection on two or more columns?

Regards
Jian

2010/2/26 Liu (JIRA) <ji...@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