Phonix按照时间倒序排序实现

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);