question Re: analyze table compute statistics - staging directory in Archives of Support Questions (Read Only)

analyze table compute statistics - staging directory

vtpcnk — Wed, 04 Oct 2017 03:03:46 GMT

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.

Re: analyze table compute statistics - staging directory

thussain — Wed, 04 Oct 2017 18:37:37 GMT

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

Re: analyze table compute statistics - staging directory

vtpcnk — Thu, 05 Oct 2017 02:58:40 GMT

thanks so much thussain. worked fine.