2.06 - Overriding Session Properties - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.06
Published
September 2018
Language
English (United States)
Last Update
2018-11-26
dita:mapPath
blo1527621308305.ditamap
dita:ditavalPath
ft:empty
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 = ;