# JDBC PreparedStatement fails. Cannot convert RexNode to equivalent Dremio expression **URL:** \ **Category:** Uncategorized\ **Created:** [November 10, 2020, 11:14pm UTC](https://community.dremio.com/t/jdbc-preparedstatement-fails-cannot-convert-rexnode-to-equivalent-dremio-expression/6567 "2020-11-10T23:14:58Z")\ **Posts on this page:** 9\ **Page:** 2
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [December 9, 2022, 6:22am UTC](https://community.dremio.com/t/jdbc-preparedstatement-fails-cannot-convert-rexnode-to-equivalent-dremio-expression/6567/21 "2022-12-09T06:22:05Z")
@hewitte Agree with your concern, As per @Brandon_Jackson The support needed is for prepare statements that can parameterized, correct? This is a road map item in Dremio that is currently in the backlog. @Benny_Chow and I will do some research on the status of the feature and get back to you soon ---
**Author:** ![Brandon\_Jackson](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/brandon_jackson/32/1509_2.png) [@Brandon\_Jackson](https://community.dremio.com/u/Brandon_Jackson)\ **Post date:** [December 13, 2022, 9:11pm UTC](https://community.dremio.com/t/jdbc-preparedstatement-fails-cannot-convert-rexnode-to-equivalent-dremio-expression/6567/22 "2022-12-13T21:11:54Z")
Hi Balaji, Yes, statements that are parameterized is what I need support for to expand interoperability. Thank you both for your diligence. I do not need the world, just certain pieces of the world. @hewitte nailed it. We use a lot of reporting tools that that use parameterized prepared statements to read data. Because I was adding support for Dremio within the Apache Hop ETL tool, initially I made some assumptions about the support. Perhaps reading queries would be supported but write queries would not be, but unfortunately I discovered no parameters are allowed in either case, so I backed off for a while. I am now running Dremio Cloud Enterprise Edition with Arctic to conduct more tests. @Benny_Chow so good to see you man! I learned more about the small file case in Iceberg and compaction. I get that. Now I am looking more into functional interoperability in Dremio. For example how well does Dremio Arrow ODBC drivers work with Excel for some of our users (it does not work at all on 23.1). How can I maintain Iceberg tables with the desire to use Nessie, but also to use other tools in AWS that depend on Glue/Hive. I am thinking of CDC/Kafka sync between the catalogs. I think there is really something wonderful in Nessie that I hope many engines will adopt so I can have one catalog and the consistency instead of multiple catalogs and awkward imports of tables and data. Warm regards, Brandon ---
**Author:** ![M.Gross](https://avatars.discourse-cdn.com/v4/letter/m/8edcca/32.png) [@M.Gross](https://community.dremio.com/u/M.Gross)\ **Post date:** [August 7, 2023, 5:48pm UTC](https://community.dremio.com/t/jdbc-preparedstatement-fails-cannot-convert-rexnode-to-equivalent-dremio-expression/6567/23 "2023-08-07T17:48:53Z")
Hi Balaji, as we are 8 months later, may I ask for an update? Parameterized query are the standard and it would be great, if Dremio would support this too. ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [August 15, 2023, 6:42am UTC](https://community.dremio.com/t/jdbc-preparedstatement-fails-cannot-convert-rexnode-to-equivalent-dremio-expression/6567/24 "2023-08-15T06:42:48Z")
@M.Gross Checking and will get back shortly ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [August 15, 2023, 8:52pm UTC](https://community.dremio.com/t/jdbc-preparedstatement-fails-cannot-convert-rexnode-to-equivalent-dremio-expression/6567/25 "2023-08-15T20:52:37Z")
@M.Gross Its in the next 6 month to 9 month road map ---
**Author:** ![lguerrin](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/lguerrin/32/5669_2.png) [@lguerrin](https://community.dremio.com/u/lguerrin)\ **Post date:** [May 16, 2024, 7:44am UTC](https://community.dremio.com/t/jdbc-preparedstatement-fails-cannot-convert-rexnode-to-equivalent-dremio-expression/6567/26 "2024-05-16T07:44:02Z")
Hi, We are 9 month later… and I have the same issue. Can you tell me what the deadline is? Thanks ---
**Author:** ![quangbilly79](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/quangbilly79/32/6549_2.png) [@quangbilly79](https://community.dremio.com/u/quangbilly79)\ **Post date:** [January 8, 2025, 4:05am UTC](https://community.dremio.com/t/jdbc-preparedstatement-fails-cannot-convert-rexnode-to-equivalent-dremio-expression/6567/27 "2025-01-08T04:05:06Z")
I’m in the same situation as you, any luck so far? ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [January 8, 2025, 6:30am UTC](https://community.dremio.com/t/jdbc-preparedstatement-fails-cannot-convert-rexnode-to-equivalent-dremio-expression/6567/28 "2025-01-08T06:30:31Z")
@quangbilly79 Hi It is targeted for V26. At this point there is no exact date for the release. ---
**Author:** ![Benny\_Chow](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/benny_chow/32/5527_2.png) [@Benny\_Chow](https://community.dremio.com/u/Benny_Chow)\ **Post date:** [January 25, 2025, 4:38am UTC](https://community.dremio.com/t/jdbc-preparedstatement-fails-cannot-convert-rexnode-to-equivalent-dremio-expression/6567/29 "2025-01-25T04:38:58Z")
Some good news here: > [@Is parameterized SQL not supported by Dremio?](https://community.dremio.com/t/is-parameterized-sql-not-supported-by-dremio/4650/22): > > Parameterized prepared statements has already been released to Dremio Cloud and the documentation is here: [JDBC Driver for Arrow Flight SQL | Dremio Documentation](https://docs.dremio.com/cloud/sonar/client-apps/drivers/arrow-flight-sql-jdbc/#parameterized-queries-with-prepared-statements) The same docs should apply to v26 which is targeted for 2025. Regarding the implementation, the primary driver was security and preventing SQL injection attacks. Parameterized SELECT statement will also benefit from the existing plan cache feature. [Previous page](https://community.dremio.com/t/jdbc-preparedstatement-fails-cannot-convert-rexnode-to-equivalent-dremio-expression/6567.md?page=1)