[
https://issues.apache.org/jira/browse/HIVE-18598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16348054#comment-16348054
]
Vineet Garg commented on HIVE-18598:
------------------------------------
First patch only patches CREATE TABLE statement. ALTER TABLE is yet to be
patched up.
> Disallow constraints with EXTERNAL table
> ----------------------------------------
>
> Key: HIVE-18598
> URL: https://issues.apache.org/jira/browse/HIVE-18598
> Project: Hive
> Issue Type: Task
> Components: SQL
> Reporter: Vineet Garg
> Assignee: Vineet Garg
> Priority: Major
> Attachments: HIVE-18598.1.patch
>
>
> Since Hive do not manage the data for external tables and can not enforce
> constraints it doesn't make sense to allow constraints like PRIMARY KEY, NOT
> NULL etc for such tables.
> User can still specify RELY to signal optimizer for constraint related
> optimizations.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
