[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13081117#comment-13081117 ]
Patrick Hunt commented on HIVE-2315: ------------------------------------ Mythili, please take a look at the HIVE-2315_part2.patch file I just attached to this jira. The existing tests were not strongly verifying that "select * from table" was returning the partition column as part of the result set. I updated the test to do so. However subsequently the test is still passing (I verified in the debugger that this code is being executed). Please take a look at this test: org.apache.hadoop.hive.jdbc.TestJdbcDriver.doTestSelectAll(String, int, int) called from here: org.apache.hadoop.hive.jdbc.TestJdbcDriver.testSelectAllPartioned() So, afaict, we are returning the partition column as part of the result set. (I'm also seeing this in squirrel as I mentioned). Can you take a look at your setup again? Perhaps there is another issue somewhere in the Hive JDBC driver that's causing DBVizualizer to display this problem while Squirrel is fine? > 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, HIVE-2315_part2.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