hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gunther Hagleitner (JIRA)" <>
Subject [jira] [Created] (HIVE-6348) Order by/Sort by in subquery
Date Sat, 01 Feb 2014 02:00:12 GMT
Gunther Hagleitner created HIVE-6348:

             Summary: Order by/Sort by in subquery
                 Key: HIVE-6348
             Project: Hive
          Issue Type: Bug
            Reporter: Gunther Hagleitner
            Priority: Minor

select * from (select * from foo order by c asc) bar order by c desc;

in hive sorts the data set twice. The optimizer should probably remove any order by/sort by
in the sub query unless you use 'limit '. Could even go so far as barring it at the semantic

This message was sent by Atlassian JIRA

View raw message