hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xiu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3239) exception will be thrown for timestamp column in resultset from getColumns metadata method
Date Wed, 15 May 2013 00:24:13 GMT

    [ 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

Mime
View raw message