SQL - Managed Table vs External Table

Asked

Viewed 23 times

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?

  • Prevailing accessible, but not as table.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.