Return-Path: X-Original-To: apmail-hadoop-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-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 46D0511331 for ; Tue, 29 Jul 2014 08:42:18 +0000 (UTC) Received: (qmail 85135 invoked by uid 500); 29 Jul 2014 08:42:13 -0000 Delivered-To: apmail-hadoop-user-archive@hadoop.apache.org Received: (qmail 85019 invoked by uid 500); 29 Jul 2014 08:42:13 -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 85009 invoked by uid 99); 29 Jul 2014 08:42:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Jul 2014 08:42:13 +0000 X-ASF-Spam-Status: No, hits=2.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_REPLYTO_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of rj201244@yahoo.com designates 98.138.91.102 as permitted sender) Received: from [98.138.91.102] (HELO nm9-vm6.bullet.mail.ne1.yahoo.com) (98.138.91.102) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Jul 2014 08:42:06 +0000 Received: from [98.138.100.113] by nm9.bullet.mail.ne1.yahoo.com with NNFMP; 29 Jul 2014 08:41:43 -0000 Received: from [98.138.87.12] by tm104.bullet.mail.ne1.yahoo.com with NNFMP; 29 Jul 2014 08:41:43 -0000 Received: from [127.0.0.1] by omp1012.mail.ne1.yahoo.com with NNFMP; 29 Jul 2014 08:41:43 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 886943.56166.bm@omp1012.mail.ne1.yahoo.com Received: (qmail 75796 invoked by uid 60001); 29 Jul 2014 08:41:43 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1406623303; bh=sYVHua24H6OqrrZvFwB94fhFV7961Wkgkb9lqAge48M=; h=Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=FG9MCX+PGp8DqSBhOf941z4olSY/KilWNWdEHNRgWamr84c0WffMyu2V/PztuWNwf1JX+g0iN4/9naCfYe77Zoya1hpTDLETVY4wxo3AGYzP4wE7mXvre69Y4eFpccfPR8pR34Vy4f1jFRsNp5WTUNEKd+toPj7Yi7xib9ZfsY4= X-YMail-OSG: ZVzcrW8VM1nYTtfe2.CpjfKVD7IM8vErKyIA07Y1ojmP9qG KFZEW0_vhz3tLVKSfCMwQydkjlodKLW3_9tKabOmu4VIXoATAHqothGHHro_ Z1h56iqglb5LXIN3KYoznwpkaRyL8ITbFYO1l6UY8GVe4o87jdRk78mkcKjN AXFokBVRCCKr7DlpnftNRAgkqEIuNZagCWBQ9ji1ofi_LNtyaDD7nVwEfVbt LqF2i4sGWr2hjlxx57UvFuF5p761_3NSNr4t3_llAAUls2sr_ie7rCI6zFxo fXocJon3wnYweMGOa_nCq7XfDfc94RVKhk8uL12eI9gfKP3a2sP5PYRs9bvm Fw5xHAnV6iPJgvOnem2e5M9KsglB7gsuMSai8hAy7.ZkkDAXh_ARkrnliyD_ RPD8orC.0T.RSNIZzAHrhg7m1GJApeC7vtouhtxP16DMZZZQXWcjfvSKf9Bo twygIGQdBTR35B0o0VnxS2_d6HMImhi86Ve4CuL4cP2kyx.v62hYsdl5VI_h m0k_PDb8xp1eJ33d67d9V5Y9MSQKBWj4aTrNDYj_.Yna96F5gokiGuLKXhK9 0AOJgZLDglghMv7oewKnB3EiUzfAz8opaiSPizOajjxMRCnuEwz_lljJtyQ- - Received: from [67.169.31.194] by web122403.mail.ne1.yahoo.com via HTTP; Tue, 29 Jul 2014 01:41:43 PDT X-Rocket-MIMEInfo: 002.001,SGkgQWxsLAoKQ291bGQgYW55b25lIHBsZWFzZSBoZWxwIG1lIHdpdGggdGhlIFNxb29wIGNvbW1hbmQgc3ludGF4PyBJIHRyaWVkIHRoZSBmb2xsb3dpbmcgY29tbWFuZDoKCi9ob21lL2xvZ2dlci9zY29vcC9zcW9vcC0xLjQuNC5iaW5fX2hhZG9vcC0wLjIwL2Jpbi9zcW9vcCBpbXBvcnQgLS1kcml2ZXIgb3JhY2xlLmpkYmMuZHJpdmVyLk9yYWNsZURyaXZlciAtLWNvbm5lY3QgamRiYzpvcmFjbGU6dGhpbjpAbXlvcmFjbGVzZXJ2ZXIuY29tOjE1MjEvbXlzaWQgLS11c2VybmFtZSBzY290dCAtLXBhc3N3b3IBMAEBAQE- X-Mailer: YahooMailWebService/0.8.196.685 Message-ID: <1406623303.51179.YahooMailNeo@web122403.mail.ne1.yahoo.com> Date: Tue, 29 Jul 2014 01:41:43 -0700 From: R J Reply-To: R J Subject: Sqoop command syntax To: "user@hadoop.apache.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="942553102-965224697-1406623303=:51179" X-Virus-Checked: Checked by ClamAV on apache.org --942553102-965224697-1406623303=:51179 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi All,=0A=0ACould anyone please help me with the Sqoop command syntax? I t= ried the following command:=0A=0A/home/logger/scoop/sqoop-1.4.4.bin__hadoop= -0.20/bin/sqoop import --driver oracle.jdbc.driver.OracleDriver --connect j= dbc:oracle:thin:@myoracleserver.com:1521/mysid --username scott --password = tiger --table mytab1=0A=0AI get the error:=0A14/07/29 08:26:23 INFO manager= .SqlManager: Executing SQL statement: SELECT t.* FROM mytab1 AS t WHERE 1= =3D0=0A14/07/29 08:26:24 ERROR manager.SqlManager: Error executing statemen= t: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly en= ded=0A=0Ajava.sql.SQLSyntaxErrorException: ORA-00933: SQL command not prope= rly ended=0A=0A=A0=A0=A0=A0=A0=A0=A0 at oracle.jdbc.driver.T4CTTIoer.proces= sError(T4CTTIoer.java:447)=0A=A0=A0=A0=A0=A0=A0=A0 at oracle.jdbc.driver.T4= CTTIoer.processError(T4CTTIoer.java:396)=0A=A0=A0=A0=A0=A0=A0=A0 at oracle.= jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)=0A=A0=A0=A0=A0=A0=A0= =A0 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)=0A=A0=A0=A0= =A0=A0=A0=A0 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)=0A= =A0=A0=A0=A0=A0=A0=A0 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:5= 31)=0A=A0=A0=A0=A0=A0=A0=A0 at oracle.jdbc.driver.T4CPreparedStatement.doOa= ll8(T4CPreparedStatement.java:208)=0A=A0=A0=A0=A0=A0=A0=A0 at oracle.jdbc.d= river.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886= )=0A=A0=A0=A0=A0=A0=A0=A0 at oracle.jdbc.driver.OracleStatement.executeMayb= eDescribe(OracleStatement.java:1175)=0A=A0=A0=A0=A0=A0=A0=A0 at oracle.jdbc= .driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)=0A= =A0=A0=A0=A0=A0=A0=A0 at oracle.jdbc.driver.OraclePreparedStatement.execute= Internal(OraclePreparedStatement.java:3613)=0A=A0=A0=A0=A0=A0=A0=A0 at orac= le.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement= .java:3657)=0A=A0=A0=A0=A0=A0=A0=A0 at oracle.jdbc.driver.OraclePreparedSta= tementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)=0A=A0= =A0=A0=A0=A0=A0=A0 at org.apache.sqoop.manager.SqlManager.execute(SqlManage= r.java:674)=0A=A0=A0=A0=A0=A0=A0=A0 at org.apache.sqoop.manager.SqlManager.= execute(SqlManager.java:683)=0A=A0=A0=A0=A0=A0=A0=A0 at org.apache.sqoop.ma= nager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240)=0A=A0=A0=A0= =A0=A0=A0=A0 at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManag= er.java:223)=0A=A0=A0=A0=A0=A0=A0=A0 at org.apache.sqoop.manager.ConnManage= r.getColumnTypes(ConnManager.java:347)=0A=A0=A0=A0=A0=A0=A0=A0 at org.apach= e.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1277)=0A=A0=A0=A0= =A0=A0=A0=A0 at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:= 1089)=0A=A0=A0=A0=A0=A0=A0=A0 at org.apache.sqoop.tool.CodeGenTool.generate= ORM(CodeGenTool.java:96)=0A=A0=A0=A0=A0=A0=A0=A0 at org.apache.sqoop.tool.I= mportTool.importTable(ImportTool.java:396)=0A=A0=A0=A0=A0=A0=A0=A0 at org.a= pache.sqoop.tool.ImportTool.run(ImportTool.java:502)=0A=A0=A0=A0=A0=A0=A0= =A0 at org.apache.sqoop.Sqoop.run(Sqoop.java:145)=0A=A0=A0=A0=A0=A0=A0=A0 a= t org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)=0A=A0=A0=A0=A0= =A0=A0=A0 at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)=0A=A0=A0=A0=A0= =A0=A0=A0 at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)=0A=A0=A0=A0=A0= =A0=A0=A0 at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)=0A=A0=A0=A0=A0= =A0=A0=A0 at org.apache.sqoop.Sqoop.main(Sqoop.java:238)=0A14/07/29 08:26:2= 4 ERROR tool.ImportTool: Encountered IOException running import job: java.i= o.IOException: No columns to generate for ClassWriter=0A=A0=A0=A0=A0=A0=A0= =A0 at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1095)=0A= =A0=A0=A0=A0=A0=A0=A0 at org.apache.sqoop.tool.CodeGenTool.generateORM(Code= GenTool.java:96)=0A=A0=A0=A0=A0=A0=A0=A0 at org.apache.sqoop.tool.ImportToo= l.importTable(ImportTool.java:396)=0A=A0=A0=A0=A0=A0=A0=A0 at org.apache.sq= oop.tool.ImportTool.run(ImportTool.java:502)=0A=A0=A0=A0=A0=A0=A0=A0 at org= .apache.sqoop.Sqoop.run(Sqoop.java:145)=0A=A0=A0=A0=A0=A0=A0=A0 at org.apac= he.hadoop.util.ToolRunner.run(ToolRunner.java:65)=0A=A0=A0=A0=A0=A0=A0=A0 a= t org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)=0A=A0=A0=A0=A0=A0=A0=A0 a= t org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)=0A=A0=A0=A0=A0=A0=A0=A0 at= org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)=0A=A0=A0=A0=A0=A0=A0=A0 at = org.apache.sqoop.Sqoop.main(Sqoop.java:238) --942553102-965224697-1406623303=:51179 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi All,

Could anyone please help me with the Sqoop command syntax? I tr= ied the following command:

/home/logger/scoop/sqoop-1.4.4.bin__hadoop-0.20/bin/sqoop import = --driver oracle.jdbc.driver.OracleDriver --connect jdbc:oracle:thin:@myorac= leserver.com:1521/mysid --username scott --password tiger --table mytab1

I get the error:<= /div>
14/07/29 08:26:23 INF= O manager.SqlManager: Executing SQL statement: SELECT t.* FROM mytab1 AS t = WHERE 1=3D0
14/07/29 08:26:24 ERROR manager.SqlManager:= Error executing statement: java.sql.SQLSyntaxErrorException: ORA-00933: SQ= L command not properly ended

java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly= ended

   = ;     at oracle.jdbc.driver.T4CTTIoer.processError(T4CT= TIoer.java:447)
     &nbs= p;  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)        at oracl= e.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
        at oracle.jdbc.driver.T4CT= TIfun.receive(T4CTTIfun.java:513)
  &nbs= p;     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.= java:227)
        at oracle.jdbc.drive= r.T4C8Oall.doOALL(T4C8Oall.java:531)
  &= nbsp;     at oracle.jdbc.driver.T4CPreparedStatement.do= Oall8(T4CPreparedStatement.java:208)
  &= nbsp;     at oracle.jdbc.driver.T4CPreparedStatement.ex= ecuteForDescribe(T4CPreparedStatement.java:886)
&n= bsp;       at oracle.jdbc.driver.OracleStatem= ent.executeMaybeDescribe(OracleStatement.java:1175)
        at oracle.jdbc.driver.OracleSt= atement.doExecuteWithTimeout(OracleStatement.java:1296)
        at oracle.jdbc.driver.Orac= lePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStat= ement.java:3657)
     &nb= sp;  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery= (OraclePreparedStatementWrapper.java:1495)
 &= nbsp;      at org.apache.sqoop.manager.SqlManager.= execute(SqlManager.java:674)
   &nb= sp;    at org.apache.sqoop.manager.SqlManager.execute(SqlMan= ager.java:683)
      = ;  at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(Sq= lManager.java:240)
     &= nbsp;  at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManage= r.java:223)
      &n= bsp; at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.jav= a:347)
        at org.ap= ache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1277)
        at org.apache.s= qoop.orm.ClassWriter.generate(ClassWriter.java:1089)
        at org.apache.sqoop.tool.Code= GenTool.generateORM(CodeGenTool.java:96)
 &nb= sp;      at org.apache.sqoop.tool.ImportTool.impor= tTable(ImportTool.java:396)
   &nbs= p;    at org.apache.sqoop.tool.ImportTool.run(ImportTool.jav= a:502)
        = at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
&nbs= p;       at org.apache.hadoop.util.ToolRunner= .run(ToolRunner.java:65)
    &= nbsp;   at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
&= nbsp;       at org.apache.sqoop.Sqoop.runTool= (Sqoop.java:220)
     &nb= sp;  at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
        at org.apache.sqoop.Sq= oop.main(Sqoop.java:238)
14/07/29 08:26:24 ERROR t= ool.ImportTool: Encountered IOException running import job: java.io.IOExcep= tion: No columns to generate for ClassWriter
 = ;       at org.apache.sqoop.orm.ClassWriter.g= enerate(ClassWriter.java:1095)
   &= nbsp;    at org.apache.sqoop.tool.CodeGenTool.generateORM(Co= deGenTool.java:96)
     &= nbsp;  at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java= :396)
        at org.apache.sqoop.= tool.ImportTool.run(ImportTool.java:502)
 &nb= sp;      at org.apache.sqoop.Sqoop.run(Sqoop.java:= 145)
        at= org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        at org.apache.sqoop.Sqo= op.runSqoop(Sqoop.java:181)
   &nbs= p;    at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
        at org.apac= he.sqoop.Sqoop.runTool(Sqoop.java:229)
  = ;      at org.apache.sqoop.Sqoop.main(Sqoop.java:2= 38)


--942553102-965224697-1406623303=:51179--