Reply
New Contributor
Posts: 6
Registered: ‎01-29-2017

Need clarity on sqoop import --impala-import

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

Cloudera Employee
Posts: 82
Registered: ‎12-07-2015

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

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
New Contributor
Posts: 6
Registered: ‎01-29-2017

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

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

 

Announcements