hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eugene Koifman (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (HIVE-11858) Hive DISTRIBUTE BY & CROSS PRODUCT should not sort output
Date Thu, 05 Jan 2017 01:33:58 GMT

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

Eugene Koifman edited comment on HIVE-11858 at 1/5/17 1:32 AM:
---------------------------------------------------------------

Also, aggregate function w/o Group By

{noformat} select count(*), min(z) from T{noformat}

{noformat}select a from T where a = 1 order by a{noformat}


was (Author: ekoifman):
Also, aggregate function w/o Group By

{noformat} select count(*), min(z) from T{noformat}

> Hive DISTRIBUTE BY & CROSS PRODUCT should not sort output
> ---------------------------------------------------------
>
>                 Key: HIVE-11858
>                 URL: https://issues.apache.org/jira/browse/HIVE-11858
>             Project: Hive
>          Issue Type: Improvement
>          Components: Physical Optimizer, Tez
>    Affects Versions: 1.3.0, 2.0.0
>            Reporter: Gopal V
>            Assignee: Eugene Koifman
>
> {code}
> select a ,b from table distribute by a;
> {code}
> Should not do any sorts at all & should use the partitioned unsorted edge instead.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message