elasticsearch/docs/reference/query-languages/esql/_snippets/commands/examples/rerank.csv-spec/two-queries.md

% This is generated by ESQL's AbstractFunctionTestCase. Do not edit it. See ../README.md for how to regenerate it.

FROM books METADATA _score
| WHERE MATCH(description, "hobbit") OR MATCH(author, "Tolkien")
| SORT _score DESC
| LIMIT 100
| RERANK rerank_score = "hobbit" ON description, author WITH { "inference_id" : "test_reranker" }
| SORT rerank_score
| LIMIT 3
| KEEP title, _score, rerank_score

title:text	_score:double	rerank_score:double
Return of the Shadow	2.8181066513061523	5.740527994930744E-4
Return of the King Being the Third Part of The Lord of the Rings	3.6248698234558105	9.000900317914784E-4
The Lays of Beleriand	1.3002015352249146	9.36329597607255E-4