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:

• Introduce Process Management

  Users can tracks the running queries and terminate the long-running queries manually

• Introduce CLI tool for repairing logical table metadata

  Add a new CLI tool for repairing logical table metadata

Contributors

For the past two weeks, our community has been super active with a total of 123 PRs merged. 5 PRs from 5 individual contributors merged successfully and lots pending to be merged.

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

• @Arshdeep54 db#6300
• @codephage2020 db#6379
• @linyihai db#6290
• @Olexandr88 db#6362
• @rgidda db#6358

👏 Welcome @Arshdeep54 @codephage2020 @Olexandr88 @rgidda to the community as a new contributor with a successfully merged PR, and more PRs from other individual contributors are waiting to be merged.

（Figure 1: New Contributors of GreptimeDB）

👏 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#5865 db#6309 Implement Process Manager and information_schema.process_list

• Introduced the Process Manager module to track currently running queries and enhance the observability of system runtime status.

• Added the kill_process capability to the Process Manager, allowing users to manually terminate specific query processes, improving system control and fault handling efficiency.

mysql> select * from information_schema.process_list;
+-----------------------+----------+---------+-----------------------------------------------+---------+---------------------+----------------------------+-----------------+
| id                    | catalog  | schemas | query                                         | client  | frontend            | start_timestamp            | elapsed_time    |
+-----------------------+----------+---------+-----------------------------------------------+---------+---------------------+----------------------------+-----------------+
| 192.168.50.164:4001/1 | greptime | public  | SELECT * FROM my_bench_table                  | unknown | 192.168.50.164:4001 | 2025-06-25 07:56:09.659000 | 00:00:11.468000 |
| 192.168.50.164:4101/0 | greptime | public  | SELECT * FROM information_schema.process_list | unknown | 192.168.50.164:4101 | 2025-06-25 07:56:21.115000 | 00:00:00.012000 |
+-----------------------+----------+---------+-----------------------------------------------+---------+---------------------+----------------------------+-----------------+

mysql> kill '192.168.50.164:4001/1';
Query OK, 1 row affected (0.01 sec)

• Support terminating current running query by Ctrl+C in MySQL client

mysql> select * from my_bench_table;
^C^C -- query aborted
ERROR 1317 (70100): (Cancelled): Stream has been cancelled

db#6322 Introduce CLI Tool for Repairing Logical Table Metadata

Introduced a CLI tool that helps users quickly repair logical table metadata in case of corruption or inconsistency.

db#6360 Introduce Pipeline Doc v2 for Combine-Transform

Officially introduced Pipeline Doc v2 for Combine-Transform operations. This version brings improvements in semantic clarity, configuration flexibility, and extensibility, enabling users to handle more complex data processing scenarios in the future.

Example:

version: 2
processors:
  - date:
    field: input_str
    formats:
      - "%Y-%m-%dT%H:%M:%S%.3fZ"

transform:
  - field: input_str, ts
    type: time

Good First Issue

Issue#6334 Improve KILL Support for INSERT INTO SELECT Queries

Keyword: Query Engine

Difficulty: Medium