You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Rajkumar Singh (Jira)" <ji...@apache.org> on 2020/02/08 02:21:00 UTC

[jira] [Updated] (HIVE-22855) Do not change DB location to external if DB URI already exists or already referring to non-managed locattion

     [ https://issues.apache.org/jira/browse/HIVE-22855?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rajkumar Singh updated HIVE-22855:
----------------------------------
    Attachment: HIVE-22855.patch
        Status: Patch Available  (was: Open)

> Do not change DB location to external if DB URI already exists or already referring to non-managed locattion
> ------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-22855
>                 URL: https://issues.apache.org/jira/browse/HIVE-22855
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>         Environment: Hive-3
>            Reporter: Rajkumar Singh
>            Assignee: Rajkumar Singh
>            Priority: Major
>         Attachments: HIVE-22855.patch
>
>
> from Spark:
> {code:java}
> spark.sql("CREATE DATABASE IF NOT EXISTS test LOCATION '/tmp/test'")
> spark.sql("describe database test").show(false)
> {code}
> describe output suggests that DB URI is updated to the external warehouse path, all data will be written to hive warehouse external path which is undesired.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)