External and Managed Table : HIVE

0 votes
What are the differences between External and Managed Table in HIVE?
Aug 30, 2018 in Database by Ashish
• 2,630 points
28 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
The metadata information along with the table data is deleted from the Hive warehouse directory if one drops a managed table.

Whereas in case of an External table, Hive just deletes the metadata information regarding the table. Further, it leaves the table data present in HDFS untouched.

Hope this helps
answered Aug 30, 2018 by kurt_cobain
• 9,260 points

Related Questions In Database

0 votes
1 answer

What do ‘Record’, ‘Field’ and ‘Table’ mean in terms of a database?

You can refer to the following definitions ...READ MORE

answered Nov 12, 2018 in Database by darklord
• 6,140 points
21 views
0 votes
1 answer

What is MSLAB and LZO?

MSLAB stands for Memstore-Local Allocation Buffer. Lempel-Ziv-Oberhumer (LZO) ...READ MORE

answered Jul 10, 2018 in Database by Data_Nerd
• 2,340 points
54 views
0 votes
1 answer

Table design approach Hbase

Tall-Narrow and Flat-Wide are the two HBase ...READ MORE

answered Jul 10, 2018 in Database by Data_Nerd
• 2,340 points
147 views
0 votes
1 answer

HLog and WAL in Hbase.

All edits in the HStore are stored ...READ MORE

answered Jul 16, 2018 in Database by Data_Nerd
• 2,340 points
276 views
0 votes
2 answers

What is Hive? Is Hive a database?

Hey, HIVE:- Hive is an ETL (extract, transform, load) ...READ MORE

answered May 8 in Big Data Hadoop by Gitika
• 7,140 points
3,161 views
0 votes
1 answer

Hadoop on cassandra database

Regarding your question - there is a ...READ MORE

answered Mar 26, 2018 in Big Data Hadoop by nitinrawat895
• 9,030 points
34 views
0 votes
1 answer
0 votes
1 answer

What is a importance of Hive ODBC Connector

The Cloudera ODBC Driver for Hive enables ...READ MORE

answered Apr 10, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
53 views
0 votes
1 answer

Common Hive Services

The following are commonly used services of ...READ MORE

answered Aug 30, 2018 in Database by kurt_cobain
• 9,260 points
18 views
0 votes
1 answer

Hcatalog in HIVE

HCatalog supports reading and writing files in ...READ MORE

answered Aug 30, 2018 in Database by kurt_cobain
• 9,260 points
67 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.