[
https://issues.apache.org/jira/browse/HIVE-20758?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16652937#comment-16652937
]
Gopal V commented on HIVE-20758:
--------------------------------
bq. This will require calling metastore for all constraints (Default, pk/fk,
Check, Not null, Unique).
This is not a particularly performance sensitive operation, so that would still
be fine (because "desc formatted" wasn't very slow).
For me, this is was filed out of just sheer laziness on copying out schema
between clusters :)
> 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)
