hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Szita (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-21681) Describe formatted shows incorrect information for multiple primary keys
Date Fri, 10 May 2019 08:00:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-21681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Adam Szita updated HIVE-21681:
------------------------------
       Resolution: Fixed
    Fix Version/s: 4.0.0
           Status: Resolved  (was: Patch Available)

> 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
>             Fix For: 4.0.0
>
>         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)

Mime
View raw message