I’ve installed dremio Community on my home Windows 10 computer and have tried using the “Keep Only” and “Exclude” functions on the sample data set, however I get the error:
“Failed to create directory for spilling. Please check that the spill location is accessible and confirm read, write ; execute permissions.”
Any insight would be greatly appreciated!
In your dremio.conf file you will see a path defined for local or spill. You are running out of disk space there
Ahhh ok, that makes sense - thank you for the prompt response!
Sorry forgot to mention that you may also not have right permissions for the process that runs Dremio on the executors to read/write/execute permissions into this folder
I’ll have to double check - thanks for the follow up!
For the Windows Local installation, where would I locate the dremio.conf file?
Never mind, found it at:
I don’t believe it’s a space issue as the data extract is fairly small (only 15 MB), which leads me to believe it’s a permissions issue. Is there any documentation I could refer to on adjusting permissions to give Dremio access to write to a folder? Or any recommendations?
Really appreciate all the help!
Nevermind, solved this by running Dremio as an administrator.