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

ALTER VIEW ADD (IF NOT EXISTS) PARTITION syntax is bad.

    Details

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

      Description

      The syntax, ALTER TABLE x ADD IF NOT EXISTS PARTITION, puts the "IF NOT EXISTS" before the subject of the statement. Not only is this weird grammar, but it is also inconsistent with other uses of "IF NOT EXISTS", for example, "CREATE TABLE IF NOT EXISTS" and "DROP TABLE IF EXISTS".

      It would be a minor improvement to align the syntaxes.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: