[
https://issues.apache.org/jira/browse/DRILL-5614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
N Campbell updated DRILL-5614:
------------------------------
Description:
Using the 1.10 JDBC driver and server, a plugin mapped to ORACLE will throw an
exception when DatabaseMetadata.getColumns is called.
This will occur when an ORACLE table has a BINARY DOUBLE data type which they
assign the type value 101.
CREATE TABLE "ABC"."TBINDOUBLE"
( "RNUM" NUMBER(*,0),
"C1" BINARY_DOUBLE
) ;
Exception in thread "main" java.sql.SQLException: Failure getting metadata:
Unknown SQL type 101
at
org.apache.drill.jdbc.impl.DrillMetaImpl$MetadataAdapter.getMeta(DrillMetaImpl.java:310)
at
org.apache.drill.jdbc.impl.DrillMetaImpl.serverGetColumns(DrillMetaImpl.java:713)
at
org.apache.drill.jdbc.impl.DrillMetaImpl.getColumns(DrillMetaImpl.java:971)
at
oadd.org.apache.calcite.avatica.AvaticaDatabaseMetaData.getColumns(AvaticaDatabaseMetaData.java:621)
at
org.apache.drill.jdbc.impl.DrillDatabaseMetaDataImpl.getColumns(DrillDatabaseMetaDataImpl.java:1186)
Similar issues with interval day second, interval year month
was:
Using the 1.10 JDBC driver and server, a plugin mapped to ORACLE will throw an
exception when DatabaseMetadata.getColumns is called.
This will occur when an ORACLE table has a BINARY DOUBLE data type which they
assign the type value 101.
CREATE TABLE "ABC"."TBINDOUBLE"
( "RNUM" NUMBER(*,0),
"C1" BINARY_DOUBLE
) ;
Exception in thread "main" java.sql.SQLException: Failure getting metadata:
Unknown SQL type 101
at
org.apache.drill.jdbc.impl.DrillMetaImpl$MetadataAdapter.getMeta(DrillMetaImpl.java:310)
at
org.apache.drill.jdbc.impl.DrillMetaImpl.serverGetColumns(DrillMetaImpl.java:713)
at
org.apache.drill.jdbc.impl.DrillMetaImpl.getColumns(DrillMetaImpl.java:971)
at
oadd.org.apache.calcite.avatica.AvaticaDatabaseMetaData.getColumns(AvaticaDatabaseMetaData.java:621)
at
org.apache.drill.jdbc.impl.DrillDatabaseMetaDataImpl.getColumns(DrillDatabaseMetaDataImpl.java:1186)
> DatabaseMetadata.getColumns fails with ORACLE (Unknown SQL type 101, -104)
> --------------------------------------------------------------------------
>
> Key: DRILL-5614
> URL: https://issues.apache.org/jira/browse/DRILL-5614
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
> Affects Versions: 1.10.0
> Reporter: N Campbell
>
> Using the 1.10 JDBC driver and server, a plugin mapped to ORACLE will throw
> an exception when DatabaseMetadata.getColumns is called.
> This will occur when an ORACLE table has a BINARY DOUBLE data type which they
> assign the type value 101.
> CREATE TABLE "ABC"."TBINDOUBLE"
> ( "RNUM" NUMBER(*,0),
> "C1" BINARY_DOUBLE
> ) ;
> Exception in thread "main" java.sql.SQLException: Failure getting metadata:
> Unknown SQL type 101
> at
> org.apache.drill.jdbc.impl.DrillMetaImpl$MetadataAdapter.getMeta(DrillMetaImpl.java:310)
> at
> org.apache.drill.jdbc.impl.DrillMetaImpl.serverGetColumns(DrillMetaImpl.java:713)
> at
> org.apache.drill.jdbc.impl.DrillMetaImpl.getColumns(DrillMetaImpl.java:971)
> at
> oadd.org.apache.calcite.avatica.AvaticaDatabaseMetaData.getColumns(AvaticaDatabaseMetaData.java:621)
> at
> org.apache.drill.jdbc.impl.DrillDatabaseMetaDataImpl.getColumns(DrillDatabaseMetaDataImpl.java:1186)
> Similar issues with interval day second, interval year month
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
