[
https://issues.apache.org/jira/browse/HIVE-21681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16834915#comment-16834915
]
Jesus Camacho Rodriguez commented on HIVE-21681:
------------------------------------------------
+1
> Describe formatted shows incorrect information for multiple primary keys
> ------------------------------------------------------------------------
>
> Key: HIVE-21681
> URL: https://issues.apache.org/jira/browse/HIVE-21681
> Project: Hive
> Issue Type: Bug
> Reporter: Adam Szita
> Assignee: Adam Szita
> Priority: Minor
> Attachments: HIVE-21681.0.patch, HIVE-21681.1.patch
>
>
> In tables with primary key spanning across multiple columns 'describe
> formatted' shows a maximum of two column names only: In the ASCII art table
> of 3 columns it will show:
> {{Column name|p1|p2}}
> Example queries:
> {code:java}
> CREATE TABLE test (
> p1 string,
> p2 string,
> p3 string,
> c0 int,
> PRIMARY KEY(p1,p2,p3) DISABLE NOVALIDATE
> );
> describe formatted test;{code}
> I propose we fix this so that primary key columns get listed one-by-one in
> separate rows, somewhat like how foreign keys are listed too.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
