...
HiveServer2 operation logs are available to clients starting in Hive 0.14. See See HiveServer2 Logging for configuration.
Audit Logs
Audit logs are logged from the Hive metastore server for every metastore API invocation.
...
An audit log has the function and some of the relevant function arguments logged in the metastore log file. It is logged at the INFO level of log4j, so you need to make sure that the logging at the INFO level is enabled (see HIVE-3505). The name of the log entry is "HiveMetaStore.audit".
Audit logs were added in Hive 0.7 for secure client connections (HIVE-1948) and in Hive 0.10 for non-secure connections (HIVE-3277; also see HIVE-2797).
...
Perf Logger
In order to obtain the performance metrics via the PerfLogger,
...
you need to set DEBUG level logging for the PerfLogger class (HIVE-12675).
...
This can be achieved by setting the following in the log4j properties file.
log4j.logger.org.apache.hadoop.hive.ql.log.PerfLogger=DEBUG
...
If the
...
logger level has already been set
...
to DEBUG at root via hive.root.logger, the above setting is not required to see the performance logs.
DDL Operations
The Hive DDL operations are are documented in Hive Data Definition Language.
Creating Hive Tables
No Format |
---|
hive> CREATE TABLE pokes (foo INT, bar STRING); |
...