Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

HIVE query logs location

Tags:

hive

I am find very difficult to locate the HIVE query logs, basically i want to see what queries were executed.

Basically i want to find the queries in this state:

select foo, count(*) from table where field=value group by foo;
like image 451
SQL.injection Avatar asked Oct 18 '22 18:10

SQL.injection


1 Answers

From 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

like image 107
Samson Scharfrichter Avatar answered Jan 04 '23 05:01

Samson Scharfrichter