'While creating view in Hive SQL, getting error as duplicate column present

create view comb as select * from dept d join dept_part p on d.dept_name = p.dept_name;

Error Message as "Duplicate column name: dept_name"



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source