Skip to content
On this page

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

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...

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