Drill JDBC Driver Configuration Options

The following table lists the properties that you can use to configure the behavior of the Drill JDBC driver:

Property Description Default Value Required
auth (or AuthMech)

If the server you are connecting to does not require authentication, then do not set this property and do not specify any credentials in the connection URL.

If this property is not set but some credentials are specified in the connection URL, then the Drill client tries to detect and use the appropriate authentication mechanism.

  • MAPRSASL-The driver authenticates the connection using the MapR-SASL protocol.
  • PLAIN-The driver authenticates the connection using your Drill user name and password.
  • KERBEROS-The driver authenticates the connection using the Kerberos protocol.
None No
CastAnyToVarchar When set to true. the driver casts columns to VARCHAR if SQLColumns returns columns of type ANY.

When set to false, the driver does not change the returned columns.

false No
DelegationUID Use this option to delegate all operations against Drill to a specific user. The type is string. None No
ExcludedSchemas A list of schemas that do not appear in client applications. Use a comma (,) to separate schemas in the list. None No
keytab (or KrbKeytab) The full path and file name of the keytab file to use for Kerberos authentication. The type is string. None Yes, if authenticating the connection through Kerberos without providing the service principal name.
principal (or KRBPRincipal)

The complete service principal name to use for Kerberos authentication, including the primary and instance (and optionally, the Kerberos realm). The type is string.

For example:

bridget/maprdrill or cathy/maprdrill@DRILL.EXAMPLE.COM

None Yes, if using a complete service principal name to authenticate the connection through Kerberos.
PWD The password that corresponds to the user name that you provided using the property UID. The data type is string. None Yes, if you are authenticating the connection using your Drill credentials.
realm (or KrbRealm) The realm of the service principal. The default value depends on your Kerberos environment. The type is string. None

No. If your Kerberos configuration already defines the realm of the service principal as the default realm, then you do not need to configure this property.

service_host (or KrbHostFQDN) The host name of the drillbit. The type is string. None Yes, for Kerberos authentication.
service_name (or KrbServiceName)

The primary name of the service principal to use for Kerberos authentication. The type is string.

drill No
UID The name of the user accessing the Drill server.

If the AuthMech (or auth) property is set to Plain, then set this property to the user name that you use to access the Drill server.

Or, if the AuthMech (or auth) property is set to Kerberos, then set this property to the client principal name.

None Yes, if you are authenticating the connection using your Drill credentials or a Kerberos keytab.