HIVE 查询日志位置

Question

我发现很难找到 HIVE 查询日志，基本上我想看看执行了哪些查询。

基本上我想在这种状态下找到查询:

select foo, count(*) from table where field=value group by foo;

Answer 1

来自 Hive documentation :

hive.exec.scratchdir Default Value:

• /tmp/${user.name} in Hive 0.2.0 through 0.8.0
• /tmp/hive-${user.name} in Hive 0.8.1 through 0.14.0
• /tmp/hive in Hive 0.14.0 and later

This directory is used by Hive to store the plans for different map/reduce stages for the query as well as to stored the intermediate outputs of these stages

hive.start.cleanup.scratchdir Default Value: false