Welcome back from the holidays! (If you had one...)

In the latest QuestDB release, we've focused on enhanced stability and introduced two innovative features, currently in beta. Notably, we've improved GROUP BY performance tenfold through parallel SQL executions and introduced InfluxDB Line Protocol (ILP) support over HTTP, which is compatible with existing InfluxDB drivers. Those familiar with ILP will find a clean entryway into QuestDB.

Thanks to @ssharaev and @pompeiifreckles for their first contributions - we appreciate you.

Dive in to explore the release in detail. 🤿

What's changed

Please note that the following features are in beta - please let us know if you run into any issues.

• 10x GROUP BY performance improvement via parallel SQL executions. Should you encounter any problems with this implementation, you can safely disabled [cairo.sql.parallel.groupby.enabled=false] it via configuration without downgrading the database instance.
• InfluxDB Line Protocol (ILP) support over HTTP. This implementation supports existing InfluxDB drivers and eases the transition into QuestDB for existing ILP users. The new client has control over transaction boundaries and will offer helpful feedback on transaction activity. We're also pleased to offer no noticeable performance impact in ingestions performance compared to our TCP implementation.

New features

• feat(sql): add sign() functions by @bziobrowski in https://github.com/questdb/questdb/pull/4050
• feat(ilp): ILP over HTTP, InfluxDB native clients writing support, ILP feedback by @ideoma in https://github.com/questdb/questdb/pull/4034
• feat(sql): add nullif(double, double) SQL function by @ssharaev in https://github.com/questdb/questdb/pull/4063
• perf(sql): parallel group by with optional filtering by @puzpuzpuz in https://github.com/questdb/questdb/pull/4032
• feat(sql): add query registry and query cancellation by @bziobrowski in https://github.com/questdb/questdb/pull/4066

Fixes and improvements

• fix(sql): fix handling of keyed string aggregation of first(), first_not_null(), last(), last_not_null() functions by @bziobrowski in https://github.com/questdb/questdb/pull/4068
• fix(core): fix non-existing partition drop can suspend WAL table by @ideoma in https://github.com/questdb/questdb/pull/4064
• fix(ilp): ilp@http small fixes by @glasstiger in https://github.com/questdb/questdb/pull/4077
• fix(sql): implement 'case expression when value' for float and double data types by @bziobrowski in https://github.com/questdb/questdb/pull/4046
• fix(sql): fix NullPointerException in replace() function with symbol arguments by @bziobrowski in https://github.com/questdb/questdb/pull/4073
• fix(core): fix tables() function permanently returning error after some DDLs by @ideoma in https://github.com/questdb/questdb/pull/4081
• fix(core): fix potential and unlikely numeric overlflow that could lead to incorrect query results by @pompeiifreckles in https://github.com/questdb/questdb/pull/4093
• fix(sql): fix potential races when regexp_replace function is used in where or group by clause by @puzpuzpuz in https://github.com/questdb/questdb/pull/4102
• fix(core): fix non-partitioned table corruption caused by truncate & table corruption after restore from snapshot by @bluestreak01 in https://github.com/questdb/questdb/pull/4095
• fix(core): fix edge case error when importing a large CSV file @jerrinot in https://github.com/questdb/questdb/pull/4103

New Contributors

• @ssharaev made their first contribution in https://github.com/questdb/questdb/pull/4063
• @pompeiifreckles made their first contribution in https://github.com/questdb/questdb/pull/4093

Full Changelog: https://github.com/questdb/questdb/compare/7.3.7...7.3.8b