I have been using Ranger for Hive authorization. The environment I am using is HDP 2.5. I started playing around with sqoop to import data from mysql. The import from sqoop works just fine. However, how can I enforce Hive policies to allow only authorized users to import tables. Should scoop be using this authorization already or is there some configuration involved.
Also is there a way to tell sqoop to use the knox jdbc endpoint instead of the regular hiverserver2 endpoint?
Any help would be much appreciated. Thanks!
Currently, Sqoop does not use the hiveserver2 interface, so Ranger Hive policies (which use hiveserver2 interface) are not enforced on import.