[KYLIN-4356] Failed "Hive Column Cardinality calculation for table" jobs cannot be delete

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v3.1.0
• Assignee: ZhouKang
• Reporter: ZhouKang
• Created: 19/Jan/20 11:35
• Updated: 31/Jul/20 12:25
• Resolved: 28/Feb/20 12:03

Description

In KylinHealthCheck, we found there are too many failed jobs like this:

"name" : "Hive Column Cardinality calculation for table 'xxx.xxxxxxx'"

the FAILED job cannot be cleanup by MetastoreCleanupJob,

and the RESTful API  DELETE jobs/{uuid}/drop cannot work, return exeception 

// code placeholder
Caused by: org.apache.kylin.rest.exception.BadRequestException: Illegal job type, id: 4257d976-706b-90cb-d82b-1828e0128fd1.
  at org.apache.kylin.rest.service.JobService.getSingleJobInstance(JobService.java:501)
  at org.apache.kylin.rest.service.JobService.getJobInstance(JobService.java:486)
  at org.apache.kylin.rest.controller.JobController.dropJob(JobController.java:264)
  ... 75 more
 

seems there is no api to delete failed job of "Cardinality calculation" .

 

Issue Links

• links to: GitHub Pull Request #1072