Differentiate between Hive internal tables an external tables

0 votes
Can you elaborate the difference between Hive internal tables and external tables? I understood that it differs in the way it drops the tables down but why do the table schema and table data get deleted in internal tables and why the external tables delete only the schema of the table? Explain to me this in terms of nodes.
Mar 27, 2019 in Big Data Hadoop by ravi
• 220 points
831 views

1 answer to this question.

0 votes
Hive comprises of an RDBMS(Relational-Database-Management-Systems) on its Master-Node which is used to keep track of the status of the data table.

consider you create a certain table with a certain schema or meta-data, then this particular schema is stored in the RDBMS. In case, if the table is partitioned, then these partitions are stored into a database and hive is allowed to use these lists of partitions to access the data with having the need to go the original file-system to fetch the data. this data which helps the Hive to fetch data is known as Metadata.

This is why when the internal table is dropped, the data along with its schema(metadata) is also dropped.

And when an external table is dropped, only the metadata is dropped making the Hive to ignore the data present in the table.
answered Mar 27, 2019 by nitinrawat895
• 11,380 points

Related Questions In Big Data Hadoop

0 votes
1 answer

What is the difference between Hive internal tables and external tables?

Hive has a relational database on the ...READ MORE

answered Nov 19, 2018 in Big Data Hadoop by Neha
• 6,300 points
2,824 views
0 votes
1 answer

Error creating External Tables in Hive

The path which you have given for ...READ MORE

answered Feb 9, 2019 in Big Data Hadoop by Omkar
• 69,230 points
3,215 views
0 votes
1 answer

what is the difference between CREATE TABLE and CREATE EXTERNAL TABLE in Hive?

Hey, Although, we can create two types of ...READ MORE

answered Jun 26, 2019 in Big Data Hadoop by Gitika
• 65,890 points
1,525 views
0 votes
1 answer

Unable to move Hadoop Hive tables from Source to Destination.

First, check the permissions of HDFS Directory ...READ MORE

answered Dec 1, 2018 in Big Data Hadoop by Omkar
• 69,230 points
6,208 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
10,909 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
2,442 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
108,220 views
–1 vote
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,390 points
4,534 views
0 votes
1 answer
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,609 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