I don't think there are any audit tables, but stats are there for tables, partitions and columns. You can get at the statistics information via the describe commands (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Describe).