[ https://issues.apache.org/jira/browse/DRILL-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
N Campbell updated DRILL-5615: ------------------------------ Description: 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) Similar problem with columns of VARIANT type was: 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) > 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) > Similar problem with columns of VARIANT type -- This message was sent by Atlassian JIRA (v6.4.14#64029)