[
https://issues.apache.org/jira/browse/HIVE-20758?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16763715#comment-16763715
]
Hive QA commented on HIVE-20758:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12958051/HIVE-20758.5.patch
{color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 15784 tests
executed
*Failed tests:*
{noformat}
org.apache.hive.jdbc.TestSSL.testMetastoreWithSSL (batchId=260)
{noformat}
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/15999/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15999/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15999/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 1 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12958051 - PreCommit-HIVE-Build
> 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, HIVE-20758.2.patch,
> HIVE-20758.3.patch, HIVE-20758.4.patch, HIVE-20758.5.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)
