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 in Big Data Hadoop by ravi
• 220 points
87 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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 by nitinrawat895
• 9,030 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,140 points
301 views
0 votes
1 answer

Error creating External Tables in Hive

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

answered Feb 9 in Big Data Hadoop by Omkar
• 65,820 points
118 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 Nov 30, 2018 in Big Data Hadoop by Omkar
• 65,820 points
151 views
0 votes
1 answer

Hive:Unable to insert values to an array column using "insert".

make a dummy table which has at least one row. INSERT ...READ MORE

answered Nov 30, 2018 in Big Data Hadoop by Omkar
• 65,820 points
437 views
0 votes
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
• 9,030 points
1,637 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
• 9,030 points
130 views
0 votes
10 answers

hadoop fs -put command?

copy command can be used to copy files ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Sujay
7,950 views
0 votes
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,260 points
551 views
0 votes
1 answer
0 votes
2 answers

What is Hive? Is Hive a database?

Hey, HIVE:- Hive is an ETL (extract, transform, load) ...READ MORE

answered May 8 in Big Data Hadoop by Gitika
• 6,700 points
3,136 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"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.