Review Board 1.7.22


SQOOP-749: Exports Using Stored Procedures (Functions)

Review Request #8806 - Created Jan. 3, 2013 and updated

Nick White
SQOOP-749
Reviewers
Sqoop
jarcec
sqoop-trunk
It'd be useful if you could use stored procedures (or functions) to insert data - currently you can only use insert or update statements (or upsert / merges, depending on the SqlManager you're using). This would help sqoop adoption / migration into environments which have existing, SQL-based data import workflows. 

The attached patch adds a --call argument to the export tool that can be used in place of --table.

Note that this patch depends on HSQLDB 2.x, whereas trunk currently depends on 1.8, so it can't be committed until that situation's resolved (see SQOOP-519 and linked tickets). 
I've added a subclass of TestExport to make sure all the usual export functionality works. I've also used it on live data exporting to postgres.
Review request changed
Updated (Jan. 17, 2013, 2:25 p.m.)
Sorry about the import stuff - I haven't figured out how to make eclipse remove unused imports without sorting the remaining ones alphabetically (or how to be as productive in a different editor :). The attached patch fixes all the issues you've raised. Thanks!
Ship it!
Posted (Jan. 22, 2013, 8:24 p.m.)
Ship It!