A Hive view is a logical table. It is just like any RDBMS view. The concept is the same. When a view is created, Hive will not store any data into it. When a view is created, Hive freezes the metadata. Hive does not support the materialized view concept of any RDBMS. The basic purpose of a view is to hide the query complexity. At times, HQL contains complex joins, subqueries, or filters. With the help of view, the entire query can be flattened out in a virtual table.
When a view is created on an underlying table, any changes to that table, or even adding or deleting the table, are invalidated in the view. Also, when a view is created, it only changes the metadata. But when that view is accessed by a query, it triggers the MapReduce ...
