[
https://issues.apache.org/jira/browse/HIVE-3239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13657736#comment-13657736
]
Xiu commented on HIVE-3239:
---------------------------
This issue is fixed in the newest Hive Server 2 JDBC.
> exception will be thrown for timestamp column in resultset from getColumns
> metadata method
> ------------------------------------------------------------------------------------------
>
> Key: HIVE-3239
> URL: https://issues.apache.org/jira/browse/HIVE-3239
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.8.1
> Reporter: N Campbell
>
> create table cert.tts ( x int, y timestamp )
> describe the table column metadata using
> rs = meta.getColumns(null, "cert", "tts", "%");
> ..
> while (rs.next()) {
> for (int i = 1; i <= rsmd.getColumnCount(); i++) {
> if (i > 1) {
> System.out.print(",");
> }
> System.out.print(String.format("(%s)", rs.getObject(i)));
> .....
> 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)
> at bug.main(bug.java:232)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
