Apache Hive tables are similar to Relational Database. The metadata describes the layout of data in the table. In Hadoop, data lives in HDFS. HIVE stores metadata in the relational database and not in HDFS.
There are two types of tables in HIVE:
Managed Tables (Internal)
External Tables.