This page makes it seem like some types of group by push downs are supported.
https://mariadb.com/kb/en/connect-external-table-types/

On Fri, Jul 3, 2020 at 7:11 PM Dan Hill <quietgolfer@gmail.com> wrote:
Hi!

I'm evaluating if I can use Maria's JDBC connector to join tables from Apache Pinot (they have a prototype jdbc connector). 

When external tables are used (like JDBC or FederatedX), are group bys pushed down or do these connectors return the raw rows to Maria?  I see comments about lack of filter pushdowns for FederatedX.  I wouldn't the raw level data coming back from Pinot (there are too many rows to be performant).

Thanks!
- Dan