search

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

pgloader做表迁移时报错 #27

Open windtalkerbj opened 4 years ago

windtalkerbj commented 4 years ago

在使用pgloader做mysql->TBASE的数据迁移测试时，在标准PG上未遇到问题； 在TBASE上，pgloader提示错误如下： create temp table reloids(oid) as values ('public.yxhscs_itf_contract_validated'::regclass)

ERROR: Cannot support distribute type: RoundRobin

该SQL由pgloader工具发出，请问可以增加对这种临时表的支持吗？pgloader在一键迁移/持续化迁移MYSQL数据到PG上时很好用

whf307 commented 4 years ago

TBase是分布式的，默认不指定的话第一个列作为分布键。regclass这种作为分布键，不支持吧。具体这样可以根据需求再改一下呢