You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Yuto Akutsu (Jira)" <ji...@apache.org> on 2022/01/14 06:14:00 UTC

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

Yuto Akutsu created HIVE-25866:
----------------------------------

             Summary: ALTER DATABASE SET LOCATION does not work on the default database
                 Key: HIVE-25866
                 URL: https://issues.apache.org/jira/browse/HIVE-25866
             Project: Hive
          Issue Type: Bug
          Components: SQL
    Affects Versions: 3.1.2
            Reporter: Yuto Akutsu


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.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)