[ 
https://issues.apache.org/jira/browse/SQOOP-749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13550336#comment-13550336
 ] 

Venkat Ranganathan commented on SQOOP-749:
------------------------------------------

Thanks Nick.  Don't we have to register the out only parameter types of out 
params?   Do you think it will be better to
  1)  Throw an error if we encounter out params during export to DB while 
getting procedure columns
and check if DB supports procedures and throw an error if DBmetadata for 
procedure support is missing?


BTW, you have added a  patch to this JIRA meant for another JIRA - (SQOOP-808)

Thanks
                
> 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

Reply via email to