Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # dev >> Re: [jira] [Commented] (HIVE-3831) Add Command to Turn Sorting Off for a Bucketed Table


Copy link to this message
-
Re: [jira] [Commented] (HIVE-3831) Add Command to Turn Sorting Off for a Bucketed Table
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) <[EMAIL PROTECTED]>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
>