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
Rising Star

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
Rising Star
@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
Rising Star
@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
Rising Star

thanks so much thussain. worked fine.