How to see table creation date?

Question

I created a table a couple of months ago. Is there any way in HIVE that I can see when the table was created?

show table does not give the date the table was created.

Answer 1

Run the desc formatted <database>.<table_name> command in the hive cli. It will show detailed table information similar to

Details of the table

Database:
Owner:
CreateTime:
LastAccessTime:

Answer 2

You need to run the following command:

 describe formatted <your_table_name>; 

Or, if you need this information about a specific section:

 describe formatted <your_table_name> partition (<partition_field>=<value>); 

Answer 3

I believe that you still have sys.tables inside Hive, that you can SELECT [name], create_date, modify_date.