[ 
https://issues.apache.org/jira/browse/HIVE-3239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

N Campbell updated HIVE-3239:
-----------------------------

          Component/s: JDBC
    Affects Version/s: 0.8.1
    
> 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: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to