Hello! First of all, what is the problem that you are facing? Why DROP TABLE taking 15s while being ran infrequently is a cause for concern?
Regards, -- Ilya Kasnacheev вт, 28 авг. 2018 г. в 17:42, Sriveena Mattaparthi < [email protected]>: > 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 <[email protected]> > *Sent:* 28 August 2018 20:04:09 > *To:* [email protected] > *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 < > [email protected]>: > > 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.” >
