analyze table compute statistics - staging directory

[#1]

Is it possible to specify the staging directory for analyze table compute statistics instead of accepting the default that is.

In our DR, the target hive database directory is read only but we have to keep our metadata in sync and need to run this command. But since the database directory is read only, the command fails.

Appreciate any insights.

[#2 · Accepted solution]

@n c

You can set use the hive.exec.staging.dir property to have the staging dir created in a HDFS location having sufficient permissions.

For example:

set hive.exec.stagingdir=/tmp/.hivestaging;

[#3]

thanks so much thussain. worked fine.