Baike.dev
All toolsAI codingTrendingOpen sourceNewsSubmit
Log in
Back to tool/Back to issues
#15114·databend

tracking: inverted index benchmark

Author: bohutangCreated Mar 28, 2024Updated Sep 15, 2026
LabelsTracking

Summary

Version

https://github.com/datafuselabs/databend/releases/tag/v1.2.393-nightly

Table

CREATE OR REPLACE TABLE log (
    user_id INT,
    log_json VARIANT,
    time TIMESTAMP,
    url VARCHAR AS (log_json['request_url']::VARCHAR) STORED
);

CREATE OR REPLACE INVERTED INDEX idx_url ON log(url);

Source: databendlabs/databend

View original on GitHubView discussion on GitHub