I have this index which contains filds "firstName", "lastName", "patronymic", "birthDate" and i need to add char_filter for field "birthDate". For example, 1939-02-21 have to be 1939.02.21. All fields are text. Is it possible to create char_filter that will affect on "birthDate" and not other fields? >Solution : In Elasticsearch, you can achieve this by… Read More How can i add char_filter for a single field
I’m trying to extract, for each event_type, in how many days the event occurred and the last occurrence. Currently I wrote the following query: { "size": 0, "query": { … }, "_source": false, "aggregations": { "events": { "terms": { "field": "event_type" }, "aggs": { "event_timestamp": { "date_histogram": { "field": "@timestamp", "calendar_interval": "day", "min_doc_count": 1, "order":… Read More Further aggregate date histogram in Elasticsearch query
I am looking to do below with a Elasticsearch query, -> filter by condition X -> get records that do not satisfy either condition A or condition B To do this I had below initially, then realized that ‘must_not’ does AND between conditions A and B. { "query": { "bool": { "filter": [ { "term":… Read More Elasticsearch 'must not' with OR operator
I can see that for non-bulk PUT operations this functionality exists, for the _id field, using "op_type" as explained in the API. So I tried this URL: https://localhost:9200/my_index/_bulk/?op_type=create and also https://localhost:9200/my_index/_bulk?op_type=create Both failed: "error": { "reason": "request [/my_index/_bulk/] contains unrecognized parameter: [op_type]", Is there any way to accomplish this? The request body is the bulk… Read More Raise error during bulk POST if an index document with identical _id already exists?
My mapping looks like: { "mappings": { "dynamic": "strict", "_meta": { "version": 9 }, "properties": { "__myVersion": { "type": "integer" }, "businessKey": { "type": "keyword" }, "businessStatus": { "type": "keyword" }, "candidateGroups": { "type": "keyword" }, "definitionCategory": { "type": "keyword" }, "definitionId": { "type": "keyword" }, "definitionKey": { "type": "keyword" }, "definitionName": { "type": "text",… Read More How do we query Elastic Search when there is a JSON object inside a nested type?
context.analyzer("email_indexing_exact") .custom() .tokenizer("uax_url_email"); SearchSession searchSession = Search.session(entityManager); String[] fieldsArray = {"displayName", "email"}; String[] filterEmailArray = filterEmail.split(","); var query = searchSession.search(User.class) .extension(ElasticsearchExtension.get()) .select(ElasticsearchSearchProjectionFactory::source) .where(f -> f.bool() .must(f.match().fields(fieldsArray).matching(word).analyzer("autocomplete_search")) .mustNot(f.match().field("email").matching(filterEmailArray[0]).analyzer("email_indexing_exact")) ) .sort(f -> f.score().desc()); As you can see I only can filter out the 0th index of the array. How to filter out all of them? >Solution :… Read More How To Filter Out List of Word from ElasticSearch Query Result?
Using elasticseach, I want to search all documents with two words. I use: { "query": { "match": { "text": "word1 word2" } } } but instead of having documents with word1 and word2, i have documents with word1 or word2. ¿how can i search docs with word1 AND word2? >Solution : You can use operator… Read More Search exact words in elastichsearch
I send this query and it works fine. It returns filtered data: { "query": { "bool": { "filter": [ { "match": { "lang": "en" } } ] } }, "size": 10, "from": 0, "sort": [] } If I want to search with searchstring then it workst fine too: { "query": { "query_string": { "query": "big… Read More Filter with querystring in elasticsearch
I trying out the new Java Client for Elastic 8.1.1. In older versions i was able to print out the generated json query by using searchRequest.source(). I cannot find out actuallay what methode/service i can use do to so with the new client. My code looks: final Query range_query = new Query.Builder().range(r -> r.field("pixel_x") .from(String.valueOf(lookupDto.getPixel_x_min())).to(String.valueOf(lookupDto.getPixel_x_max())))… Read More ElasticSearch new Java API print created quesy
GET /civile/_search { "size": 0, "query": { "match": { "distretto": "MI" } }, "aggs": { "our_buckets": { "composite": { "size": 1000, "sources": [ { "codiceoggetto": { "terms": { "field": "codiceoggetto.keyword", "order": "desc" } } } ] } } } } My Elasticsearch query match documents by distretto = "MI". With size = 0 I hide… Read More How to sort buckets by doc_count?