在elasticsearch中,我们使用搜索模板构建日期范围查询时遇到了一个问题。它工作得很好,只有一个条件子句,但是当提供多个条件时,我们会得到以下错误。
{
"script": {
"lang": "mustache",
"source": "{
\"query\":{
\"bool\":{
\"must\":[
{{#since}}
{\"range\":
{\"@timestamp\":
{
{{#from}}\"from\":\"{{from}}\"{{/from}}
}
}
},{{/since}}
{\"query_string\":
{
\"query\":\"(title:({{query_string}}))\"
}
}
]
}
}
}"
}
}
错误:
{
error: {
root_cause: [
{
type: "general_script_exception",
reason: "Failed to compile stored script [dateTemplate] using lang [mustache]",
}
],
type: "general_script_exception",
reason: "Failed to compile stored script [dateTemplate] using lang [mustache]",
caused_by: {
type: "mustache_exception",
reason: "Improperly closed variable in query-template:1",
},
},
status: 500,
}
查询:
{“id”:“datetemplate”,“params”:{“query\u string”:“*”}
同样的方法也适用于此模板:
{
"script": {
"lang": "mustache",
"source": "{\"query\":{\"bool\":{\"must\":[{{#since}}{\"range\": {\"@timestamp\": {\"from\": \"{{since}}\"}}},{{/since}}{\"query_string\":{\"query\":\"(title:({{query_string}}))\"}}]}}}"
}
}
查询
{
"id": "date",
"params": {
"query_string": "*",
"since": "2018-07-23"
}
}
1条答案
按热度按时间jslywgbw1#
首先,我建议您使用三重引号重写模板,因为它更易于阅读和维护,如下所示:
然后,调用该查询的正确方法如下(即,您缺少
from
params对象中的变量):