2.10 - Creating a Custom Push Profile - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K
Base the settings in custom push profiles on workload and the recommendations of your Teradata Customer Support Representative.
This procedure shows how to use the following macros to create custom push profiles.
  • Copy macro (TD_COPY_PUSHPROFILE).
  • Overwrite macro (TD_OVERWRITE_PUSHPROFILE).
Hive is used as an example. Use the same steps to create custom push profiles for Teradata and Presto.
  1. Create a custom push profile.
    Option Steps
    Copy and Overwrite the push profile
    1. Copy the default push profile and rename it.
      In the example below, the default push profile HIVE_V1 is copied and renamed Hive_Custom1.
      EXECUTE TD_COPY_PUSHPROFILE(‘HIVE_V1’, ‘Hive_Custom1’);
    2. Update the push profile.
      The following example uses the overwrite macro to overwrite an entire existing custom push profile (Hive_Custom1) with a new JSON specification.
      EXECUTE TD_OVERWRITE_PUSHPROFILE('Hive_Custom1', new JSON(‘{"SourceProfile":"Hive_V1",
      "ColOp":[{"timestamp":false,"varbyte":false,"byte":false,
      "CompareOp":{"default":true,"GT":false,"LT":false}
      "CastOp":{"default":false}}],
      "AggrOp":{"count":false}}’))