Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB