hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shantian Purkad <>
Subject External tables pros & cons
Date Tue, 26 Apr 2011 16:18:46 GMT

What is the difference between external table and managed tables (apart from 
data being stored outside hive warehouse and not deleted when table is dropped)

Are there any drawbacks of external tables? Or lack of support for certain 
features (such as indexes, joins, subqueries etc etc )?

When and why should one not use external tables?

Thanks and Regards,
View raw message