How to set query timeout or cancel query when submit SQL query from SQL tool like DBweaver and sqlline?

[Ray <ra...@cisco.com>]

When I go through this document
https://apacheignite-sql.readme.io/docs/query-cancellation, it seems query
can set timeout if the query submitted through java API(SqlQuery,
SqlFieldsQuery).
So my question is how to set query timeout or cancel query when submit SQL
query from SQL tool like DBweaver?

One more question if query submitted through SQL tool can't be cancelled,
how to set global query timeout parameter?
https://issues.apache.org/jira/browse/IGNITE-2680
In the comments of this ticket, Alexie mentioned the global timeout
parameter is jdbc:h2:~/db/test;query_timeout=10000.
But I don't see a way of setting it.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: How to set query timeout or cancel query when submit SQL query from SQL tool like DBweaver and sqlline?

[Павлухин Иван <vo...@gmail.com>]

Hi Ray,

As far as I know query timeout can be configured only for
SqlQuery/SqlFieldsQuery API. Mentioned global timeout configuration through
"jdbc:h2..." URL was not implemented.