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? ----------------------------------------------- [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/>
