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 Impala server.

You can set the connection properties described below in a connection string, in a DSN (in the odbc.ini file), or as a connector-wide setting (in the simba.impalaodbc.ini file). Settings in the connection string take precedence over settings in the DSN, and settings in the DSN take precedence over connector-wide settings.

Important:

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

To configure server-side properties:

To set a server-side property, use the syntax SSP_[SSPKey]=[SSPValue], where [SSPKey] is the name of the server-side property and [SSPValue] is the value to specify for that property. For example, to set the MEM_LIMIT query option to 1 GB and the REQUEST_POOL query option to myPool, type the following in the odbc.ini file:

SSP_MEM_LIMIT=1000000000

SSP_REQUEST_POOL=myPool

Or, to set those properties in a connection string, type the following:

SSP_MEM_LIMIT={1000000000};SSP_REQUEST_POOL={myPool}

Note:

When setting a server-side property in a connection string, it is recommended that you enclose the value in braces ({ }) to make sure that special characters can be properly escaped.

To disable the connector's default behavior of converting server-side property key names to all lower-case characters, set the LCaseSspKeyName property to 0.

SSP_
Driver Configuration Options on page 1
Configuring the Driver on page 1