GitHub user laurentgo opened a pull request:
https://github.com/apache/drill/pull/601
Improve JDBC Metadata support
Improve Drill JDBC metadata support by upgrading Avatica version, adding
types filter to getTable Metadata API, and letting the JDBC driver using new
Metadata API instead of SQL queries.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/laurentgo/drill laurent/improve-jdbc-driver
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/601.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #601
----
commit 7072685e7c5e1969a2f0a14165638abe9db337fa
Author: Laurent Goujon <[email protected]>
Date: 2016-08-15T23:57:23Z
DRILL-4452: Uses Apache Calcite Avatica driver vs Optiq driver for Drill
JDBC
Drill JDBC driver uses Optiq Avatica as its basis, but this dependency has
been moved over to Calcite, for quite some time without Drill code being
updated for it.
This patch updates Avatica version to the version from Calcite
(1.4.0-drill-r10). It also refactors Drill JDBC driver to comply with the
packages and API changes in Avatica. Finally it fixes the the SQL types for
lists and structs, since Drill doesn't support java.sql.Array and
java.sql.Struct interfaces.
commit 5c103c20d8b9c78a7505b0adfffe1eb67952635a
Author: Laurent Goujon <[email protected]>
Date: 2016-09-27T00:14:59Z
DRILL-4880: Support JDBC driver registration using ServiceLoader
Support loading Drill driver using ServiceLoader. From the user perspective,
it means being able to use the driver without registering it first, like by
using
Class.forName("org.apache.drill.jdbc.Driver") for example.
commit 492a8daa727df73e5b81f7aa0853379d348504cb
Author: Laurent Goujon <[email protected]>
Date: 2016-09-27T20:37:31Z
DRILL-4925: Add tableType filter to GetTables metadata query
- Adding tableType filter to GetTablesReq query (needed for JDBC and ODBC
drivers).
- Fix table type returned by sys and INFORMATION_SCHEMA tables
- Also fixes some protobuf typos to related classes.
commit 993ca43f588f70d46dcffa13a6176942dec56cc9
Author: Laurent Goujon <[email protected]>
Date: 2016-10-03T21:13:23Z
DRILL-4730: Update JDBC DatabaseMetaData implementation to use new Metadata
APIs
Update JDBC driver to use Metadata APIs instead of executing SQL queries
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
