Hi. Drill does not support dynamic parameters
Kind regards, Oleg. 25 февр. 2021 г., в 11:27, James Turton <[email protected]<mailto:[email protected]>> написал(а): 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
