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
118 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 by nitinrawat895
• 10,710 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,280 points
768 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
• 67,660 points
551 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 in Big Data Hadoop by Gitika
• 25,340 points
128 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
• 67,660 points
679 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
• 10,710 points
3,303 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
• 10,710 points
391 views
0 votes
10 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
16,289 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
1,187 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 in Big Data Hadoop by Ved Gupta
6,859 views