How do I find the creator of a VIEW along with the timestamp?
@MONORANJAN MOHAPATRA, Can you try to do
Hive# desc formatted <database-name.view-name>;
# Detailed Table Information Database: Owner: CreateTime:
Once you execute desc formatted command you find CreateTime,Owner of the view from Detailed Table Information section.
In addition if you want to see the create view statement then use, as views also treated as tables in hive
Use the below statement it will displays the create statement of the view.
show create table <database-name.view-name>;