Uploaded image for project: 'CDH (READ-ONLY)'
  1. CDH (READ-ONLY)
  2. DISTRO-589

Improve LOGS for Hive when a table it is not able to acquire locks

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CDH5.0.0, CDH 5.0.1
    • Fix Version/s: None
    • Component/s: Hive
    • Labels:
    • Environment:
      RHEL

      Description

      This error:

      Error in acquireLocks...
      FAILED: Error in acquiring locks: Locks on the underlying objects cannot be acquired. retry after some time

      Need to be more descriptive and tell which jobID or table is not able to acquire the locks

      In addition to add it need to say that please tune the following parameters:

      SET hive.lock.numretries XXX;
      SET hive.lock.sleep.between.retries YYY;

      in your hive script or in the hive-site.xml

      <property>
      <name>hive.lock.numretries</name>
      <value>XXX</value>
      <description>The number of times you want to try to get all the
      locks</description>
      </property>

      <property>
      <name>hive.lock.sleep.between.retries</name>
      <value>YYY</value>
      <description>The sleep time (in seconds) between various retries</description>
      </property>

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              joao Joao Salcedo
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: