Query optimization by using Rules

2016-09-17 Thread Γιώργος Θεοδωράκης
Hi, I am trying to create a basic planner that enforces rules on simple queries. At the moment I have created a planner from the examples (and samza-sql integration I found online) and used HepPlanner for testing some rules. My question is which form should my test data be? I am using something li

Re: Query optimization by using Rules

2016-09-17 Thread Julian Hyde
The form of your test data depends on the kind of rules you are writing. If you are aiming to push down a lot of operations down to a particular engine (e.g. Druid can handle everything except Join) then you should run on that engine. If you are interested mainly in logical transformation rules

Re: Query optimization by using Rules

2016-09-17 Thread Γιώργος Θεοδωράκης
Thank you for the quick response Julian, I am interested mainly in logical transformation rules. I try to create an optimized logical plan and transform it in a physical one in my engine. The engine is streaming and uses ByteBuffers, and I am wondering if it is possible to optimize simple queries