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