External

Internal

The Apache Hive data warehouse facilitates reading, writing, and managing large datasets residing in distributed storage using SQL

The Hive metastore contains all the metadata about the data and tables in the EMR cluster, which allows for easy data analysis.