We are testing Mapd community edition on Amazon Ec2 p3.8xlarge instance with Nvidia Tesla V100 GPU. When we was executing query like:
SELECT col1, COUNT(), COUNT(distinct col2), COUNT(distinct col3) FROM cdrs WHERE (col4=‘value1’ OR col4=‘value2’) AND col3 = value4’ AND col5=‘value3’ GROUP BY col1 HAVING COUNT() > 100 ORDER BY 2 DESC LIMIT 200;
We got an error: Exception: Not enough host memory to execute the query
This error happens if disk size of database is 1,4Gb or 32Gb. It happens also if we use 4 Tesla V100 GPUs.
We also get error ‘Exception: Sorting the result would be too slow’ when we execute query:
SELECT col1, SUM(col2*1) FROM cdrs WHERE col3=‘value1’ AND col4=‘value2’ GROUP BY col1 ORDER BY 2 DESC;
Any idea what is going wrong?