You are viewing a plain text version of this content. The canonical link for it is here.
Posted to mapreduce-issues@hadoop.apache.org by "xsuyu (Created) (JIRA)" <ji...@apache.org> on 2012/02/07 11:24:59 UTC
[jira] [Created] (MAPREDUCE-3830) DBOutputFormat can't support the
update operation to DB
DBOutputFormat can't support the update operation to DB
-------------------------------------------------------
Key: MAPREDUCE-3830
URL: https://issues.apache.org/jira/browse/MAPREDUCE-3830
Project: Hadoop Map/Reduce
Issue Type: Improvement
Affects Versions: 0.20.203.0
Reporter: xsuyu
Fix For: 0.20.203.0
After checking the DBOutputFormat class file and found it can't support the update operation to DB,
It only support the insert operation.
why it can't provide the update operation? Is it an improvement action?
--
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
[jira] [Commented] (MAPREDUCE-3830) DBOutputFormat can't support
the update operation to DB
Posted by "Bhallamudi Venkata Siva Kamesh (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/MAPREDUCE-3830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13219224#comment-13219224 ]
Bhallamudi Venkata Siva Kamesh commented on MAPREDUCE-3830:
-----------------------------------------------------------
User has not been control to provide insert query. It has been framed inside the code, using given *table name* and *fields*. I think there should be an option as a configuration property, which accepts insert query from the user side.
One advantage of having this one is, some DBs support insertion/updation using a single query.
For example, MySQL supports insertion/updation operation using a single query (insert ignore).
Or handling this inside code?
Any Comments?
> DBOutputFormat can't support the update operation to DB
> -------------------------------------------------------
>
> Key: MAPREDUCE-3830
> URL: https://issues.apache.org/jira/browse/MAPREDUCE-3830
> Project: Hadoop Map/Reduce
> Issue Type: Improvement
> Affects Versions: 0.20.203.0
> Reporter: xsuyu
> Fix For: 0.20.203.0
>
>
> After checking the DBOutputFormat class file and found it can't support the update operation to DB,
> It only support the insert operation.
> why it can't provide the update operation? Is it an improvement action?
--
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