[ 
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

        

Reply via email to