[HIVE-25866] ALTER DATABASE SET LOCATION does not work on the default database

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 3.1.2
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuto Akutsu
• Created: 14/Jan/22 06:13
• Updated: 14/Jan/22 06:13

Description

After I tried ALTER DATABASE SET LOCATION command on the default database to change the location of table data stored, Hive still outputted the table data on the initial location.

I checked the DBS table in metastore_db to see if the location uri of the default database has been changed and it has, so I assume Hive outputs table data of the default database in the initial location no matter if you change it.