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

[#1]

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

[#2 · Accepted solution]

@Nube Technologies

For Hive:

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>

For append or incremental export

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,

HDP services for HDFS encryption

Let me know if you have any other questions

[#3]

Thanks @Yogeshprabhu. It works perfectly.

[#4]

@Nube Technologies Good to hear that.