[SQOOP-453] Oozie does not work with Sqoop metastore

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3.0
• Fix Version/s: 1.4.2
• Assignee: Cheolsoo Park
• Reporter: Patrick Angeles
• Created: 02/Mar/12 20:50
• Updated: 25/Apr/12 14:05
• Resolved: 25/Apr/12 13:15

Description

The sqoop metastore is handy for retaining lastvalue during incremental imports.
Unfortunately, it does not work with Oozie. Here's the log from the launcher:

java.lang.NullPointerException
at com.cloudera.sqoop.SqoopOptions.securePasswordEntry(SqoopOptions.java:1069)
at com.cloudera.sqoop.SqoopOptions.setPasswordFromConsole(SqoopOptions.java:1077)
at com.cloudera.sqoop.SqoopOptions.loadProperties(SqoopOptions.java:562)
at com.cloudera.sqoop.metastore.hsqldb.HsqldbJobStorage.read(HsqldbJobStorage.java:303)
at com.cloudera.sqoop.tool.JobTool.execJob(JobTool.java:203)
at com.cloudera.sqoop.tool.JobTool.run(JobTool.java:288)
at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182)
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221)
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230)
at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239)
at org.apache.oozie.action.hadoop.SqoopMain.runSqoopJob(SqoopMain.java:198)
at org.apache.oozie.action.hadoop.SqoopMain.run(SqoopMain.java:172)
at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:26)
at org.apache.oozie.action.hadoop.SqoopMain.main(SqoopMain.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:391)
at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:391)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:325)
at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1157)
at org.apache.hadoop.mapred.Child.main(Child.java:264)