Find database creation Date.

[#1]

Hi All,

In hive how to get database creation date?

can we get detail from meta data?

[#2]

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