[HIVE-1126] Missing some Jdbc functionality like getTables getColumns and HiveResultSet.get* methods based on column name.

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Component/s: JDBC
• Hadoop Flags: Reviewed
• Assignee: Bennie Schut
• Reporter: Bennie Schut
• Created: 03/Feb/10 10:51
• Updated: 16/Dec/11 23:59
• Resolved: 30/Jul/10 00:12

Description

I've been using the hive jdbc driver more and more and was missing some functionality which I added

HiveDatabaseMetaData.getTables
Using "show tables" to get the info from hive.

HiveDatabaseMetaData.getColumns
Using "describe tablename" to get the columns.

This makes using something like SQuirreL a lot nicer since you have the list of tables and just click on the content tab to see what's in the table.

I also implemented
HiveResultSet.getObject(String columnName) so you call most get* methods based on the column name.

Issue Links

• is duplicated by: HIVE-1368 Hive JDBC Integration with SQuirrel SQL Client support Enhanced
• is part of: HIVE-576 complete jdbc driver
• is related to: HIVE-1378 Return value for map, array, and struct needs to return a string
• relates to: HIVE-1368 Hive JDBC Integration with SQuirrel SQL Client support Enhanced