in hologres-connector-flink-base/src/main/java/com/alibaba/ververica/connectors/hologres/utils/PostgresTypeUtil.java [48:120]
public static DataType fromJDBCType(ResultSetMetaData metadata, int colIndex)
throws SQLException {
String pgType = metadata.getColumnTypeName(colIndex);
switch (pgType) {
case PG_BOOLEAN:
return DataTypes.BOOLEAN();
case PG_BOOLEAN_ARRAY:
return DataTypes.ARRAY(DataTypes.BOOLEAN());
case PG_BYTEA:
case PG_BYTEA_ARRAY:
return DataTypes.BYTES();
case PG_SMALLINT:
return DataTypes.SMALLINT();
case PG_SMALLINT_ARRAY:
return DataTypes.ARRAY(DataTypes.SMALLINT());
case PG_INTEGER:
return DataTypes.INT();
case PG_INTEGER_ARRAY:
return DataTypes.ARRAY(DataTypes.INT());
case PG_BIGINT:
return DataTypes.BIGINT();
case PG_BIGINT_ARRAY:
return DataTypes.ARRAY(DataTypes.BIGINT());
case PG_REAL:
return DataTypes.FLOAT();
case PG_REAL_ARRAY:
return DataTypes.ARRAY(DataTypes.FLOAT());
case PG_DOUBLE_PRECISION:
return DataTypes.DOUBLE();
case PG_DOUBLE_PRECISION_ARRAY:
return DataTypes.ARRAY(DataTypes.DOUBLE());
case PG_NUMERIC:
return DataTypes.DECIMAL(
metadata.getPrecision(colIndex), metadata.getScale(colIndex));
case PG_NUMERIC_ARRAY:
return DataTypes.ARRAY(
DataTypes.DECIMAL(
metadata.getPrecision(colIndex), metadata.getScale(colIndex)));
case PG_CHAR:
case PG_CHARACTER:
return DataTypes.CHAR(1);
case PG_CHAR_ARRAY:
case PG_CHARACTER_ARRAY:
return DataTypes.ARRAY(DataTypes.CHAR(1));
case PG_TEXT:
case PG_CHARACTER_VARYING:
return DataTypes.STRING();
case PG_TEXT_ARRAY:
case PG_CHARACTER_VARYING_ARRAY:
return DataTypes.ARRAY(DataTypes.STRING());
case PG_TIMESTAMP:
return DataTypes.TIMESTAMP();
case PG_TIMESTAMP_ARRAY:
return DataTypes.ARRAY(DataTypes.TIMESTAMP());
// TODO: add timestamptz for Holo
case PG_TIMESTAMPTZ:
return DataTypes.TIMESTAMP();
case PG_TIMESTAMPTZ_ARRAY:
return DataTypes.ARRAY(DataTypes.TIMESTAMP());
case PG_TIME:
return DataTypes.TIME();
case PG_TIME_ARRAY:
return DataTypes.ARRAY(DataTypes.TIME());
case PG_DATE:
return DataTypes.DATE();
case PG_DATE_ARRAY:
return DataTypes.ARRAY(DataTypes.DATE());
default:
throw new UnsupportedOperationException(
String.format("Doesn't support Postgres type '%s' yet", pgType));
}
}