ClickHouse is an open source column-oriented database management system capable of real time generation of analytical data reports using SQL queries.
It’s made for software like Piwik.
It’s fast (much faster then any other databases), scalable (PBs), Fault Tolerant.
ClickHouse support can be a killer feature of Piwik.
Unfortunately supporting another database than MySQL is going to be a huge project and I don’t think that the core Piwik team has time left for it.
But if you wan’t to help adding support you can contribute code or sponsor a developer.
we can continue discussion in NoSQL support · Issue #2592 · matomo-org/matomo · GitHub