Page History

...

1. add a new index type INVERTED index
2. support create INVERTED index with tokenizer and parser and fast fulltext search on text column with type char/varchar/string.
3. support create INVERTED index without tokenizer parser and fast equal, range operators on text column with type char/varchar/string.
4. support create INVERTED index without tokenizer parser and fast equal, range operators on numeric column with type int*/float*/date/datetime.

...

CREATE TABLE httplogs (
  ts datetime,
  clientip varchar(20),
  request string,
  status smallint,
  size int,
  INDEX idx_size (size) USING INVERTED,
  INDEX idx_status (status) USING INVERTED,
  INDEX idx_clientip (clientip) USING INVERTED PROPERTIES("tokenizerparser"="none"),
) ENGINE=OLAP
DUPLICATE KEY(ts);

...

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

• fulltext search query

...