You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Zheng Shao (JIRA)" <ji...@apache.org> on 2009/02/24 23:20:02 UTC

[jira] Updated: (HIVE-300) DISTRIBUTE BY should support expressions

     [ https://issues.apache.org/jira/browse/HIVE-300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zheng Shao updated HIVE-300:
----------------------------

    Attachment: HIVE-300.1.patch

Modified the syntax. No code change is needed.

> 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.