Dears,
As I query data from dremo.
When I query single SQL like below. It execute successfully.
WITH TRADE AS ( SELECT a, b FROM table1 left join table2 on table1.column1=table2.column2),
WITH CASH AS ( SELECT a, b FROM table3 left join table4 on table3.column1=table3.column2)
SELECT * FROM TRADE.
When I query union all SQL like below. It execute failed.
WITH TRADE AS ( SELECT a, b FROM table1 left join table2 on table1.column1=table2.column2),
WITH CASH AS ( SELECT a, b FROM table3 left join table4 on table3.column1=table3.column2)
SELECT * FROM TRADE union all SELECT * FROM CASH.
The error info as below. I have checked that the SQL input size is not big. Maybe I missed some config. Someone could help me. Thanks in advance.
Execute query failed: java.util.concurrent.ExecutionException: java.lang.Exception: QueryFailed: DATA_WRITE ERROR: Failed to spill to disk. Please check space availability
spill id esort-1f5495be-c68f-45f6-0952-7026d1538800.9.8.5
all spill locations [file:///hadoop/dremio/log]
for sort spilling spill id esort-1f5495be-c68f-45f6-0952-7026d1538800.9.8.5
Caller sort spilling
Failed to spill to disk. Please check space availability
Fragment 9:0
[Error Id: e13e9f60-5425-47c6-92fc-80754e50159a on xxx.com:0]