Gopal V created HIVE-20758:
------------------------------
Summary: 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
Reporter: Gopal V
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)
