SCORE

引入或更新于：v1.2.425

SCORE() 返回倒排索引搜索为当前行分配的相关性得分。请在 WHERE 子句中与 MATCH 或 QUERY 一起使用。

信息

Databend 的 SCORE 函数灵感来源于 Elasticsearch 的 SCORE。

语法

SCORE()

示例

示例：为 MATCH 准备文本注释

CREATE OR REPLACE TABLE frame_notes (
  id INT,
  camera STRING,
  summary STRING,
  tags STRING,
  INVERTED INDEX idx_notes (summary, tags)
);

INSERT INTO frame_notes VALUES
  (1, 'dashcam_front',
      'Green light at Market & 5th with pedestrian entering the crosswalk',
      'downtown commute green-light pedestrian'),
  (2, 'dashcam_front',
      'Vehicle stopped at Mission & 6th red traffic light with cyclist ahead',
      'stop urban red-light cyclist'),
  (3, 'dashcam_front',
      'School zone caution sign in SOMA with pedestrian waiting near crosswalk',
      'school-zone caution pedestrian');

示例：为 MATCH 结果评分

SELECT summary, SCORE()
FROM frame_notes
WHERE MATCH('summary^2, tags', 'traffic light red', 'operator=AND')
ORDER BY SCORE() DESC;

示例：为 QUERY 结果评分

复用 QUERY 示例中的 frames 表：

SELECT id, SCORE()
FROM frames
WHERE QUERY('meta.detections.label:pedestrian^3 AND meta.scene.time_of_day:day');