# Elasticsearch

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

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

**Page:** 1625

---

## [Mapping reports to Elasticsearch](https://discuss.elastic.co/t/mapping-reports-to-elasticsearch/138921)

<div class="topic-metadata">

**Author:** [@joshua625](https://discuss.elastic.co/u/joshua625)\
**Replies:** 7\
**Last updated:** [July 9, 2018, 1:20pm UTC](https://discuss.elastic.co/t/mapping-reports-to-elasticsearch/138921 "2018-07-09T13:20:47Z")

</div>

Hello, I have few reports that needs to be ingested or mapped as a whole file individually into elasticsearch and creating a specific index for all the reports i.e creating a dropdown for each and every individual rep…

---

## [Rollup strategies with automatic old-raw-data deletion](https://discuss.elastic.co/t/rollup-strategies-with-automatic-old-raw-data-deletion/138377)

<div class="topic-metadata">

**Author:** [@CasMeiron](https://discuss.elastic.co/u/CasMeiron)\
**Replies:** 4\
**Last updated:** [July 9, 2018, 12:48pm UTC](https://discuss.elastic.co/t/rollup-strategies-with-automatic-old-raw-data-deletion/138377 "2018-07-09T12:48:41Z")

</div>

Hi, We're using ES for Iot. A lot of data are stored in our cluster, every 3s something is indexed and after a year, we end up with tons of data that are not that important anymore so we're trying to figure out a way to…

---

## [Is email action through SENDGRID supported?](https://discuss.elastic.co/t/is-email-action-through-sendgrid-supported/139137)

<div class="topic-metadata">

**Author:** [@SanyamJ-info](https://discuss.elastic.co/u/SanyamJ-info)\
**Replies:** 1\
**Last updated:** [July 9, 2018, 12:42pm UTC](https://discuss.elastic.co/t/is-email-action-through-sendgrid-supported/139137 "2018-07-09T12:42:03Z")

</div>

Just as we can integrate Gmail,Outlook,SES,Exchange as email actions for our ElasticSearch watcher.....Is there any way of integrating SENDGRID? Since it's not given in the official documentation(https://www.elastic.co/…

---

## [My query is slow](https://discuss.elastic.co/t/my-query-is-slow/139174)

<div class="topic-metadata">

**Author:** [@makow](https://discuss.elastic.co/u/makow)\
**Replies:** 0\
**Last updated:** [July 9, 2018, 12:41pm UTC](https://discuss.elastic.co/t/my-query-is-slow/139174 "2018-07-09T12:41:12Z")

</div>

Hello, I have a list of products, each product has list of offers (nested list). The product has a price (reference price) and each offer has a price, "offers.price" which is a price from reseller ("offers.shop"). I ne…

---

## [How to get a field value greater than 50 characters](https://discuss.elastic.co/t/how-to-get-a-field-value-greater-than-50-characters/138982)

<div class="topic-metadata">

**Author:** [@thinkdffrnt](https://discuss.elastic.co/u/thinkdffrnt)\
**Replies:** 1\
**Last updated:** [July 9, 2018, 12:38pm UTC](https://discuss.elastic.co/t/how-to-get-a-field-value-greater-than-50-characters/138982 "2018-07-09T12:38:35Z")

</div>

ES version 6.1.1 Mapping "fieldName": { "type": "keyword" }

---

## [Nested object / aggregation, Get Variation with positiv stock values](https://discuss.elastic.co/t/nested-object-aggregation-get-variation-with-positiv-stock-values/139145)

<div class="topic-metadata">

**Author:** [@Ercan\_Yigit](https://discuss.elastic.co/u/Ercan_Yigit)\
**Replies:** 3\
**Last updated:** [July 9, 2018, 12:31pm UTC](https://discuss.elastic.co/t/nested-object-aggregation-get-variation-with-positiv-stock-values/139145 "2018-07-09T12:31:41Z")

</div>

Elasticsearch version: 6.2 Good day, we are not moving forward with nested object and aggregation. In the example below, there are variations as nested. We only want values ​​with positive stock in the aggregations. …

---

## [Doc\_type or Terms?](https://discuss.elastic.co/t/doc-type-or-terms/139167)

<div class="topic-metadata">

**Author:** [@sanketshinde](https://discuss.elastic.co/u/sanketshinde)\
**Replies:** 1\
**Last updated:** [July 9, 2018, 12:26pm UTC](https://discuss.elastic.co/t/doc-type-or-terms/139167 "2018-07-09T12:26:33Z")

</div>

Hello Team, I was wondering if there are any advantages in filtering query results based on doc\_type instead of terms. I would like to index data specific to a user. The two ways in which I thought of this could be done…

---

## [Why there is no close() method for BulkRequestBuilder or BulkRequest in Elasticsearch 5.6.9?](https://discuss.elastic.co/t/why-there-is-no-close-method-for-bulkrequestbuilder-or-bulkrequest-in-elasticsearch-5-6-9/139165)

<div class="topic-metadata">

**Author:** [@kant\_kodali](https://discuss.elastic.co/u/kant_kodali)\
**Replies:** 0\
**Last updated:** [July 9, 2018, 12:15pm UTC](https://discuss.elastic.co/t/why-there-is-no-close-method-for-bulkrequestbuilder-or-bulkrequest-in-elasticsearch-5-6-9/139165 "2018-07-09T12:15:18Z")

</div>

Why there is no close() method for BulkRequestBuilder or BulkRequest in Elasticsearch 5.6.9? It looks to me the number of file descriptors monotonically increases over time as I insert more and records from Kafka to ES…

---

## [Using a bucket script aggregation inside filter aggreagtion](https://discuss.elastic.co/t/using-a-bucket-script-aggregation-inside-filter-aggreagtion/139139)

<div class="topic-metadata">

**Author:** [@gevmart](https://discuss.elastic.co/u/gevmart)\
**Replies:** 3\
**Last updated:** [July 9, 2018, 11:36am UTC](https://discuss.elastic.co/t/using-a-bucket-script-aggregation-inside-filter-aggreagtion/139139 "2018-07-09T11:36:51Z")

</div>

Hi, I am trying to use bucket\_script aggregations inside a filter aggregation. My query looks like this (I used count for simplicity in this example, but actual bucket script that I need is more complicated, so I do ne…

---

## [Ec2-discovery issues with Kibana host](https://discuss.elastic.co/t/ec2-discovery-issues-with-kibana-host/139143)

<div class="topic-metadata">

**Author:** [@tomerl](https://discuss.elastic.co/u/tomerl)\
**Replies:** 0\
**Last updated:** [July 9, 2018, 10:49am UTC](https://discuss.elastic.co/t/ec2-discovery-issues-with-kibana-host/139143 "2018-07-09T10:49:42Z")

</div>

Hi, I've created a cluster of 3 ES 6.3 nodes on AWS: 2 nodes acts as master and data and 1 node serves as the coordinated server with Kibana installed. My elasticsearch.yml is configured with the ec2-discovery: networ…

---

## [What is the correct and better way to get scripted fields in elastic query](https://discuss.elastic.co/t/what-is-the-correct-and-better-way-to-get-scripted-fields-in-elastic-query/138731)

<div class="topic-metadata">

**Author:** [@Shoaib\_Mohommed](https://discuss.elastic.co/u/Shoaib_Mohommed)\
**Replies:** 0\
**Last updated:** [July 5, 2018, 1:42pm UTC](https://discuss.elastic.co/t/what-is-the-correct-and-better-way-to-get-scripted-fields-in-elastic-query/138731 "2018-07-05T13:42:55Z")

</div>

Hi, I am using below script for getting scripted fields and also in aggregation. and it works fine, but I was wondering if there is some other better way of doing this. "script\_fields": { "CustomColumn1": { "script":…

---

## [Custom plugin installation error](https://discuss.elastic.co/t/custom-plugin-installation-error/139097)

<div class="topic-metadata">

**Author:** [@Divyansh](https://discuss.elastic.co/u/Divyansh)\
**Replies:** 2\
**Last updated:** [July 9, 2018, 7:22am UTC](https://discuss.elastic.co/t/custom-plugin-installation-error/139097 "2018-07-09T07:22:50Z")

</div>

The command is - sudo bin/elasticsearch-plugin install file:///home/divyansh/Documents/AwesomePlugin/target/release/elasticsearch-AwesomePlugin-6.3.1.zip run in /usr/share/elasticsearch Error- Downloading file:///home/…

---

## [Uninstall elasticsearch completely on windows 7](https://discuss.elastic.co/t/uninstall-elasticsearch-completely-on-windows-7/138687)

<div class="topic-metadata">

**Author:** [@vivekranjan](https://discuss.elastic.co/u/vivekranjan)\
**Replies:** 6\
**Last updated:** [July 9, 2018, 9:59am UTC](https://discuss.elastic.co/t/uninstall-elasticsearch-completely-on-windows-7/138687 "2018-07-09T09:59:44Z")

</div>

Hi, I have installed elasticsearch on my system and when I hit http://localhost:9200 on the browser I can see the output but when I try to run /bin/elasticsearch.bat from command prompt it gives me some error which I am …

---

## [elasticsearch.exceptions.TransportError: \<unprintable TransportError object\>](https://discuss.elastic.co/t/elasticsearch-exceptions-transporterror-unprintable-transporterror-object/139109)

<div class="topic-metadata">

**Author:** [@Vishnu\_P\_S](https://discuss.elastic.co/u/Vishnu_P_S)\
**Replies:** 4\
**Last updated:** [July 9, 2018, 9:33am UTC](https://discuss.elastic.co/t/elasticsearch-exceptions-transporterror-unprintable-transporterror-object/139109 "2018-07-09T09:33:08Z")

</div>

I have developed a flask Api to read records from elasticsearch. This was working correctly earlier, but now its throwing an error elasticsearch.exceptions.TransportError: Please help me to solve this issue. Thanks in …

---

## [Assign primary shards to specifc set of nodes](https://discuss.elastic.co/t/assign-primary-shards-to-specifc-set-of-nodes/139120)

<div class="topic-metadata">

**Author:** [@Figedi](https://discuss.elastic.co/u/Figedi)\
**Replies:** 1\
**Last updated:** [July 9, 2018, 9:26am UTC](https://discuss.elastic.co/t/assign-primary-shards-to-specifc-set-of-nodes/139120 "2018-07-09T09:26:07Z")

</div>

Hey there, I have an ES 6.2 cluster consisting of preemptible and non-preemptible-nodes on gcloud (preemptible nodes can re-start at any point in time). The idea here is to have a (smaller) set of nodes which do not res…

---

## [Es JOIN DATA TYPE AGGRETION](https://discuss.elastic.co/t/es-join-data-type-aggretion/139108)

<div class="topic-metadata">

**Author:** [@firattaskin93](https://discuss.elastic.co/u/firattaskin93)\
**Replies:** 0\
**Last updated:** [July 9, 2018, 8:27am UTC](https://discuss.elastic.co/t/es-join-data-type-aggretion/139108 "2018-07-09T08:27:09Z")

</div>

Hi heros, I used join data type and its my query. { "size": 0, "query": { "has\_child": { "type": "variation", "query": { "bool": { "must\_not": \[ { "match":…

---

## [Bootstrap check failed issue in Elasticsearch](https://discuss.elastic.co/t/bootstrap-check-failed-issue-in-elasticsearch/139102)

<div class="topic-metadata">

**Author:** [@nandan\_bigdata](https://discuss.elastic.co/u/nandan_bigdata)\
**Replies:** 0\
**Last updated:** [July 9, 2018, 8:00am UTC](https://discuss.elastic.co/t/bootstrap-check-failed-issue-in-elasticsearch/139102 "2018-07-09T08:00:19Z")

</div>

Hi Team, I am running ES 6.3 in Centos 6.9 I changed elasticsearch.yml file and added 1 node IP address. Now after starting, I am Bootstrap check failed issue. I added JAVA\_OPTS into JVM.option file also but getting …

---

## [Elastic search 6.3.0 SQL query API](https://discuss.elastic.co/t/elastic-search-6-3-0-sql-query-api/138348)

<div class="topic-metadata">

**Author:** [@raghav1107](https://discuss.elastic.co/u/raghav1107)\
**Replies:** 6\
**Last updated:** [July 9, 2018, 7:32am UTC](https://discuss.elastic.co/t/elastic-search-6-3-0-sql-query-api/138348 "2018-07-09T07:32:56Z")

</div>

Hi, It was great to hear that SQL query like API has been introduced into elastic search 6.3.0. I installed elastic search 6.3.0 to try this feature and was able to get the data from elastic search through SQL query API…

---

## [Not able to execute actions on aggregation results](https://discuss.elastic.co/t/not-able-to-execute-actions-on-aggregation-results/138890)

<div class="topic-metadata">

**Author:** [@SanyamJ-info](https://discuss.elastic.co/u/SanyamJ-info)\
**Replies:** 1\
**Last updated:** [July 9, 2018, 6:58am UTC](https://discuss.elastic.co/t/not-able-to-execute-actions-on-aggregation-results/138890 "2018-07-09T06:58:14Z")

</div>

Hi elastic community, I've been trying to implement a watcher over http requests and then subsequently triggering an action(mailing here) to send me the reports. the code i'm trying to execute is : curl -X PUT 'http:/…

---

## [What is the maximum query length in the request body for the rest API of elasticsearch](https://discuss.elastic.co/t/what-is-the-maximum-query-length-in-the-request-body-for-the-rest-api-of-elasticsearch/139083)

<div class="topic-metadata">

**Author:** [@Jingyan](https://discuss.elastic.co/u/Jingyan)\
**Replies:** 1\
**Last updated:** [July 9, 2018, 6:46am UTC](https://discuss.elastic.co/t/what-is-the-maximum-query-length-in-the-request-body-for-the-rest-api-of-elasticsearch/139083 "2018-07-09T06:46:01Z")

</div>

I want to use query DSL to query data against elasticsearch, the request like following: GET /index\_test/\_search {"size":5000,"timeout":"500ms","query":{"range":{"@timestamp":{"from":1530768660540,"to":1530769620540,"i…

---

## [Can ES be used for this kind of use case?](https://discuss.elastic.co/t/can-es-be-used-for-this-kind-of-use-case/138350)

<div class="topic-metadata">

**Author:** [@anand\_dubey](https://discuss.elastic.co/u/anand_dubey)\
**Replies:** 0\
**Last updated:** [July 3, 2018, 10:03am UTC](https://discuss.elastic.co/t/can-es-be-used-for-this-kind-of-use-case/138350 "2018-07-03T10:03:37Z")

</div>

We are planning to store real time event based data from various systems in ES, such that a set of events has dependency on each other. Please find example below: set of events 1st event {"id":"1", "f1":"123", "f2":"abc…

---

## [Unable to send data using FSCrawler to ElasticSearch](https://discuss.elastic.co/t/unable-to-send-data-using-fscrawler-to-elasticsearch/136738)

<div class="topic-metadata">

**Author:** [@sachinkarora](https://discuss.elastic.co/u/sachinkarora)\
**Replies:** 14\
**Last updated:** [July 9, 2018, 4:06am UTC](https://discuss.elastic.co/t/unable-to-send-data-using-fscrawler-to-elasticsearch/136738 "2018-07-09T04:06:35Z")

</div>

Hi, I am newbie to Elasticsearch, so please bear with me. I am trying to index documents (DOC/PDFs/PPT etc.) using FSCrawler. When i tried on a machine which FSCrawler hosted and ElasticSearch running on the same machi…

---

## [Unable to read from standard input; is standard input open and a tty attached?](https://discuss.elastic.co/t/unable-to-read-from-standard-input-is-standard-input-open-and-a-tty-attached/138449)

<div class="topic-metadata">

**Author:** [@alexus](https://discuss.elastic.co/u/alexus)\
**Replies:** 8\
**Last updated:** [July 9, 2018, 3:41am UTC](https://discuss.elastic.co/t/unable-to-read-from-standard-input-is-standard-input-open-and-a-tty-attached/138449 "2018-07-09T03:41:18Z")

</div>

while trying to follow Install Elasticsearch with Docker | Elasticsearch Reference and stumble upon following issue using elasticsearch-plugin (A tool for managing installed elasticsearch plugins). docker run - manually…

---

## [Reindex part of Elasticsearch index onto new index](https://discuss.elastic.co/t/reindex-part-of-elasticsearch-index-onto-new-index/139076)

<div class="topic-metadata">

**Author:** [@bps](https://discuss.elastic.co/u/bps)\
**Replies:** 0\
**Last updated:** [July 9, 2018, 3:19am UTC](https://discuss.elastic.co/t/reindex-part-of-elasticsearch-index-onto-new-index/139076 "2018-07-09T03:19:59Z")

</div>

I have a test ElasticSearch 6.0 index populated with millions of records, likely to be in the billions in production. I need to search for a subset of these records, then save this subset of the original set into a secon…

---

## [English stemmer bug](https://discuss.elastic.co/t/english-stemmer-bug/139028)

<div class="topic-metadata">

**Author:** [@svarup](https://discuss.elastic.co/u/svarup)\
**Replies:** 7\
**Last updated:** [July 9, 2018, 2:46am UTC](https://discuss.elastic.co/t/english-stemmer-bug/139028 "2018-07-09T02:46:06Z")

</div>

when i analyze "movies" word using english stemmer then it will give me movi. Other word like questions(question) or states(state) work correctly. below is the api that i use. { "tokenizer": "standard", "text": "movie…

---

## [Bootstrap setting not working in elasticsearch 6.2 version](https://discuss.elastic.co/t/bootstrap-setting-not-working-in-elasticsearch-6-2-version/138366)

<div class="topic-metadata">

**Author:** [@veerabhadraiah](https://discuss.elastic.co/u/veerabhadraiah)\
**Replies:** 1\
**Last updated:** [July 9, 2018, 2:10am UTC](https://discuss.elastic.co/t/bootstrap-setting-not-working-in-elasticsearch-6-2-version/138366 "2018-07-09T02:10:00Z")

</div>

Hi, I have tried to add bootstrap in elasticsearch 6.2 version its not working please help me to set right configuration . bootstrap: mlockall: true and i tried bootstrap.memory\_lock: true Both are not worki…

---

## [Stop search if client has disconnected](https://discuss.elastic.co/t/stop-search-if-client-has-disconnected/138873)

<div class="topic-metadata">

**Author:** [@ebuildy](https://discuss.elastic.co/u/ebuildy)\
**Replies:** 4\
**Last updated:** [July 9, 2018, 1:10am UTC](https://discuss.elastic.co/t/stop-search-if-client-has-disconnected/138873 "2018-07-09T01:10:43Z")

</div>

Is it possible to stop the search if the main HTTP connection is closed by the client? My use case: "a web-site with Nginx+php+elasticsearch, public user does a search and closes the page immediately" Nginx connection…

---

## [Curator install problem with /.curator folder](https://discuss.elastic.co/t/curator-install-problem-with-curator-folder/138908)

<div class="topic-metadata">

**Author:** [@fconcha](https://discuss.elastic.co/u/fconcha)\
**Replies:** 2\
**Last updated:** [July 8, 2018, 7:40pm UTC](https://discuss.elastic.co/t/curator-install-problem-with-curator-folder/138908 "2018-07-08T19:40:56Z")

</div>

Hello, I have a couple of problems, I could not install curator in centos 7 with YUM, I had to use PIP, but I think it's already working. The problem is that I can not find the folder /.curator/curator.yml in the hidden…

---

## [Filter and tokenizer not working](https://discuss.elastic.co/t/filter-and-tokenizer-not-working/139043)

<div class="topic-metadata">

**Author:** [@Mohamed\_Lotfy](https://discuss.elastic.co/u/Mohamed_Lotfy)\
**Replies:** 7\
**Last updated:** [July 8, 2018, 6:48pm UTC](https://discuss.elastic.co/t/filter-and-tokenizer-not-working/139043 "2018-07-08T18:48:26Z")

</div>

Hello dudes recently I work for a task to use Elasticsearch with node.js and mongoose then I used Mongoosastic to be easier to link them together so I create a schema and add an analyzer called "edge\_nGram\_analyzer" a…

---

## [Debian 8 apt install issue](https://discuss.elastic.co/t/debian-8-apt-install-issue/139061)

<div class="topic-metadata">

**Author:** [@Alex4](https://discuss.elastic.co/u/Alex4)\
**Replies:** 2\
**Last updated:** [July 8, 2018, 4:22pm UTC](https://discuss.elastic.co/t/debian-8-apt-install-issue/139061 "2018-07-08T16:22:33Z")

</div>

apt-get install elasticsearch Reading package lists... Done Building dependency tree Reading state information... Done The following NEW packages will be installed: elasticsearch 0 upgraded, 1 newly installed, 0 to…

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

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