Query error out with "Request has exceeded memory quota" when quota is not set (default 0)

Query: SELECT customer.address_id, AVG(payment.amount) AS AveragePayments
FROM payment
LEFT JOIN customer ON payment.customer_id = customer.customer_id
GROUP BY customer.address_id
limit 10

Result: Got 10 results

Error:  Request has exceeded memory quota

Note: Query Memory was left at the default 0 on the cluster setting. 

Env: http://172.23.121.1:8091/  Beta2 - Enterprise Edition 7.0.0 build 4554 

https://cb-jira.s3.us-east-2.amazonaws.com/logs/QE/collectinfo-2021-03-19T184119-ns_1%40172.23.121.40.zip