Search Result: corpus - DuckDB 2.0 全文検索

Full-Text Search 9414: DuckDB supports full-text search via the fts extension . A full-text index allows for a query to quickly search for all occurrences of individual words within longer text strings. Example: Shakespeare Corpus Here's an example of building a ... full-text index of Shakespeare's plays. CREATE TABLE corpus AS SELECT * FROM 'https://blobs.duckdb.org/data/shakespeare.parquet'; DESCRIBE corpus; column_name column_type null key de ... will just index the single column text_entry , which contains the text of the lines in the play. PRAGMA create_fts_index('corpus', 'line_id', 'text_entry'); The table is now ready to query using the Okapi BM25 ranking function. Rows with no match retu ... rn a NULL score. What does Shakespeare say about butter? SELECT * FROM ( SELECT fts_main_corpus.match_bm25(line_id, 'butter') AS score, line_id, play_name, speaker, text_entry FROM corpus ) sq WHERE score IS NOT NULL O ...; https://man.mtool.work/duckdb/2.0/guides/sql_features/full_text_search.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work