JDBC PreparedStatement fails. Cannot convert RexNode to equivalent Dremio expression

The online documentation provide no details on what methods etc the JDBC driver is supposed to support or not.

Server 4.9.3-202010281843560195-edc49b6d
Driver 4.9.1-202010230218060541-2e764ed0

Attempting to use the PreparedStatement interface fails.

Connection.prepareStatement(select * from dbcert.tsint where csint = ?)

SQLException.getSQLState returned a null
SQLException.sqlState(null) SQLException.Message(Failed to create prepared statement: error_id: “e8ad9501-1c43-40db-ada5-e44499e6f4b5”
endpoint {

roles {
sql_query: true
java_executor: false
master: true
}
start_time: 1604771734645
max_direct_memory: 2837446656
available_cores: 8
node_tag: “”
conduit_port: 38827
dremio_version: “4.9.3-202010281843560195-edc49b6d”
}
error_type: PLAN
message: “PLAN ERROR: Cannot convert RexNode to equivalent Dremio expression. RexNode Class: org.apache.calcite.rex.RexDynamicParam, RexNode Digest: ?0\n\n\n[Error Id: e8ad9501-1c43-40db-ada5-e44499e6f4b5 on 172.31.22.93:31010]\n\n”
original_message: “Cannot convert RexNode to equivalent Dremio expression. RexNode Class: org.apache.calcite.rex.RexDynamicParam, RexNode Digest: ?0”
)

@dqmdev

Can you please provide us the job profile?

Just create a simple Java/JDBC test program using any VDS.

String s = "select * from dbcert.tint where cint = ? ";
PreparedStatement stmt = dbConnection.prepareStatement(s);

24a220e9-58d5-42b4-b1d5-565d1e93890d.zip (6.5 KB)

@dqmdev

‘?’ is a character, what should the expected resulted be for this query?

Did you mean to give single quotes around the filter value?

Example

select * from dbcert.tint where cint = ‘?’

The statement is using a JDBC parameter marker (the question mark).

Does Dremio JDBC driver claim to support
(a) Prepared Statements
(b) Parameter markers in Prepared Statements

@dqmdev,

Currently we do not support this

Where is Dremio capturing enhancement requests or showing roadmap etc?