问题描述
查看oozie的catalina.out日志，报错如下：ERROR:OoziecouldnotbestartedREASON:org.apache.oozie.service.ServiceException:E0103:Couldnotloadserviceclasses,Column'T0.RECOVERY'iseithernotinanytableintheFROMlistorappearswithinajoinspecificationandisoutsidethescopeofthejoinspecificationorappearsinaHAVINGclauseandisnotintheGROUPBYlist.IfthisisaCREATEorALTERTABLEstatementthen'T0.RECOVERY'isnotacolumninthetargettable.{SELECTt0.bean_type,t0.app_name,t0.app_path,t0.bundle_id,t0.concurrency,t0.conf,t0.external_id,t0.frequency,t0.group_name,t0.last_action_number,t0.mat_throttling,t0.time_out,t0.time_zone,t0.user_name,t0.app_namespace,t0.created_time,t0.done_materialization,t0.end_time,t0.execution,t0.job_xml,t0.last_action,t0.last_modified_time,t0.next_matd_time,t0.orig_job_xml,t0.pause_time,t0.pending,t0.recovery,t0.sla_xml,t0.start_time,t0.status,t0.suspended_time,t0.time_unitFROMCOORD_JOBSt0WHEREt0.bean_type=?ANDt0.id=?}[code=30000,state=42X04]Stacktrace:-----------------------------------------------------------------org.apache.oozie.service.ServiceException:E0103:Couldnotloadserviceclasses,Column'T0.RECOVERY'iseithernotinanytableintheFROMlistorappearswithinajoinspecificationandisoutsidethescopeofthejoinspecificationorappearsinaHAVINGclauseandisnotintheGROUPBYlist.IfthisisaCREATEorALTERTABLEstatementthen'T0.RECOVERY'isnotacolumninthetargettable.{SELECTt0.bean_type,t0.app_name,t0.app_path,t0.bundle_id,t0.concurrency,t0.conf,t0.external_id,t0.frequency,t0.group_name,t0.last_action_number,t0.mat_throttling,t0.time_out,t0.time_zone,t0.user_name,t0.app_namespace,t0.created_time,t0.done_materialization,t0.end_time,t0.execution,t0.job_xml,t0.last_action,t0.last_modified_time,t0.next_matd_time,t0.orig_job_xml,t0.pause_time,t0.pending,t0.recovery,t0.sla_xml,t0.start_time,t0.status,t0.suspended_time,t0.time_unitFROMCOORD_JOBSt0WHEREt0.bean_type=?ANDt0.id=?}[code=30000,state=42X04]atorg.apache.oozie.service.Services.loadServices(Services.java:296)atorg.apache.oozie.service.Services.init(Services.java:213)atorg.apache.oozie.servlet.ServicesLoader.contextInitialized(ServicesLoader.java:45)atorg.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)atorg.apache.catalina.core.StandardContext.start(StandardContext.java:4705)atorg.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)通过日志来看，启动后查了COORD_JOBS表，为什么要查这张表呢？