MapR 5.0 Documentation : 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

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

ExcludedSchemas

A list of schemas that do not appear in client applications. Use a comma (,) to separate schemas in the list.

None

No

PWD

The password that corresponds to the user name that you provided using the property UID.

None

Yes, if the server requires authentication for access.

UID

The name of the user accessing the Drill server.

None

Yes, if the server requires authentication for access.