N Campbell created DRILL-5619: --------------------------------- Summary: DatabaseMetadata.getColumns fails with Postgres Key: DRILL-5619 URL: https://issues.apache.org/jira/browse/DRILL-5619 Project: Apache Drill Issue Type: Bug Components: Client - JDBC Affects Versions: 1.10.0 Environment: Drill JDBC 1.10 and Drill server 1.10
Using Postgres postgresql-42.0.0.jar accessing Postgres 9.6 Reporter: N Campbell While DatabaseMetadata.getCatalogs and getSchemas does not abort. Attempting to invoke DatabaseMetadata.getTables passing the catalog name DRILL and the schema name returned by getSchemas will abort with Postgres. The same logic when performed with Drill mapped to ORACLE, SQL Server etc. does not abort. String [] types = { "TABLE" }; ResultSet tbl = dbMeta.getTables("DRILL", "certpostgres.dbcert", "%", types); Exception in thread "main" java.sql.SQLException: Failure getting metadata: at org.apache.drill.jdbc.impl.DrillMetaImpl$MetadataAdapter.getMeta(DrillMetaImpl.java:310) at org.apache.drill.jdbc.impl.DrillMetaImpl.serverGetTables(DrillMetaImpl.java:394) at org.apache.drill.jdbc.impl.DrillMetaImpl.getTables(DrillMetaImpl.java:428) at oadd.org.apache.calcite.avatica.AvaticaDatabaseMetaData.getTables(AvaticaDatabaseMetaData.java:587) at org.apache.drill.jdbc.impl.DrillDatabaseMetaDataImpl.getTables(DrillDatabaseMetaDataImpl.java:1145) -- This message was sent by Atlassian JIRA (v6.4.14#64029)