# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1031 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1032 --- ## [Trouble comparing fields of 2 separate index](https://discuss.elastic.co/t/trouble-comparing-fields-of-2-separate-index/217215)
**Author:** [@Preeti](https://discuss.elastic.co/u/Preeti)\ **Replies:** 0\ **Last updated:** [January 30, 2020, 2:47pm UTC](https://discuss.elastic.co/t/trouble-comparing-fields-of-2-separate-index/217215 "2020-01-30T14:47:41Z")
Hi All, Need advise in creating a watch which will compare 2 text fields present in 2 different indexes. Condition is if any word present in field of 2nd index is found in field of 1st index, it should alert. Eg - In… --- ## [Elasticsearch and deb repository (specific version?)](https://discuss.elastic.co/t/elasticsearch-and-deb-repository-specific-version/217057)
**Author:** [@Rysiu](https://discuss.elastic.co/u/Rysiu)\ **Replies:** 1\ **Last updated:** [January 30, 2020, 2:37pm UTC](https://discuss.elastic.co/t/elasticsearch-and-deb-repository-specific-version/217057 "2020-01-30T14:37:18Z")
Hi! In the documentation we can find information: Save the repository definition to /etc/apt/sources.list.d/elastic-7.x.list : echo "deb https://artifacts.elastic.co/packages/7.x/apt stable main" | sudo tee -a /etc/… --- ## [Mapping; extract substring from URL as its own field](https://discuss.elastic.co/t/mapping-extract-substring-from-url-as-its-own-field/217128)
**Author:** [@Tobias\_Eriksson](https://discuss.elastic.co/u/Tobias_Eriksson)\ **Replies:** 1\ **Last updated:** [January 30, 2020, 2:29pm UTC](https://discuss.elastic.co/t/mapping-extract-substring-from-url-as-its-own-field/217128 "2020-01-30T14:29:09Z")
Out logging contains all URLs that comes in to our server Now in the full URL is in the "message" field e.g. "http://server/api/orders?filter=(EQ%20reference-number%20"5c631c69-e06f-411b-8a21-d1bb37958071")&include=or… --- ## [Unassigned shards - problem (does not recover / assign)](https://discuss.elastic.co/t/unassigned-shards-problem-does-not-recover-assign/217022)
**Author:** [@Rysiu](https://discuss.elastic.co/u/Rysiu)\ **Replies:** 3\ **Last updated:** [January 30, 2020, 2:26pm UTC](https://discuss.elastic.co/t/unassigned-shards-problem-does-not-recover-assign/217022 "2020-01-30T14:26:06Z")
Hi! I have a problem with the Elasticsearch cluster. After restarting one of the nodes (resizing partitions in virtualization) this node started normally. Some shards on the node work good. A few shards, however, hav… --- ## [Elasticsearch hits in logs per index](https://discuss.elastic.co/t/elasticsearch-hits-in-logs-per-index/217199)
**Author:** [@negiadventures](https://discuss.elastic.co/u/negiadventures)\ **Replies:** 1\ **Last updated:** [January 30, 2020, 2:11pm UTC](https://discuss.elastic.co/t/elasticsearch-hits-in-logs-per-index/217199 "2020-01-30T14:11:38Z")
Is there a way in which we can track the hits for each query in log file? --- ## [Increasing the search.max\_buckets makes kibana stuck](https://discuss.elastic.co/t/increasing-the-search-max-buckets-makes-kibana-stuck/217192)
**Author:** [@Voula\_Mikr](https://discuss.elastic.co/u/Voula_Mikr)\ **Replies:** 0\ **Last updated:** [January 30, 2020, 1:08pm UTC](https://discuss.elastic.co/t/increasing-the-search-max-buckets-makes-kibana-stuck/217192 "2020-01-30T13:08:35Z")
I am trying to make an histogram with 3 sub-bucket but I get "Request to Elasticsearch failed:" with error : "Trying to create too many buckets. Must be less than or equal to: \[10000\] but was \[10001\]. This limit can be… --- ## [Modify search.max\_buckets](https://discuss.elastic.co/t/modify-search-max-buckets/217175)
**Author:** [@Voula\_Mikr](https://discuss.elastic.co/u/Voula_Mikr)\ **Replies:** 2\ **Last updated:** [January 30, 2020, 1:01pm UTC](https://discuss.elastic.co/t/modify-search-max-buckets/217175 "2020-01-30T13:01:31Z")
Hi, I am trying to modify "search.max\_buckets" by: curl -X PUT "localhost:9200/\_cluster/settings?pretty" -H 'Content-Type: application/json' -d' { "defaults" : { "search.max\_buckets" : "15000" } } ' and I get t… --- ## [Accurate count of distinct values](https://discuss.elastic.co/t/accurate-count-of-distinct-values/217188)
**Author:** [@Kobi\_Atun](https://discuss.elastic.co/u/Kobi_Atun)\ **Replies:** 0\ **Last updated:** [January 30, 2020, 12:57pm UTC](https://discuss.elastic.co/t/accurate-count-of-distinct-values/217188 "2020-01-30T12:57:54Z")
Hello, I'm using elastic search in order to store information about search terms. My document structure: site search term date (year and month) data1 data2 I have an index for each month. For a given query with sit… --- ## [Handling cluster.initial\_master\_nodes on automated provisioning](https://discuss.elastic.co/t/handling-cluster-initial-master-nodes-on-automated-provisioning/217166)
**Author:** [@LED](https://discuss.elastic.co/u/LED)\ **Replies:** 2\ **Last updated:** [January 30, 2020, 12:42pm UTC](https://discuss.elastic.co/t/handling-cluster-initial-master-nodes-on-automated-provisioning/217166 "2020-01-30T12:42:08Z")
Hi, I'm trying to deploy a ES Cluster in Azure using Machine Scale Sets; to allow us to increase the number of nodes quickly.I would like these to be configured automatically using packer to create the machine image pri… --- ## [Rollup indices have the "avg" field containing the same value as the "sum" field](https://discuss.elastic.co/t/rollup-indices-have-the-avg-field-containing-the-same-value-as-the-sum-field/217177)
**Author:** [@yagodorea](https://discuss.elastic.co/u/yagodorea)\ **Replies:** 0\ **Last updated:** [January 30, 2020, 12:16pm UTC](https://discuss.elastic.co/t/rollup-indices-have-the-avg-field-containing-the-same-value-as-the-sum-field/217177 "2020-01-30T12:16:59Z")
I think this is a bug in the rollup job, I can't plot reliable data using the rolled up indice because I can't get metrics average, only the sum. I'm using ES 7.4.0 and I'm specifically trying to make visualizations on k… --- ## [Migrate cloud.elastic.co index from amazon deployment to azure deployment](https://discuss.elastic.co/t/migrate-cloud-elastic-co-index-from-amazon-deployment-to-azure-deployment/216302)
**Author:** [@vchalmel](https://discuss.elastic.co/u/vchalmel)\ **Replies:** 2\ **Last updated:** [January 30, 2020, 12:33pm UTC](https://discuss.elastic.co/t/migrate-cloud-elastic-co-index-from-amazon-deployment-to-azure-deployment/216302 "2020-01-30T12:33:46Z")
Hi ! In order to avoid connexion stability issues for an Azure hosted API using an originally AWS hosted elastic cloud deployment I am seeking to migrate the indices of said deployment to a new Azure hosted deployment i… --- ## [Which node is used for transforms?](https://discuss.elastic.co/t/which-node-is-used-for-transforms/217163)
**Author:** [@Federico\_Bevione](https://discuss.elastic.co/u/Federico_Bevione)\ **Replies:** 1\ **Last updated:** [January 30, 2020, 12:26pm UTC](https://discuss.elastic.co/t/which-node-is-used-for-transforms/217163 "2020-01-30T12:26:32Z")
Hi there, I'm new to this community. I'm wondering which kind of node (data, ingest, etc) is used to run transforms. I've defined 2 different transforms and I'm trying to understand why cpu usage on data nodes is rais… --- ## [Circuit breaker logging](https://discuss.elastic.co/t/circuit-breaker-logging/217170)
**Author:** [@mats990](https://discuss.elastic.co/u/mats990)\ **Replies:** 2\ **Last updated:** [January 30, 2020, 12:19pm UTC](https://discuss.elastic.co/t/circuit-breaker-logging/217170 "2020-01-30T12:19:41Z")
Hi, We have configured circuit breakers which from time to time get triggered. We can see logs similar to this: Example: \[request\] New used memory 320131168 \[305.3mb\] for data of \[\\] would be larger than … --- ## [How to retrieve sum from elasticSearch using java](https://discuss.elastic.co/t/how-to-retrieve-sum-from-elasticsearch-using-java/217158)
**Author:** [@Toshif](https://discuss.elastic.co/u/Toshif)\ **Replies:** 3\ **Last updated:** [January 30, 2020, 12:11pm UTC](https://discuss.elastic.co/t/how-to-retrieve-sum-from-elasticsearch-using-java/217158 "2020-01-30T12:11:35Z")
Hello, I am having 5 fileds (viz. A,B,C & D) in my index. I want to retrieve sum of field B for my query using java. Can any1 explain me to do so ? I've gone through Elastic Docs about aggregation, but did not unders… --- ## [Elasticsearch installation issues on RHEL6](https://discuss.elastic.co/t/elasticsearch-installation-issues-on-rhel6/216374)
**Author:** [@Shreya](https://discuss.elastic.co/u/Shreya)\ **Replies:** 5\ **Last updated:** [January 30, 2020, 11:56am UTC](https://discuss.elastic.co/t/elasticsearch-installation-issues-on-rhel6/216374 "2020-01-30T11:56:02Z")
I am facing the following issue while installing Elasticsearch. Kindly help. \`\[root@abc log\]# yum install -y elasticsearch Setting up Install Process Filebeat-7.x | 1.3 kB … --- ## [Language Translation API](https://discuss.elastic.co/t/language-translation-api/216886)
**Author:** [@jyotis](https://discuss.elastic.co/u/jyotis)\ **Replies:** 3\ **Last updated:** [January 30, 2020, 11:47am UTC](https://discuss.elastic.co/t/language-translation-api/216886 "2020-01-30T11:47:37Z")
Hi Team, I want to integrate Elastic search with my App. I'm wondering if there is any API(Rest API) for language translation. My use case is if i search in french "problème", would be able to get result related to prob… --- ## [Multiple search filters in has\_child query](https://discuss.elastic.co/t/multiple-search-filters-in-has-child-query/216634)
**Author:** [@johnkary](https://discuss.elastic.co/u/johnkary)\ **Replies:** 3\ **Last updated:** [January 29, 2020, 3:40pm UTC](https://discuss.elastic.co/t/multiple-search-filters-in-has-child-query/216634 "2020-01-29T15:40:06Z")
Hi all! I have an index with parent-child capability and the has\_child query below with a filter-range applied on children (child\_field\_1). My issues here are 2. I cannot put multiple filters to children (only one), M… --- ## [Map only specific fields to save space](https://discuss.elastic.co/t/map-only-specific-fields-to-save-space/217157)
**Author:** [@Tobias\_Eriksson](https://discuss.elastic.co/u/Tobias_Eriksson)\ **Replies:** 0\ **Last updated:** [January 30, 2020, 10:33am UTC](https://discuss.elastic.co/t/map-only-specific-fields-to-save-space/217157 "2020-01-30T10:33:21Z")
I would like to map only 5 or so fields in the incoming data, the rest I do not care about How would my mapping look like then ? Right now it looks like this: PUT /\_template/tobias2-all-audit { "order" : 0, "versi… --- ## [ILM policy not working for all indexes](https://discuss.elastic.co/t/ilm-policy-not-working-for-all-indexes/216792)
**Author:** [@SergeSpinoza](https://discuss.elastic.co/u/SergeSpinoza)\ **Replies:** 4\ **Last updated:** [January 30, 2020, 10:26am UTC](https://discuss.elastic.co/t/ilm-policy-not-working-for-all-indexes/216792 "2020-01-30T10:26:08Z")
Hi! At some point ILM stopped working for all indexes. For example - ILM policy for index nginx-\*: GET /\_ilm/policy/nginx\_index\_delete: { "nginx\_index\_delete": { "policy": { "phases": { "hot": { … --- ## [Elasticsearch cluster across multiple servers](https://discuss.elastic.co/t/elasticsearch-cluster-across-multiple-servers/217150)
**Author:** [@Janardhan\_Raju](https://discuss.elastic.co/u/Janardhan_Raju)\ **Replies:** 0\ **Last updated:** [January 30, 2020, 10:04am UTC](https://discuss.elastic.co/t/elasticsearch-cluster-across-multiple-servers/217150 "2020-01-30T10:04:34Z")
I am setting up elastic search( v7.5.0) cluster in 2 nodes. Below is the configuration. Node1 cluster.name: es-cluster node.name: esnode01 node.master: true node.data: true http.port: 9200 network.bind\_host: 162.X.… --- ## [How up score for one a index if I have many indexes](https://discuss.elastic.co/t/how-up-score-for-one-a-index-if-i-have-many-indexes/217145)
**Author:** [@RussLan\_Gutsalyuk](https://discuss.elastic.co/u/RussLan_Gutsalyuk)\ **Replies:** 0\ **Last updated:** [January 30, 2020, 9:48am UTC](https://discuss.elastic.co/t/how-up-score-for-one-a-index-if-i-have-many-indexes/217145 "2020-01-30T09:48:41Z")
Hello. I have many indexes ("INDEX1","INDEX2","INDEX3") \[ "index" =\> \["INDEX1","INDEX2","INDEX3"\] "body" =\> \[ "query" =\> \[ "bool" =\> \[ "must" =\> \[ … --- ## [CentOS Docker host problems](https://discuss.elastic.co/t/centos-docker-host-problems/217129)
**Author:** [@tilchl](https://discuss.elastic.co/u/tilchl)\ **Replies:** 0\ **Last updated:** [January 30, 2020, 8:39am UTC](https://discuss.elastic.co/t/centos-docker-host-problems/217129 "2020-01-30T08:39:10Z")
Hello, I would like somebody to confirm my suspicions with CentOS 8 as a Docker host. My problem is that I can not get the containers to talk to each other. Neither Kibana is connecting to Elasticsearch nor are the nod… --- ## [Drop in CPU usage](https://discuss.elastic.co/t/drop-in-cpu-usage/217119)
**Author:** [@royal\_man](https://discuss.elastic.co/u/royal_man)\ **Replies:** 0\ **Last updated:** [January 30, 2020, 7:28am UTC](https://discuss.elastic.co/t/drop-in-cpu-usage/217119 "2020-01-30T07:28:41Z")
Sorry for a naive question. At a constant QPS, CPU first increasing and then dropping 5% approximately. Can someone help me understand the issue. I suspect it is because of Garbage collector but I am not sure. I am … --- ## [Cluster recommended for crawling 150 million documents](https://discuss.elastic.co/t/cluster-recommended-for-crawling-150-million-documents/216126)
**Author:** [@Shubham\_Mittal](https://discuss.elastic.co/u/Shubham_Mittal)\ **Replies:** 5\ **Last updated:** [January 29, 2020, 1:04pm UTC](https://discuss.elastic.co/t/cluster-recommended-for-crawling-150-million-documents/216126 "2020-01-29T13:04:45Z")
Hi Team, I have to crawl 150 million documents from SQL server database using apache manifold jdbc connector to elasticsearch. Average size of document is 500KB. I was thinking of using 5 nodes elastic cluster as belo… --- ## [How to combine terms and sum aggregations](https://discuss.elastic.co/t/how-to-combine-terms-and-sum-aggregations/217109)
**Author:** [@fenster25](https://discuss.elastic.co/u/fenster25)\ **Replies:** 0\ **Last updated:** [January 30, 2020, 6:07am UTC](https://discuss.elastic.co/t/how-to-combine-terms-and-sum-aggregations/217109 "2020-01-30T06:07:03Z")
So I want to run a sum aggregation after I have ran a terms aggregation on my index. This is what a document in my index looks like { "\_index" : "pr-delta", "\_type" : "\_doc", "\_id" : "ot5Y8W8BHWq44CdbYJ3n", … --- ## [Unable to login to Kibana](https://discuss.elastic.co/t/unable-to-login-to-kibana/215410)
**Author:** [@noble](https://discuss.elastic.co/u/noble)\ **Replies:** 7\ **Last updated:** [January 30, 2020, 12:18am UTC](https://discuss.elastic.co/t/unable-to-login-to-kibana/215410 "2020-01-30T00:18:41Z")
Trying to setup ES with LDAP. Getting the follow error while logging in Kibana. {"statusCode":401,"error":"Unauthorized","message":"\[security\_exception\] unable to authenticate user \[\*\*\*\*\*\] for REST request \[/\_security/\_… --- ## [Using mongo connector to sync collections between mongo and ES 7](https://discuss.elastic.co/t/using-mongo-connector-to-sync-collections-between-mongo-and-es-7/216822)
**Author:** [@gidgid](https://discuss.elastic.co/u/gidgid)\ **Replies:** 1\ **Last updated:** [January 30, 2020, 4:51am UTC](https://discuss.elastic.co/t/using-mongo-connector-to-sync-collections-between-mongo-and-es-7/216822 "2020-01-30T04:51:05Z")
Hi, We're been using Mongo 3.4 and ES 2.4 and syncing them using Mongo Connector. We're finally upgrading our ES to 7.5. Reading online it seems that Mongo Connector doesnt work with versions that are higher than 5.x an… --- ## [Ulimit changes for prod node servers](https://discuss.elastic.co/t/ulimit-changes-for-prod-node-servers/216949)
**Author:** [@Ajay16](https://discuss.elastic.co/u/Ajay16)\ **Replies:** 4\ **Last updated:** [January 30, 2020, 4:28am UTC](https://discuss.elastic.co/t/ulimit-changes-for-prod-node-servers/216949 "2020-01-30T04:28:51Z")
Hey., Guys pls help me on this ., What are the safe., U limit Changes for max processes in Elastic search nodes for prod servers --- ## [Client sent an HTTP request to an HTTPS server](https://discuss.elastic.co/t/client-sent-an-http-request-to-an-https-server/216365)
**Author:** [@VIGNESHkumar](https://discuss.elastic.co/u/VIGNESHkumar)\ **Replies:** 4\ **Last updated:** [January 30, 2020, 4:26am UTC](https://discuss.elastic.co/t/client-sent-an-http-request-to-an-https-server/216365 "2020-01-30T04:26:59Z")
getting error when try to check elasticsearch Client sent an HTTP request to an HTTPS server --- ## [Allowing unlimited dynamic fields ( dynamic fields based on new data ) into single index . Is this efficient?](https://discuss.elastic.co/t/allowing-unlimited-dynamic-fields-dynamic-fields-based-on-new-data-into-single-index-is-this-efficient/217049)
**Author:** [@sarath\_r\_nair](https://discuss.elastic.co/u/sarath_r_nair)\ **Replies:** 2\ **Last updated:** [January 30, 2020, 4:13am UTC](https://discuss.elastic.co/t/allowing-unlimited-dynamic-fields-dynamic-fields-based-on-new-data-into-single-index-is-this-efficient/217049 "2020-01-30T04:13:41Z")
In our use case, ( ES 7.4.0 ) we will iterate over multiple data ( text, pdf, etc ). Assume we have (name, status, salary, designation, location) are necessary and mandatory fields we require from each data. Apart from… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1030) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1032)