in flink-doris-connector/src/main/java/org/apache/doris/flink/tools/cdc/sqlserver/SqlServerType.java [53:114]
public static String toDorisType(String originSqlServerType, Integer precision, Integer scale) {
originSqlServerType = originSqlServerType.toLowerCase();
// For sqlserver IDENTITY type, such as 'INT IDENTITY'
// originSqlServerType is "int identity", so we only get "int".
String sqlServerType = originSqlServerType.split(" ")[0];
switch (sqlServerType) {
case BIT:
return DorisType.BOOLEAN;
case TINYINT:
return DorisType.TINYINT;
case SMALLINT:
return DorisType.SMALLINT;
case INT:
return DorisType.INT;
case BIGINT:
return DorisType.BIGINT;
case REAL:
return DorisType.FLOAT;
case FLOAT:
return DorisType.DOUBLE;
case MONEY:
return String.format("%s(%s,%s)", DorisType.DECIMAL_V3, 19, 4);
case SMALLMONEY:
return String.format("%s(%s,%s)", DorisType.DECIMAL_V3, 10, 4);
case DECIMAL:
case NUMERIC:
return precision != null && precision > 0 && precision <= 38
? String.format(
"%s(%s,%s)",
DorisType.DECIMAL_V3,
precision,
scale != null && scale >= 0 ? scale : 0)
: DorisType.STRING;
case DATE:
return DorisType.DATE_V2;
case DATETIME:
case DATETIME2:
case SMALLDATETIME:
return String.format(
"%s(%s)", DorisType.DATETIME_V2, Math.min(scale == null ? 0 : scale, 6));
case CHAR:
case VARCHAR:
case NCHAR:
case NVARCHAR:
return precision * 3 > 65533
? DorisType.STRING
: String.format("%s(%s)", DorisType.VARCHAR, precision * 3);
case TEXT:
case NTEXT:
case TIME:
case DATETIMEOFFSET:
case TIMESTAMP:
case UNIQUEIDENTIFIER:
case BINARY:
case VARBINARY:
case XML:
return DorisType.STRING;
default:
throw new UnsupportedOperationException(
"Unsupported SqlServer Type: " + sqlServerType);
}
}