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

Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL table

    Details

    • Type: Task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.0.0
    • Component/s: SQL
    • Labels:
      None

      Description

      HIVE-16605 is enabling/enforcing NOT NULL constraint. But since Hive do not manage the data for external tables and can not enforce constraints it doesn't make sense to allow NOT NULL constraints to be enabled/enforced on external table.
      User can still specify RELY to signal optimizer for constraint related optimizations.

        Attachments

        1. HIVE-18598.1.patch
          3 kB
          Vineet Garg
        2. HIVE-18598.2.patch
          441 kB
          Vineet Garg
        3. HIVE-18598.3.patch
          8 kB
          Vineet Garg
        4. HIVE-18598.4.patch
          8 kB
          Vineet Garg

          Issue Links

            Activity

              People

              • Assignee:
                vgarg Vineet Garg
                Reporter:
                vgarg Vineet Garg
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: