Hi, ANother way is to concat tablename to the schema name as follows select t1.code, t2.name from fsfile.default.`dataFile1.psv` t1 join fsfile.default.`dataFile2.psv` t2 on t1.code=t2.code;
Regards Prabhakar On Thu, Feb 25, 2021 at 2:41 AM Charles Givre <[email protected]> wrote: > 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 <[email protected]> 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. > >
