question Re: Sqoop import data using stored procedure in Archives of Support Questions (Read Only)

Sqoop import data using stored procedure

Alessio — Fri, 16 Sep 2022 09:04:07 GMT

Hi,

I have a Stored Procedure (that runs a select query ) to import data from a DB2 database

How can I use it in sqoop?

I'm using the version 1.4.4-cdh5.0.2 of sqoop

I have tried to launch this command:

sqoop import --verbose --connect jdbc:db2://hostname:5300/db --username username --password password  --call NameStoredProcedure -m 1 --target-dir /tmp/DeltaY0/

But this doesn't work !!!

Have you any idea ? How can I solve it ?

Thanks

Alessio

Re: Sqoop import data using stored procedure

abe — Tue, 05 Aug 2014 17:56:42 GMT

Stored procedures are an export only feature. See https://issues.apache.org/jira/browse/SQOOP-769 for more information.

Re: Sqoop import data using stored procedure

singh_vijay87 — Sun, 14 Sep 2014 18:15:21 GMT

How do we import more than one table in sqoop, lets say i have two table one is employee and other one is department and both are having primary-foreign key constraints , i want to import some columns from employee table and some from department based on primary-foreign key.

Re: Sqoop import data using stored procedure

PeteMeers — Thu, 05 Mar 2015 04:06:02 GMT

2 options.

1) import all the data (it's called big data for a reason)

2) create a View in your RDBS and sqoop will treat that like a table.

Cheers

Pete

Re: Sqoop import data using stored procedure

Nilesh2110 — Tue, 12 Jul 2016 06:34:05 GMT

for this requirment you can write join quiry withing sqoop import statement..coz of this u can import only required data in hadoop ecosystem.