# 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

**URL:** <https://community.dremio.com/t/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/9700>\
**Category:** Dremio University\
**Created:** [September 19, 2022, 10:16am UTC](https://community.dremio.com/t/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/9700 "2022-09-19T10:16:57Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kathiresan](https://avatars.discourse-cdn.com/v4/letter/k/a9a28c/32.png) [@Kathiresan](https://community.dremio.com/u/Kathiresan)\
**Post date:** [September 19, 2022, 10:16am UTC](https://community.dremio.com/t/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/9700/1 "2022-09-19T10:16:57Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![fetanchaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/fetanchaud/32/4192_2.png) [@fetanchaud](https://community.dremio.com/u/fetanchaud)\
**Post date:** [September 19, 2022, 1:23pm UTC](https://community.dremio.com/t/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/9700/2 "2022-09-19T13:23:14Z")

</div>

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;

---

<div class="post-metadata">

**Author:** ![Kathiresan](https://avatars.discourse-cdn.com/v4/letter/k/a9a28c/32.png) [@Kathiresan](https://community.dremio.com/u/Kathiresan)\
**Post date:** [September 19, 2022, 1:41pm UTC](https://community.dremio.com/t/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/9700/3 "2022-09-19T13:41:30Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![lenoyjacob](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/lenoyjacob/32/3474_2.png) [@lenoyjacob](https://community.dremio.com/u/lenoyjacob)\
**Post date:** [September 19, 2022, 5:15pm UTC](https://community.dremio.com/t/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/9700/5 "2022-09-19T17:15:42Z")

</div>

> [@Kathiresan](#):
>
> dremio version of 4.5.0

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

---

<div class="post-metadata">

**Author:** ![lenoyjacob](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/lenoyjacob/32/3474_2.png) [@lenoyjacob](https://community.dremio.com/u/lenoyjacob)\
**Post date:** [September 19, 2022, 5:19pm UTC](https://community.dremio.com/t/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/9700/6 "2022-09-19T17:19:54Z")

</div>

> [@fetanchaud](#):
>
> dremio supports only single SQL statements;

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

![sql runner](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/b/b321b8c3b6309c9f387bf54a6fcf69d420b6d62a.gif)

---

<div class="post-metadata">

**Author:** ![fetanchaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/fetanchaud/32/4192_2.png) [@fetanchaud](https://community.dremio.com/u/fetanchaud)\
**Post date:** [September 21, 2022, 2:39pm UTC](https://community.dremio.com/t/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/9700/7 "2022-09-21T14:39:24Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![lenoyjacob](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/lenoyjacob/32/3474_2.png) [@lenoyjacob](https://community.dremio.com/u/lenoyjacob)\
**Post date:** [September 21, 2022, 4:13pm UTC](https://community.dremio.com/t/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/9700/8 "2022-09-21T16:13:42Z")

</div>

@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…

---

<div class="post-metadata">

**Author:** ![fetanchaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/fetanchaud/32/4192_2.png) [@fetanchaud](https://community.dremio.com/u/fetanchaud)\
**Post date:** [September 22, 2022, 10:50am UTC](https://community.dremio.com/t/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/9700/9 "2022-09-22T10:50:58Z")

</div>

Thank you @lenoyjacob for your fast answer !