question How to use sqoop to import the data in to Encrypt zone ? we are using HDP 2.5 + Kerberized and Ranger installed in Archives of Support Questions (Read Only)

How to use sqoop to import the data in to Encrypt zone ? we are using HDP 2.5 + Kerberized and Ranger installed

nube_techno — Sat, 10 Dec 2016 04:23:18 GMT

How to use sqoop to import the data in to Encrypt zone ? we are using HDP 2.5 + Kerberized and Ranger installed

yjagadeesan — Sat, 10 Dec 2016 04:39:17 GMT

You can use Sqoop with the --target-dir parameter set to a directory inside the Hive encryption zone.

You need to specify the -D option after sqoop import.

sqoop import \-D sqoop.test.import.rootDir=<root-directory> \--target-dir <directory-inside-encryption-zone> \<additional-arguments>

Make sure that the sqoop.test.import.rootDir property points to the encryption zone specified in the --target-dir argument.

For HCatalog:

No config required.

For more information on HDP services for HDFS encryption refer this link below,

Let me know if you have any other questions

nube_techno — Mon, 12 Dec 2016 01:38:22 GMT

Thanks @Yogeshprabhu. It works perfectly.

yjagadeesan — Mon, 12 Dec 2016 11:20:22 GMT

@Nube Technologies Good to hear that.