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.
You can set use the hive.exec.staging.dir property to have the staging dir created in a HDFS location having sufficient permissions.
View solution in original post
thanks so much thussain. worked fine.