When will Dremio support Parameterized Queries?

1

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
2

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

3

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
4

I’ll forward to our product team for consideration!

5

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

6

Hi @laurent ,

Did this functionality is supported in latest dremio versions?

7

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…