[
https://issues.apache.org/jira/browse/HIVE-20758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gopal V updated HIVE-20758:
---------------------------
Affects Version/s: 4.0.0
> 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
> Priority: Major
>
> 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)
