questdb/questdb 4.1.5

on GitHub

IMPORTANT

Metadata file format has been changed to include version and more column flags. It is necessary to convert existing tables to new format. For more information please follow this guide.

What is new?

• Java: TableWriter.addIndex() implementation - adds index to existing table
• SQL: CASE statement implementation
• SQL: CAST implementation (documentation)
• SQL: RENAME TABLE implementation
• SQL: round() multiple implementations (documentation)
• SQL: ALTER TABLE X ALTER COLUMN SYM ADD INDEX - SQL to add index to SYMBOL columns of existing tables (documentation)
• SQL: symbol in (list) function implementation
• SQL: optimiser improvements
• UI: Web Console has simple Charts implementation

select * from trades where ts>'2015-01-02T00:00:00.000Z' and ts<'2015-01-02T10:30:00.000Z' and sym in ('EEM', 'VXX', 'BCLI', ...) order by sym

What we fixed

• SQL: double-to-string implementation parses IEEE number, performance is up 80% on simpler values and 30% on complex ones

• SQL: aggregation without key, e.g. no 'group by' clause are 6x faster than before.

• SQL: 'SAMPLE BY' queries are faster than before

• SQL: 'COPY' is limited to picking up files only from configured location (documentation)

• SQL: improved error reporting

• UI: LONG256 0 is printed as '0x00'

• UI: Double "inifinity" values (division by zero) used to corrupt JSON