hadoop-mapreduce-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ramtin (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (MAPREDUCE-6246) DBOutputFormat.java appending extra semicolon to query which is incompatible with DB2
Date Fri, 08 May 2015 17:45:00 GMT

     [ https://issues.apache.org/jira/browse/MAPREDUCE-6246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

ramtin updated MAPREDUCE-6246:
    Labels: BB2015-05-RFC  (was: )

> DBOutputFormat.java appending extra semicolon to query which is incompatible with DB2
> -------------------------------------------------------------------------------------
>                 Key: MAPREDUCE-6246
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-6246
>             Project: Hadoop Map/Reduce
>          Issue Type: Bug
>          Components: mrv1, mrv2
>    Affects Versions: 2.4.1
>         Environment: OS: RHEL 5.x, RHEL 6.x, SLES 11.x
> Platform: xSeries, pSeries
> Browser: Firefox, IE
> Security Settings: No Security, Flat file, LDAP, PAM
> File System: HDFS, GPFS FPO
>            Reporter: ramtin
>            Assignee: ramtin
>              Labels: BB2015-05-RFC
>         Attachments: MAPREDUCE-6246.002.patch, MAPREDUCE-6246.patch
>   Original Estimate: 24h
>  Remaining Estimate: 24h
> DBoutputformat is used for writing output of mapreduce jobs to the database and when
used with db2 jdbc drivers it fails with following error
> com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601,
SQLERRMC=;;,COUNT) VALUES (?,?);END-OF-STATEMENT, DRIVER=4.16.53 at com.ibm.db2.jcc.am.fd.a(fd.java:739)
at com.ibm.db2.jcc.am.fd.a(fd.java:60) at com.ibm.db2.jcc.am.fd.a(fd.java:127)
> In DBOutputFormat class there is constructQuery method that generates "INSERT INTO" statement
with semicolon(";") at the end.
> Semicolon is ANSI SQL-92 standard character for a statement terminator but this feature
is disabled(OFF) as a default settings in IBM DB2.
> Although by using -t we can turn it ON for db2. (http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0010410.html?cp=SSEPGG_9.7.0%2F3-6-2-0-2).
But there are some products that already built on top of this default setting (OFF) so by
turning ON this feature make them error prone.

This message was sent by Atlassian JIRA

View raw message