Views

Apache Hive supports views but purely as logical objects with no associated storage. As such, there is no support for materialized views in Hive; therefore, the Apache Hive Wire Protocol driver does not support materialized views.

Apache Hive does not automatically update the view's schema after it is created; therefore, subsequent changes to underlying tables are not reflected in the view's schema. Any modifications that render the view incompatible will cause queries on the view to fail. Views are intended for Read Only access. LOAD, INSERT, and ALTER statements on a view will return an error.