I recently decommissioned an analytics node with IP X.X.X.51. After this, I can't execute Shark queries since my Shark/Hive database is bound to the analytics node I just decommisioned:
shark> DESCRIBE DATABASE mykeyspace;
OK
mykeyspace cfs://X.X.X.51/user/hive/warehouse/mykeyspace.db
According to the Hive documentation for ALTER DATABASE I can't change the location of my metadata database. How can I resolve this? Is there any other way for me to change the location IP of my store?
You can't change the location of it. Sad, but true.
However, see https://stackoverflow.com/a/28112448/260805.