[ 
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

        

Reply via email to