Hi Abraham, I found the user guide pdf in the project's files :-) I hope to find the answers there.
Thank you Leo On Mon, Jun 16, 2014 at 2:56 PM, Leonardo Brambilla < [email protected]> wrote: > Thank you Abraham, do you have a sample command line syntax on how to use > the OraOop connector? I can't figure it out how to use it. > > Regards > Leo > > > On Sat, Jun 14, 2014 at 6:18 PM, Abraham Elmahrek <[email protected]> > wrote: > >> Hey there, >> >> Are you using the standard connector or the OraOop connector? I think >> OraOpp should support TIMESTAMP WITH TIME ZONE type. >> >> NOTE: There's a review to add it as part of the standard Sqoop: >> https://reviews.apache.org/r/18452/. The community is in the process of >> reviewing this. Until then, it seems available here: >> https://github.com/QuestSoftwareTCD/OracleSQOOPconnector. >> >> -Abe >> >> >> On Fri, Jun 13, 2014 at 3:02 PM, Leonardo Brambilla < >> [email protected]> wrote: >> >>> Hello, >>> >>> I'm trying to use Sqoop to export data to an Oracle table. The table has >>> a Timestamp column with Type TIMESTAMP(6) WITH TIME ZONE. The value is a >>> long representing milliseconds. >>> >>> Here is a sample row: >>> *1400040430901* NULL NULL 7205849 591117613 SkipNotificationExp >>> >>> The first column is the one with the problem. >>> Here is part of the log: >>> 14/06/13 17:56:08 WARN tool.BaseSqoopTool: Setting your password on the >>> command-line is insecure. Consider using -P instead. >>> 14/06/13 17:56:08 INFO manager.SqlManager: Using default fetchSize of >>> 1000 >>> 14/06/13 17:56:08 INFO tool.CodeGenTool: Beginning code generation >>> 14/06/13 17:56:09 INFO manager.OracleManager: Time zone has been set to >>> GMT >>> 14/06/13 17:56:09 INFO manager.SqlManager: Executing SQL statement: >>> SELECT t.* FROM etl.expt_email_rec t WHERE 1=0 >>> 14/06/13 17:56:09 INFO manager.SqlManager: Executing SQL statement: >>> SELECT t.* FROM etl.expt_email_rec t WHERE 1=0 >>> 14/06/13 17:56:09 ERROR orm.ClassWriter: Cannot resolve SQL type -101 >>> 14/06/13 17:56:09 ERROR orm.ClassWriter: Cannot resolve SQL type -101 >>> 14/06/13 17:56:09 ERROR orm.ClassWriter: No Java type for SQL type -101 >>> for column timestamp >>> 14/06/13 17:56:09 ERROR orm.ClassWriter: No Java type for SQL type -101 >>> for column timestamp >>> 14/06/13 17:56:09 ERROR orm.ClassWriter: No Java type for SQL type -101 >>> for column timestamp >>> 14/06/13 17:56:09 ERROR orm.ClassWriter: No Java type for SQL type -101 >>> for column timestamp >>> 14/06/13 17:56:09 ERROR orm.ClassWriter: No Java type for SQL type -101 >>> for column timestamp >>> 14/06/13 17:56:09 ERROR orm.ClassWriter: No Java type for SQL type -101 >>> for column timestamp >>> 14/06/13 17:56:09 ERROR sqoop.Sqoop: Got exception running Sqoop: >>> java.lang.NullPointerException >>> java.lang.NullPointerException >>> at >>> org.apache.sqoop.orm.ClassWriter.parseNullVal(ClassWriter.java:912) >>> at >>> org.apache.sqoop.orm.ClassWriter.parseColumn(ClassWriter.java:937) >>> at >>> org.apache.sqoop.orm.ClassWriter.generateParser(ClassWriter.java:1020) >>> at >>> org.apache.sqoop.orm.ClassWriter.generateClassForColumns(ClassWriter.java:1364) >>> at >>> org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1176) >>> at >>> org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96) >>> at >>> org.apache.sqoop.tool.ExportTool.exportTable(ExportTool.java:64) >>> at org.apache.sqoop.tool.ExportTool.run(ExportTool.java:100) >>> at org.apache.sqoop.Sqoop.run(Sqoop.java:145) >>> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) >>> 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) >>> >>> Any hint please? >>> I tried with Sqoop 1.4.3 and 1.4.4, with oracle driver 6. >>> >>> Thanks >>> Leonardo >>> >>> >>> >> >
