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,650 points
218 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,390 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 Sahiti
• 6,380 points
10,414 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, 2019 in Database by sampriti
• 1,120 points
650 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, 2019 in Database by sampriti
• 1,120 points
350 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, 2019 in Big Data Hadoop by Ved Gupta
19,534 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
• 11,380 points
265 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,390 points
380 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,390 points
454 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,390 points
831 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP