Override Session Properties | Hive Connector | QueryGrid - Overriding Session Properties (Hive) - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
lifecycle
latest
Product Category
Analytical Ecosystem
Hive has an available global session configuration that allows you to override any property and the overriding of Hive connector properties when running 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. Perform one of the following:
    Option Description
    To override a Hive connector property in the Connectors tab
    1. Select the Connectors tab.
    2. Select "" next to the connector that has a property to override.
    3. Select Edit.
    4. Select "" next to Connector Software.
    5. Find the Hive connector property to override and select the Overridable check box.
    6. Select OK.
    7. Select Save..
    To override a Hive connector property in the Links tab
    1. Select the Links tab.
    2. Select "" next to the link that has a property to override.
    3. Select Edit.
    4. Select "" next to Initiating Connector or Target Connector.
    5. Find the Hive link property to override and select the Overridable check box.
    6. Select OK.
    7. Select Save..
  4. To override the Hive connector property during a Hive session, use the syntax in the following example where the connector properties responseTimeout and linkBufferCount are overridden.
    SET <databaseName>.<nonNativeTableName>.override = responsetimeout = 3000000, linkBufferCount=3;
  5. [Optional] To override hadoopProperties when using the Hive connector that 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 ;
  6. [Optional] To clear Hive connector property overrides without closing a Hive session, use the syntax as in the following example.
    SET <databaseName>.<nonNativeTableName>.override = ;