# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1487 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1488 --- ## [Update with calculation](https://discuss.elastic.co/t/update-with-calculation/156305)
**Author:** [@boeledi01](https://discuss.elastic.co/u/boeledi01)\ **Replies:** 1\ **Last updated:** [November 12, 2018, 3:51pm UTC](https://discuss.elastic.co/t/update-with-calculation/156305 "2018-11-12T15:51:11Z")
Hi, We have just discovered a bug in our system which made a wrong calculation. Fortunately for us, all documents contain enough data to reprocess the calculation. My question How can I run an "update" so that it rec… --- ## [I need a query that can list an UniqueID that misses data](https://discuss.elastic.co/t/i-need-a-query-that-can-list-an-uniqueid-that-misses-data/155690)
**Author:** [@d\_g](https://discuss.elastic.co/u/d_g)\ **Replies:** 1\ **Last updated:** [November 12, 2018, 3:45pm UTC](https://discuss.elastic.co/t/i-need-a-query-that-can-list-an-uniqueid-that-misses-data/155690 "2018-11-12T15:45:30Z")
Im new to elasticsearch and i really need some help to get a thing done. Every user has it own unique ID, ex; 111112,111113,111114. Every user is connected to a user type, Ex; AA, AB,AC,AD And every user type has one … --- ## [Composite aggregation max bucket size](https://discuss.elastic.co/t/composite-aggregation-max-bucket-size/155663)
**Author:** [@blueren](https://discuss.elastic.co/u/blueren)\ **Replies:** 1\ **Last updated:** [November 12, 2018, 3:42pm UTC](https://discuss.elastic.co/t/composite-aggregation-max-bucket-size/155663 "2018-11-12T15:42:58Z")
I have a query that I need to run every 30s to check if there are any docs matching the params. { "version": true, "size": 0, "sort": \[ { "@timestamp": { "order": "desc", "unmapped\_type":… --- ## [Sorting memory impact on Elasticsearch](https://discuss.elastic.co/t/sorting-memory-impact-on-elasticsearch/155369)
**Author:** [@Yashasvi\_Raj\_Pant](https://discuss.elastic.co/u/Yashasvi_Raj_Pant)\ **Replies:** 1\ **Last updated:** [November 12, 2018, 3:40pm UTC](https://discuss.elastic.co/t/sorting-memory-impact-on-elasticsearch/155369 "2018-11-12T15:40:25Z")
Suppose I have to sort elasticsearch documents by a field "A"(ElasticSearch 2.4.4) as shown here: https://www.elastic.co/guide/en/elasticsearch/reference/2.4/search-request-sort.html i.) Which will consume more memory?… --- ## [Buckets\_path not resolving to correct metric](https://discuss.elastic.co/t/buckets-path-not-resolving-to-correct-metric/155204)
**Author:** [@Vikas\_Sidana](https://discuss.elastic.co/u/Vikas_Sidana)\ **Replies:** 0\ **Last updated:** [November 2, 2018, 4:26pm UTC](https://discuss.elastic.co/t/buckets-path-not-resolving-to-correct-metric/155204 "2018-11-02T16:26:10Z")
Using mutiple filter aggregation and then using buckets\_path to compare the metrics in bucket. But it's not working. Here's the JSON I wrote: GET /test/\_search?pretty { "query": { "bool": { "filter": { … --- ## ["Logrotate" for Curator](https://discuss.elastic.co/t/logrotate-for-curator/156261)
**Author:** [@aleksei.saiko](https://discuss.elastic.co/u/aleksei.saiko)\ **Replies:** 4\ **Last updated:** [November 12, 2018, 1:54pm UTC](https://discuss.elastic.co/t/logrotate-for-curator/156261 "2018-11-12T13:54:29Z")
Hi, Currently , I'm making backup using Curator. And wrote a script for deleting old Snapshots. Is there something in Curator, that can make such thing without a script? Some kind of Logrotate, to remove old Snapshots? … --- ## [Rollover index creation failed](https://discuss.elastic.co/t/rollover-index-creation-failed/155517)
**Author:** [@jacobot](https://discuss.elastic.co/u/jacobot)\ **Replies:** 8\ **Last updated:** [November 12, 2018, 1:45pm UTC](https://discuss.elastic.co/t/rollover-index-creation-failed/155517 "2018-11-12T13:45:32Z")
Hi, we normally dont want elastic to create index on insert, so we turned action.auto\_create\_index = false, But today we found out that if this option is false index rollover will not work (no rollover at midnight as co… --- ## [Difference in the buckets while using offset in date histogram](https://discuss.elastic.co/t/difference-in-the-buckets-while-using-offset-in-date-histogram/156294)
**Author:** [@mssvema](https://discuss.elastic.co/u/mssvema)\ **Replies:** 0\ **Last updated:** [November 12, 2018, 1:30pm UTC](https://discuss.elastic.co/t/difference-in-the-buckets-while-using-offset-in-date-histogram/156294 "2018-11-12T13:30:32Z")
i have a query for which response buckets created for previous dates and if we are removing offset for the query then buckets are getting created for same date range GET fpm/\_search { "size" : 0, "query" : { … --- ## [Mapping geo\_point](https://discuss.elastic.co/t/mapping-geo-point/155956)
**Author:** [@lemon](https://discuss.elastic.co/u/lemon)\ **Replies:** 10\ **Last updated:** [November 12, 2018, 1:12pm UTC](https://discuss.elastic.co/t/mapping-geo-point/155956 "2018-11-12T13:12:59Z")
Hi, i'm trying to put a custom index in order to change the type of my field \[Geolocation\] (currently is string) which contain coordinates like "42.12356,72.23523". When I put the mapping i have an error: My mapping f… --- ## [Information about index loading on startup](https://discuss.elastic.co/t/information-about-index-loading-on-startup/156290)
**Author:** [@hitesh-inbetween](https://discuss.elastic.co/u/hitesh-inbetween)\ **Replies:** 0\ **Last updated:** [November 12, 2018, 1:01pm UTC](https://discuss.elastic.co/t/information-about-index-loading-on-startup/156290 "2018-11-12T13:01:54Z")
Hi Guys, I was trying to figure out what all activities elasticsearch performs when it boots up. So lets say, I have a single node with 5 indexes. The node was shut down and then started. What all steps are performed? … --- ## [Facet to Aggregations (library 1.7 to 6.3)](https://discuss.elastic.co/t/facet-to-aggregations-library-1-7-to-6-3/156284)
**Author:** [@byeong\_seok\_park](https://discuss.elastic.co/u/byeong_seok_park)\ **Replies:** 1\ **Last updated:** [November 12, 2018, 12:27pm UTC](https://discuss.elastic.co/t/facet-to-aggregations-library-1-7-to-6-3/156284 "2018-11-12T12:27:29Z")
Hi, I'm porting my project's library version from 1.7.5 to 6.3.0. Here is the previous code: SearchRequestBuilder srBuilder = client.prepareSearch(indexArr); srBuilder.setQuery(matchAllQuery()); srBuilder.addF… --- ## [Single dashboard access to a particular user](https://discuss.elastic.co/t/single-dashboard-access-to-a-particular-user/156281)
**Author:** [@460](https://discuss.elastic.co/u/460)\ **Replies:** 1\ **Last updated:** [November 12, 2018, 12:05pm UTC](https://discuss.elastic.co/t/single-dashboard-access-to-a-particular-user/156281 "2018-11-12T12:05:13Z")
I have multiple dashboards in my elasticsearch. I need to create access to a particular dashboard. How to do that? --- ## [\[ERROR\] Cannot race. Error in track preparator (("'index' is mandatory", None))](https://discuss.elastic.co/t/error-cannot-race-error-in-track-preparator-index-is-mandatory-none/156013)
**Author:** [@emil.mirzayev](https://discuss.elastic.co/u/emil.mirzayev)\ **Replies:** 3\ **Last updated:** [November 12, 2018, 11:51am UTC](https://discuss.elastic.co/t/error-cannot-race-error-in-track-preparator-index-is-mandatory-none/156013 "2018-11-12T11:51:43Z")
Hi. When trying to create a custom race which involves 4 indices, i get the following error: \[ERROR\] Cannot race. Error in track preparator (("'index' is mandatory", None)) I will share my track.json here: { "name":… --- ## [Network.host vs http.host in the elasticsearch.yml](https://discuss.elastic.co/t/network-host-vs-http-host-in-the-elasticsearch-yml/156242)
**Author:** [@sahere37](https://discuss.elastic.co/u/sahere37)\ **Replies:** 6\ **Last updated:** [November 12, 2018, 11:20am UTC](https://discuss.elastic.co/t/network-host-vs-http-host-in-the-elasticsearch-yml/156242 "2018-11-12T11:20:48Z")
hello all, when I configured (http.host: 192.168.170.146) in the elasticsearch.yml file, and comment the network.host part, elasticsearch can be started with no problem. And, I can see all the logs that filebeat ships t… --- ## [Not able to start Elastic Search](https://discuss.elastic.co/t/not-able-to-start-elastic-search/156087)
**Author:** [@pavankrishna116](https://discuss.elastic.co/u/pavankrishna116)\ **Replies:** 6\ **Last updated:** [November 12, 2018, 11:12am UTC](https://discuss.elastic.co/t/not-able-to-start-elastic-search/156087 "2018-11-12T11:12:02Z")
Hi, Team I installed elasticsearch in my System(Desktop) it is working fine, However, when I installed the same in my PC(Laptop) it is throwing an error (The data area passed to a system call is too small). Failed to s… --- ## [How to use api get mutil parent/child inner\_hits](https://discuss.elastic.co/t/how-to-use-api-get-mutil-parent-child-inner-hits/156266)
**Author:** [@MichaelHo](https://discuss.elastic.co/u/MichaelHo)\ **Replies:** 0\ **Last updated:** [November 12, 2018, 9:52am UTC](https://discuss.elastic.co/t/how-to-use-api-get-mutil-parent-child-inner-hits/156266 "2018-11-12T09:52:18Z")
i'm using the version 6.3.2. use the client org.elasticsearch elasticsearch 6.3.2 how to use api get mutil parent/child inner\_hits? //code the api below is get dept and their users @RequestMapping("/queryD… --- ## [How to map to ES type "ip" properly?](https://discuss.elastic.co/t/how-to-map-to-es-type-ip-properly/156260)
**Author:** [@jahlives](https://discuss.elastic.co/u/jahlives)\ **Replies:** 0\ **Last updated:** [November 12, 2018, 9:26am UTC](https://discuss.elastic.co/t/how-to-map-to-es-type-ip-properly/156260 "2018-11-12T09:26:29Z")
Hello use logstash+elasticsearch+kibana all in version 6.4 on a Centos7 with latest updates I have an issue with a mapping for ip-type in elasticsearch. I read that this cannot be done via convert in logstash and has t… --- ## [Perform OCR for more than one language by fscrawler](https://discuss.elastic.co/t/perform-ocr-for-more-than-one-language-by-fscrawler/156183)
**Author:** [@mohsen](https://discuss.elastic.co/u/mohsen)\ **Replies:** 5\ **Last updated:** [November 12, 2018, 9:24am UTC](https://discuss.elastic.co/t/perform-ocr-for-more-than-one-language-by-fscrawler/156183 "2018-11-12T09:24:40Z")
hi, I intend to perform OCR operations simultaneously (at the same time) in two or more languages (more than one language) As you know, by the Config file for a Job, you can specify the type of OCR language (as below). … --- ## [How expensive is the Source Filtering?](https://discuss.elastic.co/t/how-expensive-is-the-source-filtering/156164)
**Author:** [@hym](https://discuss.elastic.co/u/hym)\ **Replies:** 4\ **Last updated:** [November 12, 2018, 8:41am UTC](https://discuss.elastic.co/t/how-expensive-is-the-source-filtering/156164 "2018-11-12T08:41:34Z")
Hi, Pretty big documents are stored in the Index but with not so much of fields indexable. let's say only 5% of fields are indexed but the rest just stored in \_source field. As mentioned the document is so big and when… --- ## [Can't update cluster watermarks](https://discuss.elastic.co/t/cant-update-cluster-watermarks/156244)
**Author:** [@McElroy](https://discuss.elastic.co/u/McElroy)\ **Replies:** 6\ **Last updated:** [November 12, 2018, 8:18am UTC](https://discuss.elastic.co/t/cant-update-cluster-watermarks/156244 "2018-11-12T08:18:17Z")
Hi, I got some exceptions in my logfiles: Caused by: java.lang.IllegalArgumentException: unable to consistently parse \[cluster.routing.allocation.disk.watermark.low=20gb\], \[cluster.routing.allocation.disk.watermark… --- ## ['PreBuiltTransportClient' doesn't exist in my 6.3.0 library](https://discuss.elastic.co/t/prebuilttransportclient-doesnt-exist-in-my-6-3-0-library/156223)
**Author:** [@byeong\_seok\_park](https://discuss.elastic.co/u/byeong_seok_park)\ **Replies:** 1\ **Last updated:** [November 12, 2018, 8:02am UTC](https://discuss.elastic.co/t/prebuilttransportclient-doesnt-exist-in-my-6-3-0-library/156223 "2018-11-12T08:02:52Z")
Hi, I'm porting my project's library version from 1.7.5 to 6.3.0. The problem is here. In previous code, import org.elasticsearch.client.transport.TransportClient; import org.elasticsearch.common.settin… --- ## [Elsaticsearch 6.3.1 provides different results on cloud and local despite using dfs\_query\_then\_fetch. Query using python's elasticsearch package](https://discuss.elastic.co/t/elsaticsearch-6-3-1-provides-different-results-on-cloud-and-local-despite-using-dfs-query-then-fetch-query-using-pythons-elasticsearch-package/156241)
**Author:** [@sagard21](https://discuss.elastic.co/u/sagard21)\ **Replies:** 0\ **Last updated:** [November 12, 2018, 7:15am UTC](https://discuss.elastic.co/t/elsaticsearch-6-3-1-provides-different-results-on-cloud-and-local-despite-using-dfs-query-then-fetch-query-using-pythons-elasticsearch-package/156241 "2018-11-12T07:15:44Z")
I am using Elasticsearch for querying data. I query a medical term and in return i get the code for disease as output. Here is my sample query: es.search(index="myindex", body={"query": {"match": {"text\_field": "search\_… --- ## [Nested aggregation query for max number of employees](https://discuss.elastic.co/t/nested-aggregation-query-for-max-number-of-employees/156236)
**Author:** [@prasad.ram1431](https://discuss.elastic.co/u/prasad.ram1431)\ **Replies:** 0\ **Last updated:** [November 12, 2018, 6:47am UTC](https://discuss.elastic.co/t/nested-aggregation-query-for-max-number-of-employees/156236 "2018-11-12T06:47:15Z")
Hi All, I have a below scenario of requirement. Need top 10 companies with maximum number of employees. Below is my Elasticsearch query without nested fields. { "size": 0, "\_source": false, "stored\_fields… --- ## [Slow querying of Elasticsearch data using Python](https://discuss.elastic.co/t/slow-querying-of-elasticsearch-data-using-python/156231)
**Author:** [@josephmanalo](https://discuss.elastic.co/u/josephmanalo)\ **Replies:** 0\ **Last updated:** [November 12, 2018, 5:55am UTC](https://discuss.elastic.co/t/slow-querying-of-elasticsearch-data-using-python/156231 "2018-11-12T05:55:26Z")
Hi. I would like to ask for advice. I'm just new to Elasticsearch. I'm using Python to GET and PROCESS data from Elasticsearch. But I'm having a hard time in retrieving data from Elasticsearch... It took me 15 hours t… --- ## [Read data from RelationalDatabase to Elasticsearch](https://discuss.elastic.co/t/read-data-from-relationaldatabase-to-elasticsearch/156145)
**Author:** [@RamyaGowda](https://discuss.elastic.co/u/RamyaGowda)\ **Replies:** 2\ **Last updated:** [November 12, 2018, 4:40am UTC](https://discuss.elastic.co/t/read-data-from-relationaldatabase-to-elasticsearch/156145 "2018-11-12T04:40:36Z")
Hi I am bit confused here in reading data from Relational database to elasticsearch,should i use Logstash with jdbc input plugin or elasticsearch jbdc driver , which one fullfill my requirement ? Please help me. --- ## [Failed to create elasticsearch](https://discuss.elastic.co/t/failed-to-create-elasticsearch/156203)
**Author:** [@davlinds](https://discuss.elastic.co/u/davlinds)\ **Replies:** 1\ **Last updated:** [November 12, 2018, 12:44am UTC](https://discuss.elastic.co/t/failed-to-create-elasticsearch/156203 "2018-11-12T00:44:05Z")
Hi, I am trying to learn about Elastic and fscrawler so I can catalogue and search my pdf’s on a win7 machine. I am going up a very steep learning curve haha I have installed elastic version 6.4.2 using the suggested in… --- ## [Error while indexing documents into ES using Fscrawler](https://discuss.elastic.co/t/error-while-indexing-documents-into-es-using-fscrawler/155999)
**Author:** [@Jasmeet](https://discuss.elastic.co/u/Jasmeet)\ **Replies:** 5\ **Last updated:** [November 11, 2018, 8:20pm UTC](https://discuss.elastic.co/t/error-while-indexing-documents-into-es-using-fscrawler/155999 "2018-11-11T20:20:03Z")
Hi, I am using Fscrawler to index a large set of documents kept in varous folders. I have created separate jobs for all the major folders and i run each job in Fscrawler. Some of the folders are quite large (\>180 Gb) and… --- ## [When running Curator action.yml, getting error](https://discuss.elastic.co/t/when-running-curator-action-yml-getting-error/156201)
**Author:** [@aleksei.saiko](https://discuss.elastic.co/u/aleksei.saiko)\ **Replies:** 2\ **Last updated:** [November 11, 2018, 4:15pm UTC](https://discuss.elastic.co/t/when-running-curator-action-yml-getting-error/156201 "2018-11-11T16:15:48Z")
Hi there! Can you please help with the following - When I'm running the following command - curator action.yml I receive the following error - Traceback (most recent call last): File "/usr/local/bin/curator", line… --- ## [The cheapest price for every search result Elasticsearch](https://discuss.elastic.co/t/the-cheapest-price-for-every-search-result-elasticsearch/155798)
**Author:** [@janderot](https://discuss.elastic.co/u/janderot)\ **Replies:** 2\ **Last updated:** [November 11, 2018, 3:58pm UTC](https://discuss.elastic.co/t/the-cheapest-price-for-every-search-result-elasticsearch/155798 "2018-11-11T15:58:40Z")
I'm making a price comparison website. Many products has multiple webshops (prices). For each result based on a match query, I want to return the cheapest price of each result. For example: the match query returns 30 re… --- ## [How to identify timefield of the index?](https://discuss.elastic.co/t/how-to-identify-timefield-of-the-index/156080)
**Author:** [@tshoeb](https://discuss.elastic.co/u/tshoeb)\ **Replies:** 1\ **Last updated:** [November 11, 2018, 2:43pm UTC](https://discuss.elastic.co/t/how-to-identify-timefield-of-the-index/156080 "2018-11-11T14:43:03Z")
Is there a query or some way to ask elasticsearch that which field is being used as timefield for the index? [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1486) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1488)