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
52 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,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,170 points
52 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
• 1,100 points
56 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
• 1,100 points
46 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
6,882 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,710 points
63 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
106 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
31 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
186 views