[
https://issues.apache.org/jira/browse/HADOOP-11992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14548266#comment-14548266
]
Ravi Prakash commented on HADOOP-11992:
---------------------------------------
Hi eiko! Thanks for that report. Some databases require semicolons to end
statements. You could probably subclass DBOutputFormat to do the right thing
for Oracle. The best thing we could do here, is to specify the SQL statement
end string as a configurable property for the job. I'm going to mark this as a
duplicate of MAPREDUCE-3695 since it was reported earlier.
> ORA-00933: SQL command not properly ended
> -----------------------------------------
>
> Key: HADOOP-11992
> URL: https://issues.apache.org/jira/browse/HADOOP-11992
> Project: Hadoop Common
> Issue Type: Bug
> Reporter: eiko
> Assignee: eiko
> Labels: hadoop
>
> hello
> when I insert data into oracle database from hdfs with mapreduce.error occur
> like this.
> ORA-00933: SQL command not properly ended
> -----------------------------------------
> this is my solution
> hadoop version:hadoop-2.6.0
> file:DBOutputFormat.class
> method:constructQuery
> line:163 query.append(");");
> -------------------------------------
> modify like this
> query.append(")"+"\n");
> contact me
> email:[email protected]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
