Thanks Ilya for the quick reply.. We have to drop the table in few cases where the table columns and 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 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 to finish. With increase of load and cluster size 15s does not seem excessive. The suggestion is to avoid dropping/creating tables often, and especially as the course of normal operation. Regards, -- Ilya Kasnacheev вт, 28 авг. 2018 г. в 17:24, Sriveena Mattaparthi <sriveena.mattapar...@ekaplus.com<mailto:sriveena.mattapar...@ekaplus.com>>: 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 and/or privileged information and may be legally protected from disclosure. If you are not the intended recipient of this message or their agent, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited.” “Confidentiality Notice: The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential and/or privileged information and may be legally protected from disclosure. If you are not the intended recipient of this message or their agent, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited.”