Hello everyone. We just started integrating Drill for a POC (i.e. embedded). Through a REST API a user can submit one or more queries which in turn are sent to Drill via its own REST API (/query.json).
How can I submit multiple queries where the current query may be dependent on the previous one? As an example: 1. use fsfile.`default`; 2. select t1.code, t2.name from `dataFile1.psv` t1 join `dataFile2.psv` t2 on t1.code=t2.code; Can I do this through the REST API or should I be using the JDBC API directly instead to allow for multiple statements to be executed? Thanks.
