4 ms·
My wild guess is lack of some functions, e.g., regexp, but need to take a deep look.
by jerryjerryjerry 4y ago
My wild guess is lack of some functions, e.g., regexp, but need to take a deep look.
- 1egg0myegg0 4y agoIt's likely out of memory issues with many many distinct values in an aggregated column, or with a very large join intermediate. The joins are now able to handle larger than RAM, and larger than RAM intermediates in a group by is on the roadmap!
- jerryjerryjerry 4y agoLooking at the failed queries, yes, OOM might be one big factor due to aggregations (there is no join in these queries though).