-
Notifications
You must be signed in to change notification settings - Fork 2
converter hive mapping
wz2cool edited this page May 6, 2019
·
3 revisions
- hive 这里不支持 DROP COLUMN, 因为hive 中想要删除一个列必须使用 REPLACE 去生成新的表结构 , 但是canal 删除列的语句是拿不到整个表表结构的,所以暂时不支持。
Mysql | Hive | comment |
---|---|---|
BIT | TINYINT | |
TINYINT | TINYINT | |
SMALLINT | SMALLINT | |
MEDIUMINT | INT | |
INT | INT | |
INTEGER | INT | |
BIGINT | BIGINT | |
FLOAT | DECIMAL | |
DOUBLE | DECIMAL | |
DECIMAL | DECIMAL | |
DATE | DATE | |
DATETIME | TIMESTAMP | |
TIMESTAMP | TIMESTAMP | |
TIME | VARCHAR | 没有 TIME 类型 |
VARCHAR | VARCHAR | |
CHAR | VARCHAR | |
TINYBLOB | BINARY | |
BLOB | BINARY | |
MEDIUMBLOB | BINARY | |
LONGBLOB | BINARY | |
TINYTEXT | STRING | |
TEXT | STRING | |
MEDIUMTEXT | STRING | |
LONGTEXT | STRING |