This table identifies the ASE datatype, the Replication Definition datatype, and the Hive datatype.
ASE datatype | Replication Definition datatype | Hive datatype |
---|---|---|
bigint | bigint | bigint |
int | Integer | int |
smallint | smallint | smallint |
unsigned bigint | unsigned bigint | varchar |
unsigned int | unsigned int | bigint |
unsigned smallint | unsigned smallint | int |
tinyint | tinyint | smallint |
int identity | integer | int |
numeric | numeric | decimal |
decimal | decimal | decimal |
float | float | double |
real | real | float |
double precision | float | double |
money | money | decimal |
smallmoney | smallmoney | decimal |
datetime | datetime | timestamp |
smalldatetime | smalldatetime | timestamp |
bigdatetime | bigdatetime | timestamp |
date | date | date |
time | time | timestamp |
char | char | char |
varchar | varchar | varchar |
unichar | unichar | varchar |
univarchar | univarchar | varchar |
nchar | char | varchar |
nvarchar | varchar | varchar |
image | image | No Default |
text | text | No Default |
unitext | unitext | No Default |
binary | binary | binary |
varbinary | varbinary | binary |
bit | tinyint | tinyint |
timestamp | timestamp | No Default |
sysname | varchar | varchar |
longsysname | varchar(255) | varchar |
bigtime | bigtime | timestamp |