# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1089 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1090 --- ## [Invalid LinearRing provided for type polygon. Linear ring must be an array of coordinates](https://discuss.elastic.co/t/invalid-linearring-provided-for-type-polygon-linear-ring-must-be-an-array-of-coordinates/208428)
**Author:** [@ohoroyoi](https://discuss.elastic.co/u/ohoroyoi)\ **Replies:** 3\ **Last updated:** [November 20, 2019, 10:39am UTC](https://discuss.elastic.co/t/invalid-linearring-provided-for-type-polygon-linear-ring-must-be-an-array-of-coordinates/208428 "2019-11-20T10:39:41Z")
version 6.7.2 { "properties": { "boundaries": { "type": "geo\_shape", "ignore\_malformed":true } } } but ignore\_malformed doesn't work. I can't get documents using this query(below). { "query":{ … --- ## [Compare 2 tables with different indices and display the records that are missing in first table](https://discuss.elastic.co/t/compare-2-tables-with-different-indices-and-display-the-records-that-are-missing-in-first-table/208256)
**Author:** [@shali93](https://discuss.elastic.co/u/shali93)\ **Replies:** 5\ **Last updated:** [November 20, 2019, 10:31am UTC](https://discuss.elastic.co/t/compare-2-tables-with-different-indices-and-display-the-records-that-are-missing-in-first-table/208256 "2019-11-20T10:31:28Z")
How to compare 2 tables with different indices and display the records that are missing in first table. example: table 1 table 2 result A A B B Y X X Z Y Z … --- ## [HTTP response codes when creating a document](https://discuss.elastic.co/t/http-response-codes-when-creating-a-document/208647)
**Author:** [@kakavoul](https://discuss.elastic.co/u/kakavoul)\ **Replies:** 3\ **Last updated:** [November 20, 2019, 10:14am UTC](https://discuss.elastic.co/t/http-response-codes-when-creating-a-document/208647 "2019-11-20T10:14:45Z")
Hello, Is there somewhere a list of all possible HTTP response codes when creating a new document in ElasticSearch? I only managed to find that in case of a successful creation 201 is responded while in case of a confli… --- ## [Elastic search showing error](https://discuss.elastic.co/t/elastic-search-showing-error/208270)
**Author:** [@Aditya\_kumar\_kar](https://discuss.elastic.co/u/Aditya_kumar_kar)\ **Replies:** 3\ **Last updated:** [November 20, 2019, 8:52am UTC](https://discuss.elastic.co/t/elastic-search-showing-error/208270 "2019-11-20T08:52:40Z")
.NoShardAvailableActionException error showing elastic search. {"type": "server", "timestamp": "2019-11-18T04:35:16,649Z", "level": "WARN", "component": "r.suppressed", "cluster.name": "docker-cluster", "node.name": "el… --- ## [Index Lifecycle Policies - Create a new index every week](https://discuss.elastic.co/t/index-lifecycle-policies-create-a-new-index-every-week/208655)
**Author:** [@gerard1](https://discuss.elastic.co/u/gerard1)\ **Replies:** 0\ **Last updated:** [November 20, 2019, 8:50am UTC](https://discuss.elastic.co/t/index-lifecycle-policies-create-a-new-index-every-week/208655 "2019-11-20T08:50:52Z")
I'm trying to create indexes with the format: filebeat-7.4.0-yyyy-mm-dd every 7 days, but apparently doesn't work as expected. What I did was adjusting the Index Policy (that comes with the Cloud instance by default) in … --- ## [Change time\_zone in date\_histogram composite aggregation does not work?](https://discuss.elastic.co/t/change-time-zone-in-date-histogram-composite-aggregation-does-not-work/208649)
**Author:** [@Ian\_Sofiyan](https://discuss.elastic.co/u/Ian_Sofiyan)\ **Replies:** 0\ **Last updated:** [November 20, 2019, 8:19am UTC](https://discuss.elastic.co/t/change-time-zone-in-date-histogram-composite-aggregation-does-not-work/208649 "2019-11-20T08:19:00Z")
here my mapping mapping file then i try rerquest using like this Request the result like this \> { \> "took": 1782, \> "timed\_out": false, \> "\_shards": { \> "total": 10, \> "successful": 10,… --- ## [SQL SELECT Command for Days and Hours Avererage](https://discuss.elastic.co/t/sql-select-command-for-days-and-hours-avererage/208221)
**Author:** [@pgervais](https://discuss.elastic.co/u/pgervais)\ **Replies:** 1\ **Last updated:** [November 20, 2019, 8:01am UTC](https://discuss.elastic.co/t/sql-select-command-for-days-and-hours-avererage/208221 "2019-11-20T08:01:58Z")
I have documents in an index that is timestamped. There is an index entry for each hour of the day, for each day of the month with multiple months in the index. Assume each hour document contains CPU MIPS values so the a… --- ## [RPO and backup](https://discuss.elastic.co/t/rpo-and-backup/208558)
**Author:** [@granier](https://discuss.elastic.co/u/granier)\ **Replies:** 3\ **Last updated:** [November 20, 2019, 8:00am UTC](https://discuss.elastic.co/t/rpo-and-backup/208558 "2019-11-20T08:00:12Z")
Hi, After reading some topics here, i get a question about backup and RPO. If I take a snapshot every day, my RPO could be 24h : that's a lots. But taking a snapshot every hour or every 10' or more is a lots too ... W… --- ## [Indices are getting locked](https://discuss.elastic.co/t/indices-are-getting-locked/208498)
**Author:** [@Seetharaman\_K](https://discuss.elastic.co/u/Seetharaman_K)\ **Replies:** 5\ **Last updated:** [November 20, 2019, 7:49am UTC](https://discuss.elastic.co/t/indices-are-getting-locked/208498 "2019-11-20T07:49:36Z")
Not sure what is the reason why indices are getting locked , every time one of the index is getting locked , i have to go and remove the lock . the obvious answer is as many may say "its due to do disk space issue" bu… --- ## [Aggregation on Nested Field of child document with nested aggregation on parent document](https://discuss.elastic.co/t/aggregation-on-nested-field-of-child-document-with-nested-aggregation-on-parent-document/208642)
**Author:** [@Animesh\_singh](https://discuss.elastic.co/u/Animesh_singh)\ **Replies:** 0\ **Last updated:** [November 20, 2019, 7:38am UTC](https://discuss.elastic.co/t/aggregation-on-nested-field-of-child-document-with-nested-aggregation-on-parent-document/208642 "2019-11-20T07:38:00Z")
Hey , Can anyone help me with this , the buckets are not formed by elastic search . What i want to is - Aggregate on a nested field present in child document\[object.name\] and further aggregate them their parent docume… --- ## [Any idea about Join query](https://discuss.elastic.co/t/any-idea-about-join-query/207982)
**Author:** [@Mudboyzh](https://discuss.elastic.co/u/Mudboyzh)\ **Replies:** 4\ **Last updated:** [November 20, 2019, 3:52am UTC](https://discuss.elastic.co/t/any-idea-about-join-query/207982 "2019-11-20T03:52:33Z")
It seems hard to query with relation like SQL in elasticsearch. I want some recommendation in my case. I have to two indices, user info and user event log. Here is part of the data: User Info +-------+-----------+---… --- ## [Elasticsearch problem managing via puppet](https://discuss.elastic.co/t/elasticsearch-problem-managing-via-puppet/208465)
**Author:** [@111242](https://discuss.elastic.co/u/111242)\ **Replies:** 1\ **Last updated:** [November 19, 2019, 10:54pm UTC](https://discuss.elastic.co/t/elasticsearch-problem-managing-via-puppet/208465 "2019-11-19T22:54:18Z")
Hi My elasticsearch is managed via puppet All was ok some time before And all is ok on another instances But on one instance where elasticsearch service stopped to work I got errors when apply puppet config Error: Coul… --- ## [Date\_histogram of date\_range with null end points runs out of memory](https://discuss.elastic.co/t/date-histogram-of-date-range-with-null-end-points-runs-out-of-memory/208589)
**Author:** [@EconCoder](https://discuss.elastic.co/u/EconCoder)\ **Replies:** 0\ **Last updated:** [November 19, 2019, 9:23pm UTC](https://discuss.elastic.co/t/date-histogram-of-date-range-with-null-end-points-runs-out-of-memory/208589 "2019-11-19T21:23:31Z")
I'm attempting to do a date\_histogram aggregation on a date\_range field now that it is supported in 7.4.1. This works well for fully defined date ranges (the first document in my example), but I have a large number of do… --- ## [Display intermediate function results, not only combined ranking score](https://discuss.elastic.co/t/display-intermediate-function-results-not-only-combined-ranking-score/208588)
**Author:** [@KevinVDS](https://discuss.elastic.co/u/KevinVDS)\ **Replies:** 0\ **Last updated:** [November 19, 2019, 9:17pm UTC](https://discuss.elastic.co/t/display-intermediate-function-results-not-only-combined-ranking-score/208588 "2019-11-19T21:17:48Z")
We've build a newsfeed based on Elasticsearch. To be able to rank the posts we combine (multiply) several functions (think about time decay, number of likes, ...). This all works perfectly, but as with most algoritmes it… --- ## [Custom analyzer don't match with ASCII folding filter values](https://discuss.elastic.co/t/custom-analyzer-dont-match-with-ascii-folding-filter-values/208576)
**Author:** [@faruk](https://discuss.elastic.co/u/faruk)\ **Replies:** 0\ **Last updated:** [November 19, 2019, 8:15pm UTC](https://discuss.elastic.co/t/custom-analyzer-dont-match-with-ascii-folding-filter-values/208576 "2019-11-19T20:15:21Z")
I'm using a custom rebuilt turkish analyzer like this: "analysis": { "filter":{ "turkish\_lowercase": { "type": "lowercase", "language": "turkish" }, "turkish\_sto… --- ## [Error for too many documents, API says we are still below the limit](https://discuss.elastic.co/t/error-for-too-many-documents-api-says-we-are-still-below-the-limit/208575)
**Author:** [@holgr](https://discuss.elastic.co/u/holgr)\ **Replies:** 0\ **Last updated:** [November 19, 2019, 8:08pm UTC](https://discuss.elastic.co/t/error-for-too-many-documents-api-says-we-are-still-below-the-limit/208575 "2019-11-19T20:08:05Z")
While indexing new documents we've recently started getting errors for having too many (java.lang.IllegalArgumentException: number of documents in the index cannot exceed 2147483519). We are aware of this limit, but loo… --- ## [Max file descriptors \[4096\] for elasticsearch process is too low - Running as a service](https://discuss.elastic.co/t/max-file-descriptors-4096-for-elasticsearch-process-is-too-low-running-as-a-service/208238)
**Author:** [@mauriciothomsen](https://discuss.elastic.co/u/mauriciothomsen)\ **Replies:** 2\ **Last updated:** [November 19, 2019, 6:30pm UTC](https://discuss.elastic.co/t/max-file-descriptors-4096-for-elasticsearch-process-is-too-low-running-as-a-service/208238 "2019-11-19T18:30:49Z")
Hello All, Instead of run elasticsearch as a command everytime I start the machine, I decided to switch as a service. An old issue related to the max file descriptors came back but this time I could not make work when t… --- ## [Index Lifecycle Error- Check rollover ready](https://discuss.elastic.co/t/index-lifecycle-error-check-rollover-ready/208556)
**Author:** [@Mehak\_Bhargava](https://discuss.elastic.co/u/Mehak_Bhargava)\ **Replies:** 0\ **Last updated:** [November 19, 2019, 6:04pm UTC](https://discuss.elastic.co/t/index-lifecycle-error-check-rollover-ready/208556 "2019-11-19T18:04:44Z")
After I ran these queries, my filebeat index isn't collecting data on discover and gives me following error- PUT filebeat-7.4.0-2019.11.08-000001/\_settings { "index": { "blocks": { "read\_only\_allow\_dele… --- ## [Load JSON Schema to Elastic Search](https://discuss.elastic.co/t/load-json-schema-to-elastic-search/208382)
**Author:** [@Rao\_Waqas\_Akram](https://discuss.elastic.co/u/Rao_Waqas_Akram)\ **Replies:** 2\ **Last updated:** [November 19, 2019, 5:32pm UTC](https://discuss.elastic.co/t/load-json-schema-to-elastic-search/208382 "2019-11-19T17:32:41Z")
I am working with Elastic Search v 5.6.16 . I want to provide the JSON schema to the ES and than load the data as per this schema to ES and get back result as List. Please help out how to proceed with this --- ## [What is this added "field" thing?](https://discuss.elastic.co/t/what-is-this-added-field-thing/208349)
**Author:** [@EricJohnson](https://discuss.elastic.co/u/EricJohnson)\ **Replies:** 7\ **Last updated:** [November 19, 2019, 4:32pm UTC](https://discuss.elastic.co/t/what-is-this-added-field-thing/208349 "2019-11-19T16:32:37Z")
Greetings. This is probably a simple question. I'm creating records that look like this: { "\_index": "metrics\_daily\_summary", "\_type": "\_doc", "\_id": "E36Bbm4B8gCymL1PmIcS", "\_version": 1, "\_score": 0, "\_s… --- ## [When does ILM trigger?](https://discuss.elastic.co/t/when-does-ilm-trigger/208540)
**Author:** [@lask001](https://discuss.elastic.co/u/lask001)\ **Replies:** 2\ **Last updated:** [November 19, 2019, 4:03pm UTC](https://discuss.elastic.co/t/when-does-ilm-trigger/208540 "2019-11-19T16:03:40Z")
I have ILM setup on my elasticsearch cluster and for the most part it seems to be working but I have a few questions on how things are working behind the scenes. Currently I have my settings identical to the examples in … --- ## [Query\_string search with ignoring some characters](https://discuss.elastic.co/t/query-string-search-with-ignoring-some-characters/206165)
**Author:** [@milk911](https://discuss.elastic.co/u/milk911)\ **Replies:** 1\ **Last updated:** [November 19, 2019, 2:42pm UTC](https://discuss.elastic.co/t/query-string-search-with-ignoring-some-characters/206165 "2019-11-19T14:42:59Z")
Hi all! I have a record in index, that contains some spec characters " ", "/", "-": { "documentData" : { "refNo" : "8652 / 58996-3", "status" : "Rejected", } } How should I do query\_string search if I have only … --- ## [Hardware Sizing Estimation](https://discuss.elastic.co/t/hardware-sizing-estimation/208522)
**Author:** [@Praveen\_Kamble](https://discuss.elastic.co/u/Praveen_Kamble)\ **Replies:** 0\ **Last updated:** [November 19, 2019, 2:08pm UTC](https://discuss.elastic.co/t/hardware-sizing-estimation/208522 "2019-11-19T14:08:25Z")
Hello, We are planning to design a solution of Elastic Stack wherein the requirement is 10GB/Day volume of log data. And the log retention is as follows: 7 days of Hot 358 days of Warm and then 2 years on NAS Also,… --- ## [Getting Storage Size by Tenant from a shared index](https://discuss.elastic.co/t/getting-storage-size-by-tenant-from-a-shared-index/208521)
**Author:** [@Ravi\_Narayan](https://discuss.elastic.co/u/Ravi_Narayan)\ **Replies:** 0\ **Last updated:** [November 19, 2019, 2:05pm UTC](https://discuss.elastic.co/t/getting-storage-size-by-tenant-from-a-shared-index/208521 "2019-11-19T14:05:57Z")
I have a MT environment where some of my indices are shared between tenants. I need a way to find out the total storage used by each tenant. We use Filtered Alias for tenants for searching , but I cannot figure out a way… --- ## [This error is coming when we are build elastic search 7.4 version code.use gradle version 5.6.2 and java version 12 in windows](https://discuss.elastic.co/t/this-error-is-coming-when-we-are-build-elastic-search-7-4-version-code-use-gradle-version-5-6-2-and-java-version-12-in-windows/208510)
**Author:** [@Ankur\_Agarwal1](https://discuss.elastic.co/u/Ankur_Agarwal1)\ **Replies:** 0\ **Last updated:** [November 19, 2019, 1:28pm UTC](https://discuss.elastic.co/t/this-error-is-coming-when-we-are-build-elastic-search-7-4-version-code-use-gradle-version-5-6-2-and-java-version-12-in-windows/208510 "2019-11-19T13:28:17Z")
Configure project :x-pack:test:smb-fixture Tests for :x-pack:test:smb-fixture require docker-compose at /usr/local/bin/docker-compose or /usr/bin/docker-compose but none could be found so these will be skipped Confi… --- ## [Group by not working with other column](https://discuss.elastic.co/t/group-by-not-working-with-other-column/207829)
**Author:** [@KrishK](https://discuss.elastic.co/u/KrishK)\ **Replies:** 3\ **Last updated:** [November 19, 2019, 1:16pm UTC](https://discuss.elastic.co/t/group-by-not-working-with-other-column/207829 "2019-11-19T13:16:41Z")
Hi Support, Below query is not working for me. POST \_sql/format=txt { "query":"""SELECT count(\*) as matched,col1,col2 FROM index WHERE col0 = 1 group by col1""" } Error : { "error": { "root\_cause": \[ { "type":… --- ## [Volume Sizing Example](https://discuss.elastic.co/t/volume-sizing-example/208357)
**Author:** [@magneton](https://discuss.elastic.co/u/magneton)\ **Replies:** 3\ **Last updated:** [November 19, 2019, 12:04pm UTC](https://discuss.elastic.co/t/volume-sizing-example/208357 "2019-11-19T12:04:08Z")
Dear Elastic In your webinar, you gave the following formula for volume sizing: I want to just check with a worked example. so for 1.5TB retained for 7 days with one replica Total Data = 1.5 \*7 \*2 = 22TB. Total Sto… --- ## [7.4.0 Circuit breaking exceptions](https://discuss.elastic.co/t/7-4-0-circuit-breaking-exceptions/203063)
**Author:** [@MattJones](https://discuss.elastic.co/u/MattJones)\ **Replies:** 7\ **Last updated:** [November 19, 2019, 12:00pm UTC](https://discuss.elastic.co/t/7-4-0-circuit-breaking-exceptions/203063 "2019-11-19T12:00:27Z")
Hi, I'm seeing quite a few Circuit Breaking Exceptions happening in my cluster when indexing new data. I'm feeling a bit out of my depth here, so any advice is greatly appreciated!!! :slight\_smile: The errors: \[2019-1… --- ## [CIRCLE geo\_shape query not supported in ES7.4.2](https://discuss.elastic.co/t/circle-geo-shape-query-not-supported-in-es7-4-2/208404)
**Author:** [@UglyBarnacle](https://discuss.elastic.co/u/UglyBarnacle)\ **Replies:** 1\ **Last updated:** [November 19, 2019, 11:26am UTC](https://discuss.elastic.co/t/circle-geo-shape-query-not-supported-in-es7-4-2/208404 "2019-11-19T11:26:44Z")
Hello, we currently want to move from ES6.8.1 to 7.4.2. so far everything went fine but one application querying on geolocations fails with an error currently on our test system unsupported\_operation\_exception: CIRCLE … --- ## [Elasticsearch cumulative sum on derivative units(normalized\_value)](https://discuss.elastic.co/t/elasticsearch-cumulative-sum-on-derivative-units-normalized-value/205594)
**Author:** [@Narayana\_Pachava](https://discuss.elastic.co/u/Narayana_Pachava)\ **Replies:** 1\ **Last updated:** [November 19, 2019, 11:19am UTC](https://discuss.elastic.co/t/elasticsearch-cumulative-sum-on-derivative-units-normalized-value/205594 "2019-11-19T11:19:06Z")
i have running counter say port.packets and i want to calculate the cumulative sum on the buckets path of the derivates normalised value by units instead of the actual derivative value . Usually cumulative sum is taking… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1088) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1090)