Can we create a table based on a view in Hive?

Can we create a table based on a view in Hive?

Yes, we can.!!

Let’s create “View” by combining Emp and Dept tables.

-~ To create a view

CREATE VIEW Emp_View
AS
SELECT Ename, DName FROM Emp
INNER JOIN Dept ON Emp.DeptNo = Dept.DeptNo;

Now let’s create the table based on the view.

CREATE TABLE EmpDept
AS
SELECT * FROM Emp_View;