Return-Path: X-Original-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C26DF17F78 for ; Fri, 8 May 2015 05:34:42 +0000 (UTC) Received: (qmail 21385 invoked by uid 500); 8 May 2015 05:34:37 -0000 Delivered-To: apmail-hadoop-hdfs-user-archive@hadoop.apache.org Received: (qmail 21266 invoked by uid 500); 8 May 2015 05:34:37 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 21256 invoked by uid 99); 8 May 2015 05:34:37 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 May 2015 05:34:37 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id ED129183A28 for ; Fri, 8 May 2015 05:34:36 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.129 X-Spam-Level: *** X-Spam-Status: No, score=3.129 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id kcYQjgszU6R7 for ; Fri, 8 May 2015 05:34:35 +0000 (UTC) Received: from mail-ob0-f181.google.com (mail-ob0-f181.google.com [209.85.214.181]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id 653DF2310B for ; Fri, 8 May 2015 05:34:34 +0000 (UTC) Received: by obbkp3 with SMTP id kp3so48091174obb.3 for ; Thu, 07 May 2015 22:34:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=ewXYXl1DgLoYlU9yGI7sKIXRBfMabwO8MWB/lWbt/jY=; b=fHJ5vRHmCYqgLZMOgT7TtLPlRpyb6uNbgGL7bfPOTd5ZgnIMwVbncWywXMFi4xoPX4 3Zmrc0LNoJ4YK8+IOA1cxyaUngnjS2lyn8PdbFc3u7R8UN3JoSW//hqS6G1Eh3/FS1dA X3U3kuliLo4TR7ZOIRg44aDt+n88hiA5Xu5uqTQawl4AiqKF+JTNxoWa22uGUo3lMClm ESGsCe6lO05+tfmsYcdA0MgZb5uf95Ari7it3JtMoZ/njLnnG41kwEU6UCq0kgHiIx8S Z0RPXXpZXaStlDUpjVgEQ55b63zTw/+7YBdZ6nSfCxnKBrs7jEipsPUXDgo+hB67wjBX tTBw== MIME-Version: 1.0 X-Received: by 10.202.191.6 with SMTP id p6mr1590741oif.109.1431063271299; Thu, 07 May 2015 22:34:31 -0700 (PDT) Received: by 10.202.88.195 with HTTP; Thu, 7 May 2015 22:34:31 -0700 (PDT) Date: Thu, 7 May 2015 22:34:31 -0700 Message-ID: Subject: From: Kumar Jayapal To: user@hadoop.apache.org Content-Type: multipart/alternative; boundary=001a113dde92efddcb05158b619c --001a113dde92efddcb05158b619c Content-Type: text/plain; charset=UTF-8 Can some one please help me. I am running the simple sqoop command to import the table with split by options I am getting this error. Does any one solved this error before. I searched site no resolution so far. sqoop command sqoop import --connect "jdbc:oracle:thin:@mysql.1521/PR" --username "edhdtaesvc" --P --table "SAPSR3.BUT000" --map-column-java "PARTNER=Long" --split-by "SAPSR3.BUT000.PARTNER" --target-dir "/data/crmdq/CS2_PR/BUT000_MAP50" --as-avrodatafile --compression-codec org.apache.hadoop.io.compress.SnappyCodec --m 50 15/05/08 05:26:54 INFO mapreduce.Job: Task Id : attempt_1430997877297_0255_m_000010_1, Status : FAILED Error: java.io.IOException: SQLException in nextKeyValue at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:277) at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:553) at org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:80) at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:91) at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144) at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:784) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1642) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163) Caused by: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495) at org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:111) at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:235) Thanks Jay --001a113dde92efddcb05158b619c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
= Can some one please help me.

I am running the simp= le sqoop command to import the table with split by options I am getting thi= s error. Does any one solved this error before.

I = searched site no resolution so far.

sqoop command<= /div>

=C2=A0sqoop import --connect "jdbc:oracl= e:thin:@mysql.1521/PR" --username "edhdtaesvc" --P =C2=A0--t= able "SAPSR3.BUT000" --map-column-java "PARTNER=3DLong"= --split-by "SAPSR3.BUT000.PARTNER" --target-dir "/data/crmd= q/CS2_PR/BUT000_MAP50" --as-avrodatafile --compression-codec org.apach= e.hadoop.io.compress.SnappyCodec --m 50


=


15/05/08 05:26:54 INFO mapred= uce.Job: Task Id : attempt_1430997877297_0255_m_000010_1, Status : FAILED
Error: java.io.IOException: SQLException in nextKeyValue
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.sqoop.mapreduce.db.DBRecordReade= r.nextKeyValue(DBRecordReader.java:277)
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValu= e(MapTask.java:553)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.had= oop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:80)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hadoop.mapreduce.lib.map.Wr= appedMapper$Context.nextKeyValue(WrappedMapper.java:91)
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:= 144)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.sqoop.mapreduce.Au= toProgressMapper.run(AutoProgressMapper.java:64)
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java= :784)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hadoop.mapred.Map= Task.run(MapTask.java:341)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apa= che.hadoop.mapred.YarnChild$2.run(YarnChild.java:168)
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 at java.security.AccessController.doPrivileged(Native Met= hod)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at javax.security.auth.Subject.d= oAs(Subject.java:415)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.h= adoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1642)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hadoop.mapred.YarnChild.m= ain(YarnChild.java:163)
Caused by: java.sql.SQLSyntaxErrorExcepti= on: ORA-00907: missing right parenthesis

=C2=A0 = =C2=A0 =C2=A0 =C2=A0 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer= .java:447)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at oracle.jdbc.driver.T4CT= TIoer.processError(T4CTTIoer.java:396)
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTT= Ifun.java:513)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at oracle.jdbc.driver.= T4CTTIfun.doRPC(T4CTTIfun.java:227)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 a= t oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4C= PreparedStatement.java:208)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at oracle= .jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.j= ava:886)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at oracle.jdbc.driver.Oracle= Statement.executeMaybeDescribe(OracleStatement.java:1175)
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 at oracle.jdbc.driver.OracleStatement.doExecuteWithTim= eout(OracleStatement.java:1296)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at or= acle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStat= ement.java:3613)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at oracle.jdbc.drive= r.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at oracle.jdbc.driver.OraclePreparedSt= atementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.sqoop.mapreduce.db.DBRecordR= eader.executeQuery(DBRecordReader.java:111)
=C2=A0 =C2=A0 =C2=A0 = =C2=A0 at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecor= dReader.java:235)



<= div>



Thanks
Jay
--001a113dde92efddcb05158b619c--