Configure Asynchronous Queries | Teradata Query Service - Configuring Asynchronous Queries - Teradata Query Service

Teradata® Query Service Installation, Configuration, and Upgrade Guide for Customers

Product
Teradata Query Service
Release Number
4.01.02.02
Published
February 2022
Language
English (United States)
Last Update
2022-03-13
dita:mapPath
hsa1645169645769.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2700
Product Category
Analytical Ecosystem
When you set queries with an asyncResponse flag, the result sets are saved. You can set limits for these saving these metrics.
  1. From the Service Configuration view, click Advanced.
  2. Under Advanced Details, enter a number for any of the following metrics:
    Metric Description
    Maximum number of rows to spool per query Maximum number of rows that are returned by an asynchronous query.

    Default value: 1,000,000

    Maximum number of spooled result sets Number of result sets to keep.

    Increase this number if you have many short queries or a heavily used Query server.

    After this setting is reached, the oldest spool files are automatically deleted until approximately 10% of the maximum result set count is deleted.

    Default value: 1,000

    Maximum retention time for spooled result sets Number of hours results are stored for asynchronous queries before they are deleted.

    The minimum setting is 1 hour.

    Every hour, all spool files that exceed the maximum retention time are deleted.

    Default value: 24 hours

    Maximum space available for spooled result sets Total allocated space, in gigabytes, for saving result sets of asynchronous queries before they are deleted.

    After this setting is reached, the oldest spool files are automatically deleted until approximately 10% free space is reached.

    Increase this number for a heavily used Query server.

    Default value: 20 GB

  3. [Optional] Enter a new default location of the spool directory that stores the result sets for asynchronous queries.
    Current default location is /var/opt/teradata/rest/daemon/spool.
  4. Click Apply.