As TiDB is compatible with MySQL, you can sink data to TiDB the same way you would sink data to MySQL with the JDBC connector.
RisingWave type | TiDB type |
---|---|
BOOLEAN | BOOLEAN |
SMALLINT | TINYINT/SMALLINT |
INT | INT/MEDIUMINT |
BIGINT | BIGINT |
REAL | FLOAT |
DOUBLE | DOUBLE |
DECIMAL | DECIMAL |
DATE | DATE |
TIMESTAMP | DATETIME |
TIME | TIME |
TIMESTAMPTZ | TIMESTAMP |
VARCHAR | VARCHAR/CHAR/TEXT/TINYTEXT/MEDIUMTEXT/LONGTEXT |
BYTEA | VARBINARY/BINARY/BLOB/TINYBLOB/MEDIUMBLOB/LONGBLOB |
JSONB | JSON |