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
}
}
'));
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
}
}'));
Arrow Flight SQL Default Push Profile
EXECUTE TD_SERVER_DB.TD_CONN_REGISTER_PUSHPROFILE('ARROW_V1', 'dummy', 'dummy', 'arrow', 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": {
"default": true
},
"AggrOp": {
"count": true,
"sum": true,
"minimum": true,
"maximum": true,
"avg": true
},
"ServerSettings": {
"importCostAdj": 1,
"exportCostAdj": 1,
"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.