I have seen cases where if the table is a partitioned one or the data in table is large it will take a lot of time to delete. Also its the case that hive contacts hadoop during deletion of a table and if this connection is delayed it will take more time.
On 22 October 2014 15:14, Dima Machlin <[email protected]> wrote: > Hi, > > Hive (0.12) seems to be very inconsistent with the duration for dropping a > table. > > The tables’ size varies between 5-10 GB. > > > > Here is an example of few drops done in a row : > > > > > > [hadoop@server ~]$ hive > > > > Logging initialized using configuration in > file:/opt/mapr/hive/hive-0.12/conf/hive-log4j.properties > > hive> use DB; > > OK > > Time taken: 1.828 seconds > > hive> drop table T1; > > OK > > Time taken: 4.407 seconds > > hive> drop table T2; > > OK > > Time taken: 0.139 seconds > > hive> drop table T3; > > OK > > Time taken: 2.434 seconds > > hive> drop table T4; > > OK > > Time taken: 4.007 seconds > > hive> drop table T5; > > OK > > Time taken: 64.427 seconds > > hive> drop table T6; > > OK > > Time taken: 63.621 seconds > > hive> drop table T7; > > OK > > Time taken: 63.621 seconds > > hive> drop table T8; > > OK > > Time taken: 0.148 seconds > > hive> drop table T9; > > OK > > Time taken: 63.838 seconds > > hive> drop table T10; > > OK > > Time taken: 1.392 seconds > > hive> drop table T11; > > OK > > Time taken: 0.79 seconds > > hive> drop table T12; > > OK > > Time taken: 0.35 seconds > > > > > > Anyone has idea why dropping a table could take up to 60 seconds? > > > > ----------------------------------------------- > > [image: cid:[email protected]] > > *Dima Machlin, **Big Data Architect* > > 15 Abba Eban Blvd. PO Box 4125, Herzliya 46140 IL > > P: +972-9-9518147 |M: +972-54-5671337|F: +972-9-9584736 > > *Pursway.com* <http://www.pursway.com/> > > > -- Sreenath S Kamath Bangalore Ph No:+91-9590989106
