Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

analyze table compute statistics - staging directory

avatar
Contributor

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.

1 ACCEPTED SOLUTION

avatar
Contributor
@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;

View solution in original post

2 REPLIES 2

avatar
Contributor
@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;

avatar
Contributor

thanks so much thussain. worked fine.