Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop authorization for Hive Tables


Sqoop authorization for Hive Tables

New Contributor

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!


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


@Raffi Abberbock Please refer to get some insight on running a sqoop job via knox shell DSL

Don't have an account?
Coming from Hortonworks? Activate your account here