Tencent / TBase

TBase is an enterprise-level distributed HTAP database. Through a single database cluster to provide users with highly consistent distributed database services and high-performance data warehouse services, a set of integrated enterprise-level solutions is formed.
Other
1.38k stars 262 forks source link

postgres迁移到TBase时uuid类型的字段如何处理? #133

Open childewuque opened 1 year ago

childewuque commented 1 year ago

从已有的pg库导出DDL,有一些表有uuid类型的字段,比如: CREATE TABLE version (rule_id uuid NOT NULL PRIMARY KEY,description character varying(255) )

最新版的tbase,部署好后,通过psql 导入DDL,会报错: ERROR: Column rule_id is not a shard distributable data type 从TBASE的角度看,有什么办法解决吗?--不要修改已有的数据,因为这个uuid字段的内容,在多个表也有用到,想平滑的迁移数据过来