Apache Hive Internal and External Tables
Especially, for querying and analyzing large datasets, Hive is an open source data warehouse system. We can categorize data into Table, Partition, and Bucket. So, in Hive, the table is logically made up of the data being stored. They are of 2 kinds:
– Managed Table (Internal Table)
– External Table
Hive Managed Tables-
A table in Hive manages the data, by default. That says Hive moves the data into its warehouse directory.
Hive External Tables-
Also, we create an external table. So, it is responsible for Hive to refer to the data which is at an existing location outside the warehouse directory.