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

[Anton Vinogradov (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)

[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/

[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 <[hidden email]> 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/
>

[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/