[ 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 d...@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-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@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)