In this post, you’ll learn more about the MariaDB Error 1509 ER_COALESCE_ONLY_ON_HASH_PARTITION with the details of the error message and why you receive this error
Maria DB Error Description
MariaDB Error 1509 – ER_COALESCE_ONLY_ON_HASH_PARTITION with the sqlState HY000
Error Description for the MariaDB Error ER_COALESCE_ONLY_ON_HASH_PARTITION
COALESCE PARTITION can only be used on HASH/KEY partitions