When will Dremio support Parameterized Queries?

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?

1 Like

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

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.

1 Like

I’ll forward to our product team for consideration!

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

Hi @laurent ,

Did this functionality is supported in latest dremio versions?

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

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…