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
34 views

1 answer to this question.

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,240 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
32 views
0 votes
1 answer

How will I get all the rows from my table where name starts with 's' and ending with 'I'?

Hi Santanu, I understand your problem, You can try ...READ MORE

answered May 28 in Database by Sampriti
• 860 points
32 views
0 votes
1 answer

Do I need to add primary key in each and every table?

Hi Shraddha, You have a doubt to add ...READ MORE

answered May 29 in Database by Sampriti
• 860 points
31 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,360 points
68 views
0 votes
3 answers

What is Hive? Is Hive a database?

Hive is a data Warehouse infrastructure/system built ...READ MORE

answered Jul 1 in Big Data Hadoop by Ved Gupta
4,512 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
• 10,110 points
43 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,240 points
86 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,240 points
23 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,240 points
96 views