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.

Need clarity on sqoop import --impala-import

Need clarity on sqoop import --impala-import

New Contributor

Dear Cloudera Community,

 

is there any syntax to replace my query below for Impala database instead of Hive? I am intended to ingest table into impala from Oracle.

 

sqoop import --hive-import --connect "jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=192.168.1.3)(port=1521))(connect_data=(service_name=cdb)))" --table EMPLOYEE1 --username system --password XXXX --m 1

 

Regards

Anis

2 REPLIES 2

Re: Need clarity on sqoop import --impala-import

Expert Contributor

Hi Anis,

 

While I've never used sqoop, you may want to ask your question in http://community.cloudera.com/t5/Data-Ingestion-Integration/bd-p/SqoopFlume . Maybe someone with more sqoop experience knows.

 

Cheers, Lars

Highlighted

Re: Need clarity on sqoop import --impala-import

New Contributor

Glad to see advice and I have posted my query over there. Regards