Re: [jira] [Commented] (SQOOP-469) Can we fire the trigger in SQL Server after exporting the data from HIVE using SQOOP

[Bhavesh Shah <bh...@gmail.com>]

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) <
jira@apache.org> 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