Keep Only and Exclude Functions - Directory for Spilling Error

1

Hi Team,

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!

Thank you!

2

Hi @mathew.lee

In your dremio.conf file you will see a path defined for local or spill. You are running out of disk space there

Thanks
@balaji.ramaswamy

3

Ahhh ok, that makes sense - thank you for the prompt response!

4

Hi @mathew.lee

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

Thanks
@balaji.ramaswamy

5

I’ll have to double check - thanks for the follow up!
Mathew

6

HI @balaji.ramaswamy,

For the Windows Local installation, where would I locate the dremio.conf file?

Thank you,
Mathew

7

@balaji.ramaswamy

Never mind, found it at:

“C:\Program Files\Dremio\conf\dremio.conf”

Thanks!
Mathew

8

@balaji.ramaswamy,

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!

Thanks,
Mathew

9

@balaji.ramaswamy

Nevermind, solved this by running Dremio as an administrator.

Thanks,
Mat