Can anyone confirm and provide more details on hive-impersonation in hadoop.For, hive-impersonation i believe below 'do.as' property needs to be set to true and does hive-impersonation works on non-secure cluster or it will work only on secure(kerberos) hadoop cluster. hive.server2.enable.do=true ... View more

Whats the difference between granting privileges on tables and granting privileges on a databases. Example: By granting below privileges on a table for a user, the user would be able to insert, update etc on a table. grant insert,update,delete,select on table test01 to user user1; Now, what would be the use of granting below insert, delete etc privileges on a database for a user ?. As in a database, we can only create and delete tables but we can't insert/update in databases. grant insert,update,delete,select on database db1 to user user1; And, does by granting insert, delete etc privileges on a database for a user, will the user be getting those privileges on all the objects in that database ? ... View more