hadoop-common-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ravi Prakash (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HADOOP-11992) ORA-00933: SQL command not properly ended
Date Mon, 18 May 2015 16:48:00 GMT

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

Mime
View raw message