calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacques Nadeau <jacq...@apache.org>
Subject Re: Using Calcite pushdown rules with MySQL
Date Thu, 27 Aug 2015 05:22:49 GMT
I suggest you look at the jdbc adapter. It does a bunch of this already.
On Aug 25, 2015 10:31 PM, "Ken" <naturen@gmail.com> wrote:

> Hi all,
>
> I'm using Calcite with MySQL as my datasource now. The thing I'm trying is
> to create some rules which will modify my original sql and pushdown to
> database. I followed the query over CSV example in tutorial but meet some
> problem. Here are my steps:
>
> 1. My customise rule class(MysqlPushDownRules) extends the RelOptRule, and
> register the rules in its constructor method. This will be matched with
> incoming query and when it matches, the onMatch method in the Rule class
> will be called.
>
> 2. From the tutorial, I then need to register the rules by a tablescan
> class which extends  TableAccessRelBase and implement EnumberableRel, and
> override the method register.
>
> In my case of using MySQL as datasoure, where should I implement this? I'm
> not sure that should I implement another table scan class for MySQL and
> register my rules. Can any one have experience help me with this? Or
> correct my misunderstand of using pushdown rules in Calcite.
>
> Thanks in advance.
>
> Ken
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message