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;
