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
Designating a Presto connector property as overridable in the QueryGrid portlet allows users to override configured Presto connector properties when starting queries during an individual processing session.

Presto catalogs can define their own properties. You can view these properties using the show session command. This example shows the Presto session property called override in the Presto QueryGrid catalog p2p_active.

presto:default> show session;

 Name              |Value|Default|  Type  |                             
-------------------+---------------------------------------------------------
p2p_active.override|     |       | varchar| Properties to p2p_active.override

-----------------------------------------------------------+
for QG connector. Of form [name]=[value];[name]=[value];...
  1. Under Fabric Configuration, select Fabrics.
  2. Select the fabric.
  3. Do one of the following:
    Option Description
    To override a Presto 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 Presto connector property you want to override and click the Overridable check box.
    6. Click OK.
    7. Click Save.
    To override a Presto 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 Presto link property you want to override and click the Overridable check box.
    6. Click OK.
    7. Click Save.
  4. To override the Presto connector property during a Presto session, use the syntax in the following example. 
    set session p2p_active.override = ‘<prop1>=<overrideVal1>;<prop2>=<overrideVal2>;…’;
    For example:
    SET SESSION p2p_active.override='responsetimeout = 3000000;linkBufferCount=3;';
    presto:default> show session;

 Name               |     Value                                   |Default
--------------------+---------------------------------------------+-------
 p2p_active.override| responsetimeout = 3000000;linkBufferCount=3 |       

| Type  |  
+-----------------------------------------------------------------------   
|varchar|Properties to override for QG connector. Of form [name]=[value]; 
                     
---------------
[name]=[value];
  5. [Optional] To clear Presto connector property overrides without closing a Presto session, use the syntax in the following example. 
    reset session p2p_active.override;