After adding the parameter

append_mode = 'true'

, the query performance improved significantly. However, compared with ClickHouse and Apache Druid, the gap is still quite obvious.

We noticed that you have 128 partitions. Could you run EXPLAIN ANALYZE VERBOSE with these queries, the results can help us to analyze the execution. https://docs.greptime.com/reference/sql/explain/#examples You can also do it from our UI dashboard and dashboard the explain result as JSON. Thank you!