Hi James, thanks for your reply. But it is giving error *java.sql.SQLException*: [MapR][DrillJDBCDriver](500980) Encountered error while creating prepared statement. Details: PLAN ERROR: Cannot convert RexNode to equivalent Drill expression. RexNode Class: org.apache.calcite.rex.RexDynamicParam, RexNode Digest: ?0
after googling i understood that it is not supported. So just wanted to understand is there any further updates on it? thanks Regards Prabhakar On Thu, Feb 25, 2021 at 1:57 PM James Turton <[email protected]> wrote: > If I remember right, prepared statements will cause the JDBC driver to > run a > > SELECT * from (your query) LIMIT 0 > > for schema discovery before running your query. As you may deduce from > the syntax I've shown, this works but only for when your query is itself > a SELECT. One conclusion one could draw is: only use prepared > statements for SELECTs. > > On 2021/02/25 09:25, Prabhakar Bhosaale wrote: > > Hi Team, > > I am integrating pentaho with Drill to create the reports on drill file > > storage. I have created the view on files which are accessible in pentaho > > as views. > > I am trying to send the prepared statement to query these views. But it > > seems Drill JDBC driver does not support prepared statements. > > Any further updates on this? is there any updated JDBC driver > > available which supports prepared statement? thanks > > > > > > Regards > > Prabhakar > > > >
