[jira] [Assigned] (HIVE-24970) Reject location and managed locations in DDL for REMOTE databases.
[ https://issues.apache.org/jira/browse/HIVE-24970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naveen Gangam reassigned HIVE-24970: Assignee: Dantong Dong (was: Naveen Gangam) > 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: Dantong Dong >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)
[jira] [Assigned] (HIVE-24970) Reject location and managed locations in DDL for REMOTE databases.
[ 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)
