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.
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).
Edit: If you’re using clients like DBeaver, you can always run multiple SQL statements in the same connection…
Thank you @lenoyjacob for your fast answer !