...

• fulltext search query

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

• equal query

SELECT * FROM httplogs WHERE status = 404;

...

SELECT COUNT() FROM httplogs WHERE size > 1024;

Implementation

Scheduling

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

Step2: INVERTED index implementation for string type

Step3: INVERTED index implementation for numeric type

Step4: INVERTED index implementation for array typespecific implementation steps and approximate scheduling.