I want to do schema migration with StarRocks, but it seems not support it well?
维护者通常 1 天内回复
还没有人认领这个 Issue。
评估
调研方向
尚未确定任何仓库文件、测试或入口点。首先在 3.1、3.3 和 3.4 版本上复现报告的 StarRocks schema 同步失败,然后定义 StarRocks 环境之间同步和 rollout 所支持的对象以及 schema-diff 行为。
由索引模型根据 Issue 内容生成。
描述
Is your feature request related to a problem?
I'm a StarRocks user.
I noticed that Bytebase has supported StarRocks since 2023.
But, I don't know whether Bytebase has good support for StarRocks.
And, I've seen more than ten issues are about StarRocks and Doris. Especially for PRs submitted by @rebelice @d-bytebase
I want to use Bytebase to do schema migration with StarRocks. includes:
- Syncing the schema from SR to Bytebase, such as dbs/tables, views, materialized views, users / roles / grants, external catalogs, row access policies, global variables, and generated columns.
- Being able to directly change the schemas in Bytebase, by providing a complete table schema or a
ALTER TABLEstatement. Then Bytebase should able to diff the schema if provided with a complete table schema and finally rollout the changes. - I have a test env and a prod env, I want to do sync schema from the test env to the prod env, that Bytebase can diff the schema change between the test db and the prod db.
Current problems of testing
About syncing schema from SR
- It fails to sync schema from StarRocks for v3.3 and v3.4.
- It can sync schema from StarRocks for v3.1, but only with tables and views, other objects are not synced.
- About some properties of tables or views and other info which is different with MySQL, I don't know whether Bytebase stores them.
About editing schemas
- I want to edit table schema in Bytebase's web page, but it seems that Bytebase doesn't support adding columns to a SR table, -- it only allows updating the entire table schema.
- I also can't see the schema diff when making changes.
About sync schema between two databases
- I can't choose a SR's database as the source or target database to sync schema. But for MySQL or Postgres, I can.
- I have a Postgres upstream source, I want to sync the schema from Postgres to StarRocks, it seems that Bytebase doesn't support sync schema between different types of databases.
About output schema
- Can I output all the schemas, including tables, views, users, etc., in Bytebase about a database?
- How can I check what objects for SR are suppported?
Some questions about Bytebase
- Do we have a plan to improve StarRocks integration, since it is becoming more widely adopted?
Describe the solution you'd like
- Imporve the integration with StarRocks by adding more objects.
- Be able to sync schema between two SR databases, and diff the schema.
Additional context
No response
- 主要语言
- TypeScript
- 星标
- 14.7k
- 派生
- 1k
- 平均合并
- 7 小时 23 分钟
- 30 天内合并 PR
- 454
环境准备
这个项目没有提供开发容器、Dockerfile 或贡献指南,环境需要你自己搭建:先看它的 README,通用步骤见我们的新手贡献指南。
从这里开始
- 先读完整个 Issue,再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库,在一个分支上完成修改。
- 提交 Pull Request,并在描述里引用这个 Issue 编号。
bytebase/bytebase 的其他 Issue
-
BigQuery schema sync fails when ORDINAL_POSITION is NULL可能已有人在做 @tuyndoan 于 89 天前认领。 未关闭
难度 2/5 1-3 小时 新手友好度 70/100
bytebase/bytebase#21217 · 4 条评论 ·
维护者通常 1 天内回复
-
Bug Github
难度 4/5 3-5 天 新手友好度 48/100
维护者通常 1 天内回复
-
Bug Github
难度 4/5 3-5 天 新手友好度 18/100
维护者通常 1 天内回复
-
Feature Github
难度 5/5 一周以上 新手友好度 35/100
维护者通常 1 天内回复
-
Unbounded goroutine/memory growth: 28k goroutines parked in MCP streamable session reads (OOM)可能已有人在做 @vsai12 于 19 天前认领。 未关闭Bug Github
bytebase/bytebase#21721 · 3 条评论 · 已指派 1 人 ·
维护者通常 1 天内回复
查看 bytebase/bytebase 的全部 Issue
相似的 Issue
-
难度 2/5 1-3 小时 新手友好度 76/100
维护者通常 1 天内回复
-
e2e-failure ready-to-code
难度 1/5 1 小时以内 新手友好度 72/100
redhat-developer/rhdh-plugin-export-overlays#4794 · 1 条评论 ·
维护者通常 1 天内回复
-
难度 2/5 1-3 小时 新手友好度 78/100
维护者通常 1 天内回复
-
难度 2/5 1-3 小时 新手友好度 82/100
维护者通常 1 天内回复
-
area: plugins documentation good first issue
难度 2/5 1-3 小时 新手友好度 83/100
CatVinci-Studio/Textus#727 ·
维护者通常 1 天内回复