Updated on 2022-11-18 GMT+08:00

Operation Concurrent Execution

Before performing DDL and DML operations, you need to obtain the corresponding locks. See Table 1 for details about the locks that need to be obtained for each operation. The check mark (√) indicates that the lock is required. An operation can be performed only after all required locks are obtained.

You can check whether any two operations can be executed concurrently by using the following method: The first two lines in Table 1 indicate two operations. If no column in the two lines is marked with the check mark (√), the two operations can be executed concurrently. That is, if the columns with check marks (√) in the two lines do not exist, the two operations can be executed concurrently.

Table 1 List of obtaining locks for operations

Operation

METADATA_LOCK

COMPACTION_LOCK

DROP_TABLE_LOCK

DELETE_SEGMENT_LOCK

CLEAN_FILES_LOCK

ALTER_PARTITION_LOCK

UPDATE_LOCK

STREAMING_LOCK

CONCURRENT_LOAD_LOCK

SEGMENT_LOCK

CREATE TABLE

-

-

-

-

-

-

-

-

-

-

CREATE TABLE As SELECT

-

-

-

-

-

-

-

-

-

-

DROP TABLE

-

-

-

-

-

-

-

ALTER TABLE COMPACTION

-

-

-

-

-

-

-

-

TABLE RENAME

-

-

-

-

-

-

-

-

-

-

ADD COLUMNS

-

-

-

-

-

-

-

-

DROP COLUMNS

-

-

-

-

-

-

-

-

CHANGE DATA TYPE

-

-

-

-

-

-

-

-

REFRESH TABLE

-

-

-

-

-

-

-

-

-

-

REGISTER INDEX TABLE

-

-

-

-

-

-

-

-

-

REFRESH INDEX

-

-

-

-

-

-

-

-

-

LOAD DATA/INSERT INTO

-

-

-

-

-

-

-

-

UPDATE CARBON TABLE

-

-

-

-

-

-

-

DELETE RECORDS from CARBON TABLE

-

-

-

-

-

-

-

DELETE SEGMENT by ID

-

-

-

-

-

-

-

-

DELETE SEGMENT by DATE

-

-

-

-

-

-

-

-

SHOW SEGMENTS

-

-

-

-

-

-

-

-

-

-

CREATE SECONDARY INDEX

-

-

-

-

-

-

-

SHOW SECONDARY INDEXES

-

-

-

-

-

-

-

-

-

-

DROP SECONDARY INDEX

-

-

-

-

-

-

-

-

CLEAN FILES

-

-

-

-

-

-

-

-

-

-

SET/RESET

-

-

-

-

-

-

-

-

-

-

Add Hive Partition

-

-

-

-

-

-

-

-

-

-

Drop Hive Partition

-

-

-

-

Drop Partition

-

-

-

-

Alter table set

-

-

-

-

-

-

-

-