QuestDB 8.1 Release

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) and FILL(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

1 Like