We have a requirement where two of our clusters is sharing the same Hive metastore. We are storing the data in S3.
Due to some requirement we had to move the S3 buckets. After this we repaired the tables in one cluster and everything is running fine. On the other cluster we did not repair the tables assuming that running on the first cluster should be fine.
But on the second cluster the queries are throwing error as "S3 path does not exist".
So, is it not sufficient to repair the tables from one cluster which updates the hive metastore? Is it required to repair the same tables from other cluster as well?