Versions Compared

Old Version 7

changes.mady.by.user Unknown User (morningman)

Saved on

compared with

New Version 8

changes.mady.by.user Unknown User (xiaokang)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
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'


  • fulltext search query
Code Block
languagesql
-- search for request contains word 'login'
SELECT * FROM httplogs WHERE request MATCH 'login';

-- search for request contains word 'login' or 'error'
SELECT * FROM httplogs WHERE request MATCH 'login error';

-- search for request contains word 'login' and 'error'
SELECT * FROM httplogs WHERE request MATCH_ALL 'login';

...

Step1: INVERTED index SQL spec and code interface (2022.10)

  Step1.1: SQL syntax and metadata

  Step1.2: index write interface and related call in write path

  Step1.3: index query interface and related call in query path

Step2: INVERTED index implementation for string type

...