[HIVE-2957] Hive JDBC doesn't support TIMESTAMP column

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.8.1, 0.9.0
• Fix Version/s: 0.10.0
• Component/s: JDBC
• Hadoop Flags: Reviewed
• Assignee: Richard Ding
• Reporter: Bharath Ganesh
• Created: 17/Apr/12 14:25
• Updated: 06/Sep/15 15:22
• Resolved: 13/Sep/12 17:51

Description

Steps to replicate:
1. Create a table with at least one column of type TIMESTAMP
2. Do a DatabaseMetaData.getColumns () such that this TIMESTAMP column is part of the resultset.
3. When you iterate over the TIMESTAMP column it would fail, throwing the below exception:

Exception in thread "main" java.sql.SQLException: Unrecognized column type: timestamp
at org.apache.hadoop.hive.jdbc.Utils.hiveTypeToSqlType(Utils.java:56)
at org.apache.hadoop.hive.jdbc.JdbcColumn.getSqlType(JdbcColumn.java:62)
at org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData$2.next(HiveDatabaseMetaData.java:244)

Issue Links

• relates to: HIVE-11748 HivePreparedStatement's setTimestamp() does not quote value as required