Hi. I am facing some problems with Hive. I want to change the location of a database in Hive and for that I am using the SET LOCATION command as follows:
ALTER DATABASE employee SET LOCATION <hdfs_path>;
But the location of this database is still the same. I did not get any errors so I am assuming that the command worked fine but I don't see the change reflecting.