To reproduce

CREATE TABLE 'test' ( id SYMBOL CAPACITY 10 NOCACHE, mySymbol SYMBOL, dateTime TIMESTAMP) timestamp(dateTime) PARTITION BY DAY WAL;

insert into test VALUES ('1', NULL, '2025-10-01T07:20:06.948000Z');
insert into test VALUES ('2', NULL, '2025-10-02T07:20:06.948000Z');

alter table test CONVERT PARTITION TO PARQUET WHERE dateTime <= '2025-10-01';

update test set mySymbol='TEST' where mySymbol is NULL

QuestDB version:

9.1.0

OS, in case of Docker specify Docker and the Host OS:

Debian

File System, in case of Docker specify Host File System:

ext4

Full Name:

Wiktorowski Maximilien

Affiliation:

Echoes

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response