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