← Back to team overview

maria-discuss team mailing list archive

Re: Group by pushdown for JDBC or FederatedX


Hi, Dan!

On Jul 03, Dan Hill 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).

No, at the moment neither FederatedX nor CONNECT engines
support group by pushdown.

The server supports it, some engines support it (namely, ColumnStore and
Spider), but not all.

VP of MariaDB Server Engineering
and security@xxxxxxxxxxx

Follow ups