...
SQL Server Data Type | CDAP Schema Data Type | Comments |
|---|---|---|
BIGINT | long | |
BINARY | bytes | |
BIT | boolean | |
CHAR | string | |
DATE | datetime | |
DATETIME | datetime (version 1.5.5 and later) timestamp (version 1.5.4 and earlier) | Users can manually set output schema to map it to timestamp. |
DATETIME2 | datetime (version 1.5.5 and later) timestamp (version 1.5.4 and earlier) | Users can manually set output schema to map it to timestamp. |
DATETIMEOFFSET | datetime (version 1.5.5 and later) string (version 1.5.4 and earlier) | Users can manually set output schema to map it to string. |
DECIMAL | decimal | |
FLOAT | double | |
IMAGE | bytes | |
INT | int | |
MONEY | decimal | |
NCHAR | string | |
NTEXT | string | |
NUMERIC | decimal | |
NVARCHAR | string | |
NVARCHAR(MAX) | string | |
REAL | float | |
SMALLDATETIME | timestamp | |
SMALLINT | int | |
SMALLMONEY | decimal | |
TEXT | string | |
TIME | time | TIME data type has the accuracy of 100 nanoseconds which is not currently supported. Values of this type will be rounded to microsecond. |
TINYINT | int | |
UDT | bytes | UDT types are mapped according to the type they are an alias of. For example, is there is an 'SSN' type that was created as'CREATE TYPE SSN FROM varchar(11);', that type would get mapped to a CDAP string. Common Language Runtime UDTs are mapped to CDAP bytes. |
UNIQUEIDENTIFIER | string | |
VARBINARY | bytes | |
VARBINARY(MAX) | bytes | |
VARCHAR | string | |
VARACHAR(MAX) | string | |
XML | string | |
SQLVARIANT | string | |
GEOMETRY | bytes | |
GEOGRAPHY | bytes |