drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-5615) DatabaseMetadata.getColumns fails with SQL Server (Unknown SQL type -155, -150)
Date Thu, 29 Jun 2017 11:10:00 GMT

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

N Campbell updated DRILL-5615:
------------------------------
    Summary: DatabaseMetadata.getColumns fails with SQL Server  (Unknown SQL type -155, -150)
 (was: DatabaseMetadata.getColumns fails with SQL Serrver  (Unknown SQL type -155))

> DatabaseMetadata.getColumns fails with SQL Server  (Unknown SQL type -155, -150)
> --------------------------------------------------------------------------------
>
>                 Key: DRILL-5615
>                 URL: https://issues.apache.org/jira/browse/DRILL-5615
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - Java
>    Affects Versions: 1.10.0
>            Reporter: N Campbell
>
> Attempting to call DatabaseMetadata.getColumns against SQL Server 2016 will fail for
a datetimeoffset type.
> create type DISTSTZ from datetimeoffset;
> go
> create table "TDISTSTZ" ( "RNUM" integer  not null , "CDISTSTZ" DISTSTZ   );
> Exception in thread "main" java.sql.SQLException: Failure getting metadata: Unknown SQL
type -155
> 	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)



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message