• MapReduce Service

mrs
  1. Help Center
  2. MapReduce Service
  3. User Guide
  4. MRS Manager Operation Guide
  5. Alarm Reference
  6. ALM-16002 Successful Hive SQL Operations Are Lower than the Threshold

ALM-16002 Successful Hive SQL Operations Are Lower than the Threshold

Description

Every 30 seconds, the system checks the percentage of successfully executed HiveQL statements. Percentage of successfully executed HiveQL statements = Number of HiveQL statements successfully executed by Hive in a specified period/Total number of HiveQL statements executed by Hive. This indicator can be viewed on the Hive service monitoring page.

This alarm is generated when the percentage of successfully executed HiveQL statements is lower than the specified threshold and is cleared when the percentage is greater than or equal to the threshold.

The name of the host where the alarm is generated can be obtained from the alarm location information. The host IP address is the IP address of the HiveServer node.

Attribute

Alarm ID

Alarm Severity

Automatically Cleared

16002

Major

Yes

Parameters

Parameter

Description

ServiceName

Specifies the service for which the alarm is generated.

RoleName

Specifies the role for which the alarm is generated.

HostName

Specifies the host for which the alarm is generated.

Trigger condition

Generates an alarm when the actual indicator value exceeds the specified threshold.

Impact on the System

The system configuration and performance cannot meet service processing requirements.

Possible Causes

  • A syntax error occurs in HiveQL commands.
  • The HBase service is abnormal when a Hive on HBase task is being performed.
  • Basic services that are depended on are abnormal, such as HDFS, Yarn, and ZooKeeper.

Procedure

  1. Check whether the HiveQL commands comply with syntax.

    1. Use the Hive client to log in to the HiveServer node where the alarm is generated. Query the HiveQL syntax standard provided by Apache, and check whether the HiveQL commands are correct. For details, see https://cwiki.apache.org/confluence/display/hive/languagemanual.
      • If yes, go to 2.a.
      • If no, go to 1.b.
      NOTE:

      To view the user who runs an incorrect statement, download the HiveServerAudit logs of the HiveServer node where this alarm is generated. Set Start Time and End Time to 10 minutes before and after the alarm generation time respectively. Open the log file and search for the Result=FAIL keyword to filter the log information about the incorrect statement, and then view the user who runs the incorrect statement according to UserName in the log information.

    2. Enter correct HiveQL statements, and check whether the command can be properly executed.
      • If yes, go to 4.e.
      • If no, go to 2.a.

  2. Check whether the HBase service is abnormal.

    1. Check whether a Hive on HBase task is performed.
      • If yes, go to 2.b.
      • If no, go to 3.a.
    2. Check whether the HBase service is in the normal state in the service list.
      • If yes, go to 3.a.
      • If no, go to 2.c.
    3. Check the alarms displayed on the alarm page and clear them according to Alarm Help.
    4. Enter correct HiveQL statements, and check whether the command can be properly executed.
      • If yes, go to 4.e.
      • If no, go to 3.a.

  3. Check whether the Spark service is abnormal.

    1. Check whether the Spark service is in the normal state in the service list.
      • If yes, go to 4.a.
      • If no, go to 3.b.
    2. Check the alarms displayed on the alarm page and clear them according to Alarm Help.
    3. Enter correct HiveQL statements, and check whether the command can be properly executed.
      • If yes, go to 4.e.
      • If no, go to 4.a.

  4. Check whether HDFS, Yarn, and ZooKeeper are in the normal state.

    1. On the MRS Manager portal, click Service.
    2. In the service list, check whether the services, such as HDFS, Yarn, and ZooKeeper are in the normal state.
      • If yes, go to 4.e.
      • If no, go to 4.c.
    3. Check the alarms displayed on the alarm page and clear them according to Alarm Help.
    4. Enter correct HiveQL statements, and check whether the command can be properly executed.
    5. Wait 5 minutes and check whether the alarm is cleared.
      • If yes, no further action is required.
      • If no, go to Step 5.

  5. Collect fault information.

    1. On MRS Manager, choose System > Export Log.
    2. Contact technical support engineers for help, detail see technical support.

Related Information

N/A