Description
- Create a default index. Vector fields are not indexed in default index
- Run an fts SEARCH query
-
select car.Car, car.Color from carwhere SEARCH(c,{ "query": { "match_none": {} }, "knn": [{ "field": "color_rgb_vector", "vector": [0,255,255], "k": 3 }]});
-
- Getting random results
[ { "Car": "Ferrari", "Color": "strawberry" }, { "Car": "Chevrolet", "Color": "deep brown" }, { "Car": "Saab", "Color": "british racing green" }, { "Car": "De Lorean", "Color": "light lilac" }, { "Car": "Rolls-Royce", "Color": "greeny yellow" }, { "Car": "Bentley", "Color": "lighter green" }, { "Car": "Citroen", "Color": "blush" }, { "Car": "Chevrolet", "Color": "rosy pink" }, { "Car": "Bentley", "Color": "dusky rose" }, { "Car": "Bentley", "Color": "dull blue" }, { "Car": "Rolls-Royce", "Color": "ugly purple" }, { "Car": "Bentley", "Color": "dark plum" }, { "Car": "Porsche", "Color": "pale aqua" }, { "Car": "Porsche", "Color": "grassy green" }, { "Car": "Volvo", "Color": "magenta" }, { "Car": "Daihatsu", "Color": "neon blue" }, { "Car": "Ferrari", "Color": "pale sky blue" }, { "Car": "Bentley", "Color": "deep lavender" }, { "Car": "Maserati", "Color": "deep sea blue" }, { "Car": "Honda", "Color": "camo" }, { "Car": "Rolls-Royce", "Color": "spearmint" }, { "Car": "Volvo", "Color": "white" }, { "Car": "Volvo", "Color": "sand" }, { "Car": "Bentley", "Color": "grey pink" }, { "Car": "Ferrari", "Color": "ocher" }, { "Car": "Audi", "Color": "medium pink" }, { "Car": "Ferrari", "Color": "aqua blue" }, { "Car": "Chevrolet", "Color": "bright lilac" }, { "Car": "Maserati", "Color": "dark seafoam green" }, { "Car": "Daihatsu", "Color": "light royal blue" }, { "Car": "Suzuki", "Color": "cobalt" }, { "Car": "De Lorean", "Color": "black" }, { "Car": "Porsche", "Color": "shit brown" }, { "Car": "Bentley", "Color": "orange yellow" }, { "Car": "Fiat", "Color": "pine green" }, { "Car": "Ford", "Color": "heliotrope" }, { "Car": "Saab", "Color": "purpleish blue" }, { "Car": "Maserati", "Color": "pale gold" }, { "Car": "Volvo", "Color": "off blue" }, { "Car": "Audi", "Color": "pastel yellow" }, { "Car": "Chevrolet", "Color": "coral" }, { "Car": "Chevrolet", "Color": "light khaki" }, { "Car": "Bentley", "Color": "mid green" }, { "Car": "Saab", "Color": "ugly yellow" }, { "Car": "Maserati", "Color": "light beige" }, { "Car": "Saab", "Color": "bottle green" }, { "Car": "De Lorean", "Color": "shit" }, { "Car": "Ford", "Color": "dull green" }, { "Car": "Bentley", "Color": "dark mint" }, { "Car": "Porsche", "Color": "pale" }, { "Car": "Porsche", "Color": "strawberry" }, { "Car": "Bentley", "Color": "swamp" }, a lotttt more documents |
|
If I create another index on vector fields I get correct results.
[ { "Car": "Daihatsu", "Color": "cyan" }, { "Car": "Daihatsu", "Color": "neon blue" }, { "Car": "Porsche", "Color": "neon blue" }] |
Attachments
Issue Links
- relates to
-
MB-61545 KNN queries (that do not use a search index) are not adding any value if run along with AND queries
- Closed