[ https://issues.apache.org/jira/browse/HIVE-27531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krisztian Kasa resolved HIVE-27531. ----------------------------------- Resolution: Fixed Merged to master. Thanks [~soumyakanti.das] for the patch. > 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 > Labels: pull-request-available > > 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} > Ideally all identifiers should be unparsed in the output of show create table. -- This message was sent by Atlassian Jira (v8.20.10#820010)