You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Mark Grover (JIRA)" <ji...@apache.org> on 2012/12/22 05:23:12 UTC
[jira] [Commented] (HIVE-3831) Add Command to Turn Sorting Off for
a Bucketed Table
[ 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
Re: [jira] [Commented] (HIVE-3831) Add Command to Turn Sorting Off
for a Bucketed Table
Posted by Edward Capriolo <ed...@gmail.com>.
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) <ji...@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
>