[jira] [Work logged] (HIVE-25270) To create external table without schema should use db schema instead of the metastore default fs

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-25270?focusedWorklogId=648942&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-648942 ]

ASF GitHub Bot logged work on HIVE-25270:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 10/Sep/21 00:09
            Start Date: 10/Sep/21 00:09
    Worklog Time Spent: 10m 
      Work Description: github-actions[bot] commented on pull request #2468:
URL: https://github.com/apache/hive/pull/2468#issuecomment-916524765


   This pull request has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
   Feel free to reach out on the dev@hive.apache.org list if the patch is in need of reviews.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

    Worklog Id:     (was: 648942)
    Time Spent: 0.5h  (was: 20m)

> To create external table without schema should use db schema instead of the metastore default fs
> ------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-25270
>                 URL: https://issues.apache.org/jira/browse/HIVE-25270
>             Project: Hive
>          Issue Type: Improvement
>          Components: Metastore
>            Reporter: shezm
>            Assignee: shezm
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.0.0
>
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> Hi
> when hive creates an external table without specifying the schema of the location, such as the following sql
> {code:java}
> CREATE EXTERNAL TABLE `user.test_tbl` (
> id string,
> name string
> )
> LOCATION '/user/data/test_tbl'
> {code}
> The default schema will use the default.fs of metastore conf.
> But in some cases, there will be multiple hadoop namenodes, such as using hadoop federation or hadoop rbf.
> I think that when creating an external table without specifying a schema, the schema of db should be used.



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