[
https://issues.apache.org/jira/browse/HIVE-24970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Naveen Gangam reassigned HIVE-24970:
------------------------------------
> Reject location and managed locations in DDL for REMOTE databases.
> ------------------------------------------------------------------
>
> Key: HIVE-24970
> URL: https://issues.apache.org/jira/browse/HIVE-24970
> Project: Hive
> Issue Type: Sub-task
> Components: HiveServer2
> Affects Versions: 4.0.0
> Reporter: Naveen Gangam
> Assignee: Naveen Gangam
> Priority: Major
>
> This was part of the review feedback from Yongzhi. Creating a followup jira
> to track this discussion.
> So, using DB connector for DB, will not create managed tables?
>
> @nrg4878 nrg4878 1 hour ago Author Member
> we don't support create/drop/alter in REMOTE databases at this point. the
> concepts of managed vs external is not in the picture at this point. When we
> do support it, it will be application to the hive connectors only (or other
> hive based connectors like AWS Glue)
>
> @nrg4878 nrg4878 2 minutes ago Author Member
> will file a separate jira for this. Basically, instead of ignoring the
> location and managedlocation that may be specified for remote database, the
> grammer needs to not accept any locations in the DDL at all.
> The argument is fair, why accept something we do not honor or entirely
> irrelevant for such databases. However, this requires some thought when we
> have additional connectors for remote hive instances. It might have some
> relevance in terms of security with Ranger etc.
> So will create new jira for followup discussion.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)