[dogman123]

One thing that I never really see mentioned in these types of articles is that a lot of DuckDB’s functionality does not work if you need to spill to disk. iirc, percentiles/quartiles (among other aggregate functions) caused DuckDB to crash out when it spilled to disk.

[jtbaker]

I’m pretty sure I’ve done this and not had any issues. Can you share a minimum reproducible example?