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.

Important:

Important:

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

The following instructions describe how to configure server-side properties in a DSN. You can specify the connection settings described below in a DSN, in a connection string, or as connector-wide settings. Settings in the connection string take precedence over settings in the DSN, and settings in the DSN take precedence over connector-wide settings.

To configure server-side properties:

  1. To configure server-side properties, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, then click Advanced Options, and then click Server Side Properties.
  2. To create a server-side property, click Add, then type appropriate values in the Key and Value fields, and then click OK. For example, to set the value of the MEM_LIMIT query option to 1 GB, type MEM_LIMIT in the Key field and then type 1000000000 in the Value field.
  3. To edit a server-side property, select the property from the list, then click Edit, then update the Key and Value fields as needed, and then click OK.
  4. To delete a server-side property, select the property from the list, and then click Remove. In the confirmation dialog box, click Yes.
  5. To configure the connector to convert server-side property key names to all lower-case characters, select the Convert Key Name To Lower Case check box.
  6. To save your settings and close the Server Side Properties dialog box, click OK.

Related topics