【ElasticSearch Cannot generate a query DSL for an SQL query that either its WHERE clause evaluates 】

错误日志

下面展示一些 内联代码片。

// A code block
var foo = 'bar';

// An highlighted block
ERROR c.o.f.c.e.ICommonExceptionProcessor [CmsExceptionProcessor.java: 26] [UNKNOWN_SYSTEM_EXCEPTION] Message: method [POST], host [http://10.10.6.138:9200], URI [/_sql/translate], status line [HTTP/1.1 400 Bad Request]
{"error":{"root_cause":[{"type":"planning_exception","reason":"Cannot generate a query DSL for an SQL query that either its WHERE clause evaluates to FALSE or doesn't operate on a table (missing a FROM clause), sql statement: [ SELECT * FROM cms_dzsc_sales_skill_alias WHERE(codeId LIKE '%PWMA0119%' AND esTags.neirongfenlei.value = '产品手册' AND esTags.productChannel.value = 'STARHOMES橱柜' AND esTags.productChannel.value = 'Baunis铂尼思木门') ORDER BY lastUpdateDt ASC]"}],"type":"planning_exception","reason":"Cannot generate a query DSL for an SQL query that either its WHERE clause evaluates to FALSE or doesn't operate on a table (missing a FROM clause), sql statement: [ SELECT * FROM cms_dzsc_sales_skill_alias WHERE(codeId LIKE '%PWMA0119%' AND esTags.neirongfenlei.value = 'XX手册' AND esTags.productChannel.value = 'XXX橱柜' AND esTags.productChannel.value = 'XX木门') ORDER BY lastUpdateDt ASC]"},"status":400}
StackTrace:
org.elasticsearch.client.ResponseException: method [POST], host [http://10.10.6.138:9200], URI [/_sql/translate], status line [HTTP/1.1 400 Bad Request]
{"error":{"root_cause":[{"type":"planning_exception","reason":"Cannot generate a query DSL for an SQL query that either its WHERE clause evaluates to FALSE or doesn't operate on a table (missing a FROM clause), sql statement:

错误原因

either its WHERE clause evaluates to FALSE or doesn’t operate on a table
where里面and过滤条件有相同key的过滤条件：有两个esTags.neirongfenlei.value

解决办法

and过滤条件避免相同key的拼接参数