[HIVE-4519] JDBC getColumnTypeName() should respond with the Hive-specifc type name for ARRAY, STRUCT and MAP

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.11.0
• Fix Version/s: 0.13.0
• Component/s: JDBC
• Assignee: Robert Roland
• Reporter: Robert Roland
• Created: 07/May/13 23:46
• Updated: 16/Jan/14 22:08
• Resolved: 16/Jan/14 22:08

Description

Per the Javadocs for ResultSetMetaData#getColumnTypeName():

"type name used by the database. If the column type is a user-defined type, then a fully-qualified type name is returned."

Hive's type for array, struct and map is not String. It is array, struct or map, using a JSON string serialization. Returning the Hive type here will allow you to programmatically determine if you should parse the value in the ResultSet as JSON.

ResultSetMetaData#getColumnType() should potentially return OTHER to indicate the column is a database-specific return type.

This would replace the fix provided HIVE-1378.

Issue Links

• blocks: HIVE-3015 org.apache.hadoop.hive.jdbc.HiveResultSetMetaData.getColumnClassName Method not supported