In CrateDB we are makıng Fulltext search we have a huge data like 69 million rows. When we make searches with analyzer only with standart tokenizer and lowercase filter and phrase_prefix included it seems like cratedb does not match everything. It is missing many rows with valid matches. with small db it works good. Did anybody make same kind of search in such big data and faced similar issue? Is there anybody who can help us the trace what is happening.
1 Like
Hi, could you share your table and analyzer definitions, the query you are using and examples of strings that match and strings you would expect to match and are not matching?
1 Like