Hi, It is not currently supported (See also `org.apache.drill.jdbc.PreparedStatementTest#testSqlQueryWithParamNotSupported()`). However, Drill is a user-centric software. So, Would you please create a JIRA on https://issues.apache.org <https://issues.apache.org/>? then we will evaluate whether to develop. thanks
> 2021年2月25日 下午5:37,Зиновьев Олег <le.lo...@live.ru> 写道: > > Hi. > > Drill does not support dynamic parameters > > Kind regards, > Oleg. > > 25 февр. 2021 г., в 11:27, James Turton > <ja...@somecomputer.xyz.INVALID<mailto:ja...@somecomputer.xyz.INVALID>> > написал(а): > > 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 > > >