[jira] [Commented] (HADOOP-11992) ORA-00933: SQL command not properly ended

["Ravi Prakash (JIRA)" <ji...@apache.org>]

    [ 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:minicoolva@gmail.com



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)