Building the Connection URL

Use the connection URL to supply connection information to the data store that you are accessing. The following is the format of the connection URL for the Simba Impala JDBC Connector, where [Host] is the DNS or IP address of the Impala server and [Port] is the number of the TCP port that the server uses to listen for client requests:

jdbc:impala://[Host]:[Port]

Note:

By default, the connector uses port 28000 when TransportMode is set to http, and 21050 when TransportMode is not set or is set to sasl or binary.

By default, the connector uses the schema named default.

You can specify optional settings such as the schema to use or any of the connection properties supported by the connector. For a list of the properties available in the connector, see Connector Configuration Options.

Note:

If you specify a property that is not supported by the connector, then the connector attempts to apply the property as a Impala server-side property for the client session. For more information, see Configuring Server-Side Properties.

The following is the format of a connection URL that specifies some optional settings:

jdbc:impala://[Host]:[Port]/[Schema];[Property1]=[Value];[Property2]=[Value];...

For example, to connect to port 18000 on an Impala server installed on the local machine, use a schema named default2, and authenticate the connection using a user name and password, you would use the following connection URL:

jdbc:impala://node1.example.com:18000/default2;AuthMech=3;
UID=simba;PWD=simba

Important:

  • Properties are case-sensitive.
  • Do not duplicate properties in the connection URL.