Configuring Server-Side Properties

You can use the connector to apply configuration properties to the Spark server.

The following instructions describe how to configure server-side properties in a DSN and in the connector configuration tool. 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. Choose one:
    • To configure server-side properties for a DSN, 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.
    • Or, to configure server-side properties for a DSN-less connection, open the Simba Spark ODBC Driver Configuration tool, 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.

    3. Note:

    For a list of all Hadoop and Spark server-side properties that your implementation supports, type set -v at the Spark CLI command line. You can also execute the set -v query after connecting using the connector.

  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 change the method that the connector uses to apply server-side properties, do one of the following:
    • To configure the connector to apply each server-side property by executing a query when opening a session to the Spark server, select the Apply Server Side Properties With Queries check box.
    • Or, to configure the connector to use a more efficient method for applying server-side properties that does not involve additional network round-tripping, clear the Apply Server Side Properties With Queries check box.

    Note:

    The more efficient method is not available for Shark Server, and it might not be compatible with some Spark Thrift Server builds. If the server-side properties do not take effect when the check box is clear, then select the check box.

  7. To save your settings and close the Server Side Properties dialog box, click OK.

Related topics