[HIVE-1368] Hive JDBC Integration with SQuirrel SQL Client support Enhanced

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.5.0
• Fix Version/s: 0.5.0
• Component/s: Clients

Environment

ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1

• Release Note: Hive JDBC Integration with SQuirrel SQL Client support Enhanced
• Assignee: Sunil Kumar
• Reporter: Sunil Kumar
• Created: 25/May/10 11:18
• Updated: 17/Dec/11 00:05
• Resolved: 09/Jun/10 00:09

Description

Hive JDBC Integration with SQuirrel SQL Client support Enhanced:-

Hive JDBC Client enhanced to browse hive default schema tables through Squirrel SQL Client.
This enhancement help to browse the hive table's structure i.e. table's column and their data type in the Squirrel SQL client interface and SQL query can be also performed on the tables through Squirrel SQL client.
To enable this following Hive JDBC Java files are modified and added:-
1. Methods of org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.java are updated.
2. Hive org.apache.hadoop.hive.jdbc.ResultSet.java updated and extended (org.apache.hadoop.hive.jdbc.ExtendedHiveResultSet.java) to support additional JDBC metadata
3. Methods of org.apache.hadoop.hive.jdbc. HiveResultSetMetaData are updated.
4. Methods of org.apache.hadoop.hive.jdbc. HiveConnection are updated.

Issue Links

• duplicates: HIVE-1126 Missing some Jdbc functionality like getTables getColumns and HiveResultSet.get* methods based on column name.
• is related to: HIVE-1126 Missing some Jdbc functionality like getTables getColumns and HiveResultSet.get* methods based on column name.