JSON Support Updates and New Geometry UDF Features | Greptime Biweekly Report

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 ​

We help industries that generate large amounts of time-series data, such as Connected Vehicles (CV), IoT, and Observability, to efficiently uncover the hidden value of data in real-time.

Visit the latest version from any device to get started and get the most out of your data.

• GreptimeDB, written in Rust, is a distributed, open-source, time-series database designed for scalability, efficiency, and powerful analytics.
• Edge-Cloud Integrated TSDB is designed for the unique demands of edge storage and compute in IoT. It tackles the exponential growth of edge data by integrating a multimodal edge-side database with cloud-based GreptimeDB Enterprise. This combination reduces traffic, computing, and storage costs while enhancing data timeliness and business insights.
• GreptimeCloud is a fully-managed cloud database-as-a-service (DBaaS) solution built on GreptimeDB. It efficiently supports applications in fields such as observability, IoT, and finance.

Star us on GitHub or join GreptimeDB Community on Slack to get connected. Also, you can go to our contribution page to find some interesting issues to start with.