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. ... View more

We have a hive database on cluster 1. We want to move this hive database to cluster 2. Both clusters have other hive databases as well. For Hive backup, we normally backup the hive metadata on MYSQL and also the physical hive files (database directories with table sub-directories) and use this for restore. So for this purpose of backing up a single database we can get the particular database's data directory. But how to get the metadata for a particular database from MYSQL? Appreciate any insights. ... View more

Will truncating a HBASE table affect the region server spread of data? Let us suppose I export the data of a HBASE table. Somebody deletes a lot of rows and now the app group wants to recover the table data from the backed up export. So now I truncate the table and then I import the data from the exported data. What effect will it (truncate/import) have on the region server on which the table originally existed? Appreciate the insights. ... View more