2.10 - Default Push Profiles - 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

Teradata Default Push Profile

EXECUTE TD_SERVER_DB.TD_CONN_REGISTER_PUSHPROFILE('TERADATA_V1', 'dummy', 'dummy', 'teradata', 1, new JSON('{
  "ColOp":  [
  {
    "default": true,
    "array": false,
    "CompareOp": {
      "default": true
    },
    "ArithOp": {
      "default": true
    },
    "LogicalOp": {
      "default": true
    }
  }
 ],
  "JoinOp": {
    "default": true
  },
  "AggrOp": {
    "default":  true
  },
  "ServerSettings": {
    "importCostAdj": 1.00,
    "exportCostAdj": 1.50,
    "delayedFetchThresh": 0,
    "doCluster": true,
    "doRemoteJoin": true,
    "remJoinTransAdj": 0,
    "doMultiTblClustering": true,
    "doSingleTblDelayedFetch": false
  }
 }
'));

Presto Default Push Profile

EXECUTE TD_SERVER_DB.TD_CONN_REGISTER_PUSHPROFILE('PRESTO_V1', 'dummy', 'dummy', 'presto', 1, new JSON('{
"ColOp": [
    {
      "default":true,
      "array":false,
      "CompareOp": {
        "default": true,
        "overlap":false
      },
      "ArithOp": {
        "default": true,
        "mod":false
      },
      "LogicalOp": {
        "default": true
      }
    }
  ],
  "JoinOp": {
    "inner": true
  },
  "AggrOp": {
    "count":true,
    "sum":true,
    "minimum":true,
    "maximum":true,
    "avg":true
  },
  "ServerSettings":{
    "importCostAdj": 1.00,
    "exportCostAdj": 1.50,
    "delayedFetchThresh": 0,
    "doCluster": true,
    "doRemoteJoin": true,
    "remJoinTransAdj": 0,
    "doMultiTblClustering": true,
    "doSingleTblDelayedFetch": false
  }
 }
'));

Hive Default Push Profile

EXECUTE TD_SERVER_DB.TD_CONN_REGISTER_PUSHPROFILE('HIVE_V1', 'dummy', 'dummy', 'hive', 1, new JSON('{
  "ColOp":[
    {
      "date":true,
      "char":true,
  
      "varchar":true,
      "byteint":true,
      "smallint":true,
      "int":true,
      "bigint":true,
      "decimal":true,
      "real":true,
      "varbyte":true,
      "timestamp":true,
      "CompareOp": {
        "default":true,
        "overlap":false
      },
      "ArithOp": {
        "default": true,
        "mod":false
      },
      "LogicalOp": {
        "default":true
      }
    }
  ],
  "JoinOp": {
    "inner":true
  },
  "AggrOp": {
    "count":true,
    "sum":true
  },
  "ServerSettings": {
    "importCostAdj": 1.00,
    "exportCostAdj": 1.50,
    "delayedFetchThresh": 0,
    "doCluster": true,
    "doRemoteJoin": true,
    "remJoinTransAdj": 0,
    "doMultiTblClustering": true,
    "doSingleTblDelayedFetch": false
    }
  }
'));

Spark Default Push Profile

EXECUTE TD_SERVER_DB.TD_CONN_REGISTER_PUSHPROFILE('SPARK_V1', 'dummy', 'dummy', 'spark', 1, new JSON('{
  "ColOp": [
    {
    "date": true,
    "byteint": true,
    "smallint": true,
    "int": true,
    "bigint": true,
    "decimal": true,
    "real": true,
    "varbyte": true,
    "timestamp": true,
    "CompareOp": {
      "default": true,
      "overlap": false
    },
    "ArithOp": {
      "default":true,
      "mod": false
    },
    "LogicalOp": {
      "default": true
    }
   }
  ],
  "JoinOp": {
    "inner": true
  },
  "AggrOp": {
    "count": true,
    "sum": true
    "minimum": true,
    "maximum": true,
    "avg": true
  },
  "ServerSettings": {
    "importCostAdj": 1.00,
    "exportCostAdj": 1.50,
    "delayedFetchThresh": 0,
    "doCluster": true,
    "doRemoteJoin": true,
    "remJoinTransAdj": 0,
    "doMultiTblClustering": true,
    "doSingleTblDelayedFetch": false
  }
 }
'));

Oracle Default Push Profile

EXECUTE TD_SERVER_DB.TD_CONN_REGISTER_PUSHPROFILE('ORACLE_V1', 'dummy', 'dummy', 'oracle', 1, new JSON('{
  "ColOp":[
    {
      "char":true,
      "varchar":true,
      "smallint":true,
      "int":true,
      "decimal":true,
      "number":true,
      "timestamp":true,
      "CompareOp":{
        "default":true,
        "overlap":false
      },
      "ArithOp":{
        "default":true,
        "mod":false
      },
      "LogicalOp":{
        "default":true
      }
    }
  ],
  "JoinOp":{
    "inner":true
  },
  "AggrOp":{
    "count":true,
    "sum":true
  },
  "ServerSettings":{
    "importCostAdj":1.00,
    "exportCostAdj":1.50,
    "delayedFetchThresh":0,
    "doCluster":true,
    "doRemoteJoin":true,
    "remJoinTransAdj":0,
    "doMultiTblClustering":true,
    "doSingleTblDelayedFetch":false
  }
}'));