We have a Map-R cluster setup with drill-bits on 3 nodes and i'm trying to create a partitioned table on top of csv files in Mapr-fs.
I got an issue with respect to spill directories and configuring to spill directories to respective /tmp/nodes (How to use MapR local volume as the spill directory for Apache Drill | Open Knowledge Base ).
Now I'm getting diff error but also throws memory error.
Can someone please help me to get rid of this issue?`
I have also set below parameters to allocate more memory for sorting but didn't help though.
alter session set `planner.memory.max_query_memory_per_node`=2147483647;
ALTER SESSION SET `planner.width.max_per_node`=1;