Hello Drill users, I have multiple kind of remote database (postgresql, mongodb..) I have tested to query them within drill. It appears drill first ingest data from sources, and then query them.
EG: CREATE TABLE dfs.tmp.test AS SELECT * FROM postgresql.schem.table1 t1 JOIN postgresql.schem.table2 t2 ON t1.id = t2.id Leads to : 1)copy table1 to drill 2)copy table2 to drill 3)Join on drill 4)result It can be problematic if I tables are huge. Is there a solution to make remote database do the join ? I could create a view in postgresql/mongodb and query it, is it the only solution ? Thanks by advance,
