[ https://issues.apache.org/jira/browse/HIVE-3016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13277488#comment-13277488 ]
Sambavi Muthukrishnan commented on HIVE-3016: --------------------------------------------- To enable better tracking of capacity utilization by teams sharing the warehouse, we want the ability to group users by teams and let them operate within a database as their logical container. The operation of using data in another database would require explicitly “linking” of the data into their database so we can track the storage capacity clearly. Auth wont do this for us, since a user could concurrently be operating against two databases that he/she is allowed to operate on. This would be useful in general for any shared warehouses. Edward: can you please elaborate on what you mean by this could be a hook? > Allow disabling foreign table access (cross database) using hiveconf > -------------------------------------------------------------------- > > Key: HIVE-3016 > URL: https://issues.apache.org/jira/browse/HIVE-3016 > Project: Hive > Issue Type: Improvement > Components: Query Processor > Reporter: Sambavi Muthukrishnan > Assignee: Sambavi Muthukrishnan > Priority: Minor > Attachments: hive-3016.1.patch.txt > > Original Estimate: 48h > Remaining Estimate: 48h > > Disallow cross database access to tables using Y.T syntax under a specific > configuration in HiveConf. > i.e. when hive.error.on.crossdatabaseaccess is set to true, return an error > when Y.T syntax is used to access tables and Y is not the current database. > This can be set both via the client and in hive-site.xml, and will default to > false. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira