Created 06-28-2017 03:35 AM
Hi All,
In hive how to get database creation date?
can we get detail from meta data?
Created 06-28-2017 04:12 AM
@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>