I want to do schema migration with StarRocks, but it seems not support it well?

未关闭
#16,796 0 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看

维护者通常 1 天内回复

还没有人认领这个 Issue。

评估

难度
5/5
预计耗时
一周以上
新手友好度
20/100
Issue 类型
功能
描述清晰度
需要澄清
活跃度
停滞
技术栈
sql
领域
databases

调研方向

尚未确定任何仓库文件、测试或入口点。首先在 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:

  1. 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.
  2. Being able to directly change the schemas in Bytebase, by providing a complete table schema or a ALTER TABLE statement. Then Bytebase should able to diff the schema if provided with a complete table schema and finally rollout the changes.
  3. 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
  1. It fails to sync schema from StarRocks for v3.3 and v3.4.
  2. It can sync schema from StarRocks for v3.1, but only with tables and views, other objects are not synced.
  3. 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
  1. 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.
  2. I also can't see the schema diff when making changes.
About sync schema between two databases
  1. I can't choose a SR's database as the source or target database to sync schema. But for MySQL or Postgres, I can.
  2. 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
  1. Can I output all the schemas, including tables, views, users, etc., in Bytebase about a database?
  2. How can I check what objects for SR are suppported?
Some questions about Bytebase
  1. Do we have a plan to improve StarRocks integration, since it is becoming more widely adopted?
Describe the solution you'd like
  1. Imporve the integration with StarRocks by adding more objects.
  2. 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,通用步骤见我们的新手贡献指南。

从这里开始

  1. 先读完整个 Issue,再读项目的贡献指南。
  2. 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
  3. Fork 仓库,在一个分支上完成修改。
  4. 提交 Pull Request,并在描述里引用这个 Issue 编号。

bytebase/bytebase 的其他 Issue

查看 bytebase/bytebase 的全部 Issue

相似的 Issue

更多 TypeScript Issue

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。