If your table has a large number of files, it may take a while for Hive to remove all of them from HDFS and thus there's a delay.
To be 100% sure, bump up the logging level of the Hive client to DEBUG and check where the time is being spent. On 31 March 2014 14:02, ch huang <justlo...@gmail.com> wrote: > hi,maillist: > > i find sometime hive drop table will take long time ,why? > > Time taken: 0.994 seconds > hive (default)> drop table t2; > OK > Time taken: 60.661 seconds > hive (default)> drop table t3; > OK > Time taken: 0.229 seconds > -- André Araújo Big Data Consultant/Solutions Architect The Pythian Group - Australia - www.pythian.com Office (calls from within Australia): 1300 366 021 x1270 Office (international): +61 2 8016 7000 x270 *OR* +1 613 565 8696 x1270 Mobile: +61 410 323 559 Fax: +61 2 9805 0544 IM: pythianaraujo @ AIM/MSN/Y! or ara...@pythian.com @ GTalk "Success is not about standing at the top, it's the steps you leave behind." -- Iker Pou (rock climber) -- --
