[jira] [Created] (HIVE-27532) Missing semicolon in show create table output

[Soumyakanti Das (Jira)]

Soumyakanti Das created HIVE-27532:
--------------------------------------

             Summary: Missing semicolon in show create table output
                 Key: HIVE-27532
                 URL: https://issues.apache.org/jira/browse/HIVE-27532
             Project: Hive
          Issue Type: Bug
          Components: Hive
            Reporter: Soumyakanti Das
            Assignee: Soumyakanti Das


When we run SHOW CREATE TABLE on a table with constraints, it doesn't add a 
semi-colon to the create table ddl. Here's an output for tpcds table reason:


{code:java}
 CREATE TABLE `reason`(
   `r_reason_sk` int,
   `r_reason_id` string,
   `r_reason_desc` string)
 ROW FORMAT SERDE
   'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
 WITH SERDEPROPERTIES (
   'field.delim'='|',
   'serialization.format'='|')
 STORED AS ORC
 TBLPROPERTIES (
   'transactional'='true',
   'OBJCAPABILITIES'='EXTREAD,EXTWRITE',
   'STATS_GENERATED'='TASK',
   'impala.lastComputeStatsTime'='1674074181',
   'serialization.null.format'='',
   'transient_lastDdlTime'='1674073496')
 ALTER TABLE reason ADD CONSTRAINT 2e47abb2-b6c7-450a-8229-395d6b1ff168 PRIMARY 
KEY (r_reason_sk) DISABLE NOVALIDATE RELY; {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)