taosdata/TDengine

can tdengine compress rows like Pi System?

Open

#27,165 opened on Aug 12, 2024

View on GitHub
 (3 comments) (0 reactions) (0 assignees)C (5,002 forks)batch import
help wantedquestion

Repository metrics

Stars
 (24,849 stars)
PR merge metrics
 (Avg merge 1d 1h) (4 merged PRs in 30d)

Description

存在如下时序数据:

ts value
now()-10s 1
now()-9s 1
now()-8s 1
now()-7s 1
now()-6s 1
now()-5s 2
now()-4s 2
now()-3s 2
now()-2s 2
now()-1s 2
now() 0

在 TDEngine 中, 是否可以实现以某些 stable 或者 database 或者 server 级的配置, 实现如下的数据库记录(或者实际存储的记录)

ts value
now()-10s 1
now()-5s 2
now() 0

并且可以基于这样的记录实现一些子查询, join, intervall fill 等聚类的功能?

Contributor guide

Research direction
Investigate if TDengine supports compression of repeated column values to store only changes, similar to Pi System's compression, and how this affects query operations like subqueries, joins, and interval fill. Check documentation and configuration options such as stable level, database level, or server level settings.
Tech stack
c
Domain
database
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Needs investigation
Prerequisites
SQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60