admin管理员组文章数量:1434943
I am working with Elasticsearch and need to filter documents based on the value of a field in the first element of an array. Specifically, I have an array field called Tickers, and I want to check if the name field of the first element in this array matches any value from a provided list.
Here’s an example of the document structure:
{
"Tickers": [
{
"name": "AAPL",
"description": "description 0"
},
{
"name": "GOOG",
"description": "description 1"
}
]
}
I need to filter documents where the name of the first element in the Tickers array is in a given list of ticker names (e.g., ["AAPL", "MSFT", "TSLA"]).
Here are my elasticsearch index mappings for Tickers Field:
{
"Tickers":{
"properties":{
"name":{
"type":"text",
"fields":{
"keyword":{
"type":"keyword",
"ignore_above":256
}
}
},
"description":{
"type":"text",
"fields":{
"keyword":{
"type":"keyword",
"ignore_above":256
}
}
}
}
}
}
What I've Tried
{
"query": {
"bool": {
"filter": [
{
"script": {
"script": {
"source": "doc['Tickers.name.keyword'].length > 0 && params.symbols.contains(doc['Tickers.name.keyword'].value)",
"params": {"symbols": ["TSLA"]}
}
}
}
]
}
}
}
I am working with Elasticsearch and need to filter documents based on the value of a field in the first element of an array. Specifically, I have an array field called Tickers, and I want to check if the name field of the first element in this array matches any value from a provided list.
Here’s an example of the document structure:
{
"Tickers": [
{
"name": "AAPL",
"description": "description 0"
},
{
"name": "GOOG",
"description": "description 1"
}
]
}
I need to filter documents where the name of the first element in the Tickers array is in a given list of ticker names (e.g., ["AAPL", "MSFT", "TSLA"]).
Here are my elasticsearch index mappings for Tickers Field:
{
"Tickers":{
"properties":{
"name":{
"type":"text",
"fields":{
"keyword":{
"type":"keyword",
"ignore_above":256
}
}
},
"description":{
"type":"text",
"fields":{
"keyword":{
"type":"keyword",
"ignore_above":256
}
}
}
}
}
}
What I've Tried
{
"query": {
"bool": {
"filter": [
{
"script": {
"script": {
"source": "doc['Tickers.name.keyword'].length > 0 && params.symbols.contains(doc['Tickers.name.keyword'].value)",
"params": {"symbols": ["TSLA"]}
}
}
}
]
}
}
}
- 1 What issue are facing with this ? It seems like this query must work. – Sagar Patel Commented Nov 18, 2024 at 18:15
- For elasticsearch version 8.16, it works well – Paulo Commented Nov 18, 2024 at 20:34
- Yea, it works. Not sure why it wasn't working yesterday. Tried different solutions. – GM_1 Commented Nov 19, 2024 at 5:29
1 Answer
Reset to default 0You could unscript the search query in the following way
Mapping with copy of the name field into a new field with the limit filter
PUT /first_ticker_searching
{
"settings": {
"analysis": {
"analyzer": {
"whitespace_limit_analyzer": {
"tokenizer": "whitespace",
"filter": [
"limit_filter"
]
}
},
"filter": {
"limit_filter": {
"type": "limit"
}
}
}
},
"mappings": {
"properties": {
"Tickers": {
"properties": {
"name": {
"type": "text",
"copy_to": "first_ticker",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"description": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
},
"first_ticker": {
"type": "text",
"analyzer": "whitespace_limit_analyzer"
}
}
}
}
Your and my sample documents
PUT /first_ticker_searching/_bulk
{"create":{"_id":1}}
{"Tickers":[{"name":"AAPL","description":"description 0"},{"name":"GOOG","description":"description 1"}]}
{"create":{"_id":2}}
{"Tickers":[{"name":"APLA","description":"description 0"},{"name":"AAPL","description":"description 1"}]}
Search span_first query
GET /first_ticker_searching/_search?filter_path=hits.hits
{
"query": {
"bool": {
"filter": [
{
"span_first": {
"match": {
"span_term": {
"first_ticker": "AAPL"
}
},
"end": 1
}
}
]
}
}
}
Response. The first document is in the hits, the second one isn't
{
"hits" : {
"hits" : [
{
"_index" : "first_ticker_searching",
"_type" : "_doc",
"_id" : "1",
"_score" : 0.0,
"_source" : {
"Tickers" : [
{
"name" : "AAPL",
"description" : "description 0"
},
{
"name" : "GOOG",
"description" : "description 1"
}
]
}
}
]
}
}
本文标签：
版权声明：本文标题：search - How to filter documents in Elasticsearch where the name field of the first element of an array is in a given list? - St 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1745620254a2666640.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论