[HIVE-21681] Describe formatted shows incorrect information for multiple primary keys

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Assignee: Ádám Szita
• Reporter: Ádám Szita
• Created: 02/May/19 15:08
• Updated: 27/Feb/24 22:23
• Resolved: 10/May/19 07:59

Description

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:

CREATE TABLE test (
  p1 string,
  p2 string,
  p3 string,
  c0 int,
  PRIMARY KEY(p1,p2,p3) DISABLE NOVALIDATE
);
describe formatted test;

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.