Override Session Properties | Presto Connector | QueryGrid - Overriding Session Properties (Presto) - 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
Designating a Presto connector property as overridable in the QueryGrid portlet allows you to override configured Presto connector properties when running queries during an individual processing session.

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

trino: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. Perform one of the following:
    Option Description
    To override a Presto 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 Presto connector property to override and select the Overridable check box.
    6. Select OK.
    7. Select Save..
    To override a Presto 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 Presto link property to override and select the Overridable check box.
    6. Select OK.
    7. Select 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;';
    trino: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;