QuestDB 8.1 is out!
The biggest news of all is Parquet read beta support.
-
Use the
read_parquet()
function to read Apache Parquet files. -
SAMPLE BY syntax improvements:
-
FROM-TO syntax: Specify result ranges, with support for prefilling and postfilling data. Also can correct misaligned buckets.
-
Parallel SAMPLE BY: Now supports
FILL(VALUE)
andFILL(NULL)
. -
Snapshot recovery: Added a trigger file to initiate snapshot recovery, improving database resilience and ease-of-use.
-
SQL Performance
** Speedup for small transaction writing by 50-100%.
** Enhanced performance for the like/ilike operator on symbol columns.
** Speed improvements for regexp_replace(varchar) with simple patterns.
SQL example:
ASOF join between a normal table and a parquet table where we ASOF join by timestamp and also by a column extracted from JSON