Re: [Maria-discuss] Group by pushdown for JDBC or FederatedX

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