Configuring Server-Side Properties

When connecting to a server that is running Impala 2.0 or later, you can use the connector to apply configuration properties to the server by setting the properties in the connection URL.

Important:

This feature is not supported for earlier versions of Impala, where the SET statement can only be executed from within the Impala shell.

For example, to set the MEM_LIMIT query option to 1 GB and the REQUEST_POOL query option to myPool, you would use a connection URL such as the following:

jdbc:impala://localhost:18000/default2;AuthMech=3;
UID=simba;PWD=simba;MEM_LIMIT=1000000000;REQUEST_POOL=myPool