Hi Igniters! As you might know currently we have many open issues relating to current H2 based engine and its execution flow.
Some of them are critical (like impossibility to execute particular queries), some of them are majors (like impossibility to execute particular queries without pre-preparation your data to have a collocation) and many minors. Most of the issues cannot be solved without whole engine redesign. So, here the proposal: https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=130028084 I'll appreciate if you share your thoughts on top of that. Regards, Igor