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

Implement Auto increment, primary-foreign Key, not null constraints and default value in Hive Table columns

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 0.14.0
    • None
    • Database/Schema
    • None

    Description

      For Hive to replace a modern datawarehouse based on RDBMS, it must have support for keys, constraints, auto-increment values, surrogate keys and not null features etc. Many customers do not move their EDW to Hive due to these reasons as these have been challenging to maintain in Hive.

      This must be implemented once https://issues.apache.org/jira/browse/HIVE-5317 for Updates, Deletes and Inserts are done in Hive. This should be next step for Hive enhancement to take it closer to a very wide mainstream adoption..

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. HIVE-13061 Advance Hybrid Cloud Architecture (AHA) - Advance Hive (Umbrella) JIRA -- Enhanced Updates & others

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. HIVE-5317 Implement insert, update, and delete in Hive with full ACID support

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. HIVE-16575 Support for 'UNIQUE' and 'NOT NULL' constraints

          • Major - Major loss of function.
          • Closed

          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

          New Feature - A new feature of the product, which has yet to be developed. HIVE-18726 Implement DEFAULT constraint

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-13076 Implement FK/PK "rely novalidate" constraints for better CBO

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              codebunker Pardeep Kumar
              Votes:
              15 Vote for this issue
              Watchers:
              25 Start watching this issue

              Dates

                Created:
                Updated: