tracking: inverted index benchmark about databend HOT 2 OPEN

INSERT INTO log
SELECT
    (FLOOR(RAND() * 1000000) % 10000)::INT,
    JSON_OBJECT(
        'user_ip', CONCAT_WS(
            '.',
            FLOOR(RAND() * 255)::STRING,
            FLOOR(RAND() * 255)::STRING,
            FLOOR(RAND() * 255)::STRING,
            FLOOR(RAND() * 255)::STRING
        ),
        'request_method', IF(RAND() > 0.5, 'GET', 'POST'),
        'request_url', CONCAT(
            'http://example.com/',
            CASE
                WHEN RAND() < 0.1 THEN 'login'
                WHEN RAND() < 0.2 THEN 'logout'
                WHEN RAND() < 0.3 THEN 'profile'
                WHEN RAND() < 0.4 THEN 'settings'
                WHEN RAND() < 0.5 THEN 'dashboard'
                WHEN RAND() < 0.6 THEN 'search?q=example'
                WHEN RAND() < 0.7 THEN 'help'
                WHEN RAND() < 0.8 THEN 'contact'
                WHEN RAND() < 0.9 THEN 'about'
                ELSE 'home'
            END
        ),
        'response_status', IF(RAND() > 0.5, '200', '404')
    ),
    NOW()
FROM numbers(100000000);

SELECT count(*)
FROM log
WHERE MATCH(url, 'logout');

SELECT count(*)
FROM log
WHERE url like '%logout%';

INSERT INTO log
SELECT
    (FLOOR(RAND() * 1000000) % 10000)::INT,
    JSON_OBJECT(
        'user_ip', CONCAT_WS(
            '.',
            FLOOR(RAND() * 255)::STRING,
            FLOOR(RAND() * 255)::STRING,
            FLOOR(RAND() * 255)::STRING,
            FLOOR(RAND() * 255)::STRING
        ),
        'request_method', IF(RAND() > 0.5, 'GET', 'POST'),
        'request_url', CONCAT(
            'http://example.com/',
           LEFT(MD5(RAND()::STRING), 5)
        ),
        'response_status', IF(RAND() > 0.5, '200', '404')
    ),
    NOW()
FROM numbers(100000000);

SELECT count(*)
FROM log
WHERE MATCH(url, '78114');

SELECT count(*)
FROM log
WHERE url like '%78114%';