[HIVE-2358] JDBC DatabaseMetaData and ResultSetMetaData need to match for particular types

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 0.8.0
• Component/s: JDBC
• Hadoop Flags: Reviewed
• Assignee: Patrick D. Hunt
• Reporter: Patrick D. Hunt
• Created: 08/Aug/11 21:43
• Updated: 16/Dec/11 23:56
• Resolved: 15/Aug/11 07:23

Description

My patch for HIVE-1631 did not ensure the following (from comment on 1631):
-------------
Mythili Gopalakrishnan added a comment - 08/Aug/11 08:42

Just tested this fix and does NOT work correctly. Here are my findings on a FLOAT column

Without Patch on a FLOAT Column
--------------------------------
DatabaseMetaData.getColumns () COLUMN_SIZE returns 12
DatabaseMetaData.getColumns () DECIMAL_DIGITS - returns 0

ResultSetMetaData.getPrecision() returns 0
ResultSetMetaData.getScale() returns 0

With Patch on a FLOAT Column
----------------------------
DatabaseMetaData.getColumns () COLUMN_SIZE returns 24
DatabaseMetaData.getColumns () DECIMAL_DIGITS - returns 0

ResultSetMetaData.getPrecision() returns 7
ResultSetMetaData.getScale() returns 7

Also both DatabaseMetadata and ResultSetMetaData must return the same information for Precision and Scale for FLOAT,DOUBLE types.

Issue Links

• blocks: HIVE-1631 JDBC driver returns wrong precision, scale, or column size for some data types