[
https://issues.apache.org/jira/browse/HIVE-27532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated HIVE-27532:
----------------------------------
Labels: pull-request-available (was: )
> 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
> Priority: Major
> Labels: pull-request-available
>
> 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)
