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

DB Created in HIVE warehouse location, using SQOOP not able to load data to external table

Highlighted

DB Created in HIVE warehouse location, using SQOOP not able to load data to external table

New Contributor

DB Created in HIVE warehouse location and HIVE external table created in HDFS location (Not warehouse).

Uisng SQOOP, pulling data and trying to write/load into external table, but not able to do  with any user.

Reason is HIVE warehouse location is accessble to HIVEHIVE user only.

Why we created DB in warehouse is becaus of Sentry rules.

Please suggest me here.

Thanks in Advance.