hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-17039) Implement optimization rewritings that rely on database SQL constraints
Date Mon, 24 Jul 2017 20:32:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-17039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16099080#comment-16099080
] 

Sergey Shelukhin commented on HIVE-17039:
-----------------------------------------

Hmm... I thought the Hive SQL constraints are not enforced.

> 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)

Mime
View raw message