You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Abhijeet Gaikwad (Commented) (JIRA)" <ji...@apache.org> on 2012/03/30 06:58:35 UTC

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

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

Abhijeet Gaikwad commented on SQOOP-469:
----------------------------------------

This is not related to SQOOP. You will have to write a trigger in SQL Server which will execute when you perform any of the desired operations (INSERT/UPDATE query in this scenario). Let me know if that answers your question.
                
> 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