AnsweredAssumed Answered

Drill create partitioned table error

Question asked by senthilv on Jul 6, 2017
Latest reply on Jul 7, 2017 by maprcommunity

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;

Outcomes