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 <laur...@dremio.com> 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 <laur...@dremio.com> 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 <laur...@dremio.com> 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 <laur...@dremio.com> 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 infrastruct...@apache.org or file a JIRA ticket with INFRA. ---