Mailing-List: contact dev-help@sqoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@sqoop.apache.org
Received-SPF: pass (athena.apache.org: domain of bhavesh25shah@gmail.com
 designates 209.85.216.51 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <1821444135.36755.1333087712253.JavaMail.tomcat@hel.zones.apache.org>
References: 
 <1821444135.36755.1333087712253.JavaMail.tomcat@hel.zones.apache.org>
Date: Tue, 17 Apr 2012 12:40:17 +0530
Message-ID: 
 <CAGif4YQCvBCPNGj9t7LXJk68uDffqo1rXSAcpTRmazYf2rfnrg@mail.gmail.com>
Subject: Re: [jira] [Commented] (SQOOP-469) Can we fire the trigger in SQL
 Server after exporting the data from HIVE using SQOOP
From: Bhavesh Shah <bhavesh25shah@gmail.com>
To: dev@sqoop.apache.org
Content-Type: multipart/alternative; boundary=00235429cdbc89b91004bddaa19b

--00235429cdbc89b91004bddaa19b
Content-Type: text/plain; charset=ISO-8859-1

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

--00235429cdbc89b91004bddaa19b--