Hive itself does not actually use the sorting to optimize any queries other then queries that can be optimized by index ( select min do not short circuit. They are still a full table scan)
On Fri, Dec 21, 2012 at 11:23 PM, Mark Grover (JIRA) <j...@apache.org>wrote: > > [ > https://issues.apache.org/jira/browse/HIVE-3831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13538663#comment-13538663] > > Mark Grover commented on HIVE-3831: > ----------------------------------- > > Bhushan, I am not sure I understand. > 2 things: > 1. If you wanted to disable sorting, can't you just set > {{hive.enforce.sorting}} to false before your queries. > 2. If you disable sorting, the metadata of the table would still reflect > that the table is sorted but the actual data would not be sorted. I can't > think of a scenario where that would be desirable. > > Thoughts? > > > Add Command to Turn Sorting Off for a Bucketed Table > > ---------------------------------------------------- > > > > Key: HIVE-3831 > > URL: https://issues.apache.org/jira/browse/HIVE-3831 > > Project: Hive > > Issue Type: Bug > > Reporter: Bhushan Mandhani > > Assignee: Bhushan Mandhani > > Priority: Minor > > > > If we have specified a bucketed table as sorted on some columns, there > is no Hive command to turn the sorting off for that table. There are > scenarios where we need to do this. > > -- > This message is automatically generated by JIRA. > If you think it was sent incorrectly, please contact your JIRA > administrators > For more information on JIRA, see: http://www.atlassian.com/software/jira >
