https://slingdata.io logo
`SLING_SCHEMA_MIGRATION` makes invalid
# sling-help
i
SLING_SCHEMA_MIGRATION
makes invalid DDL for a StarRocks target (v1.6.3) Hi! We use Sling CLI 1.6.3 (official build, Pro trial) from Postgres to StarRocks. With
SLING_SCHEMA_MIGRATION=primary_key
, Sling finds the source primary key, but StarRocks rejects the DDL:
Copy code
create table ... (`_sling_row_id` varchar(65533), `id` bigint, ..., PRIMARY KEY (`id`)) distributed by hash(`_sling_row_id`)
Error 1064: Getting syntax error at line 5, column 2 With
all
,
DEFAULT uuid()
and
DEFAULT current_timestamp NOT NULL
also fail. Do you plan StarRocks support for schema migration? We want to sync all tables of a source without a primary_key for each stream.
f
@István Karaszi Thank you for raising, StarRocks has been added as a target for Schema Migration. This will be released this weekend in v1.6.4. Feel free to raise any other issues!
i
That is great to hear, thank you!
Thank you for the quick release!