Hi All,

first of all, thanks for make Apache Drill available to us, it is a really
great software in my honest opinion.

Since I was new to develop Drill, *I was wondering how to execute two
Queries at once via Rest API.*


1. First Business Case

For example, I have Postgresql *Storage *named *psql. *Inside the DB, there
is *postgres *schema, I execute this query command on Apache Drill Web
Interface and Drill-Embedded Shell

USE psql.postgres


Then I fetch out rows from *student_list *table.

SELECT * FROM student_list


This is already done and working perfectly.



2. Second Business Case

I need to repeat the query via REST API. Then I send this query via HTTP
Requests.

SELECT * FROM psql.postgres.student_list


This was also working perfectly



3. -Still working on it- Business Case

Sometimes the query is more complex, and I need to call it via HTTP request
too.

Is it possible to query this

USE psql.postgres; SELECT * FROM student_list;


with two 'sentences' in one Query Syntax,

instead of

 SELECT * FROM psql.postgres.student_list


?


Because, when I tried to, send with two separate syntax through two HTTP
request call,
*it failed.*


*[image: Inline image 1]*
What do you suggest for us?




best regards,

-- 
Muhammad Fahreza

Reply via email to