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

[Soumyakanti Das (Jira)]

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)