[
https://issues.apache.org/jira/browse/HIVE-25270?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
shezm updated HIVE-25270:
-------------------------
Comment: was deleted
(was: Attached patch #1 that changes behavior of create external table without
schema .)
> 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: 20m
> 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)
