Data type support & mapping for Oracle sources
Oracle source type | BigQuery | Databricks | MySQL | Oracle | PostgreSQL | Snowflake | Spanner | SQL Server / Azure Synapse |
---|---|---|---|---|---|---|---|---|
binary_double | float64 | double | double | double precision | double Precision | float | float64 | float(s) |
binary_float | float64 | float | float(s) | float | real | float | float64 | float(s) |
blob | bytes | binary | longblob | blob | bytea | binary | bytes(p) bytes(max) if p > 10485760 | in Striim 4.2.0.3 and earlier: varbinary(p) if <= 8000 varbinary(max) if > 8000 in Striim 4.2.0.4 and later: varbinary(max) |
character | string | string | character(1) | character(1) | character(1) | character(1) | string(1) | character(1) |
character(s) | string | string | character(s) longtext if (s)>255 | character(s) | character(s) | character(s) | string(s) | character(s) |
clob | string | string | text | clob | text | varchar | string(4000) string(max) if (s) > 2621440 | in Striim 4.2.0.3 and earlier: varchar(s) varchar(max) if (s) > 8000 in Striim 4.2.0.4 and later: varchar(max) |
date | date | date | datetime | date | timestamp without time zone | date | date | datetime2 |
float | float64 | float | double | float | double precision | float | float64 | varchar(8000) |
float(s) | float64 | float | float(s) | float | double precision | float | float64 | float(s) |
int | numeric | decimal(38) | decimal(38,0) | number(38,0) | numeric(38,0) | numeric(38,0) | float64 | numeric(38,0) |
interval day to second | string | string | varchar(100) | interval day(2) to second(6) | character varying | varchar | string(max) | varchar(100) |
interval year to Month | string | string | varchar(100) | interval year(2) to month | character varying | varchar | string(max) | varchar(100) |
long* | bytes | binary | longblob | longblob | bytea | binary | bytes(max) | varbinary(max) |
long_raw* | bytes | binary | longblob | longblob | bytea | binary | bytes(max) | varbinary(max) |
nchar(s) | string | string | nvarchar(s) | nchar(s) | character(s) | character(s) | string(s) | nchar(s) |
nclob | string | string | longtext | nclob | text | varchar | string(s) string(max) if > 2621440 | nvarchar if <= 4000 nvarchar(max) if > 4000 |
number | numeric | decimal(38) | decimal(65) | number | numeric | numeric | float64 | numeric(38) |
number(p,s) | numeric string if (s)>9 | decimal(p,s) (if p<=38 and s<=37) string (if p>38 or s>37) | decimal(p,s) | numeric(p,s) | numeric (p,s) | numeric(p,s) | numeric string(max) if (s)>15 | numeric(p,s) |
number(p) | numeric | decimal(p,0) (if p <= 38) string (if p>38) | decimal(p,0) | number(p,0) | numeric(p,0) | numeric(p,0) | float64 | numeric(p,0) |
nvarchar2(s) | string | string | nvarchar(s) | nvarchar2(s) | character varying(s) | varchar(s) | string(s) | nvarchar(s) |
Object type | not supported | Not Supported | not supported | not supported | not supported | not supported | not supported | not supported |
raw | bytes | binary | longblob | blob | bytea | binary | bytes(p) bytes(max) if > 10485760 | varbinary(p) if <= 8000 varbinary(max) if > 8000 |
timestamp | datetime | timestamp | datetime | timestamp | timestamp without timezone | timestamp | timestamp | datetime2 |
timestamp with local time zone | timestamp | timestamp | datetime | timestamp with time zone | timestamp with time zone | timestamp with time zone | timestamp | datetimeOffset |
timestamp with time zone | timestamp | timestamp | datetime | timestamp with time zone | timestamp with time zone | timestamp with time zone | timestamp | datetimeoffset |
varchar | string | string | varchar(s) | Mapped with varchar(s) | character varying(s) | Mapped with varchar(s) | string(s) | varchar(s) |
varchar2(s) | string | string | varchar(s) | varchar2(s) | character Varying(s) | varchar(s) | string(s) | varchar(s) |
xml | string | string | longtext | xmltype | xml | varchar | string(max) | xml |
*OJet supports these types, but Oracle Reader does not. Oracle suggests using CLOB in place of LONG or LONG RAW. Oracle source types ADT, ARRAY, BFILE, LONG, LONG RAW, NESTED TABLE, REF, ROWID, SD0_GEOMETRY, UDT, and UROWID are not supported. VARCHAR with a JSON constraint is not supported in this release (DEV-26815). |