Mailing-List: contact mapreduce-issues-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Date: Fri, 7 Jul 2017 21:26:00 +0000 (UTC)
From: "Junping Du (JIRA)" <jira@apache.org>
To: mapreduce-issues@hadoop.apache.org
Message-ID: <JIRA.12773535.1423508085000.197269.1499462760455@Atlassian.JIRA>
In-Reply-To: <JIRA.12773535.1423508085000@Atlassian.JIRA>
References: <JIRA.12773535.1423508085000@Atlassian.JIRA> <JIRA.12773535.1423508085111@jira-lw-us.apache.org>
Subject: [jira] [Updated] (MAPREDUCE-6246) DBOutputFormat.java appending
 extra semicolon to query which is incompatible with DB2
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Fri, 07 Jul 2017 21:26:06 -0000


     [ https://issues.apache.org/jira/browse/MAPREDUCE-6246?page=3Dcom.atla=
ssian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Junping Du updated MAPREDUCE-6246:
----------------------------------
       Resolution: Fixed
         Assignee: Gergely Nov=C3=A1k  (was: ramtin)
     Hadoop Flags: Reviewed
    Fix Version/s: 2.8.2
           Status: Resolved  (was: Patch Available)

I have commit the patch to trunk, branch-2, branch-2.8 and branch-2.8.2. Th=
anks [~ramtinb] and [~GergelyNovak] for patch contribution!

> DBOutputFormat.java appending extra semicolon to query which is incompati=
ble 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=C3=A1k
>             Fix For: 2.8.2
>
>         Attachments: MAPREDUCE-6246.002.patch, MAPREDUCE-6246.003.patch, =
MAPREDUCE-6246.004.patch, MAPREDUCE-6246.patch
>
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> DBoutputformat is used for writing output of mapreduce jobs to the databa=
se and when used with db2 jdbc drivers it fails with following error
> com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=3D-104=
, SQLSTATE=3D42601, SQLERRMC=3D;;,COUNT) VALUES (?,?);END-OF-STATEMENT, DRI=
VER=3D4.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 "IN=
SERT INTO" statement with semicolon(";") at the end.
> Semicolon is ANSI SQL-92 standard character for a statement terminator bu=
t 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/su=
pport/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.cmd.doc/doc/r00104=
10.html?cp=3DSSEPGG_9.7.0%2F3-6-2-0-2). But there are some products that al=
ready built on top of this default setting (OFF) so by turning ON this feat=
ure make them error prone.


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

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