We have installed the community edition. When we run :
select * from cust_performance
we get the error message: Exception: Query would require a scan without a limit on table(s).
When we put a limit it works upto the some point . However after passing a point we get the error message:
select * from cus_performance_V3 limit 10000000
Exception: Query couldn’t keep the entire working set of columns in GPU memory
Does Mapd not work in cpu memory(RAM)? We thought that mapd keeps data in memory and put data in gpu memory if need be.
Do we get this error messages because we use the community edition? Moreover, we have 2 Gpus whose memory amounts to 32GB but when we checked the nvidia-smi command the gpu memory usage does not exceed 3GB on each gpu. What is the reason for this?