Page History

CREATE INDEX idx_request ON httplogs(request) USING INVERTED PROPERTIES("parser"="english");

// Other type of indexes:
CREATE INDEX idx_ngrambf ON tblname(username) USING NGRAM_BF PROPERTIES("size"="3", "other" = "256")  COMMENT "xxx";

CREATE INDEX idx ON tblname(username) USING BITMAP;

CREATE INDEX idx ON tblname(username) USING BLOOM_FILTER PROPERTIES("xxx"="asdasd");

// INDEX idx_ngrambf (`username`) USING NGRAM_BF(3,256) COMMENT 'username ngram_bf index'