我的是生产环境5张表没有，但是测试环境5张表都是全的，以下是五张表的建表语句
CREATE TABLE hive.COMPACTION_QUEUE (
CQ_ID bigint(20) NOT NULL,
CQ_DATABASE varchar(128) NOT NULL,
CQ_TABLE varchar(128) NOT NULL,
CQ_PARTITION varchar(767) DEFAULT NULL,
CQ_STATE char(1) NOT NULL,
CQ_TYPE char(1) NOT NULL,
CQ_WORKER_ID varchar(128) DEFAULT NULL,
CQ_START bigint(20) DEFAULT NULL,
CQ_RUN_AS varchar(128) DEFAULT NULL,
PRIMARY KEY (CQ_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE hive.HIVE_LOCKS (
HL_LOCK_EXT_ID bigint(20) NOT NULL,
HL_LOCK_INT_ID bigint(20) NOT NULL,
HL_TXNID bigint(20) DEFAULT NULL,
HL_DB varchar(128) NOT NULL,
HL_TABLE varchar(128) DEFAULT NULL,
HL_PARTITION varchar(767) DEFAULT NULL,
HL_LOCK_STATE char(1) NOT NULL,
HL_LOCK_TYPE char(1) NOT NULL,
HL_LAST_HEARTBEAT bigint(20) NOT NULL,
HL_ACQUIRED_AT bigint(20) DEFAULT NULL,
HL_USER varchar(128) NOT NULL,
HL_HOST varchar(128) NOT NULL,
PRIMARY KEY (HL_LOCK_EXT_ID,HL_LOCK_INT_ID),
KEY HIVE_LOCK_TXNID_INDEX (HL_TXNID),
KEY HL_TXNID_IDX (HL_TXNID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE hive.NEXT_COMPACTION_QUEUE_ID (
NCQ_NEXT bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE NEXT_TXN_ID (
NTXN_NEXT bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE next_lock_id (
NL_NEXT bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;