[jira] [Commented] (MAPREDUCE-3830) DBOutputFormat can't support the update operation to DB

["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