I have created the trigger in SQL and it works for me. For every sqoop-export, I am able to fire the trigger and I getting the result as expected.
On Fri, Mar 30, 2012 at 11:38 AM, Jarek Jarcec Cecho (Commented) (JIRA) < [email protected]> wrote: > > [ > https://issues.apache.org/jira/browse/SQOOP-469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13242092#comment-13242092] > > Jarek Jarcec Cecho commented on SQOOP-469: > ------------------------------------------ > > Actually I also do have a need to execute some code (stored procedure) on > database side before and after each sqoop import. > > I'm currently doing that by additional actions in my oozie workflow that > is driving the import. It might be beneficial to put something like > "callbacks" into sqoop that user could use to execute arbitrary code as he > needs at given points (for example "before import", "after import"). > > Jarcec > > > Can we fire the trigger in SQL Server after exporting the data from HIVE > using SQOOP > > > ------------------------------------------------------------------------------------ > > > > Key: SQOOP-469 > > URL: https://issues.apache.org/jira/browse/SQOOP-469 > > Project: Sqoop > > Issue Type: New Feature > > Components: connectors/sqlserver > > Affects Versions: 1.3.0 > > Environment: Operating System - Ubuntu-11.10 > > Softwares Used - Sqoop, Hive, Hadoop, (SQL Server in Window 7) > > Reporter: Bhavesh Shah > > Labels: hive, ms-sql, sqoop > > Original Estimate: 168h > > Remaining Estimate: 168h > > > > I have implemented some task in Hive and wanted to export a table from > Hive into SQL Server using SQOOP. > > When table gets exported from Hive to SQL Server, I want to fire the > trigger in SQL Server. > > Is it possible to fire the trigger in SQL Server? > > -- > This message is automatically generated by JIRA. > If you think it was sent incorrectly, please contact your JIRA > administrators: > https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa > For more information on JIRA, see: http://www.atlassian.com/software/jira > > > -- Regards, Bhavesh Shah
