Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Find database creation Date.

avatar
Contributor

Hi All,

In hive how to get database creation date?

can we get detail from meta data?

1 REPLY 1

avatar
Rising Star

@Anishkumar Valsalam You can run the command desc database <db_name>. There you can find the location of hdfs directory where the db exists and then navigate to find the creation date. From hdfs you can run this command to find the creation date

hdfs dfs -stat /apps/hive/warehouse/<db_name.db>