Hi all! [root@cdh ~]# sqoop version Sqoop 1.4.2-cdh4.2.1 git commit id a0862dc56393e3096c65d6ca26766c67f5ab5309 Compiled by jenkins on Mon Apr 22 11:36:27 PDT 2013
and Quest Connector for Oracle and Hadoop 1.6 <http://downloads.cloudera.com/connectors/oraoop-1.6.0-cdh4.tgz> 2013/9/4 Jarek Jarcec Cecho <[email protected]> > Hi Alexey, > would you mind be a bit more specific? What exact version of Sqoop and > what exact version of OraOop are you using? > > Jarcec > > On Mon, Sep 02, 2013 at 03:11:23PM +0300, Alexey Filanovskiy wrote: > > Hi! > > > > 1.4 > > > > Отправлено с iPad > > > > 02.09.2013, в 11:55, Jarek Jarcec Cecho <[email protected]> написал(а): > > > > > Hi Alexey, > > > what Sqoop and OraOop version are you using? > > > > > > Jarcec > > > > > > On Fri, Aug 30, 2013 at 11:55:03AM +0400, Алексей Филановский wrote: > > >> Hi all! > > >> > > >> I install OraOop as pointed in instruction: > > >> http://archive.cloudera.com/cdh/3/adapters/oraoopuserguide.pdf< > http://archive.cloudera.com/cdh/4/adapters/oraoopuserguide.pdf> > > >> > > >> And try to use OraOop,but get error: > > >> > > >> [oracle@db11203x64 ~]$ sqoop import --connection-manager > > >> com.quest.oraoop.OraOopConnManager --connect > > >> jdbc:oracle:thin:@//localhost:1521/orcl > > >> --username demouser --password welcome1 --table > DEMOUSER.GUP_PROFILE_V2 > > >> 13/08/30 03:15:45 WARN tool.BaseSqoopTool: Setting your password on > the > > >> command-line is insecure. Consider using -P instead. > > >> 13/08/30 03:15:45 INFO manager.SqlManager: Using default fetchSize of > 1000 > > >> 13/08/30 03:15:45 INFO tool.CodeGenTool: Beginning code generation > > >> 13/08/30 03:15:48 ERROR sqoop.Sqoop: Got exception running Sqoop: > > >> java.lang.RuntimeException: RecallSqoopJobType() cannot be called > unless > > >> RememberSqoopJobType() has been used. > > >> java.lang.RuntimeException: RecallSqoopJobType() cannot be called > unless > > >> RememberSqoopJobType() has been used. > > >> at > > >> > com.quest.oraoop.OraOopUtilities.recallSqoopJobType(OraOopUtilities.java:757) > > >> at > > >> > com.quest.oraoop.OraOopConnManager.getColumnNamesInOracleTable(OraOopConnManager.java:115) > > >> at > > >> > com.quest.oraoop.OraOopConnManager.getSelectedColumnNamesInOracleTable(OraOopConnManager.java:135) > > >> at > > >> > com.quest.oraoop.OraOopConnManager.getColTypesQuery(OraOopConnManager.java:198) > > >> at > > >> > org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:220) > > >> at > > >> > com.quest.oraoop.OraOopConnManager.getColumnTypes(OraOopConnManager.java:460) > > >> at > > >> > org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:283) > > >> at > > >> org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1268) > > >> at > org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1080) > > >> at > > >> org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96) > > >> at > org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:390) > > >> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476) > > >> at org.apache.sqoop.Sqoop.run(Sqoop.java:145) > > >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > > >> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) > > >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) > > >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) > > >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) > > >> > > >> Sorry I didn't found the same case in web... > > >> > > >> -- > > >> Best regards, > > >> Alexey Filanovskiy > -- С уважением, Филановский Алексей
