Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Message-ID: <5903568.82771289251808224.JavaMail.jira@thor>
Date: Mon, 8 Nov 2010 16:30:08 -0500 (EST)
From: "John Sichi (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Subject: [jira] Commented: (HIVE-1497) support COMMENT clause on CREATE
 INDEX, and add new commands for SHOW/DESCRIBE indexes
In-Reply-To: <10743623.97781280536156541.JavaMail.jira@thor>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ 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.