[
https://issues.apache.org/jira/browse/HIVE-20758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Barnabas Maidics updated HIVE-20758:
------------------------------------
Attachment: HIVE-20758.1.patch
Status: Patch Available (was: Open)
Resubmitting the patch, since the Precommit test was triggered by an image :)
> 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, 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)
