Search Result: Shakespeare - 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 ... ; The table is now ready to query using the Okapi BM25 ranking function. Rows with no match return 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, speak ... ex('corpus') and recreate it when appropriate. Note on Generating the Corpus Table For more details, see the “Generating a Shakespeare corpus for full-text searching from JSON” blog post . The Columns are: line_id , play_name , line_number , speaker , text_ ...; https://man.mtool.work/duckdb/2.0/guides/sql_features/full_text_search.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work