# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1283 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1284 --- ## [ES indexing cost on updates](https://discuss.elastic.co/t/es-indexing-cost-on-updates/182296)
**Author:** [@Anand\_Swaminathan](https://discuss.elastic.co/u/Anand_Swaminathan)\ **Replies:** 2\ **Last updated:** [May 28, 2019, 2:18pm UTC](https://discuss.elastic.co/t/es-indexing-cost-on-updates/182296 "2019-05-28T14:18:22Z")
Hi, I would like to understand the numbers around how costly indexing is when there are updates. Are there any numbers that can be shared, based on your experiences ? Specifically, lets say I have a blog posts index c… --- ## [Elasticsearch-certutil - can it access keystore?](https://discuss.elastic.co/t/elasticsearch-certutil-can-it-access-keystore/183093)
**Author:** [@asp](https://discuss.elastic.co/u/asp)\ **Replies:** 1\ **Last updated:** [May 28, 2019, 2:13pm UTC](https://discuss.elastic.co/t/elasticsearch-certutil-can-it-access-keystore/183093 "2019-05-28T14:13:01Z")
Hi together, I noticed the tool elasticsearch-certutil which helps to create the certificates for TLS security in the stack. I want to partly automate the step of certificate creation in docker environment. I am think… --- ## [Doc\_count type cast error while using bucket aggregations](https://discuss.elastic.co/t/doc-count-type-cast-error-while-using-bucket-aggregations/182185)
**Author:** [@TEJASWI\_CHUNDURI](https://discuss.elastic.co/u/TEJASWI_CHUNDURI)\ **Replies:** 4\ **Last updated:** [May 28, 2019, 1:57pm UTC](https://discuss.elastic.co/t/doc-count-type-cast-error-while-using-bucket-aggregations/182185 "2019-05-28T13:57:08Z")
Using kibana 6.5.4 When checking the doc\_count . it is replying with cast issue .. I need the results only doc\_count \<2 { "error": { "root\_cause": \[\], "type": "search\_phase\_execution\_exception", "reason… --- ## [\[ERROR\] Cannot race. Error in track preparator (No host specified.)](https://discuss.elastic.co/t/error-cannot-race-error-in-track-preparator-no-host-specified/182740)
**Author:** [@azuresky11](https://discuss.elastic.co/u/azuresky11)\ **Replies:** 6\ **Last updated:** [May 28, 2019, 1:54pm UTC](https://discuss.elastic.co/t/error-cannot-race-error-in-track-preparator-no-host-specified/182740 "2019-05-28T13:54:20Z")
After the following command line was executed, I faced error. Would you please tell me how to resolve it? $ esrally --pipeline=benchmark-only --target-hosts=192.168.133.130:9201 --track=geonames --challenge=append-no-… --- ## [Possible to log to my elastic stack from an Excel VBA macro?](https://discuss.elastic.co/t/possible-to-log-to-my-elastic-stack-from-an-excel-vba-macro/182517)
**Author:** [@ljh33txm](https://discuss.elastic.co/u/ljh33txm)\ **Replies:** 1\ **Last updated:** [May 28, 2019, 1:53pm UTC](https://discuss.elastic.co/t/possible-to-log-to-my-elastic-stack-from-an-excel-vba-macro/182517 "2019-05-28T13:53:49Z")
Hey all! My elastic static is hosted on an internal server and is accessible via url. Is it possible to log to it in an Excel VBA macro via webservice call? If not, is there any way to log to it in an Excel VBA macro? … --- ## [Field type for decimal values such as 20.5, 10,3 etc?](https://discuss.elastic.co/t/field-type-for-decimal-values-such-as-20-5-10-3-etc/182139)
**Author:** [@Sjaak01](https://discuss.elastic.co/u/Sjaak01)\ **Replies:** 3\ **Last updated:** [May 28, 2019, 1:41pm UTC](https://discuss.elastic.co/t/field-type-for-decimal-values-such-as-20-5-10-3-etc/182139 "2019-05-28T13:41:22Z")
Hi, What is the best field type to use numerical values such as 20.5, 10,3? For some reason I mapped them as half-float long ago but now I sometimes get values such as 20.5123. At the time this was fine as I used Kibana… --- ## [Structured hierarchy: Repeating fields causing low performance](https://discuss.elastic.co/t/structured-hierarchy-repeating-fields-causing-low-performance/182482)
**Author:** [@pokaleshrey](https://discuss.elastic.co/u/pokaleshrey)\ **Replies:** 7\ **Last updated:** [May 28, 2019, 1:18pm UTC](https://discuss.elastic.co/t/structured-hierarchy-repeating-fields-causing-low-performance/182482 "2019-05-28T13:18:22Z")
I have a mapping setting that has below types (self maintained type field). I have not used parent child relationship, rather repeated fields and the data for writing simpler queries. { "type": "city", "countryName": … --- ## [Mapper\_parsing\_exception on Date](https://discuss.elastic.co/t/mapper-parsing-exception-on-date/183068)
**Author:** [@broly21](https://discuss.elastic.co/u/broly21)\ **Replies:** 4\ **Last updated:** [May 28, 2019, 12:45pm UTC](https://discuss.elastic.co/t/mapper-parsing-exception-on-date/183068 "2019-05-28T12:45:40Z")
hello everyone, I have an error when I insert my data, because of my bad mapping. the format is 31/12/2018 for exemple Here is the error { "error": { "root\_cause": \[ { "type": "mapper\_parsing\_exception", "reason"… --- ## [Problem installing ElasticSearsh](https://discuss.elastic.co/t/problem-installing-elasticsearsh/183083)
**Author:** [@Maidovix](https://discuss.elastic.co/u/Maidovix)\ **Replies:** 3\ **Last updated:** [May 28, 2019, 12:45pm UTC](https://discuss.elastic.co/t/problem-installing-elasticsearsh/183083 "2019-05-28T12:45:17Z")
Hi All, I am trying to install the elasticsearsh and kibana on windows Server 2008 R2 withe commande promet, but i have error on Windows event " : --\> Product: Elasticsearch 7.1.0 -- Installation failed." Also i am tr… --- ## [Add Index 7.1.0 "index.mapper.dynamic was removed after version 6.0.0"](https://discuss.elastic.co/t/add-index-7-1-0-index-mapper-dynamic-was-removed-after-version-6-0-0/183067)
**Author:** [@SpinDORK](https://discuss.elastic.co/u/SpinDORK)\ **Replies:** 3\ **Last updated:** [May 28, 2019, 12:38pm UTC](https://discuss.elastic.co/t/add-index-7-1-0-index-mapper-dynamic-was-removed-after-version-6-0-0/183067 "2019-05-28T12:38:03Z")
Hi, I have recently installed ElasticSearch and Kibana 7.1.0 and I'm trying to use the Document API to submit a new Index to ElasticSearch, I'm using the same method and json file as we used for ElasticSearch v6.5.4 how… --- ## [High CPU usage due to certain stack trace](https://discuss.elastic.co/t/high-cpu-usage-due-to-certain-stack-trace/183094)
**Author:** [@shshnk28](https://discuss.elastic.co/u/shshnk28)\ **Replies:** 0\ **Last updated:** [May 28, 2019, 12:21pm UTC](https://discuss.elastic.co/t/high-cpu-usage-due-to-certain-stack-trace/183094 "2019-05-28T12:21:18Z")
Hi, We are running a cluster of 8 master eligible data nodes on ES 6.7.1. For one of our indices we have 18 shards with 0 replica's spread across 3 nodes(EC2 m5.2x large servers with 8 cores and 32). Shard size is appr… --- ## [Inconsistent results when sorting on index order](https://discuss.elastic.co/t/inconsistent-results-when-sorting-on-index-order/183014)
**Author:** [@val](https://discuss.elastic.co/u/val)\ **Replies:** 1\ **Last updated:** [May 28, 2019, 11:56am UTC](https://discuss.elastic.co/t/inconsistent-results-when-sorting-on-index-order/183014 "2019-05-28T11:56:14Z")
I have a weird situation on ES 5.6.3 when using search\_after and sorting on index order using \_doc. The following query exhibits the behavior (the query part is not important): { "from": 0, "size": 25, "query": { … --- ## [Advice on how to best store my data](https://discuss.elastic.co/t/advice-on-how-to-best-store-my-data/183084)
**Author:** [@haych1702](https://discuss.elastic.co/u/haych1702)\ **Replies:** 0\ **Last updated:** [May 28, 2019, 11:37am UTC](https://discuss.elastic.co/t/advice-on-how-to-best-store-my-data/183084 "2019-05-28T11:37:40Z")
I am having a problem with how I should best store my data in Elasticsearch. I want it to be able to store the data in the exact format that it will be returned to the user in. I also don't want to do any processing afte… --- ## [Elasticsearch is not working due to following error](https://discuss.elastic.co/t/elasticsearch-is-not-working-due-to-following-error/182997)
**Author:** [@tahseen\_fatima](https://discuss.elastic.co/u/tahseen_fatima)\ **Replies:** 4\ **Last updated:** [May 28, 2019, 11:36am UTC](https://discuss.elastic.co/t/elasticsearch-is-not-working-due-to-following-error/182997 "2019-05-28T11:36:25Z")
Hi , I have installed elasticsearch version 6.5.4 and it was working fine but recently I observed now its giving error. Below is the following error. \[2019-05-28T12:28:36,597\]\[WARN \]\[o.e.c.r.a.DiskThresholdMonitor\] \[n… --- ## [Shard re-balance is happning with only incude\_ip](https://discuss.elastic.co/t/shard-re-balance-is-happning-with-only-incude-ip/182832)
**Author:** [@pribal](https://discuss.elastic.co/u/pribal)\ **Replies:** 8\ **Last updated:** [May 28, 2019, 10:53am UTC](https://discuss.elastic.co/t/shard-re-balance-is-happning-with-only-incude-ip/182832 "2019-05-28T10:53:58Z")
We have some issue one node and we remove the node by using Exclude\_ip .Rebuild that nodes and successfully added that nodes with same ip amd hostname but when i am adding new nodes , re-balanced is not happening with… --- ## [Lowercase fields text with dots](https://discuss.elastic.co/t/lowercase-fields-text-with-dots/183061)
**Author:** [@Fabio-sama](https://discuss.elastic.co/u/Fabio-sama)\ **Replies:** 1\ **Last updated:** [May 28, 2019, 10:46am UTC](https://discuss.elastic.co/t/lowercase-fields-text-with-dots/183061 "2019-05-28T10:46:59Z")
Hi! I'm having a problem trying to interact with some fields created by the rollup job. Once the job has finished running, it creates a given index where for example the previous usernames are now saved in fields calle… --- ## [Spike in Fielddata memory usage](https://discuss.elastic.co/t/spike-in-fielddata-memory-usage/183065)
**Author:** [@prbhardwaj](https://discuss.elastic.co/u/prbhardwaj)\ **Replies:** 0\ **Last updated:** [May 28, 2019, 10:42am UTC](https://discuss.elastic.co/t/spike-in-fielddata-memory-usage/183065 "2019-05-28T10:42:28Z")
ES Version: 5.5.1 We use Elasticsearch mainly for term aggregation. In one of our index, we see a spike in field data memory usage which corresponds with a spike in CPU utilization and load average too. All the fields i… --- ## [How to deal with partial success bulk request?](https://discuss.elastic.co/t/how-to-deal-with-partial-success-bulk-request/183059)
**Author:** [@zhuxiufenghust](https://discuss.elastic.co/u/zhuxiufenghust)\ **Replies:** 0\ **Last updated:** [May 28, 2019, 10:37am UTC](https://discuss.elastic.co/t/how-to-deal-with-partial-success-bulk-request/183059 "2019-05-28T10:37:28Z")
if bulk request success with partial failure, should i retry all the bulk request or can i parse the response to get the failed items and just retry the failed items. currently i try to improve the performance by retry … --- ## [Hot to use hot / warm storage](https://discuss.elastic.co/t/hot-to-use-hot-warm-storage/183045)
**Author:** [@asp](https://discuss.elastic.co/u/asp)\ **Replies:** 1\ **Last updated:** [May 28, 2019, 10:35am UTC](https://discuss.elastic.co/t/hot-to-use-hot-warm-storage/183045 "2019-05-28T10:35:27Z")
Hi, I want to use different storage options by my indices. Recent indices should stay on fast SSDs while older indices should be moved to classical HDDs to save storage costs. The hot / warm architecture looks quite lik… --- ## [How to setup snapshot repository for multi node cluster?](https://discuss.elastic.co/t/how-to-setup-snapshot-repository-for-multi-node-cluster/183031)
**Author:** [@asp](https://discuss.elastic.co/u/asp)\ **Replies:** 1\ **Last updated:** [May 28, 2019, 10:18am UTC](https://discuss.elastic.co/t/how-to-setup-snapshot-repository-for-multi-node-cluster/183031 "2019-05-28T10:18:29Z")
Hi, I am familiar with snapshots and snapshot repositories on a single node cluster. Currently I am triggering snapshots via cron calling REST API via curl. Now I am setting up my first multi node cluster, and I need … --- ## [Does node.name need to match ip or hostname?](https://discuss.elastic.co/t/does-node-name-need-to-match-ip-or-hostname/183042)
**Author:** [@asp](https://discuss.elastic.co/u/asp)\ **Replies:** 1\ **Last updated:** [May 28, 2019, 10:15am UTC](https://discuss.elastic.co/t/does-node-name-need-to-match-ip-or-hostname/183042 "2019-05-28T10:15:58Z")
Hi, I am setting up my first multi node cluster. I only made it running, when the node.name equals to the hostname. It did not work when I said: cluster.name: multinode node.name: 0 hostname is multinode-es-0 I had … --- ## [Elasticsearch 6.6.2 - JDBC driver java code](https://discuss.elastic.co/t/elasticsearch-6-6-2-jdbc-driver-java-code/183049)
**Author:** [@ManimaranS](https://discuss.elastic.co/u/ManimaranS)\ **Replies:** 1\ **Last updated:** [May 28, 2019, 10:09am UTC](https://discuss.elastic.co/t/elasticsearch-6-6-2-jdbc-driver-java-code/183049 "2019-05-28T10:09:22Z")
Hi I'm using ELK 6.6.2 and when i try to connect via JDBC, below is the error occured. Could you please help to resolve? Have downloaded the api from the downloads of elasticsearch. java.sql.SQLInvalidAuthorizationSpec… --- ## [Temp directory - how to change it to existing directory](https://discuss.elastic.co/t/temp-directory-how-to-change-it-to-existing-directory/183053)
**Author:** [@Gosforth](https://discuss.elastic.co/u/Gosforth)\ **Replies:** 0\ **Last updated:** [May 28, 2019, 9:59am UTC](https://discuss.elastic.co/t/temp-directory-how-to-change-it-to-existing-directory/183053 "2019-05-28T09:59:26Z")
ES display error (starts well then after some time stops because of this): ERROR: Temporary file directory \[C:\\Users\\SomeUser\\AppData\\Local\\Temp\\2\\elasticsearch\] does not exist or is not accessible Some way to set te… --- ## [Next\_doc takes a long time](https://discuss.elastic.co/t/next-doc-takes-a-long-time/183041)
**Author:** [@Zyuxing](https://discuss.elastic.co/u/Zyuxing)\ **Replies:** 0\ **Last updated:** [May 28, 2019, 9:22am UTC](https://discuss.elastic.co/t/next-doc-takes-a-long-time/183041 "2019-05-28T09:22:38Z")
{ "size":0, "query": { "more\_like\_this": { "fields": \["abstractText"\], "like": \[{ "\_index": "pubmed2", "\_id": "30948449" }\], "max\_query\_terms": 40, "min\_term\_freq": 2, "min\_doc\_freq": 5, "… --- ## [Search across index](https://discuss.elastic.co/t/search-across-index/182593)
**Author:** [@kent120103](https://discuss.elastic.co/u/kent120103)\ **Replies:** 8\ **Last updated:** [May 28, 2019, 8:56am UTC](https://discuss.elastic.co/t/search-across-index/182593 "2019-05-28T08:56:15Z")
Dear Eleasticsearch team, My team is facing an interesting situation. There are two web services - "Account" and "Membership". "Account" service stores customers' names, gender, date\_of\_birth, etc. "Membership" service … --- ## [Please tell the template for creating index of the following JSON data](https://discuss.elastic.co/t/please-tell-the-template-for-creating-index-of-the-following-json-data/183026)
**Author:** [@sana1](https://discuss.elastic.co/u/sana1)\ **Replies:** 0\ **Last updated:** [May 28, 2019, 8:53am UTC](https://discuss.elastic.co/t/please-tell-the-template-for-creating-index-of-the-following-json-data/183026 "2019-05-28T08:53:58Z")
I am getting the data from a server in the following form \[\["5666", "8888", "8888"\], \["88888", "666", "777"\]\] when viewed as json they become 0: 0: 5666 1: 8888 2: 8888 1: 0: 88888 1: 666 2: 777 I need to wri… --- ## [Scaling Watcher to a Scalable Framework - versus a hack pile of code](https://discuss.elastic.co/t/scaling-watcher-to-a-scalable-framework-versus-a-hack-pile-of-code/182657)
**Author:** [@lbi2000](https://discuss.elastic.co/u/lbi2000)\ **Replies:** 1\ **Last updated:** [May 28, 2019, 8:53am UTC](https://discuss.elastic.co/t/scaling-watcher-to-a-scalable-framework-versus-a-hack-pile-of-code/182657 "2019-05-28T08:53:25Z")
Our organization is trying to create a scalable framework for how any alert built by watcher analysis logic will (a) have a configuration metdata setup for each watcher and (b) have a well-formed output index structure t… --- ## [Cloudwatch Logs to Elasticsearch using AWS Lambda](https://discuss.elastic.co/t/cloudwatch-logs-to-elasticsearch-using-aws-lambda/182956)
**Author:** [@EZprogramming](https://discuss.elastic.co/u/EZprogramming)\ **Replies:** 1\ **Last updated:** [May 28, 2019, 8:51am UTC](https://discuss.elastic.co/t/cloudwatch-logs-to-elasticsearch-using-aws-lambda/182956 "2019-05-28T08:51:27Z")
Hi everyone, I am trying to confirm my tehcnical approach on solving a problem. Background Information: Elasticsearch: 7.0.1 Logstash: 7.0.1 Kibana: 7.0.1 I need a serverless solution on how to transfer AWS Cloudw… --- ## [Parse date format with timezone CST](https://discuss.elastic.co/t/parse-date-format-with-timezone-cst/182118)
**Author:** [@phelim13](https://discuss.elastic.co/u/phelim13)\ **Replies:** 5\ **Last updated:** [May 28, 2019, 8:47am UTC](https://discuss.elastic.co/t/parse-date-format-with-timezone-cst/182118 "2019-05-28T08:47:26Z")
hello, in my case, my log insert logTime like 19-5-21 11:00:00:000 CST I parse date with format yy-M-d HH:mm:ss:SSS zzz everything is looks good but when I query this date field, I found that timezone is wrong becau… --- ## [Count of hits per error](https://discuss.elastic.co/t/count-of-hits-per-error/182486)
**Author:** [@devendra121dev](https://discuss.elastic.co/u/devendra121dev)\ **Replies:** 1\ **Last updated:** [May 28, 2019, 8:46am UTC](https://discuss.elastic.co/t/count-of-hits-per-error/182486 "2019-05-28T08:46:51Z")
Hi, I am trying to get email notification with number of hits for each error types mentioned in my below query. { "trigger": { "schedule": { "daily": { "at": \[ { "hour": \[ 7, 17 \], "minute": \[ 0, 30 \] } … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1282) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1284)