[
https://issues.apache.org/jira/browse/HIVE-27531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Soumyakanti Das updated HIVE-27531:
-----------------------------------
Summary: Unparse identifiers in show create table output (was: Incorrect
constraint name format in the output of show create table)
> Unparse identifiers in show create table output
> -----------------------------------------------
>
> Key: HIVE-27531
> URL: https://issues.apache.org/jira/browse/HIVE-27531
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Reporter: Soumyakanti Das
> Assignee: Soumyakanti Das
> Priority: Major
>
> Currently, {{SHOW CREATE TABLE}} on tables with constraints return {{ALTER
> TABLE}} statements with incompatible constraint names. Running the ALTER
> TABLE statements throw ParseException.
> For example:
> {code:java}
> 0: jdbc:hive2://localhost:11050/default> ALTER TABLE reason ADD CONSTRAINT
> 2e47abb2-b6c7-450a-8229-395d6b1ff168 PRIMARY KEY (r_reason_sk) DISABLE
> NOVALIDATE RELY;
> Error: Error while compiling statement: FAILED: ParseException line 1:43
> cannot recognize input near 'CONSTRAINT' '2e47abb2' '-' in add constraint
> statement (state=42000,code=40000) {code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
