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
