To reproduce

reproducible on demo:

SELECT cast(timestamp as LONG) AS timestamp, symbol::SYMBOL AS "ID",round(avg(price))::LONG AS "Evt1" 
FROM 'trades' 
WHERE timestamp IN '2025-05-24';

Fails at:

QuestDB version:

9.0.2

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

N/A

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

N/A

Full Name:

Nick Woolmer

Affiliation:

QuestDB

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