Drill Drivers

Drill 1.10 introduced updated JDBC and ODBC drivers featuring client-to-drillbit connections using the following authentication options:
  • MapR-SASL
  • Kerberos
  • Plain (basic authentication with a username and password)

See MapR JDBC driver documenation for information about the MapR JDBC driver.

See MapR ODBC driver documenation for information about the MapR ODBC driver.

Driver Limitations

When using MapR SASL with JDBC or ODBC drivers, there is not a way to specify the target cluster name as part of the connection parameters. MapR SASL reads the first entry in the /opt/mapr/conf/mapr-clusters.conf file and assumes it is the target cluster name. For example, if the mapr-clusters.conf file has an entry for 'cluster1' followed by an entry for 'cluster2' and the user wants to connect to a node in 'cluster2', then authentication will fail. To work around this, the user must manually switch the order of entries in the mapr-clusters.conf file.

Driver Installation

For driver installation instructions, see ODBC/JDBC Interfaces in the Apache Drill documentation.