Perfiles de inserción predeterminados - Teradata QueryGrid

Teradata® QueryGrid™ Guía de instalación y uso- 3.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.00
Published
Marzo de 2023
Language
Español
Last Update
2023-04-04
dita:mapPath
es-ES/dtm1676313130103.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-5991
Product Category
Analytical Ecosystem

Perfil de inserción predeterminado de Teradata

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

Perfil de inserción predeterminado de Presto

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

Perfil de inserción predeterminado de Hive

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

Perfil de inserción predeterminado de Spark

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

Perfil de inserción predeterminado de Oracle

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

Perfil de inserción predeterminado de BigQuery

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

Perfil de inserción predeterminado de Generic JDBC

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
  }
}'));
El perfil de inserción predeterminado del conector Generic JDBC se define de tal manera que puede funcionar con varios tipos de base de datos de destino. Sin embargo, depende de la compatibilidad de la operación con la base de datos de destino.