[ https://issues.apache.org/jira/browse/HIVE-20758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Barnabas Maidics updated HIVE-20758: ------------------------------------ Status: Open (was: Patch Available) > Constraints: Show create table does not show constraints > -------------------------------------------------------- > > Key: HIVE-20758 > URL: https://issues.apache.org/jira/browse/HIVE-20758 > Project: Hive > Issue Type: Bug > Affects Versions: 4.0.0 > Reporter: Gopal V > Assignee: Barnabas Maidics > Priority: Major > Attachments: HIVE-20758.1.patch, HIVE-20758.2.patch, > HIVE-20758.3.patch, HIVE-20758.4.patch, HIVE-20758.5.patch, Screen Shot > 2019-01-23 at 11.52.04.png > > > Even though the desc formatted shows the constraints, the show create table > does not > {code} > | # Primary Key | NULL > | NULL > | > | Table: | > tpcds_bin_partitioned_orc_10000.inventory | NULL > | > | Constraint Name: | pk_in > | NULL > | > | Column Names: | inv_date_sk > | inv_item_sk > | > | | NULL > | NULL > | > | # Foreign Keys | NULL > | NULL > | > | Table: | > tpcds_bin_partitioned_orc_10000.inventory | NULL > | > | Constraint Name: | inv_d > | NULL > | > | Parent Column Name:tpcds_bin_partitioned_orc_10000.date_dim.d_date_sk | > Column Name:inv_date_sk | Key Sequence:1 > | > | | NULL > | NULL > | > | Constraint Name: | inv_i > | NULL > | > | Parent Column Name:tpcds_bin_partitioned_orc_10000.item.i_item_sk | Column > Name:inv_item_sk | Key Sequence:1 > | > | | NULL > | NULL > | > | Constraint Name: | inv_w > | NULL > | > | Parent Column Name:tpcds_bin_partitioned_orc_10000.warehouse.w_warehouse_sk > | Column Name:inv_warehouse_sk | Key Sequence:1 > | > | | NULL > | NULL > | > {code} > But > {code} > +----------------------------------------------------+ > | createtab_stmt | > +----------------------------------------------------+ > | CREATE TABLE `inventory`( | > | `inv_item_sk` bigint, | > | `inv_warehouse_sk` bigint, | > | `inv_quantity_on_hand` int, | > | `inv_date_sk` bigint) | > | ROW FORMAT SERDE | > | 'org.apache.hadoop.hive.ql.io.orc.OrcSerde' | > | STORED AS INPUTFORMAT | > | 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' | > | OUTPUTFORMAT | > | 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' | > | LOCATION | > | > 'hdfs:///warehouse/tablespace/managed/hive/tpcds_bin_partitioned_orc_10000.db/inventory' > | > | TBLPROPERTIES ( | > | 'bucketing_version'='2', | > | 'transactional'='true', | > | 'transactional_properties'='default', | > | 'transient_lastDdlTime'='1539710410') | > +----------------------------------------------------+ > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)