[ 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