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

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.

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;

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?

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

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

sql runner

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

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

Thank you @lenoyjacob for your fast answer !