Hi Luoc, As suggested by you, I have created the JIRA. The link is https://issues.apache.org/jira/browse/DRILL-7870
Regards Prabhakar On Thu, Feb 25, 2021 at 4:40 PM luoc <l...@apache.org> wrote: > 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 > > > > > > > >