Thanks so much.
> 2021年2月26日 下午12:26,Prabhakar Bhosaale <[email protected]> 写道:
>
> 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 <[email protected]> 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,Зиновьев Олег <[email protected]> 写道:
>>>
>>> Hi.
>>>
>>> Drill does not support dynamic parameters
>>>
>>> Kind regards,
>>> Oleg.
>>>
>>> 25 февр. 2021 г., в 11:27, James Turton <[email protected]
>> .INVALID<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
>>>
>>>
>>>
>>
>>