I am running the open source version of MapD Core with CPU using mapdql.
The mapdql frequently hangs (not always) when I issue a sql that will return a big result set. (to be specific, a sql that generate 6 millions rows result) However, for those sqls issued to the same table but result set is small, the mapdql behave well.
The interesting thing is, the “mapd_server.INFO” log shows that the sql is already finished, something like:
“sql_execute-COMPLETED Total: 12330 (ms), Execution: 2056 (ms)”
But the mapdql hangs and does not return result for me. I set “enable-dynamic-watchdog” to “true” and set the “dynamic-watchdog-time-limit” to some value but still cannot solve this problem.
Currently, what I do is I issue the sqls multiple times until it succeed. (the success chance is low)
It will be great if any one can help with this.