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

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

shezm created HIVE-25270:
----------------------------

             Summary: 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
             Fix For: 4.0.0


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)