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