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.