# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=677 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 678 --- ## [Elasticsearch 5.6 docker-compose x-pack license expired](https://discuss.elastic.co/t/elasticsearch-5-6-docker-compose-x-pack-license-expired/268068)
**Author:** [@s-light](https://discuss.elastic.co/u/s-light)\ **Replies:** 1\ **Last updated:** [March 23, 2021, 11:33pm UTC](https://discuss.elastic.co/t/elasticsearch-5-6-docker-compose-x-pack-license-expired/268068 "2021-03-23T23:33:44Z")
hello community, iam currently try to restart my elastic-search setup for my owncloud instance. sadly the newest elasticsearch version supported there is 5.6 :frowning: after my first setup all was fine. now i had so… --- ## [Indexing documents with different data types for a same field](https://discuss.elastic.co/t/indexing-documents-with-different-data-types-for-a-same-field/268086)
**Author:** [@ashit\_pupu](https://discuss.elastic.co/u/ashit_pupu)\ **Replies:** 1\ **Last updated:** [March 23, 2021, 11:31pm UTC](https://discuss.elastic.co/t/indexing-documents-with-different-data-types-for-a-same-field/268086 "2021-03-23T23:31:00Z")
I am using kafka connect elasticsearch sink to index data from kafka to elasticsearch index. The problem which I am facing is for particular event a field value is coming as text and for some event it's coming as object.… --- ## [Can't I send emails from my own server in elastic service?](https://discuss.elastic.co/t/cant-i-send-emails-from-my-own-server-in-elastic-service/268083)
**Author:** [@sireesha\_m](https://discuss.elastic.co/u/sireesha_m)\ **Replies:** 25\ **Last updated:** [March 23, 2021, 10:09pm UTC](https://discuss.elastic.co/t/cant-i-send-emails-from-my-own-server-in-elastic-service/268083 "2021-03-23T22:09:29Z")
I am not able to update the settings in Elasticsearch.yml file. Not able to include any settings in .yml file -\> Elasticsearch - 'xpack.notification.email.html.sanitization': is not allowed --- ## [Elasticsearch Optimization Automation](https://discuss.elastic.co/t/elasticsearch-optimization-automation/268123)
**Author:** [@Yashasvi\_Raj\_Pant](https://discuss.elastic.co/u/Yashasvi_Raj_Pant)\ **Replies:** 0\ **Last updated:** [March 23, 2021, 5:23pm UTC](https://discuss.elastic.co/t/elasticsearch-optimization-automation/268123 "2021-03-23T17:23:06Z")
I am planning to do a thesis in the elasticsearch parameter optimization using some machine learning algorithm or optimization technique(automate the optimization of parameters based on current data/conditions). Which ML… --- ## [Sum aggs returning scientific value](https://discuss.elastic.co/t/sum-aggs-returning-scientific-value/267861)
**Author:** [@leela\_kumili](https://discuss.elastic.co/u/leela_kumili)\ **Replies:** 6\ **Last updated:** [March 23, 2021, 8:57pm UTC](https://discuss.elastic.co/t/sum-aggs-returning-scientific-value/267861 "2021-03-23T20:57:44Z")
Sum aggs gives scientific value as result as shown below. Expected value 11111108.6789 Actual value : 1.1111108625E7 Index Mapping { "sample-tx" : { "mappings" : { "properties" : { "Id" : { … --- ## [Aggregation only on hits returned](https://discuss.elastic.co/t/aggregation-only-on-hits-returned/268131)
**Author:** [@sidnei\_de\_souza](https://discuss.elastic.co/u/sidnei_de_souza)\ **Replies:** 4\ **Last updated:** [March 23, 2021, 8:53pm UTC](https://discuss.elastic.co/t/aggregation-only-on-hits-returned/268131 "2021-03-23T20:53:00Z")
First question here, new on Elasticsearch. Is it possible to do an aggregation on the hits returned on a search? I mean, if there are 8000 docs that match my query but I limit the size to 200, is it possible to do an ag… --- ## [Unable to create account for E;astic Cloud Managed Services on Microsoft Azure](https://discuss.elastic.co/t/unable-to-create-account-for-e-astic-cloud-managed-services-on-microsoft-azure/267988)
**Author:** [@pavank](https://discuss.elastic.co/u/pavank)\ **Replies:** 1\ **Last updated:** [March 23, 2021, 3:36pm UTC](https://discuss.elastic.co/t/unable-to-create-account-for-e-astic-cloud-managed-services-on-microsoft-azure/267988 "2021-03-23T15:36:54Z")
We are trying to create an Account for Elastic Cloud Managed Services on Azure. The Create Account option redirects us to the Elastic.co site. How do we create an Elastic Cloud Managed Service instance on Azure Cloud? … --- ## [Mapping conflict](https://discuss.elastic.co/t/mapping-conflict/268088)
**Author:** [@riahc3](https://discuss.elastic.co/u/riahc3)\ **Replies:** 4\ **Last updated:** [March 23, 2021, 2:58pm UTC](https://discuss.elastic.co/t/mapping-conflict/268088 "2021-03-23T14:58:20Z")
Im having this error: And Im not sure how to fully fix this issue. Ive been able to specify it when I create the mapping for a future index but it doesnt seem to work this time around. --- ## [Index default pipeline](https://discuss.elastic.co/t/index-default-pipeline/268103)
**Author:** [@Robo](https://discuss.elastic.co/u/Robo)\ **Replies:** 2\ **Last updated:** [March 23, 2021, 2:47pm UTC](https://discuss.elastic.co/t/index-default-pipeline/268103 "2021-03-23T14:47:54Z")
I would like to create an ingest pipeline that will create a field called "free\_ratio". The pipeline has to be applied on current ".monitoring-es" index. The definition of the pipeline is following: { "free\_ratio" : … --- ## [Can a Filter be Applied with "OR" Logic?](https://discuss.elastic.co/t/can-a-filter-be-applied-with-or-logic/266959)
**Author:** [@spyderman4g63](https://discuss.elastic.co/u/spyderman4g63)\ **Replies:** 4\ **Last updated:** [March 23, 2021, 2:37pm UTC](https://discuss.elastic.co/t/can-a-filter-be-applied-with-or-logic/266959 "2021-03-23T14:37:52Z")
I'm trying to mimic the functionality of another search engine. The functionality I want is that when a user selects a filter it first limits a search, as expected. However, I want to still return all possible aggregatio… --- ## [Unexpected match when using edgeNgram filter](https://discuss.elastic.co/t/unexpected-match-when-using-edgengram-filter/268105)
**Author:** [@matt4](https://discuss.elastic.co/u/matt4)\ **Replies:** 0\ **Last updated:** [March 23, 2021, 2:15pm UTC](https://discuss.elastic.co/t/unexpected-match-when-using-edgengram-filter/268105 "2021-03-23T14:15:27Z")
I encountered some unexpected matches when I set up a field with an analyzer that contains an edgeNgram filter. This is how I set up the mappings and the settings: PUT test-index { "mappings": { "properties": { … --- ## [Data in Dashboard Kibana](https://discuss.elastic.co/t/data-in-dashboard-kibana/268066)
**Author:** [@Weathmious](https://discuss.elastic.co/u/Weathmious)\ **Replies:** 2\ **Last updated:** [March 23, 2021, 1:50pm UTC](https://discuss.elastic.co/t/data-in-dashboard-kibana/268066 "2021-03-23T13:50:55Z")
Hello, I currently have a graylog server on which I installed kibana to better visualize the data I would like to create a dashboard on which we could see the users who make the most AD connection errors As you can se… --- ## [Documents not being replicated to replica shards](https://discuss.elastic.co/t/documents-not-being-replicated-to-replica-shards/268093)
**Author:** [@zeljko-bal](https://discuss.elastic.co/u/zeljko-bal)\ **Replies:** 2\ **Last updated:** [March 23, 2021, 1:46pm UTC](https://discuss.elastic.co/t/documents-not-being-replicated-to-replica-shards/268093 "2021-03-23T13:46:23Z")
Hi, I have a problem where for the same query executed multiple times, for some indices in my cluster, I get alternating different results (two sets of results alternating between each other with each subsequent request… --- ## [Elastic: ilm-history-3-000004 index created with wrong number\_of\_replicas according to template](https://discuss.elastic.co/t/elastic-ilm-history-3-000004-index-created-with-wrong-number-of-replicas-according-to-template/268071)
**Author:** [@raulk89](https://discuss.elastic.co/u/raulk89)\ **Replies:** 12\ **Last updated:** [March 23, 2021, 1:39pm UTC](https://discuss.elastic.co/t/elastic-ilm-history-3-000004-index-created-with-wrong-number-of-replicas-according-to-template/268071 "2021-03-23T13:39:09Z")
Elastic 7.11.1 Today, two of my elastic hosts (where there is 0 replicas), somehow created this index with number\_of\_replicas=1 yellow open ilm-history-3-000004 That is why it is in yellow state. When I look index … --- ## [Elasticsearch security with a multiple Helm charts cluster](https://discuss.elastic.co/t/elasticsearch-security-with-a-multiple-helm-charts-cluster/268081)
**Author:** [@ebuildy](https://discuss.elastic.co/u/ebuildy)\ **Replies:** 1\ **Last updated:** [March 23, 2021, 1:24pm UTC](https://discuss.elastic.co/t/elasticsearch-security-with-a-multiple-helm-charts-cluster/268081 "2021-03-23T13:24:14Z")
We are running elasticsearch on kubernetes, via official elastic Helm chart. As per elastic recommandation, we run 3 Helm releases with dedicated role: master data client Usually, I deploy master release first, then d… --- ## [Performance impact of increasing position\_increment\_gap](https://discuss.elastic.co/t/performance-impact-of-increasing-position-increment-gap/268070)
**Author:** [@ssephillip](https://discuss.elastic.co/u/ssephillip)\ **Replies:** 2\ **Last updated:** [March 23, 2021, 12:45pm UTC](https://discuss.elastic.co/t/performance-impact-of-increasing-position-increment-gap/268070 "2021-03-23T12:45:08Z")
Hi everyone, for my current task it would help me to have a large position\_increment\_gap on some fields. These fields may each contain 100 values or more. My question is: How (severely) does increasing position\_increm… --- ## [Suggesters with autcomplete on match\_phrase\_prefix](https://discuss.elastic.co/t/suggesters-with-autcomplete-on-match-phrase-prefix/267978)
**Author:** [@BIRENDRA](https://discuss.elastic.co/u/BIRENDRA)\ **Replies:** 2\ **Last updated:** [March 23, 2021, 12:18pm UTC](https://discuss.elastic.co/t/suggesters-with-autcomplete-on-match-phrase-prefix/267978 "2021-03-23T12:18:27Z")
Hi Team, I want to create suggester with autocomplete feature. Currently, suggestions are coming on prefix which i need to change. For example: I have machine name as ROV Magnum 001. My current suggester is working fine… --- ## [PLEASE HELP! Problem with tribe node not discovering index](https://discuss.elastic.co/t/please-help-problem-with-tribe-node-not-discovering-index/267810)
**Author:** [@new\_user1](https://discuss.elastic.co/u/new_user1)\ **Replies:** 5\ **Last updated:** [March 23, 2021, 11:07am UTC](https://discuss.elastic.co/t/please-help-problem-with-tribe-node-not-discovering-index/267810 "2021-03-23T11:07:17Z")
I have a number of clusters running elasticsearch 5.2 and a tribe cluster for cross-cluster search which is all hosted on GCP. I also have an alias setup on the one index on one of the clusters. In the process of makin… --- ## [Merge document by condition](https://discuss.elastic.co/t/merge-document-by-condition/268046)
**Author:** [@ku\_kon](https://discuss.elastic.co/u/ku_kon)\ **Replies:** 6\ **Last updated:** [March 23, 2021, 9:36am UTC](https://discuss.elastic.co/t/merge-document-by-condition/268046 "2021-03-23T09:36:24Z")
Hi, I have document : {"match\_id": xxx, userid: yyy, "bonus": zzz} I want to result like: {"match\_id" : xxx, users: \[{"userid": user1, bonos: bonus1}, {"userid": user2, bonos: bonus2}\]} Please help me. Thank you . --- ## [How to resolve the below unassigned shards?](https://discuss.elastic.co/t/how-to-resolve-the-below-unassigned-shards/268037)
**Author:** [@Jax\_dev](https://discuss.elastic.co/u/Jax_dev)\ **Replies:** 5\ **Last updated:** [March 23, 2021, 5:22am UTC](https://discuss.elastic.co/t/how-to-resolve-the-below-unassigned-shards/268037 "2021-03-23T05:22:03Z")
How do I resolve the below unassigned shards ? What exactly happened - one of the node in the cluster was down for 2days and I bought the node back again. After above issue - I could see shards got unassigned. Again I… --- ## [Update license](https://discuss.elastic.co/t/update-license/267351)
**Author:** [@alipujaistopo](https://discuss.elastic.co/u/alipujaistopo)\ **Replies:** 16\ **Last updated:** [March 23, 2021, 5:00am UTC](https://discuss.elastic.co/t/update-license/267351 "2021-03-23T05:00:31Z")
right now i using "open-source" license, can i update to "basic" license manually? because i need a map --- ## [JVM Heap space recommendation on 7.11.2](https://discuss.elastic.co/t/jvm-heap-space-recommendation-on-7-11-2/268017)
**Author:** [@vee](https://discuss.elastic.co/u/vee)\ **Replies:** 8\ **Last updated:** [March 23, 2021, 2:27am UTC](https://discuss.elastic.co/t/jvm-heap-space-recommendation-on-7-11-2/268017 "2021-03-23T02:27:34Z")
Hi, am planning to upgrade elastic from v7.5 to v7.11.2. We currently have heapspace settings in jvm.options using the Xmx and Xms settings, and we do use the OpenJDK that comes with the product. Is the recommendation al… --- ## [ILM policy is notworking](https://discuss.elastic.co/t/ilm-policy-is-notworking/267891)
**Author:** [@Narayan\_Banik](https://discuss.elastic.co/u/Narayan_Banik)\ **Replies:** 5\ **Last updated:** [March 23, 2021, 12:07am UTC](https://discuss.elastic.co/t/ilm-policy-is-notworking/267891 "2021-03-23T00:07:34Z")
I'm using ES 7.1... here is my ILM policy: GET \_ilm/policy/el\_metric\_policy { "el\_metric\_policy" : { "version" : 1, "modified\_date" : "2021-03-20T15:53:20.941Z", "policy" : { "phases" : { "h… --- ## [Indexing three different documents as logically one](https://discuss.elastic.co/t/indexing-three-different-documents-as-logically-one/267896)
**Author:** [@Marco\_Tedone](https://discuss.elastic.co/u/Marco_Tedone)\ **Replies:** 5\ **Last updated:** [March 22, 2021, 11:55pm UTC](https://discuss.elastic.co/t/indexing-three-different-documents-as-logically-one/267896 "2021-03-22T23:55:59Z")
Hi, I’m new to ES. I want to index OAS APIs. For each of these APIs I’ve got the OAS3 contract, a markdown documentation file as well as a JSON metadata file. I’d like to submit all three or them (for each API) and have … --- ## [Artifacts.elastic.co forced HTTPS redirect](https://discuss.elastic.co/t/artifacts-elastic-co-forced-https-redirect/267491)
**Author:** [@sfinke0](https://discuss.elastic.co/u/sfinke0)\ **Replies:** 1\ **Last updated:** [March 22, 2021, 9:26pm UTC](https://discuss.elastic.co/t/artifacts-elastic-co-forced-https-redirect/267491 "2021-03-22T21:26:45Z")
Hi there, we recently noticed a forced HTTPS redirect on the artifacts.elastic.co endpoints. Since we use apt-caching (apt-cacher-ng) for more than 1000 hosts this breaks its functionality for plain HTTP proxying and ca… --- ## [Problem with JSON query understanding](https://discuss.elastic.co/t/problem-with-json-query-understanding/268020)
**Author:** [@baka109](https://discuss.elastic.co/u/baka109)\ **Replies:** 0\ **Last updated:** [March 22, 2021, 9:02pm UTC](https://discuss.elastic.co/t/problem-with-json-query-understanding/268020 "2021-03-22T21:02:33Z")
Hello there! I need a little help to understand what I'm doing wrong. I need to modify this index template trying not to rewrite all of this settings and add a value refresh\_interval curl localhost:9200/\_template/test-… --- ## [Painless SHA1 or other hash in scripted field](https://discuss.elastic.co/t/painless-sha1-or-other-hash-in-scripted-field/268018)
**Author:** [@seanziee](https://discuss.elastic.co/u/seanziee)\ **Replies:** 0\ **Last updated:** [March 22, 2021, 8:53pm UTC](https://discuss.elastic.co/t/painless-sha1-or-other-hash-in-scripted-field/268018 "2021-03-22T20:53:30Z")
I have seen a few posts recommending to use sha1() from painless but I'm unable to make it work. I have a scripted field where I take 4 fields and want to turn them into a hash: x = doc\['1'\].value +'&' + doc\['times… --- ## [Elasticsearch speed comparison issue with sql](https://discuss.elastic.co/t/elasticsearch-speed-comparison-issue-with-sql/267947)
**Author:** [@Celal\_Poyraz](https://discuss.elastic.co/u/Celal_Poyraz)\ **Replies:** 9\ **Last updated:** [March 22, 2021, 8:29pm UTC](https://discuss.elastic.co/t/elasticsearch-speed-comparison-issue-with-sql/267947 "2021-03-22T20:29:57Z")
I compare the speed of Sql with ElasticSearch. I have 1.5 million data. But sql query runs faster than elastic search. I don't understand the problem. Why is the word like query coming faster in sql? My code for Sql \< … --- ## [Is there a reason why using the index API like this does not convert data?](https://discuss.elastic.co/t/is-there-a-reason-why-using-the-index-api-like-this-does-not-convert-data/267990)
**Author:** [@riahc3](https://discuss.elastic.co/u/riahc3)\ **Replies:** 1\ **Last updated:** [March 22, 2021, 8:29pm UTC](https://discuss.elastic.co/t/is-there-a-reason-why-using-the-index-api-like-this-does-not-convert-data/267990 "2021-03-22T20:29:04Z")
Hello If I create a new index from scratch and make the mapping, it understands the data, so the data isnt the issue. But if I do something like this: POST \_reindex { "source": { "index": "myindex-2021.03.21" }, … --- ## [Highlight synonyms with multi\_match cross\_field search type](https://discuss.elastic.co/t/highlight-synonyms-with-multi-match-cross-field-search-type/268008)
**Author:** [@julioz](https://discuss.elastic.co/u/julioz)\ **Replies:** 0\ **Last updated:** [March 22, 2021, 7:16pm UTC](https://discuss.elastic.co/t/highlight-synonyms-with-multi-match-cross-field-search-type/268008 "2021-03-22T19:16:21Z")
Hi. I'm facing a problem with search highlight. When using cross\_field type of search, the content returned in highlight does not consider synonyms. Example: "settings": { "index": { "analysis": { … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=676) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=678)