[ https://issues.apache.org/jira/browse/HIVE-13351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hari Sankar Sivarama Subramaniyan updated HIVE-13351: ----------------------------------------------------- Description: ALTER TABLE TABLENAME DROP CONSTRAINT CONSTRAINTNAME; The CONSTRAINTNAME has to be associated with the mentioned table, i.e. there should be atleast 1 table column of TABLENAME participating in the constraint. Otherwise, we should throw an error. was: ALTER TABLE TABLENAME DROP CONSTRAINT CONSTRAINTNAME; The CONSTRAINTNAME has to be associated with the mentioned table. > Support drop Primary Key/Foreign Key constraints > ------------------------------------------------ > > Key: HIVE-13351 > URL: https://issues.apache.org/jira/browse/HIVE-13351 > Project: Hive > Issue Type: Sub-task > Components: CBO, Logical Optimizer > Reporter: Hari Sankar Sivarama Subramaniyan > Assignee: Hari Sankar Sivarama Subramaniyan > > ALTER TABLE TABLENAME DROP CONSTRAINT CONSTRAINTNAME; > The CONSTRAINTNAME has to be associated with the mentioned table, i.e. there > should be atleast 1 table column of TABLENAME participating in the constraint. > Otherwise, we should throw an error. -- This message was sent by Atlassian JIRA (v6.3.4#6332)