# When will Dremio support Parameterized Queries?

**URL:** <https://community.dremio.com/t/when-will-dremio-support-parameterized-queries/2618>\
**Category:** Uncategorized\
**Created:** [January 24, 2019, 4:30pm UTC](https://community.dremio.com/t/when-will-dremio-support-parameterized-queries/2618 "2019-01-24T16:30:28Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![summersmd](https://avatars.discourse-cdn.com/v4/letter/s/f9ae1b/32.png) [@summersmd](https://community.dremio.com/u/summersmd)\
**Post date:** [January 24, 2019, 4:30pm UTC](https://community.dremio.com/t/when-will-dremio-support-parameterized-queries/2618/1 "2019-01-24T16:30:28Z")

</div>

We have an urgent need to implement parameterized queries in our prototype of the Dremio platform. We’re working on a POC using a variety of tools and were wondering if this functionality exists and if not is it on your roadmap?

---

<div class="post-metadata">

**Author:** ![laurent](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/laurent/32/16_2.png) [@laurent](https://community.dremio.com/u/laurent)\
**Post date:** [January 24, 2019, 4:38pm UTC](https://community.dremio.com/t/when-will-dremio-support-parameterized-queries/2618/2 "2019-01-24T16:38:55Z")

</div>

The feature currently doesn’t exist although on our radar. No ETA at that time.

---

<div class="post-metadata">

**Author:** ![mknoop](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/mknoop/32/1552_2.png) [@mknoop](https://community.dremio.com/u/mknoop)\
**Post date:** [April 17, 2019, 5:45pm UTC](https://community.dremio.com/t/when-will-dremio-support-parameterized-queries/2618/3 "2019-04-17T17:45:22Z")

</div>

This we be a use huge help for us as well. We are trying to build some micro services with Dremio as the backend. I cant get parameterized queries to work with the JDBC or ODBC drivers.

---

<div class="post-metadata">

**Author:** ![laurent](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/laurent/32/16_2.png) [@laurent](https://community.dremio.com/u/laurent)\
**Post date:** [April 22, 2019, 6:14pm UTC](https://community.dremio.com/t/when-will-dremio-support-parameterized-queries/2618/4 "2019-04-22T18:14:30Z")

</div>

I’ll forward to our product team for consideration!

---

<div class="post-metadata">

**Author:** ![marcos.llama](https://avatars.discourse-cdn.com/v4/letter/m/7ea924/32.png) [@marcos.llama](https://community.dremio.com/u/marcos.llama)\
**Post date:** [June 4, 2019, 12:15pm UTC](https://community.dremio.com/t/when-will-dremio-support-parameterized-queries/2618/5 "2019-06-04T12:15:56Z")

</div>

Hi,

It would be of great use for me as well, to be able to pass parameters to the underlying query doing something like:

select v.\* from (select @month\_year:=‘022019’) parm, database\_name.view\_name v

This really would make a difference, as my underlying database (MariaDB) queries take too long to complete if I don’t filter by month.

Thank you for taking into consideration!  
Marcos

---

<div class="post-metadata">

**Author:** ![sauku](https://avatars.discourse-cdn.com/v4/letter/s/94ad74/32.png) [@sauku](https://community.dremio.com/u/sauku)\
**Post date:** [September 16, 2022, 6:19am UTC](https://community.dremio.com/t/when-will-dremio-support-parameterized-queries/2618/6 "2022-09-16T06:19:41Z")

</div>

Hi @laurent ,

Did this functionality is supported in latest dremio versions?

---

<div class="post-metadata">

**Author:** ![diovasques](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/diovasques/32/4805_2.png) [@diovasques](https://community.dremio.com/u/diovasques)\
**Post date:** [March 20, 2023, 5:10pm UTC](https://community.dremio.com/t/when-will-dremio-support-parameterized-queries/2618/7 "2023-03-20T17:10:45Z")

</div>

I guess not. I’m still getting this error even when using the Arrow Flight JDBC Driver…

```auto
Hibernate: 
    select
        orderdto0_."Order Number" as col_0_0_,
        orderdto0_."Creation Date" as col_1_0_,
        orderdto0_."Payment Terms" as col_2_0_,
        orderdto0_."Brand" as col_3_0_ 
    from
        cust_portal_order_status_vw orderdto0_ 
    where
        orderdto0_."Business Tax ID"=?
13:41:48.124 [http-nio-8080-exec-2] WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: null
13:41:48.127 [http-nio-8080-exec-2] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - parameter ordinal 1 out of range
13:41:48.130 [http-nio-8080-exec-2] ERROR com.xx.controller.OrdersController - org.hibernate.exception.GenericJDBCException: could not execute query

```

I’d really like to know why it isn’t supported yet…