JDBC Driver for Drill

Since the MapR 1.4 release of Drill, MapR has provided a Drill JDBC driver that you can download (from package.mapr.com/tools/MapR-JDBC/MapR_Drill/) and use on all platforms to connect BI tools, such as SQuirreL and Spotfire, to Drill. The Drill JDBC driver provides read-only access to Drill data sources and complies with the JDBC 4.1 data standards, supporting JDBC API version 4.1.

Drill provides an ANSI SQL query layer and also exposes the metadata information through an ANSI SQL Standard metadata database called INFORMATION_SCHEMA. The Drill JDBC driver leverages INFORMATION_SCHEMA to expose Drill metadata to BI tools.

Note: The Drill JDBC driver provided by MapR is the driver recommended for MapR deployments. An Apache Drill open source driver is also available.