# Elasticsearch

**URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1567

[Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md)

**Page:** 1568

---

## [Cluster status to RED while indexing and searching at same time](https://discuss.elastic.co/t/cluster-status-to-red-while-indexing-and-searching-at-same-time/146069)

<div class="topic-metadata">

**Author:** [@iluvcode](https://discuss.elastic.co/u/iluvcode)\
**Replies:** 9\
**Last updated:** [August 28, 2018, 5:19am UTC](https://discuss.elastic.co/t/cluster-status-to-red-while-indexing-and-searching-at-same-time/146069 "2018-08-28T05:19:45Z")

</div>

Hi, We recently deployed new Search functionality and day after moving things to Production, our ES server blacks out every other day. I was able to replicate the scenario in our QA servers now. While indexing 30k reco…

---

## [Rotate indice daily to hourly](https://discuss.elastic.co/t/rotate-indice-daily-to-hourly/146251)

<div class="topic-metadata">

**Author:** [@dis](https://discuss.elastic.co/u/dis)\
**Replies:** 4\
**Last updated:** [August 28, 2018, 5:16am UTC](https://discuss.elastic.co/t/rotate-indice-daily-to-hourly/146251 "2018-08-28T05:16:22Z")

</div>

Can someone point me to info on configure elasticsearch to roll over indice from daily to hourly? Using elasticsearch 6.2.4. The current index is created from fluentd (logstash\_format=true) with timestring '%Y.%m.%d'. …

---

## [Represent microservices as bars](https://discuss.elastic.co/t/represent-microservices-as-bars/145510)

<div class="topic-metadata">

**Author:** [@epsanyatoti](https://discuss.elastic.co/u/epsanyatoti)\
**Replies:** 3\
**Last updated:** [August 28, 2018, 4:12am UTC](https://discuss.elastic.co/t/represent-microservices-as-bars/145510 "2018-08-28T04:12:04Z")

</div>

Hello guys, i am finding it difficult in representing micro-services as bars in bar chart to show the control flow, i.e. when a service is invoked by a call show a bar to represent the same. can anyone help me. things t…

---

## [Reload\_secure\_settings](https://discuss.elastic.co/t/reload-secure-settings/146126)

<div class="topic-metadata">

**Author:** [@Imr](https://discuss.elastic.co/u/Imr)\
**Replies:** 5\
**Last updated:** [August 28, 2018, 2:03am UTC](https://discuss.elastic.co/t/reload-secure-settings/146126 "2018-08-28T02:03:39Z")

</div>

Hi, i find a question . https://www.elastic.co/guide/en/elasticsearch/reference/current/secure-settings.html#secure-settings curl -X POST "localhost:9200/\_nodes/reload\_secure\_settings" Everything can find in this pict…

---

## [Azure Marketplace cluster - upgrade to 6.4.0](https://discuss.elastic.co/t/azure-marketplace-cluster-upgrade-to-6-4-0/145929)

<div class="topic-metadata">

**Author:** [@djl2](https://discuss.elastic.co/u/djl2)\
**Replies:** 3\
**Last updated:** [August 27, 2018, 11:25pm UTC](https://discuss.elastic.co/t/azure-marketplace-cluster-upgrade-to-6-4-0/145929 "2018-08-27T23:25:12Z")

</div>

Is there an ETA on when the Azure Marketplace cluster will be update to deploy 6.4.0? It's still is configured for v6.3.1.

---

## [Slow geo query](https://discuss.elastic.co/t/slow-geo-query/146218)

<div class="topic-metadata">

**Author:** [@itamarkr](https://discuss.elastic.co/u/itamarkr)\
**Replies:** 2\
**Last updated:** [August 27, 2018, 9:32pm UTC](https://discuss.elastic.co/t/slow-geo-query/146218 "2018-08-27T21:32:01Z")

</div>

Hi, I have a cluster with geographical data and it used to be in version 5.3.2. We had all kinds of issues with GC and the Java transport client, so we updated to 5.6.10. After the update, we've seen many improvements …

---

## [Mapping geo\_point from .csv](https://discuss.elastic.co/t/mapping-geo-point-from-csv/146183)

<div class="topic-metadata">

**Author:** [@Tanatos\_Daniel](https://discuss.elastic.co/u/Tanatos_Daniel)\
**Replies:** 1\
**Last updated:** [August 27, 2018, 9:07pm UTC](https://discuss.elastic.co/t/mapping-geo-point-from-csv/146183 "2018-08-27T21:07:10Z")

</div>

I cannot understand what I'm missing. classes2.conf input { file { path =\> "D:\\Workspace.Elastic\\FinalVersions\\classes.csv" start\_position =\> "beginning" sincedb\_path =\> "/dev/null" } } filter { csv {…

---

## [Elasticsearch S3 repository](https://discuss.elastic.co/t/elasticsearch-s3-repository/146043)

<div class="topic-metadata">

**Author:** [@santhosh-git](https://discuss.elastic.co/u/santhosh-git)\
**Replies:** 4\
**Last updated:** [August 27, 2018, 8:12pm UTC](https://discuss.elastic.co/t/elasticsearch-s3-repository/146043 "2018-08-27T20:12:24Z")

</div>

Can we use the same snapshot storage path in the S3 repository for multiple elasticsearch servers?

---

## [Interpretation of wildcards for field names in query](https://discuss.elastic.co/t/interpretation-of-wildcards-for-field-names-in-query/146236)

<div class="topic-metadata">

**Author:** [@blevine](https://discuss.elastic.co/u/blevine)\
**Replies:** 0\
**Last updated:** [August 27, 2018, 7:43pm UTC](https://discuss.elastic.co/t/interpretation-of-wildcards-for-field-names-in-query/146236 "2018-08-27T19:43:54Z")

</div>

Hi all, When issuing a query with a field like\*.content, it appears that '\*' matches all levels in the field name. In other words, this matches foo.content, foo.bar.content, foo.bar.baz.content, etc. For my particula…

---

## [Multi-level nested sort in elasticsearch v5.5](https://discuss.elastic.co/t/multi-level-nested-sort-in-elasticsearch-v5-5/146235)

<div class="topic-metadata">

**Author:** [@Xiaofeng\_Zhan](https://discuss.elastic.co/u/Xiaofeng_Zhan)\
**Replies:** 0\
**Last updated:** [August 27, 2018, 7:37pm UTC](https://discuss.elastic.co/t/multi-level-nested-sort-in-elasticsearch-v5-5/146235 "2018-08-27T19:37:50Z")

</div>

Hello, I am using elasticsearch v5.5, and trying to build a sort query, sorted by 3 level nested field. In https://www.elastic.co/guide/en/elasticsearch/reference/5.5/search-request-sort.html, there is an example on so…

---

## [Fetching clusters failed](https://discuss.elastic.co/t/fetching-clusters-failed/146228)

<div class="topic-metadata">

**Author:** [@hyonkwak](https://discuss.elastic.co/u/hyonkwak)\
**Replies:** 0\
**Last updated:** [August 27, 2018, 6:43pm UTC](https://discuss.elastic.co/t/fetching-clusters-failed/146228 "2018-08-27T18:43:30Z")

</div>

I have installed ECE on a single AWS EC2 instances (m5.2xlarge). I am able to create a new cluster, but once I click away from clusters in the ECE Admin console (such as clicking on Platform link), it forgets all the clu…

---

## [Queries across two distinct indices](https://discuss.elastic.co/t/queries-across-two-distinct-indices/146196)

<div class="topic-metadata">

**Author:** [@mehdi-gital](https://discuss.elastic.co/u/mehdi-gital)\
**Replies:** 2\
**Last updated:** [August 27, 2018, 6:32pm UTC](https://discuss.elastic.co/t/queries-across-two-distinct-indices/146196 "2018-08-27T18:32:39Z")

</div>

Hello, Let's say I have two indices S (fields: ID, shoe size) and H (fields: ID, height) where there's at least one field that runs across the two sides. Is it possible to run a native elastic query across the two, su…

---

## [Ingest node and indices with different pipeline requirements](https://discuss.elastic.co/t/ingest-node-and-indices-with-different-pipeline-requirements/145263)

<div class="topic-metadata">

**Author:** [@fnareva](https://discuss.elastic.co/u/fnareva)\
**Replies:** 1\
**Last updated:** [August 27, 2018, 6:13pm UTC](https://discuss.elastic.co/t/ingest-node-and-indices-with-different-pipeline-requirements/145263 "2018-08-27T18:13:26Z")

</div>

Hey there - So in the same cluster we have indices with pipelines and without pipelines. A dedicated ingest node with the ingest capabilities disabled otherwise. We're still finetuning the performance on this and wante…

---

## [Index/Search API's supported content type](https://discuss.elastic.co/t/index-search-apis-supported-content-type/146219)

<div class="topic-metadata">

**Author:** [@jmnarloch](https://discuss.elastic.co/u/jmnarloch)\
**Replies:** 0\
**Last updated:** [August 27, 2018, 6:00pm UTC](https://discuss.elastic.co/t/index-search-apis-supported-content-type/146219 "2018-08-27T18:00:56Z")

</div>

Hi, I was hoping to clarify after reading the question: Elasticsearch and Smile encoded JSON what are the exact "Content-Type" values handled/supported by Elasticsearch Index/Search endpoints in Elasticsearch 6.x? I as…

---

## [Fail to create the Elasticsearch loader](https://discuss.elastic.co/t/fail-to-create-the-elasticsearch-loader/146197)

<div class="topic-metadata">

**Author:** [@w0lverin3](https://discuss.elastic.co/u/w0lverin3)\
**Replies:** 0\
**Last updated:** [August 27, 2018, 2:47pm UTC](https://discuss.elastic.co/t/fail-to-create-the-elasticsearch-loader/146197 "2018-08-27T14:47:23Z")

</div>

I am having a connection error to import my Kibana dashboards. The error is: Exiting: Error importing Kibana dashboards: fail to create the Elasticsearch loader: Error creating Elasticsearch client: Couldn't connect to…

---

## [date.getHourOfDay() is giving strange results in aggregation](https://discuss.elastic.co/t/date-gethourofday-is-giving-strange-results-in-aggregation/145967)

<div class="topic-metadata">

**Author:** [@rahul\_kanwar](https://discuss.elastic.co/u/rahul_kanwar)\
**Replies:** 2\
**Last updated:** [August 27, 2018, 2:33pm UTC](https://discuss.elastic.co/t/date-gethourofday-is-giving-strange-results-in-aggregation/145967 "2018-08-27T14:33:27Z")

</div>

I am indexing some events and trying to get unique hours but the terms aggregation is giving weird response . I have the following query. { "size": 0, "query": { "bool": { "must": \[ { "te…

---

## [\[SQL\] Surprising results with multiple levels of nesting](https://discuss.elastic.co/t/sql-surprising-results-with-multiple-levels-of-nesting/145862)

<div class="topic-metadata">

**Author:** [@paulcarey](https://discuss.elastic.co/u/paulcarey)\
**Replies:** 1\
**Last updated:** [August 27, 2018, 2:01pm UTC](https://discuss.elastic.co/t/sql-surprising-results-with-multiple-levels-of-nesting/145862 "2018-08-27T14:01:56Z")

</div>

Hi The following setup gives us a single document representing a country. The country has cities (nested), which has districts (nested), which has schools (nested). DELETE countries PUT countries { "mappings": { …

---

## [Is it necessary to test the search\_analyzer using the analyzer name?](https://discuss.elastic.co/t/is-it-necessary-to-test-the-search-analyzer-using-the-analyzer-name/145974)

<div class="topic-metadata">

**Author:** [@Elizabeth\_Haubert](https://discuss.elastic.co/u/Elizabeth_Haubert)\
**Replies:** 0\
**Last updated:** [August 24, 2018, 9:11pm UTC](https://discuss.elastic.co/t/is-it-necessary-to-test-the-search-analyzer-using-the-analyzer-name/145974 "2018-08-24T21:11:55Z")

</div>

Hi, I'm building some unit tests around parsing in a new index. We're using SynonymGraphFilter, with the intention that they be applied query-time only, which necessitates using an analyzer and a search\_analyzer. I'd …

---

## [Node cant rejoin to cluster (after reboot)](https://discuss.elastic.co/t/node-cant-rejoin-to-cluster-after-reboot/145517)

<div class="topic-metadata">

**Author:** [@lecko](https://discuss.elastic.co/u/lecko)\
**Replies:** 1\
**Last updated:** [August 27, 2018, 12:23pm UTC](https://discuss.elastic.co/t/node-cant-rejoin-to-cluster-after-reboot/145517 "2018-08-27T12:23:42Z")

</div>

Hello, I am using elasticsearch version 5.6.6 with 5 nodes on bare-metal servers. All was running fine for many months then I wanted to test how cluster behaves without one node. So I stoppped node sn5 and also reboote…

---

## [Index.mapping.depth](https://discuss.elastic.co/t/index-mapping-depth/145766)

<div class="topic-metadata">

**Author:** [@Max\_K](https://discuss.elastic.co/u/Max_K)\
**Replies:** 5\
**Last updated:** [August 27, 2018, 12:15pm UTC](https://discuss.elastic.co/t/index-mapping-depth/145766 "2018-08-27T12:15:42Z")

</div>

Hello. Please clarify the functional index.mapping.depth.limit. From the https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping.html#mapping-limit-settings documentation it seems that this option will …

---

## [Apply text analysis on a field](https://discuss.elastic.co/t/apply-text-analysis-on-a-field/146137)

<div class="topic-metadata">

**Author:** [@M.alsioufi](https://discuss.elastic.co/u/M.alsioufi)\
**Replies:** 5\
**Last updated:** [August 27, 2018, 11:45am UTC](https://discuss.elastic.co/t/apply-text-analysis-on-a-field/146137 "2018-08-27T11:45:38Z")

</div>

I have a field of type text let's call it my\_field . This field contains comma separated values, sometimes these values can repeat many times for example : 'sun' or 'sun,cloud' or 'sun,sun,sun,cloud' or 'sun,cloud,win…

---

## [NEST (C#) How to disable any automatic mapping and ensure only manually coded fields added to index](https://discuss.elastic.co/t/nest-c-how-to-disable-any-automatic-mapping-and-ensure-only-manually-coded-fields-added-to-index/145078)

<div class="topic-metadata">

**Author:** [@ivankarpey](https://discuss.elastic.co/u/ivankarpey)\
**Replies:** 3\
**Last updated:** [August 27, 2018, 11:44am UTC](https://discuss.elastic.co/t/nest-c-how-to-disable-any-automatic-mapping-and-ensure-only-manually-coded-fields-added-to-index/145078 "2018-08-27T11:44:45Z")

</div>

I have a mapping with fluent syntaxis where I carefully set only those fields I need. However when I add document to those index, i still see all fields from the object except thouse, who I manually add to ingore. I do…

---

## [Alternate approach for exceeding fields \>1000](https://discuss.elastic.co/t/alternate-approach-for-exceeding-fields-1000/146159)

<div class="topic-metadata">

**Author:** [@muthucse](https://discuss.elastic.co/u/muthucse)\
**Replies:** 0\
**Last updated:** [August 27, 2018, 11:01am UTC](https://discuss.elastic.co/t/alternate-approach-for-exceeding-fields-1000/146159 "2018-08-27T11:01:46Z")

</div>

We have index with more than 1000 fields with parent and child approach. Is it good to exceed more than 1000 fields. parent with 500 fields and child with 600 fields in a same index ? Is it good to increase the default …

---

## [Need help in upgrading elastic search for ALM Octane](https://discuss.elastic.co/t/need-help-in-upgrading-elastic-search-for-alm-octane/146152)

<div class="topic-metadata">

**Author:** [@KasuKiran](https://discuss.elastic.co/u/KasuKiran)\
**Replies:** 1\
**Last updated:** [August 27, 2018, 10:31am UTC](https://discuss.elastic.co/t/need-help-in-upgrading-elastic-search-for-alm-octane/146152 "2018-08-27T10:31:22Z")

</div>

Hi Team, we have elastic search v2.4 in linux box and ES v5.6.5 in windows. we want to upgrade v2.4 indexes to v5.6.5 in windows machine. Please advise on how to proceed. Regards, Kiran Kasu.

---

## [Where can I find list of alerts](https://discuss.elastic.co/t/where-can-i-find-list-of-alerts/146130)

<div class="topic-metadata">

**Author:** [@asallemi](https://discuss.elastic.co/u/asallemi)\
**Replies:** 5\
**Last updated:** [August 27, 2018, 10:26am UTC](https://discuss.elastic.co/t/where-can-i-find-list-of-alerts/146130 "2018-08-27T10:26:28Z")

</div>

Hello guys, I am trying to build a kibana application based in alerts and I've 2 questions: 1- Where can I find the list of alerts created by Watchers in elasticsearch ? 2- Is there a specific index name which store…

---

## [X-Pack on OSS](https://discuss.elastic.co/t/x-pack-on-oss/146143)

<div class="topic-metadata">

**Author:** [@slack](https://discuss.elastic.co/u/slack)\
**Replies:** 4\
**Last updated:** [August 27, 2018, 10:05am UTC](https://discuss.elastic.co/t/x-pack-on-oss/146143 "2018-08-27T10:05:43Z")

</div>

Hello, Some time ago there was news on blog about X-Pack free features (https://www.elastic.co/products/x-pack/open). According to such information I wonder if is possible to install X-Pack on -oss version ES? Best re…

---

## ["http client did not trust this server's certificate"](https://discuss.elastic.co/t/http-client-did-not-trust-this-servers-certificate/146136)

<div class="topic-metadata">

**Author:** [@wangqinghuan](https://discuss.elastic.co/u/wangqinghuan)\
**Replies:** 1\
**Last updated:** [August 27, 2018, 9:32am UTC](https://discuss.elastic.co/t/http-client-did-not-trust-this-servers-certificate/146136 "2018-08-27T09:32:23Z")

</div>

Hi I enabled ssl on http layer between http client and elasticsearch. When I login in cerebro, I get a exception "http client did not trust this server's certificate,". So how to configure cerebro supported ssl ?

---

## [Fos elastica custom database configuration](https://discuss.elastic.co/t/fos-elastica-custom-database-configuration/146128)

<div class="topic-metadata">

**Author:** [@ercancavusoglu](https://discuss.elastic.co/u/ercancavusoglu)\
**Replies:** 0\
**Last updated:** [August 27, 2018, 8:35am UTC](https://discuss.elastic.co/t/fos-elastica-custom-database-configuration/146128 "2018-08-27T08:35:41Z")

</div>

I want to use fos\_elastica (symfony bundle) in my projects. I have a three database connection. How can I use custom\_database\_connection? fos\_elastica: clients: default: host: %fos\_elastica.host…

---

## [Amount of writes to disk](https://discuss.elastic.co/t/amount-of-writes-to-disk/145866)

<div class="topic-metadata">

**Author:** [@habdank](https://discuss.elastic.co/u/habdank)\
**Replies:** 2\
**Last updated:** [August 27, 2018, 8:01am UTC](https://discuss.elastic.co/t/amount-of-writes-to-disk/145866 "2018-08-27T08:01:41Z")

</div>

Dears, I would like to scale my cluster with Elasticsearch 2.4 and therefore I am trying to see how much resources I need in the future. What I see now. I am processing like 6MB/s data at 4 machines. But I see this 6…

---

## [What will be cached by disk filesystem cache?](https://discuss.elastic.co/t/what-will-be-cached-by-disk-filesystem-cache/146119)

<div class="topic-metadata">

**Author:** [@bruce88](https://discuss.elastic.co/u/bruce88)\
**Replies:** 1\
**Last updated:** [August 27, 2018, 7:49am UTC](https://discuss.elastic.co/t/what-will-be-cached-by-disk-filesystem-cache/146119 "2018-08-27T07:49:31Z")

</div>

We know that it's better to make sure that at least half the available memory goes to the filesystem cache so that Elasticsearch can keep hot regions of the index in physical memory. And in the \_nodes/stats API, we can g…

[Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1566)

[Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1568)
