Hive - Scratch Directory

Scratch space for Hive jobs.

This directory is used by Hive to store:

• the plans for different map/reduce stages for the query
• intermediate outputs of plan operations

The default value is /tmp/hive

conf value

• in remote mode hive.exec.scratchdir
• in Local Mode: hive.exec.local.scratchdir

Example:

bin/hive or bin/beeline --hiveconf hive.exec.scratchdir=/tmp/mydir

• Hadoop - Winutils to set up the correct permissions.

winutils.exe chmod -R 777 c:\tmp\hive