Gopal Vijayaraghavan created HIVE-22654:
-------------------------------------------

             Summary: ACID: Allow TxnHandler::checkLock to chunk partitions by 
1000 
                 Key: HIVE-22654
                 URL: https://issues.apache.org/jira/browse/HIVE-22654
             Project: Hive
          Issue Type: Bug
            Reporter: Gopal Vijayaraghavan


The following loop can end up with too many entries within the IN clause 
throwing 

{code:java}
        // If any of the partition requests are null, then I need to pull all
        // partition locks for this table.
        sawNull = false;
        strings.clear();
        for (LockInfo info : locksBeingChecked) {
          if (info.partition == null) {
            sawNull = true;
            break;
          } else {
            strings.add(info.partition);
          }
        } 
{code}

{code}
2019-12-17T04:28:57,991 ERROR [pool-8-thread-143]: metastore.RetryingHMSHandler 
(RetryingHMSHandler.java:invokeInternal(201)) - MetaException(message:Unable to 
update transaction database java.sql.SQLSyntaxErrorException: ORA-01795: 
maximum number of expressions in a list is 1000
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to