Failed to spill to disk. Please check space availability;

1
  • Query Type:Accelerator (creation)
  • Duration:2h:57m:48s
  • Start Time:28/04/2020 09:05:04
  • End Time:28/04/2020 12:02:52

Failed to spill to disk. Please check space availability;

Input

Input Bytes: 53.80 GB
Input Records: 41,311,183

I have free 239gb in HD.

but why Spilled Operation need, Total Spilled: 1.84 TB ?

  DATA_WRITE ERROR: Failed to spill to disk. Please check space availability

spill id esort-…-33b618c45100.1.4.3
all spill locations [/var/ephemeral/spill]
for sort spilling spill id esort-…33b618c45100.1.4.3
Caller sort spilling
SqlOperatorImpl EXTERNAL_SORT
Location 1:4:3
Fragment 1:0

2

@Jadson

There could have been 2 possibilities

  1. space
  2. permission

The profile should tell us the executor name. Kindly check if Dremio is able to read/write/execute to the spill folder