Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-3831

Add Command to Turn Sorting Off for a Bucketed Table

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: 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
          mgrover 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
          mgrover 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
          mgrover Mark Grover added a comment -

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

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

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development