0
I bring a less technical SQL question.
I use Hadoop’s Hive tool to manipulate the data with SQL. And I would like to know a real situation where I should apply a Managed table and a External table. Could you give me some example?
The technical difference is basically when we delete the table. It being a Managed table, when I give the command DROP TABLE table_name
, table, data and metadata will be deleted. Already the
External table, by giving this command only the table and the metadata will be deleted, the table data remained stored in the corresponding directory.
Thanks a lot.
I don’t know Hadoop but although the data remains stored they are still accessible?
– anonimo
Prevailing accessible, but not as table.
– mflpps