2.10 - Overriding Session Properties - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K
Hive has an available global session configuration that allows users to override any property. This allows users to override Hive connector properties when starting queries during an individual processing session.

When overriding Hive connector properties for a Hive session, you must specify the non-native table whose Hive connector properties you want to override. Use commas as delimiters.

  1. Under Fabric Configuration, select Fabrics.
  2. Select the fabric.
  3. Do one of the following:
    Option Description
    To override a Hive connector property in the Connectors tab
    1. Click the Connectors tab.
    2. Click "" next to the connector that has a property you want to override.
    3. Select Edit.
    4. Click "" next to Connector Software.
    5. Find the Hive connector property you want to override and click the Overridable check box.
    6. Click OK.
    7. Click Save.
    To override a Hive connector property in the Links tab
    1. Click the Links tab.
    2. Click "" next to the link that has a property you want to override.
    3. Select Edit.
    4. Click "" next to Initiating Connector or Target Connector.
    5. Find the Hive link property you want to override and click the Overridable check box.
    6. Click OK.
    7. Click Save.
  4. To override the Hive connector property during a Hive session, use the syntax in the following example.
    SET <databaseName>.<nonNativeTableName>.override = responsetimeout = 3000000, linkBufferCount=3;
  5. [Optional] To override hadoopProperties when using the Hive connector and it is designated as overridable in the QueryGrid portlet, use the pipe (|) symbol to split Hadoop properties and a colon (:) to split name value pairs. The following example is used to override hadoopProperties during either a Hive or Presto session targeting a Hive connector:
    SET <databaseName>.<nonNativeTableName>.override = linkbuffersize=100000, DEFAULTSTRINGSIZE=32000, hadoopProperties=name1:value1 | name2:value2 ;
    The following example is used to override hadoopProperties during a Teradata Session targeting a Hive connector:
    SET FOREIGN SERVER ATTR = 'servername= hiveserver1; hadoopproperties=name1:value1|name2:value2;' FOR SESSION VOLATILE
  6. [Optional] To clear Hive connector property overrides without closing a Hive session, use the syntax in the following example.
    SET <databaseName>.<nonNativeTableName>.override = ;