JDBC

The Dremio JDBC driver is included as a part of Dremio installations under <DREMIO_HOME>/jars/jdbc-driver/. The main JAR Class is com.dremio.jdbc.Driver.

Setup

You can set up the JDBC driver in the following manner:

  • Connect directly to the Dremio server
  • Connect to the Dremio server via Zookeeper

Connecting direct to server

The following configuration establishes a direct connection to a Dremio coordinator node. Planning is done on the specified node.

jdbc:dremio:direct=<DREMIO_COORDINATOR>:31010[;schema=<OPTIONAL_SCHMEMA>]

Connecting to ZooKeeper

The following configuration established a distributed connection to Dremio coordinator nodes through a Zookeeper quorum. Planning is distributed across the available coordinator nodes.

jdbc:dremio:zk=<ZOOKEPER_QUORUM>:2181[;schema=<OPTIONAL_SCHMEMA>]

Multiple Dremio Clusters in the same ZooKeeper Quorum

Cluster A

jdbc:dremio:zk=<ZOOKEPER_QUORUM>:2181/path/to/ClusterA

Cluster B

jdbc:dremio:zk=<ZOOKEPER_QUORUM>:2181/path/to/ClusterB

JDBC Parameters for Dremio wire encryption

If you are setting up encrypted communication between your ODBC/JDBC client applications and the Dremio server, use the SSL JDBC connection parameters and fully qualified host name to configure the JDBC connection string and connect to Dremio.

Parameter Value Required
ssl true/false [Optional] If true, SSL is enabled. If not set or set to false, SSL is not enabled.
trustStoreType string [Optional] Default: JKS The trustStore type. Allowed values are : JKS PKCS12

If the useSystemTrustStore option is set to true (on Windows only), the allowed values are: Windows-MY Windows-ROOT
Import the certificate into the "Trusted Root Certificate Authorities” and set trustStoreType=Windows-ROOT.
Also import the certificate into "Trusted Root Certificate Authorities" or "Personal" and set trustStoreType=Windows-MY.
trustStorePath string [Optional] Path to the truststore.
If not provided, the default Java truststore is used.
If this is not provided, the trustStorePassword parameter is ignored.

Note that the order for looking for the default trustStore then java-home/lib/security/jssecacerts
trustStorePassword string [Optional] Password to the truststore.
disableHostVerification true/false [Optional] If true, we will not verify that the host in the certificate is the host we are connecting to. False by default.

(Hostname verification follows the specification in RFC2818)

results matching ""

    No results matching ""