[jira] [Created] (HIVE-27531) Incorrect constraint name format in the output of show create table

["Soumyakanti Das (Jira)" <ji...@apache.org>]

Soumyakanti Das created HIVE-27531:
--------------------------------------

             Summary: Incorrect constraint name format in the output of show create table
                 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


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)