New Contributor
Posts: 5
Registered: ‎04-16-2019

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

[ Edited ]

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.