Re: [jira] [Created] (IGNITE-8595) SQL: Ability to cancel DDL operations

[Ray]

Thanks for the reply, Vladimir.

Is there a ticket to track the cancel feature described by you?



--
Sent from: http://apache-ignite-developers.2346864.n4.nabble.com/

Re: [jira] [Created] (IGNITE-8595) SQL: Ability to cancel DDL operations

[Vladimir Ozerov]

Hi Ray,

We are working on it, All operations will be cancelled in case of either
explicit user request, or when user session is terminated.

On Thu, May 24, 2018 at 12:51 PM, Ray  wrote:

> Hello Vladimir.
>
> From the https://apacheignite-sql.readme.io/docs/query-cancellation, it is
> only possible to cancel select query in java API.
> So select query submitted from thin client(sqlline)/jdbc/odbc is not
> cancellable, is my understanding correct?
>
>
>
>
>
> --
> Sent from: http://apache-ignite-developers.2346864.n4.nabble.com/
>

Re: [jira] [Created] (IGNITE-8595) SQL: Ability to cancel DDL operations

[Ray]

Hello Vladimir.

>From the https://apacheignite-sql.readme.io/docs/query-cancellation, it is
only possible to cancel select query in java API.
So select query submitted from thin client(sqlline)/jdbc/odbc is not
cancellable, is my understanding correct?





--
Sent from: http://apache-ignite-developers.2346864.n4.nabble.com/

[jira] [Created] (IGNITE-8595) SQL: Ability to cancel DDL operations

[Vladimir Ozerov (JIRA)]

Vladimir Ozerov created IGNITE-8595:
---

 Summary: SQL: Ability to cancel DDL operations
 Key: IGNITE-8595
 URL: https://issues.apache.org/jira/browse/IGNITE-8595
 Project: Ignite
  Issue Type: Task
  Components: sql
Reporter: Vladimir Ozerov
 Fix For: 2.6


At the moment it is impossible to cancel DDL operations. Suppose that you 
started {{CREATE INDEX}} on very heavy table. It took hours to finish, and you 
would like to stop it because it is 9:00AM, and users are about to execute many 
queries and {{CREATE INDEX}} will slow them down or even block.

It should be possible to stop DDL operations in the same way it is done for 
{{SELECT}} queries.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)