SSP_

Set a server-side property by using the following syntax, where [SSPKey] is the name of the server-side property and [SSPValue] is the value for that property:

SSP_[SSPKey]=[SSPValue]

For example:

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}

After the connector applies the server-side property, the SSP_ prefix is removed from the DSN entry, leaving an entry of [SSPKey]=[SSPValue].

Important:

This property is supported only for connections to Impala 2.0 or later. In earlier versions of Impala, the SET statement can only be executed from within the Impala shell.

Note:

  • The SSP_ prefix must be upper case.
  • 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.

Key Name Default Value Required

SSP_

None

No