You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Raghav Kumar Gautam (JIRA)" <ji...@apache.org> on 2012/10/05 06:52:47 UTC
[jira] [Created] (SQOOP-621) Requesting support for upsert export
with MySQL
Raghav Kumar Gautam created SQOOP-621:
-----------------------------------------
Summary: Requesting support for upsert export with MySQL
Key: SQOOP-621
URL: https://issues.apache.org/jira/browse/SQOOP-621
Project: Sqoop
Issue Type: Improvement
Components: connectors/mysql
Affects Versions: 1.4.2
Reporter: Raghav Kumar Gautam
Sqoop export with upsert option gives the following error:
12/09/26 11:34:54 ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet
>From the code it seems to me that upsert is implemented only for Oracle as of now.
--
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
[jira] [Updated] (SQOOP-621) Requesting support for upsert export
with MySQL
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek Jarcec Cecho updated SQOOP-621:
-------------------------------------
Attachment: bugSQOOP-621.patch
> Requesting support for upsert export with MySQL
> -----------------------------------------------
>
> Key: SQOOP-621
> URL: https://issues.apache.org/jira/browse/SQOOP-621
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/mysql
> Affects Versions: 1.4.2
> Reporter: Raghav Kumar Gautam
> Assignee: Jarek Jarcec Cecho
> Labels: newbie
> Attachments: bugSQOOP-621.patch
>
>
> Sqoop export with upsert option gives the following error:
> 12/09/26 11:34:54 ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet
> From the code it seems to me that upsert is implemented only for Oracle as of now.
--
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
[jira] [Commented] (SQOOP-621) Requesting support for upsert export
with MySQL
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13478660#comment-13478660 ]
Hudson commented on SQOOP-621:
------------------------------
Integrated in Sqoop-ant-jdk-1.6-hadoop100 #219 (See [https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop100/219/])
SQOOP-621 Requesting support for upsert export with MySQL (Revision 2750df90f96f75f6e70bf690b88faba21fc8ab23)
Result = SUCCESS
cheolsoo : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=2750df90f96f75f6e70bf690b88faba21fc8ab23
Files :
* src/docs/user/connectors.txt
* src/java/org/apache/sqoop/manager/MySQLManager.java
* src/java/org/apache/sqoop/manager/DirectMySQLManager.java
* src/java/org/apache/sqoop/mapreduce/JdbcUpdateExportJob.java
* src/test/com/cloudera/sqoop/manager/ManualMySQLTests.java
* src/java/org/apache/sqoop/mapreduce/mysql/MySQLUpsertOutputFormat.java
* src/test/com/cloudera/sqoop/manager/JdbcMySQLExportTest.java
> Requesting support for upsert export with MySQL
> -----------------------------------------------
>
> Key: SQOOP-621
> URL: https://issues.apache.org/jira/browse/SQOOP-621
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/mysql
> Affects Versions: 1.4.2
> Reporter: Raghav Kumar Gautam
> Assignee: Jarek Jarcec Cecho
> Labels: newbie
> Attachments: bugSQOOP-621.patch
>
>
> Sqoop export with upsert option gives the following error:
> 12/09/26 11:34:54 ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet
> From the code it seems to me that upsert is implemented only for Oracle as of now.
--
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
[jira] [Commented] (SQOOP-621) Requesting support for upsert export
with MySQL
Posted by "Raghav Kumar Gautam (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13470027#comment-13470027 ]
Raghav Kumar Gautam commented on SQOOP-621:
-------------------------------------------
Also see this thread:
http://mail-archives.apache.org/mod_mbox/sqoop-user/201210.mbox/%3C20121004152956.GT16616%40jarcec-thinkpad%3E
> Requesting support for upsert export with MySQL
> -----------------------------------------------
>
> Key: SQOOP-621
> URL: https://issues.apache.org/jira/browse/SQOOP-621
> Project: Sqoop
> Issue Type: Improvement
> Components: connectors/mysql
> Affects Versions: 1.4.2
> Reporter: Raghav Kumar Gautam
> Labels: newbie
>
> Sqoop export with upsert option gives the following error:
> 12/09/26 11:34:54 ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet
> From the code it seems to me that upsert is implemented only for Oracle as of now.
--
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
[jira] [Commented] (SQOOP-621) Requesting support for upsert export
with MySQL
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13478657#comment-13478657 ]
Hudson commented on SQOOP-621:
------------------------------
Integrated in Sqoop-ant-jdk-1.6-hadoop20 #220 (See [https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop20/220/])
SQOOP-621 Requesting support for upsert export with MySQL (Revision 2750df90f96f75f6e70bf690b88faba21fc8ab23)
Result = SUCCESS
cheolsoo : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=2750df90f96f75f6e70bf690b88faba21fc8ab23
Files :
* src/java/org/apache/sqoop/manager/MySQLManager.java
* src/test/com/cloudera/sqoop/manager/ManualMySQLTests.java
* src/java/org/apache/sqoop/mapreduce/mysql/MySQLUpsertOutputFormat.java
* src/java/org/apache/sqoop/manager/DirectMySQLManager.java
* src/test/com/cloudera/sqoop/manager/JdbcMySQLExportTest.java
* src/java/org/apache/sqoop/mapreduce/JdbcUpdateExportJob.java
* src/docs/user/connectors.txt
> Requesting support for upsert export with MySQL
> -----------------------------------------------
>
> Key: SQOOP-621
> URL: https://issues.apache.org/jira/browse/SQOOP-621
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/mysql
> Affects Versions: 1.4.2
> Reporter: Raghav Kumar Gautam
> Assignee: Jarek Jarcec Cecho
> Labels: newbie
> Attachments: bugSQOOP-621.patch
>
>
> Sqoop export with upsert option gives the following error:
> 12/09/26 11:34:54 ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet
> From the code it seems to me that upsert is implemented only for Oracle as of now.
--
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
[jira] [Updated] (SQOOP-621) Requesting support for upsert export
with MySQL
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek Jarcec Cecho updated SQOOP-621:
-------------------------------------
Assignee: Jarek Jarcec Cecho
Issue Type: New Feature (was: Improvement)
> Requesting support for upsert export with MySQL
> -----------------------------------------------
>
> Key: SQOOP-621
> URL: https://issues.apache.org/jira/browse/SQOOP-621
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/mysql
> Affects Versions: 1.4.2
> Reporter: Raghav Kumar Gautam
> Assignee: Jarek Jarcec Cecho
> Labels: newbie
>
> Sqoop export with upsert option gives the following error:
> 12/09/26 11:34:54 ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet
> From the code it seems to me that upsert is implemented only for Oracle as of now.
--
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
[jira] [Commented] (SQOOP-621) Requesting support for upsert export
with MySQL
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13478663#comment-13478663 ]
Hudson commented on SQOOP-621:
------------------------------
Integrated in Sqoop-ant-jdk-1.6-hadoop23 #369 (See [https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop23/369/])
SQOOP-621 Requesting support for upsert export with MySQL (Revision 2750df90f96f75f6e70bf690b88faba21fc8ab23)
Result = SUCCESS
cheolsoo : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=2750df90f96f75f6e70bf690b88faba21fc8ab23
Files :
* src/docs/user/connectors.txt
* src/test/com/cloudera/sqoop/manager/ManualMySQLTests.java
* src/java/org/apache/sqoop/mapreduce/JdbcUpdateExportJob.java
* src/test/com/cloudera/sqoop/manager/JdbcMySQLExportTest.java
* src/java/org/apache/sqoop/manager/MySQLManager.java
* src/java/org/apache/sqoop/manager/DirectMySQLManager.java
* src/java/org/apache/sqoop/mapreduce/mysql/MySQLUpsertOutputFormat.java
> Requesting support for upsert export with MySQL
> -----------------------------------------------
>
> Key: SQOOP-621
> URL: https://issues.apache.org/jira/browse/SQOOP-621
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/mysql
> Affects Versions: 1.4.2
> Reporter: Raghav Kumar Gautam
> Assignee: Jarek Jarcec Cecho
> Labels: newbie
> Attachments: bugSQOOP-621.patch
>
>
> Sqoop export with upsert option gives the following error:
> 12/09/26 11:34:54 ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet
> From the code it seems to me that upsert is implemented only for Oracle as of now.
--
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
[jira] [Resolved] (SQOOP-621) Requesting support for upsert export
with MySQL
Posted by "Cheolsoo Park (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Cheolsoo Park resolved SQOOP-621.
---------------------------------
Resolution: Fixed
Thanks a lot Jarcec. The patch is in.
I am sorry that I forgot to add (Jarek Jarcec Cecho via Cheolsoo Park) in the commit record. I realized after I had commit... My bad.
> Requesting support for upsert export with MySQL
> -----------------------------------------------
>
> Key: SQOOP-621
> URL: https://issues.apache.org/jira/browse/SQOOP-621
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/mysql
> Affects Versions: 1.4.2
> Reporter: Raghav Kumar Gautam
> Assignee: Jarek Jarcec Cecho
> Labels: newbie
> Attachments: bugSQOOP-621.patch
>
>
> Sqoop export with upsert option gives the following error:
> 12/09/26 11:34:54 ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet
> From the code it seems to me that upsert is implemented only for Oracle as of now.
--
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
[jira] [Commented] (SQOOP-621) Requesting support for upsert export
with MySQL
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13478649#comment-13478649 ]
Jarek Jarcec Cecho commented on SQOOP-621:
------------------------------------------
That's fine sir, it happens - I won't be mad :-)
> Requesting support for upsert export with MySQL
> -----------------------------------------------
>
> Key: SQOOP-621
> URL: https://issues.apache.org/jira/browse/SQOOP-621
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/mysql
> Affects Versions: 1.4.2
> Reporter: Raghav Kumar Gautam
> Assignee: Jarek Jarcec Cecho
> Labels: newbie
> Attachments: bugSQOOP-621.patch
>
>
> Sqoop export with upsert option gives the following error:
> 12/09/26 11:34:54 ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet
> From the code it seems to me that upsert is implemented only for Oracle as of now.
--
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
[jira] [Commented] (SQOOP-621) Requesting support for upsert export
with MySQL
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13478662#comment-13478662 ]
Hudson commented on SQOOP-621:
------------------------------
Integrated in Sqoop-ant-jdk-1.6-hadoop200 #229 (See [https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop200/229/])
SQOOP-621 Requesting support for upsert export with MySQL (Revision 2750df90f96f75f6e70bf690b88faba21fc8ab23)
Result = SUCCESS
cheolsoo : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=2750df90f96f75f6e70bf690b88faba21fc8ab23
Files :
* src/test/com/cloudera/sqoop/manager/JdbcMySQLExportTest.java
* src/java/org/apache/sqoop/manager/DirectMySQLManager.java
* src/docs/user/connectors.txt
* src/test/com/cloudera/sqoop/manager/ManualMySQLTests.java
* src/java/org/apache/sqoop/manager/MySQLManager.java
* src/java/org/apache/sqoop/mapreduce/JdbcUpdateExportJob.java
* src/java/org/apache/sqoop/mapreduce/mysql/MySQLUpsertOutputFormat.java
> Requesting support for upsert export with MySQL
> -----------------------------------------------
>
> Key: SQOOP-621
> URL: https://issues.apache.org/jira/browse/SQOOP-621
> Project: Sqoop
> Issue Type: New Feature
> Components: connectors/mysql
> Affects Versions: 1.4.2
> Reporter: Raghav Kumar Gautam
> Assignee: Jarek Jarcec Cecho
> Labels: newbie
> Attachments: bugSQOOP-621.patch
>
>
> Sqoop export with upsert option gives the following error:
> 12/09/26 11:34:54 ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet
> From the code it seems to me that upsert is implemented only for Oracle as of now.
--
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