2.06 - Creating a Custom Push Profile

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.

Create a custom push profile.

Option	Steps
Using the update macro	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’); 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}}’))

Option

Steps

Using the update macro

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’);
```
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}}’))

Type the following to view a custom push profile. EXECUTE TD_SHOW_EXPANDED_PUSHPROFILE('name of custom push profile');