Page History

...

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

  hive> CREATE TABLE pokes (foo INT, bar STRING);

...