[jira] [Created] (HIVE-21681) Describe formatted shows incorrect information for multiple primary keys

["Adam Szita (JIRA)" <ji...@apache.org>]

Adam Szita created HIVE-21681:
---------------------------------

             Summary: 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


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)