CREATE TABLE IF NOT EXISTS AGENT_TEST(
time DATE NOT NULL,
vccId varchar NOT NULL,
agId varchar NOT NULL,
readyNum BIGINT
CONSTRAINT PK PRIMARY KEY(Id,time DESC,vccId,agId)
) COMPRESSION='GZ',DATA_BLOCK_ENCODING='NONE',VERSIONS=5,MAX_FILESIZE=2000000000 split on (1,2,3,4,5,6)
UPSERT INTO AGENT_TEST values ('2019-11-13 14:00:00','2000102','123456',1);
Phonix按照时间倒序排序实现
最新推荐文章于 2020-10-28 21:46:32 发布