Hive
  1. Hive
  2. HIVE-3831

Add Command to Turn Sorting Off for a Bucketed Table

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Issue Links

          Activity

          Hide
          Mark Grover added a comment -

          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?

          Show
          Mark Grover added a comment - 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?
          Hide
          Mark Grover added a comment -

          For #1, I was referring to queries that populate the table.

          Show
          Mark Grover added a comment - For #1, I was referring to queries that populate the table.

            People

            • Assignee:
              Bhushan Mandhani
              Reporter:
              Bhushan Mandhani
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development