Hi Sarnath >From what I understand by your description, you are looking to see if Drill >can push down the GROUP BY clause to the underlying JDBC sources A and B.
Unfortunately, Drill does not support pushdown for the JDBC storage plugin as yet. That said, even if the feature existed, by design, only one fragment can read from a JDBC storage plugin, as it uses a single connection to stream out the resultset. ~ Kunal On 4/9/2019 8:59:49 AM, Sarnath K <stell...@gmail.com> wrote: Hi, I have a requirement where I need to split data between a fast RDBMS system (A) that will have HOT data and a slower cold storage (B) Both A and B provide JDBC drivers I am looking to see if Drill will help me in coming with a JDBC URL (C) which will hide the fact that data is split between A and B. i.e. Can Drill be used to implement Data Virtualization? As much as I can read about Drill, I can definitely create 2 tables in Drill one pointing to A and another to B. However when I do GROUP BY queries or FILTER queries -- Does Drill take advantage of the existing JDBC systems by actually sending a part of the GROUP BY to A and another to B and then reduce the result again? i.e. Some kind of smart predicate push-down for Analytical queries? Hope I sound clear to you. Appreciate your response much. Thank you, Best, Sarnath