Support Questions
Find answers, ask questions, and share your expertise

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

New Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions

Rising Star
@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

View solution in original post

3 REPLIES 3

Rising Star
@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

View solution in original post

New Contributor

Thanks @Yogeshprabhu. It works perfectly.

Rising Star

@Nube Technologies Good to hear that.