The completion command will be used to execute a completion through an LLM using ES}QL.
| COMPLETION (<targetField>=)<prompt> WITH <inferenceId>
FROM search-movies
| WHERE match(plot, "Gandalf the grey")
| EVAL prompt= CONCAT(
"Extract movie genre:\n",
"<title>", title, "</title>",
"<actors>", MV_CONCAT(actors, ","), "</actors">,
"<plot>", plot, "</plot"
)
| COMPLETION completion=prompt WITH "openai-completion" AS genre
| DROP prompt
FROM business-news
| WHERE industry:technology AND date:today
| EVAL company_data = CONCAT(
"<title>", title, "</title>",
"<summary>", summary, "</summary">
"<article>", title, "</article"
)
| STATS company_data = VALUES(company_data) BY company
| EVAL prompt=CONCAT(
Summarize important news for the copmany\n",
"<company>", company, "</company>\n",
MV_CONCAT(company_data, "\n")
)
| COMPLETION completion=prompt WITH "openai-completion" AS company_news
Tracked in #123043
The completion command will be used to execute a completion through an LLM using ES}QL.
Command grammar
where
Usage example:
Row by row
Aggregated rows:
Development
Tech preview scope
GA scope