Does Apache Drill Supports Multiple Query at a time.?

user_5778595 0
Viewed 1373

I want to run select Sql Server Query at one time. I am using Drill in embedded mode.

select * from <storagePluginName1>.<schemaName>.<tableName>;

select * from <storagePluginName2>.<schemaName>.<tableName>;

Example:-

select * from SqlServer.dbo.`Category`;
select * from sqldemo.dbo.`Attributes`;

Whether Apache Drill Supports Multiple Query at one time or not.??? If Yes then How.??

apache-drill
2 Answers

Unfortunately the answer is NO, at least from the version I used(1.15). Drill parser would regards the ';' separator as an illegal character.

0: jdbc:drill:drillbit=localhost:3001> select 1; select 1;
Error: PARSE ERROR: Encountered ";" at line 1, column 9.
Was expecting one of:
...
user_55009450
Related