Support Questions

Find answers, ask questions, and share your expertise

Hive audit and stats tables.

Explorer

Hi Community members,

Does hive provide any metadata tables in metastore for audits and table stat collection which can be directly queried for audit purpose and query optimization ?

Regards,

Fahim

1 REPLY 1

Explorer

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).