How to group by table in duckDB when I set temp_directory = '/tmp/duckdb-tmp'

[thrmagic]

I have a parquet file(78mb),and create a table in duckDB,but throw error Out of Memory,so i set temp_directory = '/tmp/duckdb-tmp' .but throw error tried to read past the endwhen i use group by

c.query("SET temp_directory = '/tmp/duckdb-tmp'")

await c.query('CREATE TABLE dm_machine_part_recommendation_ap AS SELECT * FROM read_parquet(\'data.parquet\')')

const result = await c.query('select region,sub_region,segment,count(1) from "dm_machine_part_recommendation_ap" group by region,sub_region,segment order by region desc')