Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Find database creation Date.

Highlighted

Find database creation Date.

Contributor

Hi All,

In hive how to get database creation date?

can we get detail from meta data?

1 REPLY 1

Re: Find database creation Date.

Contributor

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