You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Gopal V (JIRA)" <ji...@apache.org> on 2018/10/16 23:53:00 UTC
[jira] [Created] (HIVE-20758) Constraints: Show create table does
not show constraints
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)