how to set temp directory for duckdb ?

[djouallah]

getting this error, due to low Memory, how to set duckdb , temp folder ?

RayTaskError(OutOfMemory): ray::000015.DataSinkTask() (pid=4642, ip=172.28.0.12)
  At least one of the input arguments for this task could not be computed:
ray.exceptions.RayTaskError: ray::000015.DataSinkTask() (pid=4642, ip=172.28.0.12)
  At least one of the input arguments for this task could not be computed:
ray.exceptions.RayTaskError: ray::000014.SqlEngineTask() (pid=4642, ip=172.28.0.12)
                   ^^^^^^^^^^^^^^^^^^^^^^^^^
duckdb.duckdb.OutOfMemoryException: Out of Memory Error: could not allocate block of size 2.0 GiB (10.2 GiB/10.8 GiB used)
Database is launched in in-memory mode and no temporary directory is specified.
Unused blocks cannot be offloaded to disk.

Launch the database with a persistent storage back-end
Or set SET temp_directory='/path/to/tmp.tmp'

[wangrunji0408]

You can add enable_temp_directory=True to SqlEngineNode or map function.

It is disabled by default because spilling data is very slow.