Hi Dave, you can always put together simple Java action that will execute your stored procedure.
Jarcec On Thu, Apr 04, 2013 at 05:13:52PM +0100, Dave Cardwell wrote: > To your second point—as part of my Oozie workflow when data has been > sqooped over from MySQL I’d like to archive it off into another table. > > This involves selecting from my table into an archive table, and then > deleting from the original. To make sure I can do this in a transaction I > created a stored procedure, and had this called using sqoop-eval. > > If this is not a recommended usage of sqoop-eval is there a more > appropriate method anyone can suggest? > > -- > Best wishes, > Dave Cardwell. > > http://davecardwell.co.uk/ > > > On 4 April 2013 15:56, Jarek Jarcec Cecho <[email protected]> wrote: > > > Hi Dave, > > do you think that you can share entire stack trace of the exception? I > > think that I do know where the issue might be, but I would like to verify > > that. > > > > However please do note that Sqoop is not general query tool and using it > > for calling stored procedures is not supported nor recommended use. The > > tool "eval" is available only for evaluation purpose and should not be used > > in any production workflow. > > > > Jarcec > > > > On Thu, Apr 04, 2013 at 02:28:55PM +0100, Dave Cardwell wrote: > > > I have a Sqoop action which uses sqoop-eval to call a MySQL stored > > > procedure. It works fine from the command line, and the call actually > > > completes in Oozie giving an external status of “SUCCEEDED”, but the > > > resulting status of the action is ERROR, with the following message: > > > > > > IllegalArgumentException: JobId string : is not properly formed > > > > > > Here is the action configuration: > > > > > > <sqoop xmlns="uri:oozie:sqoop-action:0.2"> > > > <job-tracker>my.server.com:8021</job-tracker> > > > <name-node>hdfs://my.server.com:8020</name-node> > > > <arg>eval</arg> > > > <arg>--query</arg> > > > <arg>CALL `move_cdrs_to_working`;</arg> > > > <arg>--connect</arg> > > > <arg>jdbc:mysql://my.server.com/my_database</arg> > > > <arg>--username</arg> > > > <arg>my_user</arg> > > > <arg>--password</arg> > > > <arg>my_password</arg> > > > </sqoop> > > > > > > > > > The job log: > > > https://gist.github.com/davecardwell/fd08802d6bdfd901d38a > > > > > > > > > Any ideas? > > > > > > -- > > > Best wishes, > > > Dave Cardwell. > > > > > > http://davecardwell.co.uk/ > >
signature.asc
Description: Digital signature
