You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2017/07/05 12:48:00 UTC

[jira] [Created] (HIVE-17039) Implement optimization rewritings that rely on database SQL constraints

Jesus Camacho Rodriguez created HIVE-17039:
----------------------------------------------

             Summary: Implement optimization rewritings that rely on database SQL constraints
                 Key: HIVE-17039
                 URL: https://issues.apache.org/jira/browse/HIVE-17039
             Project: Hive
          Issue Type: New Feature
          Components: Logical Optimizer
    Affects Versions: 3.0.0
            Reporter: Jesus Camacho Rodriguez


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.

This ticket is an umbrella for all the rewriting optimizations based on SQL constraints that we will be including in Hive.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)