2.06 - Creating a Custom Push Profile - 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
The settings in custom push profiles should be based on workload and the recommendations of your Teradata Customer Support Representative.
The following procedure shows how to use one of the following macros to create custom push profiles.
  • Update macro (TD_UPDATE_PUSHPROFILE). This macro uses the existing push profile name, the JSONPath of the operation that needs to be overwritten, and a JSON document containing the new values for the operation.
  • Overwrite macro (TD_OVERWRITE_PUSHPROFILE). This macro contains JSON that overwrites the entire push profile named in the macro.
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
    Using the update macro
    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. Use the update macro to update the custom push profile with a new JSON specification.
      In the example below, CompareOp in the custom push profile Hive_Custom1 is overwritten with a new JSON specification, which is ('default':false).
      EXECUTE TD_UPDATE_PUSHPROFILE(‘Hive_Custom1’, ‘$.ColOp[0].CompareOp’, new JSON(‘{default : false}’));
    Using the overwrite macro In the example below, the overwrite macro is used 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}}’))
    
  2. Type the following to view a custom push profile. EXECUTE TD_SHOW_EXPANDED_PUSHPROFILE('name of custom push profile');