Hive
  1. Hive
  2. HIVE-2537

Disallow useless DISTRIBUTE BY/SORT BY/CLUSTER BY in strict mode

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      This query:

      CREATE TABLE my_tablename AS
      SELECT a, b, c
      FROM somewhere
      CLUSTER BY c;

      ...has an unnecessary CLUSTER BY, because the resulting data will be loaded into a non-bucketed table without any enforcement of bucketing. We should disallow this in strict mode.

        Activity

        Adam Kramer created issue -

          People

          • Assignee:
            Unassigned
            Reporter:
            Adam Kramer
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development