What do you mean by that? write custom SQL to cleanup Oozie DB? I would like yo use built in Oozie service and its properties.
2013/10/2 Jabir Ahmed <[email protected]> > Its quite straight forward to purge old records. . You can set up your own > script to clean up > On Oct 2, 2013 2:47 PM, "Serega Sheypak" <[email protected]> wrote: > >> The same problem with 3.3.2-CDH-4.3 >> Don't know what to do. We have more than 2000 materializations and we >> can't setup purging policies >> >> четверг, 9 августа 2012 г., 21:14:38 UTC+4 пользователь Jabir Ahmed >> написал: >>> >>> this is where its failing >>> >>> @Override >>> public void init(Services services) { >>> Configuration conf = services.getConf(); >>> >>> Runnable purgeJobsRunnable = new PurgeRunnable(conf.getInt( >>> CONF_OLDER_**THAN, 30), >>> conf.getInt(COORD_CONF_OLDER_**THAN, 7), >>> conf.getInt(BUNDLE_CONF_OLDER_**THAN, 7), >>> >>> ** conf.getInt(PURGE_**LIMIT, 100)); >>> >>> services.get(Scheduler**Service.class).schedule(purgeJ**obsRunnable, 10, >>> conf.getInt(CONF_PURGE_**INTERVAL, 3600), >>> >>>   >>> ; ** SchedulerServic**e.Unit.SEC); >>> if (Services.get().getConf().getB**oolean(USE_XCOMMAND, true) == >>> false) { >>> >>> useXCommand = false; >>> } >>> >>> Thanks >>> >>> Jabir >>> >>> >>> On 8/9/12 10:33 PM, jabir ahmed wrote: >>> >>> i enabled the purge service in oozie and i see this error in the logs >>> >>> 2012-08-09 16:59:57,625 FATAL Services:533 - USER[-] GROUP[-] null >>> java.lang.NullPointerException >>> at org.apache.oozie.service.**PurgeService.init(** >>> PurgeService.java:92) >>> at org.apache.oozie.service.**Services.setServiceInternal(** >>> Services.java:310) >>> at org.apache.oozie.service.**Services.setService(Services.** >>> java:296) >>> at org.apache.oozie.service.**Services.init(Services.java:**206) >>> at org.apache.oozie.servlet.**ServicesLoader.**contextInitialized(** >>> ServicesLoader.java:40) >>> >>> >>> which points to this piece of the code >>> >>> 091 092 if >>> (Services.get().getConf().**getBoolean(USE_XCOMMAND, true) == false) {093 >>> useXCommand = false;094 } >>> >>> any idea how to get over this issue >>> >>> Thanks >>> >>> Jabir >>> >>> >>> >>> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "CDH Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> >> For more options, visit >> https://groups.google.com/a/cloudera.org/groups/opt_out. >> > -- > > --- > You received this message because you are subscribed to a topic in the > Google Groups "CDH Users" group. > To unsubscribe from this topic, visit > https://groups.google.com/a/cloudera.org/d/topic/cdh-user/tgY7I3JtNiY/unsubscribe > . > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit > https://groups.google.com/a/cloudera.org/groups/opt_out. >
