This is what happened. I had a table, I generated all data myself, it worked fine. Then I hit the glibc SEGV issue, I couldn’t startup Mapd. I download a new CE version 3.1.01, connect to the same table. I see immediately the aggregation result is wrong.
Here is the evidence:
mapdql> select avg(amount), max(amount) from shopping;
If the MAX(amount) is 500, the AVG(amount) can’t be 821,744,868,148.119629.
AVG() can’t be more than MAX().
Any ideas please?