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

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

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0
    • SQL
    • 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.4.patch
          8 kB
          Vineet Garg
        2. HIVE-18598.3.patch
          8 kB
          Vineet Garg
        3. HIVE-18598.2.patch
          441 kB
          Vineet Garg
        4. HIVE-18598.1.patch
          3 kB
          Vineet Garg

        Issue Links

          Dependent

          New Feature - A new feature of the product, which has yet to be developed. HIVE-16605 Enforce NOT NULL constraints

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-26130 Incorrect matching of external table when validating NOT NULL constraints

          • Major - Major loss of function.
          • In Progress

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: