When multiple SQL statements are executed in the SQL Runner, any jobs that may have failed is dremio version problem? im currently using 4.5.0

Dremio University
1

When multiple SQL statements are executed in the SQL Runner, any jobs that may have failed is dremio version problem? im currently using 4.5.0.

2

Hi, @Kathiresan , I am not sure to understand your question but if you are trying to run SQL with multiple statements, it will not work. dremio supports only single SQL statements;

3

I’m passing multiple job ID’s in while Loop, sometimes the will return empty and sometimes return a valid response in dremio version of 4.5.0. is any reason for dremio version?

5

@Kathiresan Welcome to Dremio Community. v4.5.0 is pretty old. Try with something newer → v22 & above…

6

@fetanchaud Newer versions of Dremio supports multiple SQLs via the SQL Runner.

sql runner

7

Great news !
Is it working also via the odbc, arrowflight and rest api ?

8

@fetanchaud Only via the UI. Other client side (ODBC/JDBC, Flight & REST) remains the same (one sql per call).

Edit: If you’re using clients like DBeaver, you can always run multiple SQL statements in the same connection…

9

Thank you @lenoyjacob for your fast answer !