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
