Summary

Together with our global community of contributors, GreptimeDB continues to evolve and flourish as a growing open-source project. We are grateful to each and every one of you.

Below are the highlights among recent commits:

• Added Geometry UDFs

• New JSON UDF json_path_exists

• Introduced Window Sort Physical Plan

• Added JSON Format Output for HTTP Interface

Contributors

For the past two weeks, our community has been super active with a total of 66 PRs merged. Of these, 2 PRs were contributed by 2 individual contributors, with many more pending to be merged.

• @CookiePieWw (db#4807)

• @Kev1n8 (db#4797)

Congrats on becoming our most active contributors in the past 2 weeks!

A big THANK YOU to all our members and contributors! It is people like you who are making GreptimeDB a great product. Let's build an even greater community together.

Highlights of Recent PRs

db#4770 db#4823 Added More Geometry UDFs

We introduced multiple S2 Geometry UDFs, enhancing the capabilities for processing geometric data.

Additionally, more S3 Geometry UDFs were added to improve flexibility and support in geometric calculations.

db#4798 New geojson_encode_path UADF

We introduced the geojson_encode_path UADF. This function takes multiple rows of latitude, longitude, and timestamp as input, outputting path data compatible with Deck.gl, greatly simplifying the visualization of geographic data, particularly in Deck.gl environments.

db#4807 New JSON UDF json_path_exists

We introduced the json_path_exists UDF. This function checks whether a specified path exists in JSON data, enhancing query capabilities when working with complex JSON structures.

db#4796 Fixed Panic in UNION ALL Queries

The issue that could lead to a system panic during UNION ALL queries has been resolved, improving query stability and reliability.

db#4814 Introduced Window Sort Physical Plan

A new Window Sort physical execution plan was added, optimizing the performance of large-scale data sorting by leveraging stream-based merge sorting.

db#4797 Added JSON Format Output for HTTP Interface

A JSON format output option has been added to the HTTP query interface, simplifying data consumption for clients and improving the overall user experience.

{
  "data": [
    {
      "host": "127.0.0.1",
      "ts": 1667446797450,
      "cpu": 0.2,
      "memory": 0.3
    },
    ...
  ],
  "execution_time_ms": 23
}

Good First Issue

db#3262 Provide an official Grafana configuration

Provides an intuitive out-of-the-box grafana dashboard for GreptimeDB.

• Keywords: Grafana

• Difficulty: Medium

db#4805 Add more JSON UDFs

Add more UDFs about JSON data type to achieve powerful query capabilities.

• Keywords: JSON, UDF

• Difficulty: Simple

---

About Greptime

Greptime offers industry-leading time series database products and solutions to empower IoT and Observability scenarios, enabling enterprises to uncover valuable insights from their data with less time, complexity, and cost.

GreptimeDB is an open-source, high-performance time-series database offering unified storage and analysis for metrics, logs, and events. Try it out instantly with GreptimeCloud, a fully-managed DBaaS solution—no deployment needed!

The Edge-Cloud Integrated Solution combines multimodal edge databases with cloud-based GreptimeDB to optimize IoT edge scenarios, cutting costs while boosting data performance.

Star us on GitHub or join GreptimeDB Community on Slack to get connected.