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

Expose SQL database constraints to Calcite

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • Logical Optimizer
    • None

    Description

      Hive already has support to declare multiple SQL constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, and NOT NULL). Although these constraints cannot be currently enforced on the data, they can be made available to the optimizer by using the 'RELY' keyword.

      Currently, even when they are declared with the RELY keyword, they are not exposed to Calcite.

      Attachments

        1. HIVE-17054.patch
          16 kB
          jcamachorodriguez

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. HIVE-17039 Implement optimization rewritings that rely on database SQL constraints

          • Major - Major loss of function.
          • Resolved
          causes

          Bug - A problem which impairs or prevents the functions of the product. HIVE-18482 Copy-paste error in the RelOptHiveTable

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed
          Is contained by

          New Feature - A new feature of the product, which has yet to be developed. HIVE-17432 Enable join and aggregate materialized view rewriting

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

          Web Link RB link

          Activity

            People

              jcamacho Jesús Camacho Rodríguez
              jcamacho Jesús Camacho Rodríguez
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: