[ 
https://issues.apache.org/jira/browse/HIVE-300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12676432#action_12676432
 ] 

Prasad Chakka commented on HIVE-300:
------------------------------------

+1

> DISTRIBUTE BY should support expressions
> ----------------------------------------
>
>                 Key: HIVE-300
>                 URL: https://issues.apache.org/jira/browse/HIVE-300
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Query Processor
>    Affects Versions: 0.2.0, 0.3.0
>            Reporter: Zheng Shao
>         Attachments: HIVE-300.1.patch
>
>
> We should support this kind of query.  Distribute By only generates the 
> hash-code, so it's easy to allow expressions (while it will be hard for Sort 
> By and Cluster By).
> {code}
> SELECT a.key, a.value FROM a
> DISTRIBUTE BY rand()
> {code}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to