xzxiong commented 9 months ago

Is there an existing issue for the same tech request?

[X] I have checked the existing issues.

Does this tech request not affect user experience?

[X] This tech request doesn't affect user experience.

What would you like to be added ?

ref https://github.com/matrixorigin/MO-Cloud/issues/2005

1. statement_info is account-level accessable, but all account's data is in one phy table. Hard to count each account's storage usage, and also leads to scan others accounts' data.

2. current index is `cluster by (request_at, account)`, while the correct one shoulde be `cluster by(account, request_at)` or `cluster by (request_at)`

Why is this needed ?

~solution 1~

seprate accounts' data into individul table.

solustion 2

corrent the cluster by index define

Additional information

No response

xzxiong commented 1 month ago

基于 mo 1.3.0 不兼容升级，重构相关的 cluster by 或 partition key

xzxiong commented 1 month ago

18936 先忽略 system.statement_info, system_metrics.metric 的schema 校验.

等待 mo 1.3 完成不兼容升级，再重新打开。

xzxiong commented 2 weeks ago

https://doc.weixin.qq.com/doc/w3_AW0A-gb6AOIegOzI1uxSI6PdqZMAJ?scode=AJsA6gc3AA8zld4d3NAW0A-gb6AOI

matrixorigin / matrixone

[Tech Request]: statement_info schema refactor #14293