Default Push Profiles | Teradata Connector | QueryGrid - Default Push Profiles - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem

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
  },
  "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
  }
}'));

BigQuery Default Push Profile

EXECUTE TD_SERVER_DB.TD_CONN_REGISTER_PUSHPROFILE('BIGQUERY_V1', 'dummy', 'dummy', 'bigquery', 1, new JSON('{
"ColOp":[
  {
    "default":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":false,
  "remJoinTransAdj":0,
  "doMultiTblClustering":true,
  "doSingleTblDelayedFetch":false
  }
}'));

Generic JDBC Default Push Profile

EXECUTE TD_SERVER_DB.TD_CONN_REGISTER_PUSHPROFILE('GENERICJDBC_V1', 'dummy', 'dummy', 'genericjdbc', 1, new JSON('{
"ColOp":[
  {
    "default":true,
    "array":false,
    "CLOB": false,
    "BLOB": 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
  }
}'));
The Generic JDBC Connector default push profile is defined in such a way that it can work with a number of target database types. However, it does depend on the supportability of the operation by target database.