[ 
https://issues.apache.org/jira/browse/HIVE-1497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12929742#action_12929742
 ] 

John Sichi commented on HIVE-1497:
----------------------------------

Regarding the output format, none of the other SHOW commands currently produce 
column headers, and we probably won't be able to modify them for 
backwards-compatibility reasons.  What we ended up doing for DESCRIBE was to 
introduce DESCRIBE FORMATTED with the prettier format.

Let's do the same for SHOW INDEXES.  If we see SHOW FORMATTED INDEXES, produce 
the column headers; without FORMATTED, then omit them.  (We can open a separate 
JIRA for doing that retroactively for the existing SHOW commands.)

Also:  add a test case for a compound index (multiple columns in the key), and 
change that header to col_names plural.


> support COMMENT clause on CREATE INDEX, and add new commands for 
> SHOW/DESCRIBE indexes
> --------------------------------------------------------------------------------------
>
>                 Key: HIVE-1497
>                 URL: https://issues.apache.org/jira/browse/HIVE-1497
>             Project: Hive
>          Issue Type: Improvement
>          Components: Indexing
>    Affects Versions: 0.7.0
>            Reporter: John Sichi
>            Assignee: Russell Melick
>             Fix For: 0.7.0
>
>         Attachments: HIVE-1497.4.patch, HIVE-1497.5.patch, 
> hive-1497.p1.patch, hive-1497.p2.patch, hive-1497.p3.patch
>
>
> We need to work out the syntax for SHOW/DESCRIBE, taking partitioning into 
> account.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to