hadoop-mapreduce-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Junping Du (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (MAPREDUCE-6246) DBOutputFormat.java appending extra semicolon to query which is incompatible with DB2
Date Fri, 07 Jul 2017 21:26:00 GMT

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

Junping Du updated MAPREDUCE-6246:
    Fix Version/s: 3.0.0-beta1

> 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: Gergely Novák
>             Fix For: 3.0.0-beta1, 2.8.2
>         Attachments: MAPREDUCE-6246.002.patch, MAPREDUCE-6246.003.patch, MAPREDUCE-6246.004.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

To unsubscribe, e-mail: mapreduce-issues-unsubscribe@hadoop.apache.org
For additional commands, e-mail: mapreduce-issues-help@hadoop.apache.org

View raw message