# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1004 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1005 --- ## [Sync Elasticsearch with Microsoft SQL](https://discuss.elastic.co/t/sync-elasticsearch-with-microsoft-sql/220977)
**Author:** [@skjoos](https://discuss.elastic.co/u/skjoos)\ **Replies:** 3\ **Last updated:** [February 27, 2020, 9:06am UTC](https://discuss.elastic.co/t/sync-elasticsearch-with-microsoft-sql/220977 "2020-02-27T09:06:44Z")
Hello, Does it exits any service, plugin or something like that to sync Elasticsearch with MSSQL? I've tried Logstash, but I don't think it's such a good fit since the database has alot of complicated relationship. Th… --- ## [Elasticsearch self signed certificate](https://discuss.elastic.co/t/elasticsearch-self-signed-certificate/221181)
**Author:** [@HadarPeeran](https://discuss.elastic.co/u/HadarPeeran)\ **Replies:** 0\ **Last updated:** [February 27, 2020, 9:00am UTC](https://discuss.elastic.co/t/elasticsearch-self-signed-certificate/221181 "2020-02-27T09:00:24Z")
Elasticsearch version 7.5.2 I followed instructions of blog Configuring SSL, TLS, and HTTPS to secure Elasticsearch, Kibana, Beats, and Logstash | Elastic Blog created self-signed certificate by command: elasticsearc… --- ## [Aggregate across the document from Nested Documents](https://discuss.elastic.co/t/aggregate-across-the-document-from-nested-documents/221171)
**Author:** [@Thilak](https://discuss.elastic.co/u/Thilak)\ **Replies:** 0\ **Last updated:** [February 27, 2020, 8:25am UTC](https://discuss.elastic.co/t/aggregate-across-the-document-from-nested-documents/221171 "2020-02-27T08:25:31Z")
Hello I have a document like this Example Document 1 "applicationId": "12345", "accountId": "test", "interactionInfo": \[ { "title": "body", "value": "test" }, { "title": "UserLocati… --- ## [Mapping expressions](https://discuss.elastic.co/t/mapping-expressions/221173)
**Author:** [@karnabal](https://discuss.elastic.co/u/karnabal)\ **Replies:** 0\ **Last updated:** [February 27, 2020, 8:33am UTC](https://discuss.elastic.co/t/mapping-expressions/221173 "2020-02-27T08:33:42Z")
Hello, I want to map expressions from two lists. \*black wooden console table \*black wood console table should match with: Console table Black Wood Could you bring any advice to do this? Thanks in advance! --- ## [Need help designing index & mapping (Great Type Refactoring)](https://discuss.elastic.co/t/need-help-designing-index-mapping-great-type-refactoring/221172)
**Author:** [@swarnkar](https://discuss.elastic.co/u/swarnkar)\ **Replies:** 0\ **Last updated:** [February 27, 2020, 8:26am UTC](https://discuss.elastic.co/t/need-help-designing-index-mapping-great-type-refactoring/221172 "2020-02-27T08:26:40Z")
Hello there, I have multiple data series which are inter-related, I am not sure how to logically club this and design index and mapping for below: application-name=Cloobar series-1: webtraffic with fields {co… --- ## [API to provision Elasticsearch cluster in Elastic Cloud](https://discuss.elastic.co/t/api-to-provision-elasticsearch-cluster-in-elastic-cloud/221080)
**Author:** [@alexzelenuyk](https://discuss.elastic.co/u/alexzelenuyk)\ **Replies:** 2\ **Last updated:** [February 27, 2020, 8:21am UTC](https://discuss.elastic.co/t/api-to-provision-elasticsearch-cluster-in-elastic-cloud/221080 "2020-02-27T08:21:45Z")
Hello everyone, I'd like to provision an Elasticsearch cluster in Elastic Cloud using Terraform. There is a nice community provider but it supposes to work with ECE. Is there any option how to provision a cluster in E… --- ## [Ideal number of shards for 2 node ES cluster](https://discuss.elastic.co/t/ideal-number-of-shards-for-2-node-es-cluster/221063)
**Author:** [@nityaraj06](https://discuss.elastic.co/u/nityaraj06)\ **Replies:** 3\ **Last updated:** [February 27, 2020, 8:00am UTC](https://discuss.elastic.co/t/ideal-number-of-shards-for-2-node-es-cluster/221063 "2020-02-27T08:00:33Z")
Could someone pls suggest me the number of shards and replicas for a 2 node elasticsearch cluster. Thank you! I am fully aware that the ideal setup is of 3 nodes but I would like to try with 2 nodes first before moving … --- ## [Add date timestamp to name via math expression which will contain date and time](https://discuss.elastic.co/t/add-date-timestamp-to-name-via-math-expression-which-will-contain-date-and-time/221161)
**Author:** [@Davit\_Paytyan](https://discuss.elastic.co/u/Davit_Paytyan)\ **Replies:** 0\ **Last updated:** [February 27, 2020, 7:46am UTC](https://discuss.elastic.co/t/add-date-timestamp-to-name-via-math-expression-which-will-contain-date-and-time/221161 "2020-02-27T07:46:15Z")
Hello, I have a question about elasticsearch 7.4. We want to implement backup via snapshot lifecycle management API using time frame. Here is the query PUT /\_slm/policy/dailypolicy { "schedule": "\*/5 \* \* \* \* ?", "na… --- ## [Elastic Basic license query](https://discuss.elastic.co/t/elastic-basic-license-query/220962)
**Author:** [@Sandeep\_Biswas](https://discuss.elastic.co/u/Sandeep_Biswas)\ **Replies:** 2\ **Last updated:** [February 27, 2020, 7:17am UTC](https://discuss.elastic.co/t/elastic-basic-license-query/220962 "2020-02-27T07:17:29Z")
Hello, Can anyone please help me with the Elastic Basic license usage. In my product, I want to use elastic Basic license features, without any change to source code. Can I make use of the Basic license for free? Ple… --- ## [Perform count with high-level-rest-client ans spring boot](https://discuss.elastic.co/t/perform-count-with-high-level-rest-client-ans-spring-boot/221150)
**Author:** [@RAHULRAJSONU](https://discuss.elastic.co/u/RAHULRAJSONU)\ **Replies:** 0\ **Last updated:** [February 27, 2020, 6:28am UTC](https://discuss.elastic.co/t/perform-count-with-high-level-rest-client-ans-spring-boot/221150 "2020-02-27T06:28:55Z")
I am trying to get the count of total documents with some filtration. here what I am trying- public Object count() throws IOException { SearchSourceBuilder sourceBuilder = new SearchSourceBuilder(); … --- ## [Unable to set field\_name using pre-aggregated field in machine learning](https://discuss.elastic.co/t/unable-to-set-field-name-using-pre-aggregated-field-in-machine-learning/221136)
**Author:** [@KEVISONG](https://discuss.elastic.co/u/KEVISONG)\ **Replies:** 0\ **Last updated:** [February 27, 2020, 3:31am UTC](https://discuss.elastic.co/t/unable-to-set-field-name-using-pre-aggregated-field-in-machine-learning/221136 "2020-02-27T03:31:37Z")
I configure the datafeed with aggregation and a self-defined aggregation field naming "success\_percentage". Shown below And the Datafeed preview shows correct output However, as I tried to specify this field in det… --- ## [Term query for date type field doesn't work if query is list](https://discuss.elastic.co/t/term-query-for-date-type-field-doesnt-work-if-query-is-list/218140)
**Author:** [@tnarita](https://discuss.elastic.co/u/tnarita)\ **Replies:** 2\ **Last updated:** [February 27, 2020, 3:19am UTC](https://discuss.elastic.co/t/term-query-for-date-type-field-doesnt-work-if-query-is-list/218140 "2020-02-27T03:19:06Z")
Hi, I inserted a data whose data type is "date". Then I tried to find the data by term query. If search query contains one value, it works but if search query contain a list of value, I get exception. If data type of … --- ## [Join 2 Index in elastic 7.5](https://discuss.elastic.co/t/join-2-index-in-elastic-7-5/221134)
**Author:** [@umay\_fb](https://discuss.elastic.co/u/umay_fb)\ **Replies:** 0\ **Last updated:** [February 27, 2020, 3:03am UTC](https://discuss.elastic.co/t/join-2-index-in-elastic-7-5/221134 "2020-02-27T03:03:24Z")
i want to join my data. its like VLOOKUP in Ms Excel. how can i doing this in elastic? thanks before --- ## [How to reduce doc\_count\_error\_upper\_bound to 0](https://discuss.elastic.co/t/how-to-reduce-doc-count-error-upper-bound-to-0/221130)
**Author:** [@Udayabharathi](https://discuss.elastic.co/u/Udayabharathi)\ **Replies:** 0\ **Last updated:** [February 27, 2020, 2:23am UTC](https://discuss.elastic.co/t/how-to-reduce-doc-count-error-upper-bound-to-0/221130 "2020-02-27T02:23:09Z")
I'm new to elasticsearch and I recently came across this doc\_count\_error\_upper\_bound in the results. When I tried to aggregate the data using terms based on a field with sorting based on descending count and limited the … --- ## [WARN o.e.c.s.ElasticsearchNodesSniffer - unknown role \[ml\] on node \](https://discuss.elastic.co/t/warn-o-e-c-s-elasticsearchnodessniffer-unknown-role-ml-on-node-name/221090)
**Author:** [@bobbyi](https://discuss.elastic.co/u/bobbyi)\ **Replies:** 2\ **Last updated:** [February 27, 2020, 2:25am UTC](https://discuss.elastic.co/t/warn-o-e-c-s-elasticsearchnodessniffer-unknown-role-ml-on-node-name/221090 "2020-02-27T02:25:20Z")
We have an API server using version 7.5.1 of the elasticsearch-rest-high-level-client and elasticsearch-rest-client-sniffer Java libraries, which matches the version of ES used on our cluster. It is working fine, but ou… --- ## [How to speed up msearch queries?](https://discuss.elastic.co/t/how-to-speed-up-msearch-queries/221105)
**Author:** [@hjiop\_oop](https://discuss.elastic.co/u/hjiop_oop)\ **Replies:** 5\ **Last updated:** [February 26, 2020, 10:13pm UTC](https://discuss.elastic.co/t/how-to-speed-up-msearch-queries/221105 "2020-02-26T22:13:58Z")
I'm using elasticsearch's msearch for making a large number of batch queries. Problem is this is very slow, I'm primarily using this for doing searches / counts over an index. For eg. if I have 2000 of such queries lin… --- ## [Search Overhead Per Shard](https://discuss.elastic.co/t/search-overhead-per-shard/221120)
**Author:** [@dvisz-inf](https://discuss.elastic.co/u/dvisz-inf)\ **Replies:** 0\ **Last updated:** [February 26, 2020, 10:42pm UTC](https://discuss.elastic.co/t/search-overhead-per-shard/221120 "2020-02-26T22:42:17Z")
Hi all I have a vague memory and a question I'd like to seek clarity on! ISTR reading somewhere that elasticsearch has settings to control how search across multiple shards (the usual case) is carried out: either all s… --- ## [Reason:null (unhelpful error message)](https://discuss.elastic.co/t/reason-null-unhelpful-error-message/220944)
**Author:** [@dvisz-inf](https://discuss.elastic.co/u/dvisz-inf)\ **Replies:** 1\ **Last updated:** [February 26, 2020, 10:29pm UTC](https://discuss.elastic.co/t/reason-null-unhelpful-error-message/220944 "2020-02-26T22:29:37Z")
Hi all This error isn't very helpful: Anyone have advice for where to go from here? I don't see anything in my ES logs, either. Thanks! --- ## [Daily index - lifecycle policies](https://discuss.elastic.co/t/daily-index-lifecycle-policies/221115)
**Author:** [@Federico\_Mieres](https://discuss.elastic.co/u/Federico_Mieres)\ **Replies:** 0\ **Last updated:** [February 26, 2020, 9:47pm UTC](https://discuss.elastic.co/t/daily-index-lifecycle-policies/221115 "2020-02-26T21:47:44Z")
So i am trying to set lifecycle policies to my existing indexes coming from logstash. my indexes follow a patterm myindex-yyyy-mm-dd so i have an index per day. So far, https://www.elastic.co/guide/en/elasticsearch/refe… --- ## ["apple" and the english analyzer](https://discuss.elastic.co/t/apple-and-the-english-analyzer/220753)
**Author:** [@emarthinsen](https://discuss.elastic.co/u/emarthinsen)\ **Replies:** 3\ **Last updated:** [February 26, 2020, 9:05pm UTC](https://discuss.elastic.co/t/apple-and-the-english-analyzer/220753 "2020-02-26T21:05:44Z")
I'm not sure why ES is behaving like this. Here's my request: GET /\_analyze { "analyzer": "english", "text": "apple" } And here's the response: { "tokens": \[ { "token": "appl", "start\_offset": 0, … --- ## [JSON Transformation for use in Elastic/Kibana Aggregations](https://discuss.elastic.co/t/json-transformation-for-use-in-elastic-kibana-aggregations/221097)
**Author:** [@rysisnice](https://discuss.elastic.co/u/rysisnice)\ **Replies:** 0\ **Last updated:** [February 26, 2020, 7:21pm UTC](https://discuss.elastic.co/t/json-transformation-for-use-in-elastic-kibana-aggregations/221097 "2020-02-26T19:21:39Z")
I am working to aggregate key value pairs in Kibana that currently do not have unique key names, because of this I understand that some type of document transformation needs to happen. These key value pairs are put into… --- ## [Jaro Winkler for fuzzy seach?](https://discuss.elastic.co/t/jaro-winkler-for-fuzzy-seach/221107)
**Author:** [@deslauriersp](https://discuss.elastic.co/u/deslauriersp)\ **Replies:** 0\ **Last updated:** [February 26, 2020, 8:18pm UTC](https://discuss.elastic.co/t/jaro-winkler-for-fuzzy-seach/221107 "2020-02-26T20:18:51Z")
This has been asked mulitple times, but has not been answered It is possible to configure StringDistance for suggester with JaroWrinkler... But how about fuzzy search? Thanks! --- ## [Data not found when volume mounted](https://discuss.elastic.co/t/data-not-found-when-volume-mounted/220883)
**Author:** [@saiteja](https://discuss.elastic.co/u/saiteja)\ **Replies:** 4\ **Last updated:** [February 26, 2020, 8:07pm UTC](https://discuss.elastic.co/t/data-not-found-when-volume-mounted/220883 "2020-02-26T20:07:47Z")
Hello, For elasticsearch to persist data i mounted volume to my container. below is the run command i am using. docker run -d --name elasticsearch --network=elastic -v esdata1:/usr/share/elasticsearch/data -p 9200:… --- ## [What are the best practices around increasing the replica count drastically](https://discuss.elastic.co/t/what-are-the-best-practices-around-increasing-the-replica-count-drastically/220936)
**Author:** [@UDixit](https://discuss.elastic.co/u/UDixit)\ **Replies:** 8\ **Last updated:** [February 26, 2020, 8:04pm UTC](https://discuss.elastic.co/t/what-are-the-best-practices-around-increasing-the-replica-count-drastically/220936 "2020-02-26T20:04:03Z")
I want to understand the implications of drastically increasing ReplicaCount eg:0-\>5 on Indexing requests. Since we have only 1 available copy, and the quorum has suddenly changed to 4 (n/2+1) the indexing requests are… --- ## [Some trivial command line utils](https://discuss.elastic.co/t/some-trivial-command-line-utils/221103)
**Author:** [@ppbrown](https://discuss.elastic.co/u/ppbrown)\ **Replies:** 0\ **Last updated:** [February 26, 2020, 7:54pm UTC](https://discuss.elastic.co/t/some-trivial-command-line-utils/221103 "2020-02-26T19:54:38Z")
I'm relatively new to Elastic Search. I found a kind of nice tool by way of Cerebro. But, I'm kinda shocked there doesnt seem to be any command-line oriented toolset out there. I started to put together my own tools. … --- ## [Max\_docs when using ILM and automatic rollover](https://discuss.elastic.co/t/max-docs-when-using-ilm-and-automatic-rollover/219278)
**Author:** [@orjan](https://discuss.elastic.co/u/orjan)\ **Replies:** 1\ **Last updated:** [February 26, 2020, 7:49pm UTC](https://discuss.elastic.co/t/max-docs-when-using-ilm-and-automatic-rollover/219278 "2020-02-26T19:49:54Z")
I'm exploring the automatic rollover for ILM and are looking for some sensible default when to rollover. max\_age is straight forward e.g. 1 day, 7 days e.g. 1 month. When it comes to max\_size I'll guess it depends. But l… --- ## ["could not load fields from index" in datafeed while creating a ML job](https://discuss.elastic.co/t/could-not-load-fields-from-index-in-datafeed-while-creating-a-ml-job/220693)
**Author:** [@higee](https://discuss.elastic.co/u/higee)\ **Replies:** 9\ **Last updated:** [February 26, 2020, 7:42pm UTC](https://discuss.elastic.co/t/could-not-load-fields-from-index-in-datafeed-while-creating-a-ml-job/220693 "2020-02-26T19:42:50Z")
Hi, I am trying to create a ML job with Advanced Job Creation. The thing is I get an error from datafeed tab that it "Could not load fields from index". I wonder what exactly is going wrong. For instance, if I go to Dat… --- ## [Failed to update shard information for ClusterInfoUpdateJob](https://discuss.elastic.co/t/failed-to-update-shard-information-for-clusterinfoupdatejob/221099)
**Author:** [@Sirius](https://discuss.elastic.co/u/Sirius)\ **Replies:** 0\ **Last updated:** [February 26, 2020, 7:38pm UTC](https://discuss.elastic.co/t/failed-to-update-shard-information-for-clusterinfoupdatejob/221099 "2020-02-26T19:38:11Z")
Hi Team, My ES docker cluster is constantly getting below issue : {"type": "server", "timestamp": "2020-02-26T17:54:47,908Z", "level": "WARN", "component": "o.e.c.InternalClusterInfoService", "cluster.name": "XXXXX", … --- ## [Using Painless script to perform multiple actions](https://discuss.elastic.co/t/using-painless-script-to-perform-multiple-actions/221072)
**Author:** [@mdrowl1](https://discuss.elastic.co/u/mdrowl1)\ **Replies:** 0\ **Last updated:** [February 26, 2020, 3:50pm UTC](https://discuss.elastic.co/t/using-painless-script-to-perform-multiple-actions/221072 "2020-02-26T15:50:04Z")
I am creating a visualisation in Kibana to show the average latency on traffic through the end points on a group of proxies. For the endpoints that include consumer data, I want to trim the targetUrl so I can group the t… --- ## [Monitoring error after down node from cluster](https://discuss.elastic.co/t/monitoring-error-after-down-node-from-cluster/220940)
**Author:** [@Miguel\_Plazas](https://discuss.elastic.co/u/Miguel_Plazas)\ **Replies:** 0\ **Last updated:** [February 26, 2020, 1:28am UTC](https://discuss.elastic.co/t/monitoring-error-after-down-node-from-cluster/220940 "2020-02-26T01:28:02Z")
Currently i have a cluster deployed on EC2 from AWS. There are 3 nodes. Here are the config from each node: node1 cluster.name: woombat cluster.initial\_master\_nodes: \["node1"\] node.name: node1 node.master: true networ… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1003) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1005)