sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nick White (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-749) Exports Using Stored Procedures (Functions)
Date Thu, 10 Jan 2013 19:02:13 GMT

     [ https://issues.apache.org/jira/browse/SQOOP-749?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Nick White updated SQOOP-749:

    Attachment: SQOOP-808.2.patch

Hi Venkat - with this patch sqoop will attempt to find one stored procedure parameter for
each column in the input data (matching by column name == parameter name). It only ignores
return parameters - i.e. it pass values as in, in/out and out parameters (although it ignores
the out values).
> Exports Using Stored Procedures (Functions)
> -------------------------------------------
>                 Key: SQOOP-749
>                 URL: https://issues.apache.org/jira/browse/SQOOP-749
>             Project: Sqoop
>          Issue Type: New Feature
>          Components: connectors, connectors/postgresql
>    Affects Versions: 1.4.2
>            Reporter: Nick White
>              Labels: features, patch
>         Attachments: SQOOP-749.0.patch, SQOOP-749.1.patch, SQOOP-749.2.patch, SQOOP-808.2.patch
> 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. Thanks!

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

View raw message