Altering the view as select

In this recipe, you will learn how to alter the view as select in Hive.

Getting ready

This command is used to change the SELECT query for the view. The general syntax for altering a view is as follows:

ALTER VIEW view_name AS select_statement;

Where:

select_statement: This is the new SELECT statement for the existing view.

How to do it…

Follow these steps to alter the view as select in Hive. The following SELECT statement is the new statement for the existing view, Hive_view:

alter view hive_view as select id, firstname from sales;