hive_locks字段

一、表结构

CREATE TABLE HIVE_LOCKS (
	HL_LOCK_EXT_ID bigint NOT NULL,
	HL_LOCK_INT_ID bigint NOT NULL,
	HL_TXNID bigint NOT NULL,
	HL_DB nvarchar(128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	HL_TABLE nvarchar(128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	HL_PARTITION nvarchar(767) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	HL_LOCK_STATE char(1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	HL_LOCK_TYPE char(1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	HL_LAST_HEARTBEAT bigint NOT NULL,
	HL_ACQUIRED_AT bigint NULL,
	HL_USER nvarchar(128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	HL_HOST nvarchar(128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	HL_HEARTBEAT_COUNT int NULL,
	HL_AGENT_INFO nvarchar(128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	HL_BLOCKEDBY_EXT_ID bigint NULL,
	HL_BLOCKEDBY_INT_ID bigint NULL,
	CONSTRAINT PK__HIVE_LOC__E9A2FB207A07DB2B PRIMARY KEY (HL_LOCK_EXT_ID,HL_LOCK_INT_ID)
);

HL_LOCK_EXT_ID:                    // 锁外部 ID
HL_LOCK_INT_ID:                     // 一个递增编号，和 HL_LOCK_EXT_ID 组成联合主键
HL_TXNID:                                 // 事务ID 
HL_DB: default                           // 数据库名
HL_TABLE:                                 // 表名
HL_PARTITION: pt=20241014   // 分区名
HL_LOCK_STATE: a                  // 锁状态：a（acquired）,w （waiting）
HL_LOCK_TYPE: e                    // 锁类型： e(exclusive), r (shared), w(LOCK_SEMI_SHARED)
HL_LAST_HEARTBEAT: 0
HL_ACQUIRED_AT:
HL_USER:
HL_HOST: localhost
HL_HEARTBEAT_COUNT: NULL
HL_AGENT_INFO: 
HL_BLOCKEDBY_EXT_ID: NULL
HL_BLOCKEDBY_INT_ID: NULL