Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Mon, 8 Aug 2011 16:58:27 +0000 (UTC)
From: "Patrick Hunt (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: 
 <1079632664.17008.1312822707372.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <338078591.12553.1311785289766.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Commented] (HIVE-2315) DatabaseMetadata.getColumns() does
 not return partition column names for a table
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Patrick Hunt commented on HIVE-2315:
------------------------------------

Hi Mythili can you give an example of the query you are running? i.e. steps how to reproduce.

When I run the following from hive:

{noformat}
create table foo2 (a string, b string, c string) partitioned by (dt string) row format delimited fields terminated by '\t';
load data local inpath './data.txt' overwrite into table foo2 partition (dt='8');
load data local inpath './data.txt' overwrite into table foo2 partition (dt='9');
select * from foo2;
{noformat}

I see dt in the output (hive cli). 

When I run "select * from foo2" from Squirrel I also see dt in the output after applying this patch (I also see dt in the metadata reported by Squirrel for the table).


> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
>                 Key: HIVE-2315
>                 URL: https://issues.apache.org/jira/browse/HIVE-2315
>             Project: Hive
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 0.7.1
>            Reporter: Mythili Gopalakrishnan
>            Assignee: Patrick Hunt
>            Priority: Critical
>             Fix For: 0.8.0
>
>         Attachments: HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira