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

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": false, 
	"count" : true,
	"sum" : 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
      },
      "LogicalOp": {
        "default": true
      }
    }
  ],
  "JoinOp": {
    "inner": true
  },
  "AggrOp": {
    "default": 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_CONN_REGISTER_PUSHPROFILE (‘HIVE_V1’, ‘dummy’, ‘dummy’, 'hive', 1, new JSON('{
  "ColOp": [
    {
      "date": true,
      "char":true,
      "varchar":true,
      "byteint":true,
      "smallint":true,
      "integer":true,
      "bigint":true,
      "decimal":true,
      "real":true,
      "varbyte":true,
      "timestamp":true,
      "CompareOp": {
        "default": true,
        "overlap": false
      },
      "LogicalOp": {
        "default": true
      }
    }
  ],
  "JoinOp": {
    "inner": true
  },
  "AggrOp": {
    "default": false, 
	"count" : true,
	"sum" : true
  },
  "ServerSettings": {
    "importCostAdj": 1.00,
    "exportCostAdj": 1.50,
    "delayedFetchThresh": 0,
    "doCluster":true,
    "doRemoteJoin":true,
    "remJoinTransAdj":0,
    "doMultiTblClustering":true,
    "doSingleTblDelayedFetch":false
  }
}')