...
Oracle Data Type | CDAP Schema Data Type | Support | Comment | ||
---|---|---|---|---|---|
VARCHAR2 | Schema.Type.STRING | * | No such type in java.sql.Types, mapping to String by default | + | |
NVARCHAR2 | Schema.Type.STRING | * | No such type in java.sql.Types, mapping to String by default+ | ||
VARCHAR | Schema.Type.STRING | + | |||
NUMBER | Schema.LogicalType.DECIMAL | + | |||
FLOAT | Schema.Type.DOUBLE | + | FLOAT(126) by default value is represented internally as NUMBER | ||
LONG | Schema.Type.STRING | + | Character data of variable length. | ||
DATE | Schema.LogicalType.DATETIMESTAMP_MICROS | + | |||
BINARY_FLOAT | Schema.Type.FLOAT | + | |||
BINARY_DOUBLE | Schema.Type.DOUBLE | + | |||
TIMESTAMP | Schema.LogicalType.TIMESTAMP_MICROS | + | |||
TIMESTAMP WITH TIME ZONE | Schema.LogicalType.TIMESTAMP_MICROS | +* | Currently converted to UTC time, modifying original time zone. | ||
TIMESTAMP WITH LOCAL TIME ZONE | Schema.LogicalType.TIMESTAMP_MICROS | + | |||
INTERVAL YEAR TO MONTH | Schema.Type.STRING | + | |||
INTERVAL DAY TO SECOND | Schema.Type.STRING | + | |||
RAW | Schema.Type.BYTES | + | |||
LONG RAW | - | Type is deprecated by OracleSchema.Type.BYTES | + | ||
ROWID | Schema.Type.STRING | + | |||
UROWID | Schema.Type.STRING | * | No such type in java.sql.Types, mapping to String by default+ | ||
CHAR | Schema.Type.STRING | + | |||
NCHAR | Schema.Type.STRING | + | |||
CLOB | Schema.Type.STRING | + | |||
NCLOB | Schema.Type.STRING | + | |||
BLOB | Schema.Type.BYTES | + | |||
BFILE | - | Type is deprecated by Oracle |
...