RE: Drop table taking more time for execution

2018-08-29 Thread Sriveena Mattaparthi
.org Subject: Re: Drop table taking more time for execution Next time if there is change in the data from the data source in terms of addition of new column or delete column...Then we drop the table in ignite and recreate it. Is there any reason why you can't use ALTER TABLE command for the addi

Re: Drop table taking more time for execution

2018-08-29 Thread Denis Magda
gt; datatypes changes ... > I guess alter table to add/ drop columns may take same longer time. > > Any other alternative to drop table? > > Regards, > Sriveena > > From: Ilya Kasnacheev ilya.kasnach...@gmail.com>> > Sent: 28 Aug

Re: Drop table taking more time for execution

2018-08-28 Thread Ilya Kasnacheev
it. > > Thanks, > Sriveena > > From: Ilya Kasnacheev > Sent: 28 August 2018 20:21:20 > To: user@ignite.apache.org > Subject: Re: Drop table taking more time for execution > > Hello! > > First of all, what is the problem that you are facing? Why DROP TABLE &

Re: Drop table taking more time for execution

2018-08-28 Thread Sriveena Mattaparthi
and recreate it. Thanks, Sriveena From: Ilya Kasnacheev Sent: 28 August 2018 20:21:20 To: user@ignite.apache.org Subject: Re: Drop table taking more time for execution Hello! First of all, what is the problem that you are facing? Why DROP TABLE taking 15s while being ran

Re: Drop table taking more time for execution

2018-08-28 Thread Ilya Kasnacheev
> *From:* Ilya Kasnacheev > *Sent:* 28 August 2018 20:04:09 > *To:* user@ignite.apache.org > *Subject:* Re: Drop table taking more time for execution > > Hello! > > As far as my understanding goes, DROP TABLE will usually destroy a cache, > and that will require pa

Re: Drop table taking more time for execution

2018-08-28 Thread Sriveena Mattaparthi
Kasnacheev Sent: 28 August 2018 20:04:09 To: user@ignite.apache.org Subject: Re: Drop table taking more time for execution Hello! As far as my understanding goes, DROP TABLE will usually destroy a cache, and that will require partition map exchange, which in turn will wait for all operations

Re: Drop table taking more time for execution

2018-08-28 Thread Ilya Kasnacheev
Hello! As far as my understanding goes, DROP TABLE will usually destroy a cache, and that will require partition map exchange, which in turn will wait for all operations to finish. With increase of load and cluster size 15s does not seem excessive. The suggestion is to avoid dropping/creating

Drop table taking more time for execution

2018-08-28 Thread Sriveena Mattaparthi
Hi, Execution of drop table command is taking 15 sec on client node.Any suggestions to spewed up the execution. Thanks & Regards, Sriveena "Confidentiality Notice: The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential