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 • 641 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,350 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,370 points • 22,040 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 • 2,112 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 • 1,481 views
0 votes
0 answers

What is the best design for a database table that can be owned by two different resources, and therefore needs two different foreign keys?

Oct 11, 2019 in Database by Daric
 • 500 points • 564 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
 • 23,725 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 • 733 views
0 votes
1 answer

Can we use Apache Sqoop and Hive both together? What is the difference between the two?

Yes, you can. In fact many people ...READ MORE

answered Mar 26, 2018 in Big Data Hadoop by nitinrawat895
 • 11,380 points • 2,785 views
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,350 points • 858 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,350 points • 988 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,350 points • 1,547 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
"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.