Support Questions
Find answers, ask questions, and share your expertise

Sqoop authorization for Hive Tables

Sqoop authorization for Hive Tables

Explorer

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!

2 REPLIES 2

Re: Sqoop authorization for Hive Tables

Expert Contributor

Currently, Sqoop does not use the hiveserver2 interface, so Ranger Hive policies (which use hiveserver2 interface) are not enforced on import.

Re: Sqoop authorization for Hive Tables

Contributor

@Raffi Abberbock Please refer https://cwiki.apache.org/confluence/display/KNOX/2016/11/08/Running+SQOOP+job+via+KNOX+Shell+DSL to get some insight on running a sqoop job via knox shell DSL