[ 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