hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Hunt (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2315) DatabaseMetadata.getColumns() does not return partition column names for a table
Date Mon, 08 Aug 2011 16:58:27 GMT

    [ 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

        

Mime
View raw message