I am curious to know the way to create/migrate storage plugins in Drill without having access to UI. We have this case in production environment where limited ports are accessible.
Is there any folder where i can copy the file with storage plugin semantics.
Also, if i create storage plugins to an RDBMS (say Oracle & MySQL); will the queries be executed using the RDBMS architecture or in Drill Query Engine, is there any documentation around it.
It looks like a data virtualization layer, How will the query execution work if any 2 tables belonging to heterogeneous DB's are joined (one in Oracle and other in MySQL).
Any pointers would be helpful.
Thanks in advance.