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] [Created] (DRILL-5619) DatabaseMetadata.getColumns fails with Postgres
Date Thu, 29 Jun 2017 11:29:00 GMT
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

View raw message