我有两个查询，两个查询都是从索引文档中选择的。“applications”是“candidate”内的嵌套路径。我在字段 workexp、summary 中搜索，但文档包含字段中的值，它不会显示在下面的查询 1 中。它始终显示在查询 2 的响应中。查询 1：
{
"nested": {
"path": "applications",
"query": {
"bool": {
"must": [
{
"simple_query_string": {
"default_operator": "and",
"fields": [
"applications.workexp"
],
"query": "(Tableau) Or (Tableau) Or (Tableau workbooks)"
}
},
{
"simple_query_string": {
"default_operator": "and",
"fields": [
"applications.summary"
],
"query": "(Tableau) Or (Tableau) Or (Tableau workbooks)"
}
},
{
"match": {
"applications.forreqid": {
"query": "FH-REQ-3"
}
}
}
]
}
}
}
}
查询2
{
"nested": {
"path": "applications",
"query": {
"bool": {
"must": [
{
"match": {
"applications.forreqid": {
"query": "FH-REQ-3"
}
}
}
],
"must_not": [
{
"simple_query_string": {
"default_operator": "and",
"fields": [
"applications.workexp"
],
"query": "(Tableau) Or (Tableau) Or (Tableau workbooks)"
}
},
{
"simple_query_string": {
"default_operator": "and",
"fields": [
"applications.summary"
],
"query": "(Tableau) Or (Tableau) Or (Tableau workbooks)"
}
}
]
}
}
}
}
我期望在回复中收到的文件
{
createdby : [email protected],
applications : [
{
applnid : yy,
summary : top and Tableau Server.· Involved in dashboard test cases creation and execution, prepared the understanding and function/ process flow documents on various dashboards for the end users.· Created technical specifications document as well as functional documents in support of the user requirements.· Generate Tableau reports to analyze data from multiple data sources like Oracle, SQL Server, Excel, Flat Files, etc · Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter and calculations · Having experience in Tableau Desktop Creating Sets, Group, Sort, Parameter, Quick filters, Context Filters, Data blending, Joins and Calculations etc.Experience Details · Educational Detai,
workexp : Procurement of billing the project and Project lead · The solution involves in creating dashboards and stories that depict different levels and stages.· The very first is a managerial dashboard to give quick overview of the Categories and their overview among different geographical areas, trends and comparisons using Map Charts, Pies, Stacked Bars, Scatter Plots etc.· The second one concentrates more on slicing and dicing the inventory and sales data using Dual Axis Charts, Various line charts, Waterfall charts etc.· The last one is a blend of Calculated Fields, Table Calculations and a bit of LODs to answer different types of the requirements of the client. Role : Tableau Developer Revenue Growth in % · Used Filters to know Department wise Sales and their Cost for Particular Periods and draft various charts using Show Me in Tableau Desktop.,
education : null,
certtrainings : null,
gaps : null,
skilltags : null,
forreqid : FH-REQ-3,
uploadedbyuser : null
}
]
}
查询代码如下——
Query workExQuery = SimpleQueryStringQuery.of(q -> q.query(finalQuery)
.fields(Arrays.asList("applications.workexp")).defaultOperator(Operator.And))._toQuery();
queries.add(workExQuery);
Query summaryQuery = SimpleQueryStringQuery.of(q -> q.query(finalQuery)
.fields(Arrays.asList("applications.summary")).defaultOperator(Operator.And))._toQuery();
queries.add(summaryQuery);
查询2的构成：
Query query = Query.of(q -> q.nested(p -> p.path("applications").query(b -> b.bool(bq -> bq.mustNot(queries)))));
最终查询
esClient.search(s -> s.index("candidature").query(query), Someclass.class);
查询1的形成：
Query query = Query.of(q -> q.nested(p -> p.path("applications").query(b -> b.bool(bq -> bq.must(queries)))));
java中字段的映射
@Field(type = FieldType.Keyword, name = "applnid")
private String applnid;
@Field(type = FieldType.Text, name = "summary")
private String summary;
@Field(type = FieldType.Text, name = "skills")
private String skills;
@Field(type = FieldType.Text, name = "employers")
private String employers;
@Field(type = FieldType.Integer, name = "totalexperienceinyears")
private String totalexperienceinyears;
@Field(type = FieldType.Text, name = "workexp")
private String workexp;
@Field(type = FieldType.Text, name = "education")
private String education;
@Field(type = FieldType.Text, name = "certtrainings")
private String certtrainings;
@Field(type = FieldType.Integer, name = "gaps")
private String gaps;
@Field(type = FieldType.Text, name = "skilltags")
private String skilltags;
@Field(type = FieldType.Keyword, name = "forreqid")
private String forreqid;
@Field(type = FieldType.Keyword, name = "uploadedbyuser")
private String uploadedbyuser;
来自弹性卷曲查询的映射
{
"candidature": {
"aliases": {},
"mappings": {
"properties": {
"_class": {
"type": "keyword",
"index": false,
"doc_values": false
},
"applications": {
"type": "nested",
"include_in_parent": true,
"properties": {
"_class": {
"type": "keyword",
"index": false,
"doc_values": false
},
"applnid": {
"type": "keyword"
},
"certtrainings": {
"type": "text"
},
"education": {
"type": "text"
},
"employers": {
"type": "text"
},
"forreqid": {
"type": "keyword"
},
"gaps": {
"type": "integer"
},
"skills": {
"type": "text"
},
"skilltags": {
"type": "text"
},
"summary": {
"type": "text"
},
"totalexperienceinyears": {
"type": "integer"
},
"uploadedbyuser": {
"type": "keyword"
},
"workexp": {
"type": "text"
}
}
},
"candidateId": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"contactnumber": {
"type": "keyword"
},
"createdby": {
"type": "keyword"
},
"email": {
"type": "keyword"
},
"fororg": {
"type": "keyword"
},
"name": {
"type": "text"
}
}
},
"settings": {
"index": {
"routing": {
"allocation": {
"include": {
"_tier_preference": "data_content"
}
}
},
"refresh_interval": "1s",
"number_of_shards": "1",
"provided_name": "candidature",
"creation_date": "1694872335334",
"store": {
"type": "fs"
},
"number_of_replicas": "1",
"uuid": "9cRKu-TLRsGfwuKn2UTbWg",
"version": {
"created": "8080299"
}
}
}
}
}
在 simple_query_string 中，查询
Or被视为只是一个单词。"Tableau" AND "OR" AND "workbooks"所以你的查询基本上相当于在query_string查询中搜索。所有字段都不包含该单词Or，因此您不会返回任何内容。如果您期望
Or在查询中充当布尔运算符，则需要将其替换为|. 换句话说，你的查询应该变成(Tableau) | (Tableau) | (Tableau workbooks)有关详细信息，请参阅简单查询语法。