HI there, I don't think the Drill REST API accepts multiple queries in one request. However there is an alternative which doesn't appear to be in the documentation. When you submit your query there is a parameter called defaultSchema (I think) that you can set that has the effect of executing a USE statement prior to the query. That will accomplish what you're trying to do there.
Best, -- C > On Feb 24, 2021, at 3:42 PM, KimJohn Quinn <k...@logicdrop.com> wrote: > > 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.
