Unable to cancel a running HIVE job for a Warehouse Report in RSA Security Analytics

[#1]

Article Number

000001734

Applies To

RSA Product Set: Security Analytics
RSA Product/Service Type: Security Analytics UI, Reporting Engine, Security Analytics Warehouse (SAW)
RSA Version/Condition: 10.3.x, 10.4.x
Platform: CentOS

Issue

Due to limitations in the Hive JDBC interface, Warehouse reports will continue to run on the Warehouse even after a user cancels from the Reporting Engine module in the RSA Security Analytics UI.

Workaround

In order to cancel the job, the job must be killed manually following the steps below based on the type of warehouse.

MapR Warehouse

1. Get the Jobid from the job logs, as shown in the example below.

   14/08/22 13:11:05 INFO mapred.JobClient: Running job: job_201408220629_0004

2. Login to the jobtracker UI by navigating to http://<jobtracker-host>:50030/jobtracker.jsp and search for the Jobid to kill under Running Jobs.