Support Questions

Find answers, ask questions, and share your expertise

How do I find the creator of a VIEW along with the timestamp?

New Contributor

How do I find the creator of a VIEW along with the timestamp?

1 REPLY 1

Super Guru

@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>;