How to see the date when the table was created?

问题:

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

show table doesn't give the date creation of the table.

回答1:

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

Detailed Table Information

Database:
Owner:
CreateTime:
LastAccessTime:

回答2:

You need to run the following command:

describe formatted <your_table_name>;

Or if you need this information about a particular partition:

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