Skip to content

Anomaly Detection Functions & Admin GC Support | Greptime Biweekly Report - No. 78

Three new SQL functions (anomaly_score_iqr, anomaly_score_mad) detect outliers in time series data. PostgreSQL COPY TO STDOUT now works for data...
Anomaly Detection Functions & Admin GC Support | Greptime Biweekly Report - No. 78
On this page

6,000 GitHub Stars! ​

GreptimeDB just hit 6,000 stars on GitHub! Thanks to everyone who has starred, contributed, or used the project.

6,000 GitHub Stars

GreptimeDB v1.0.0-rc.2 Released ​

We just released GreptimeDB v1.0.0-rc.2. The headline improvement is dynamic filter pushdown for TopK queries, delivering over 100× speedup in certain workloads. This release also includes PostgreSQL COPY support, Prometheus 3.x compatibility, and several repartition stability fixes.

Summary ​

Development period: 2026-02-23 - 2026-03-08

Here are the highlights from recent commits:

  • Three new SQL functions (anomaly_score_zscore, anomaly_score_iqr, anomaly_score_mad) detect outliers in time series data
  • PostgreSQL COPY TO STDOUT now works for data export
  • Admin commands can now garbage collect specific tables and regions

Contributors ​

Over the past two weeks, 11 contributors merged a total of 47 PRs.

Highlights of Recent PRs ​

db#7578 chore: upgrade DataFusion family, again ​

DataFusion upstream has moved to Arrow 58, which we're not ready to adopt yet, so we upgraded to the last commit before that. Also bumped sqlparser to v0.61.0.

db#7681 feat: implements anomaly_score_iqr, anomaly_score_mad etc. ​

Three new window functions for anomaly detection: anomaly_score_zscore(), anomaly_score_mad(), and anomaly_score_iqr(), using Z-Score, Median Absolute Deviation, and Interquartile Range methods respectively. Edge cases like insufficient data points or zero variance are handled gracefully (returns NULL or +inf).

db#7619 feat: admin gc table/regions ​

New admin commands ADMIN GC TABLE and ADMIN GC REGION for manually triggering garbage collection on specific tables or regions.

db#7709 feat: implement postgres copy to stdout ​

PostgreSQL connections now support COPY (query) TO STDOUT WITH (format binary), so ADBC-postgres drivers can use the PGCOPY binary protocol instead of text result sets.

db#7694 fix(repartition): reject writes on deallocating regions during region merge ​

Writes to deallocating regions during a merge are now rejected to prevent data inconsistencies.

Good First Issue ​

Issue#7755 Feature request: Support EKS Pod Identity / ECS container credentials endpoint for S3 object storage ​

Update GreptimeDB's OpenDAL dependency to a newer version that includes support for AWS container credentials endpoint, enabling authentication with EKS Pod Identity and ECS task roles.

  • Keywords: Storage, Dependencies
  • Difficulty: Easy

Issue#7544 Allow ALTER TABLE to modify the skip_wal option dynamically ​

Add support for dynamically modifying the skip_wal table option through ALTER TABLE SET commands, allowing users to enable or disable WAL at runtime.

  • Keywords: SQL parser, Storage, WAL
  • Difficulty: Medium

Stay in the loop

Join our community