4paradigm / 4paradigm/OpenMLDB

docs about ttl and auto index

未关闭
#2,600 0 条评论 0 个 reaction 已指派 1 人 已被 @zhanghaohit 认领 在 GitHub 查看
documentation
主要语言
C++
星标
1.7k
派生
331
平均合并
12 天 12 小时
30 天内合并 PR
1

描述

**Describe the feature you'd like**

Currently there is no place discussing about how the index ttl will be updated / set in our system. We may need a blog/page discussing how it works. It may include:
- how user define an index with ttl (it is currently covered in the `Create Index` and `Create Table`)?
- how the existing ttl (user defined) may be changed by the system? Upon a deployment, there may be an update on the ttl if the window is larger than existing ttl.
- there is also some restrictions. We may discuss it is reasonable to have such restrictions.
- If ttl is defined as `absolute`, `ROWS` window is not allowed.
- if ttl is defined as `latest`, `ROWS_RANGE` window is not allowed
- how we auto create indexes and set the ttl when `deploy`

贡献指南

打开贡献指南

调研方向

Look at the 'Create Index' and 'Create Table' documentation to understand current TTL coverage. Examine the code for index creation and deployment logic to see how TTL is set and updated. Review any existing restrictions on TTL types and window definitions. The goal is to produce a new document or blog post explaining TTL behavior and auto-indexing.

由索引模型根据 Issue 内容生成。

评估

技术栈
sql
领域
databases, documentation
Issue 类型
文档
难度
3/5
预计耗时
1-2 天
活跃度
停滞
描述清晰度
基本清楚
新手友好度
45/100

把新 issue 发到你的邮箱

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