Can you also share the stack trace from drillbit.log for the below error
RESOURCE ERROR: External Sort encountered an error while spilling to disk
And what is the version of Drill that you are running ?
Please share the table definition and the number of rows in that table,
which is being queried
hat very little disk space is available for /tmp .
Thanks,
-- Boaz
On 3/12/19 6:03 AM, Giovanni Conte wrote:
Hello,
I am doing a LAG and a SUM query over a PCAP dataset of 300Mb.
I get this error:
RESOURCE ERROR: External Sort encountered an error while spilling to d
Hello,
I am doing a LAG and a SUM query over a PCAP dataset of 300Mb.
I get this error:
RESOURCE ERROR: External Sort encountered an error while spilling to disk
Then I changetd
planner.memory.max_query_memory_per_node ---> 8589934592
and with this I am able to perform the LAG but not the SUM.