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

["Ayush Saxena (Jira)" <ji...@apache.org>]

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

Ayush Saxena commented on HIVE-25270:
-------------------------------------

Picking up the FS from database doesn't seems to be very apt.

Better we pick the defaultFs of the client shooting the create table command

> 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: 40m
>  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.20.7#820007)