# Elasticsearch

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

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

**Page:** 1755

---

## [Insert Object Data using Update](https://discuss.elastic.co/t/insert-object-data-using-update/123871)

<div class="topic-metadata">

**Author:** [@adityosn](https://discuss.elastic.co/u/adityosn)\
**Replies:** 4\
**Last updated:** [March 14, 2018, 1:06pm UTC](https://discuss.elastic.co/t/insert-object-data-using-update/123871 "2018-03-14T13:06:50Z")

</div>

Hi, I would like adding data to my new added properties. So, I have ran mapping again to update my last index mapping by adding this property: "author": { "properties": { "id": { "type": "integer" }, …

---

## [Bulk Insert to elastic search using java?](https://discuss.elastic.co/t/bulk-insert-to-elastic-search-using-java/123481)

<div class="topic-metadata">

**Author:** [@prasanth](https://discuss.elastic.co/u/prasanth)\
**Replies:** 4\
**Last updated:** [March 14, 2018, 1:04pm UTC](https://discuss.elastic.co/t/bulk-insert-to-elastic-search-using-java/123481 "2018-03-14T13:04:16Z")

</div>

Hi, I would like to insert a json array of data to elastic search . Each element in array represents different documents under a type . How can I achieve this using Java without any ES clients . ? Please suggest a solu…

---

## [Nested query filter based on date is not returning correct results](https://discuss.elastic.co/t/nested-query-filter-based-on-date-is-not-returning-correct-results/123900)

<div class="topic-metadata">

**Author:** [@Siddaram\_Jamagav](https://discuss.elastic.co/u/Siddaram_Jamagav)\
**Replies:** 0\
**Last updated:** [March 14, 2018, 12:22pm UTC](https://discuss.elastic.co/t/nested-query-filter-based-on-date-is-not-returning-correct-results/123900 "2018-03-14T12:22:33Z")

</div>

I have nested query where in i am filtering the present days data and later aggregating the data using date-histogram aggregation with hourly interval , but in date-histogram output it is returning the previous day's dat…

---

## [Two nodes on one host](https://discuss.elastic.co/t/two-nodes-on-one-host/123905)

<div class="topic-metadata">

**Author:** [@merito](https://discuss.elastic.co/u/merito)\
**Replies:** 0\
**Last updated:** [March 14, 2018, 12:42pm UTC](https://discuss.elastic.co/t/two-nodes-on-one-host/123905 "2018-03-14T12:42:58Z")

</div>

Hi, I want to run two nodes on an one host with 64 or more GBs of RAM. I am able to do this adding parameters in .service file. For the second node it looks like this: ... ExecStart=/usr/share/elasticsearch/bin/elastic…

---

## [How to show other fields apart from count](https://discuss.elastic.co/t/how-to-show-other-fields-apart-from-count/123904)

<div class="topic-metadata">

**Author:** [@amit\_ahuja](https://discuss.elastic.co/u/amit_ahuja)\
**Replies:** 0\
**Last updated:** [March 14, 2018, 12:37pm UTC](https://discuss.elastic.co/t/how-to-show-other-fields-apart-from-count/123904 "2018-03-14T12:37:06Z")

</div>

Hello , Thanks for reading my question :slight\_smile: i have below config in elastic search and i am using tile map with geo coordinates bucket. it is showing me the count aggregation on the map for lat,long . but i…

---

## [Elastic search failed to parse](https://discuss.elastic.co/t/elastic-search-failed-to-parse/123896)

<div class="topic-metadata">

**Author:** [@sri535](https://discuss.elastic.co/u/sri535)\
**Replies:** 1\
**Last updated:** [March 14, 2018, 12:28pm UTC](https://discuss.elastic.co/t/elastic-search-failed-to-parse/123896 "2018-03-14T12:28:51Z")

</div>

HI i upgraded Elastic stack to 6.2 i am getting parsing error like below. please help to get rid of this indent preformatted text by 4 spaces failed to execute bulk item (index) BulkShardRequest \[\[foltsdb-2018.03.13\]\[4…

---

## [Connecting to Postgresql from elasticsearch](https://discuss.elastic.co/t/connecting-to-postgresql-from-elasticsearch/123873)

<div class="topic-metadata">

**Author:** [@Nandhini\_murugesan](https://discuss.elastic.co/u/Nandhini_murugesan)\
**Replies:** 4\
**Last updated:** [March 14, 2018, 11:00am UTC](https://discuss.elastic.co/t/connecting-to-postgresql-from-elasticsearch/123873 "2018-03-14T11:00:40Z")

</div>

I'm new to elastic search..I need to know whether I can send data from database(Postgresql) to elastic search directly without using logstash and beats.if there any way..pls suggest me..thanks in advance.

---

## [Group/count/average consecutive buckets](https://discuss.elastic.co/t/group-count-average-consecutive-buckets/123868)

<div class="topic-metadata">

**Author:** [@Patrick\_Lam](https://discuss.elastic.co/u/Patrick_Lam)\
**Replies:** 3\
**Last updated:** [March 14, 2018, 10:39am UTC](https://discuss.elastic.co/t/group-count-average-consecutive-buckets/123868 "2018-03-14T10:39:32Z")

</div>

Suppose I have a date/time field for each document. Now suppose that I group my documents into hourly buckets using a date\_histogram aggregation. Now suppose that there are some hours with no documents. So the document c…

---

## [Aggregation over an aggregation](https://discuss.elastic.co/t/aggregation-over-an-aggregation/123784)

<div class="topic-metadata">

**Author:** [@jgrenat](https://discuss.elastic.co/u/jgrenat)\
**Replies:** 2\
**Last updated:** [March 14, 2018, 10:35am UTC](https://discuss.elastic.co/t/aggregation-over-an-aggregation/123784 "2018-03-14T10:35:41Z")

</div>

Hello, I have some entries with the following form: { "categoryId": "categoryName", "elementId": "elementId", "state": "STATE" } The state can either be "INIT", "RUN", "DONE", ''ERROR" (in this order for the fir…

---

## [Form cluster using multiple nodes from different machine](https://discuss.elastic.co/t/form-cluster-using-multiple-nodes-from-different-machine/123870)

<div class="topic-metadata">

**Author:** [@BleedCode](https://discuss.elastic.co/u/BleedCode)\
**Replies:** 1\
**Last updated:** [March 14, 2018, 9:59am UTC](https://discuss.elastic.co/t/form-cluster-using-multiple-nodes-from-different-machine/123870 "2018-03-14T09:59:47Z")

</div>

I am new to elastic-search and trying to create a cluster using nodes present in multiple different server. Node 1 gets started but in node 2 i get error as:not enough master nodes discovered. I read many blogs on same b…

---

## [How to extract the content of elasticsearch indexes?](https://discuss.elastic.co/t/how-to-extract-the-content-of-elasticsearch-indexes/123300)

<div class="topic-metadata">

**Author:** [@fmind](https://discuss.elastic.co/u/fmind)\
**Replies:** 3\
**Last updated:** [March 14, 2018, 9:33am UTC](https://discuss.elastic.co/t/how-to-extract-the-content-of-elasticsearch-indexes/123300 "2018-03-14T09:33:16Z")

</div>

Hello, I want to perform an analysis on elasticsearch indexes. For instance, I have an index that stores two fields: 'name' and 'age'. The result I want are the documents associated to each value of each field: name …

---

## [Installing Elasticsearch on 2 network interfaces](https://discuss.elastic.co/t/installing-elasticsearch-on-2-network-interfaces/123848)

<div class="topic-metadata">

**Author:** [@omer](https://discuss.elastic.co/u/omer)\
**Replies:** 2\
**Last updated:** [March 14, 2018, 9:12am UTC](https://discuss.elastic.co/t/installing-elasticsearch-on-2-network-interfaces/123848 "2018-03-14T09:12:21Z")

</div>

Hi all; I am trying to send metrics to a machine which has 2 network interfaces with different IP address. Elasticsearch is installed on first one. I need to send data from a node on second interface via topbeat. So, I …

---

## [Elastic search Indexed content retruns nothing with title should query](https://discuss.elastic.co/t/elastic-search-indexed-content-retruns-nothing-with-title-should-query/123386)

<div class="topic-metadata">

**Author:** [@satyarajp](https://discuss.elastic.co/u/satyarajp)\
**Replies:** 12\
**Last updated:** [March 14, 2018, 9:06am UTC](https://discuss.elastic.co/t/elastic-search-indexed-content-retruns-nothing-with-title-should-query/123386 "2018-03-14T09:06:53Z")

</div>

Hi Team, I've indexed a content in to my elastic search v5.6.0 in local through json. Now I can query this using POST http://localhost:9200/content/\_search with empty body, and the search returns all results indexed in…

---

## [Cannot search double quotes](https://discuss.elastic.co/t/cannot-search-double-quotes/123429)

<div class="topic-metadata">

**Author:** [@Hayk\_Hovhanisyan](https://discuss.elastic.co/u/Hayk_Hovhanisyan)\
**Replies:** 2\
**Last updated:** [March 12, 2018, 7:45am UTC](https://discuss.elastic.co/t/cannot-search-double-quotes/123429 "2018-03-12T07:45:44Z")

</div>

Hi folk, Elastic Search version 2.4 Java version 1.8 Following error when search via " java.lang.IllegalArgumentException: expected '"' at position 7. Search via double quotes query body

---

## [Which is the best way to sort data in elastic search](https://discuss.elastic.co/t/which-is-the-best-way-to-sort-data-in-elastic-search/123537)

<div class="topic-metadata">

**Author:** [@sunilkumar](https://discuss.elastic.co/u/sunilkumar)\
**Replies:** 20\
**Last updated:** [March 14, 2018, 8:34am UTC](https://discuss.elastic.co/t/which-is-the-best-way-to-sort-data-in-elastic-search/123537 "2018-03-14T08:34:17Z")

</div>

"sort" : \[ { "@timestamp" : {"order" : "asc"}} \] When i use timestamp to sort data in order,if 2 datas have the same timestamp i'm not able to get the data in logstash processed order.plz help

---

## [Shard allocation not working if on different subnet?](https://discuss.elastic.co/t/shard-allocation-not-working-if-on-different-subnet/123830)

<div class="topic-metadata">

**Author:** [@Edmund\_Cheng](https://discuss.elastic.co/u/Edmund_Cheng)\
**Replies:** 7\
**Last updated:** [March 14, 2018, 7:50am UTC](https://discuss.elastic.co/t/shard-allocation-not-working-if-on-different-subnet/123830 "2018-03-14T07:50:14Z")

</div>

hi, I was doing some testing where for e.g node1 IP : 192.168.168.X node2 IP : 192.168.168.X node3 IP : 10.91.10.X They are able to discover one another, but shards are only allocated among node1 and node2, while no…

---

## [Dangled indices](https://discuss.elastic.co/t/dangled-indices/123845)

<div class="topic-metadata">

**Author:** [@z\_y\_xing](https://discuss.elastic.co/u/z_y_xing)\
**Replies:** 0\
**Last updated:** [March 14, 2018, 6:50am UTC](https://discuss.elastic.co/t/dangled-indices/123845 "2018-03-14T06:50:35Z")

</div>

forgive my bad english! i read this document about dangling indices here was a part: ..... any shards stored in its local data directory directory which do not already exist in the cluster ... i thought closed inde…

---

## [Read timeout warning when Follow referrals is true](https://discuss.elastic.co/t/read-timeout-warning-when-follow-referrals-is-true/123814)

<div class="topic-metadata">

**Author:** [@jfreeman](https://discuss.elastic.co/u/jfreeman)\
**Replies:** 9\
**Last updated:** [March 14, 2018, 5:50am UTC](https://discuss.elastic.co/t/read-timeout-warning-when-follow-referrals-is-true/123814 "2018-03-14T05:50:25Z")

</div>

First time AD authentication using https://elasticsearchurl/\_xpack/security/\_authenticate takes around 3 mins to return a successful result. I am using x-pack 6.0 and below is the realms setting in elasticsearch.yml file …

---

## [Error in Custom Realm X-Pack Oauth](https://discuss.elastic.co/t/error-in-custom-realm-x-pack-oauth/123723)

<div class="topic-metadata">

**Author:** [@PinkiMondal](https://discuss.elastic.co/u/PinkiMondal)\
**Replies:** 2\
**Last updated:** [March 14, 2018, 5:47am UTC](https://discuss.elastic.co/t/error-in-custom-realm-x-pack-oauth/123723 "2018-03-14T05:47:43Z")

</div>

After changing version from 5.4.1 to 5.5.1 I am getting Exception in below method @override public User authenticate(AuthenticationToken authenticationToken) { UsernamePasswordToken token = (UsernamePasswordToken) aut…

---

## [Filtered Alias to return all non-filtered types and filtered type](https://discuss.elastic.co/t/filtered-alias-to-return-all-non-filtered-types-and-filtered-type/123556)

<div class="topic-metadata">

**Author:** [@unospeeder](https://discuss.elastic.co/u/unospeeder)\
**Replies:** 2\
**Last updated:** [March 14, 2018, 5:17am UTC](https://discuss.elastic.co/t/filtered-alias-to-return-all-non-filtered-types-and-filtered-type/123556 "2018-03-14T05:17:54Z")

</div>

I am trying to determine if an alias pointing at an index with multiple types can be configured to not mask the types not specified in the filter. For example using the following types Item Person I would like to fi…

---

## [Generate\_number\_parts not working as expected](https://discuss.elastic.co/t/generate-number-parts-not-working-as-expected/123468)

<div class="topic-metadata">

**Author:** [@askids](https://discuss.elastic.co/u/askids)\
**Replies:** 2\
**Last updated:** [March 14, 2018, 12:44am UTC](https://discuss.elastic.co/t/generate-number-parts-not-working-as-expected/123468 "2018-03-14T00:44:21Z")

</div>

hi, I have a requirement to include special characters in search. So for both intake and search, I am trying to create a custom analyzer so that I can retain original character as is. I have set the tokenizer to whitesp…

---

## [Does DELETE\_BY\_QUERY work with Index Sorting in ES 6.0?](https://discuss.elastic.co/t/does-delete-by-query-work-with-index-sorting-in-es-6-0/123813)

<div class="topic-metadata">

**Author:** [@kevybear](https://discuss.elastic.co/u/kevybear)\
**Replies:** 0\
**Last updated:** [March 13, 2018, 10:02pm UTC](https://discuss.elastic.co/t/does-delete-by-query-work-with-index-sorting-in-es-6-0/123813 "2018-03-13T22:02:19Z")

</div>

Hi, I am migrating an entity centric index from ES 2.3 to ES 6.0 and in ES 6.0, \_ttl is deprecated. I originally was planning on using rolling indices but it won't work for us well since routing logic is complex for my …

---

## [Help: NEST Search Match List\\ARRAY Debacle](https://discuss.elastic.co/t/help-nest-search-match-list-array-debacle/123804)

<div class="topic-metadata">

**Author:** [@JRod](https://discuss.elastic.co/u/JRod)\
**Replies:** 0\
**Last updated:** [March 13, 2018, 8:38pm UTC](https://discuss.elastic.co/t/help-nest-search-match-list-array-debacle/123804 "2018-03-13T20:38:07Z")

</div>

Hi I was hoping I could get some help on this issue I have been having. The below code works but I want to tweek it to were .MATCH is the one that is actually searching for field2Text1 or field2Text2 in field2. Most site…

---

## [Logstash error : Got response code '401' contacting Elasticsearch](https://discuss.elastic.co/t/logstash-error-got-response-code-401-contacting-elasticsearch/120792)

<div class="topic-metadata">

**Author:** [@ryext](https://discuss.elastic.co/u/ryext)\
**Replies:** 2\
**Last updated:** [March 13, 2018, 7:55pm UTC](https://discuss.elastic.co/t/logstash-error-got-response-code-401-contacting-elasticsearch/120792 "2018-03-13T19:55:41Z")

</div>

Hey, so here is my issue: I installed x-pack on elastiic kibana ana logstash the connection kibana elastic works fine. unfortunatly logstash-elasticsearch in not flowing smoothly. here is the error u am getting: :…

---

## [Scripting](https://discuss.elastic.co/t/scripting/123411)

<div class="topic-metadata">

**Author:** [@Errors](https://discuss.elastic.co/u/Errors)\
**Replies:** 3\
**Last updated:** [March 13, 2018, 6:51pm UTC](https://discuss.elastic.co/t/scripting/123411 "2018-03-13T18:51:04Z")

</div>

I've written the following script and am running it using dev tools \[asdfsafsa\] The first time I ran it, the field "result" said "created". As you can see from the screenshot, I've run this code a couple of times. Reas…

---

## [\[elasticsearch 2.3\] automatic shard rebalance?](https://discuss.elastic.co/t/elasticsearch-2-3-automatic-shard-rebalance/123775)

<div class="topic-metadata">

**Author:** [@mobidyc](https://discuss.elastic.co/u/mobidyc)\
**Replies:** 3\
**Last updated:** [March 13, 2018, 5:07pm UTC](https://discuss.elastic.co/t/elasticsearch-2-3-automatic-shard-rebalance/123775 "2018-03-13T17:07:09Z")

</div>

Hello, I have one node on 24 receiving zero shards, and I can't figure out why. Nothing in the logs, cluster is green, node accepts requests. any Idea on how to identify the problem? # curl -s '127.0.0.1:9200/\_cat/al…

---

## [ElasticSearch .NET DateTime parse failed](https://discuss.elastic.co/t/elasticsearch-net-datetime-parse-failed/123757)

<div class="topic-metadata">

**Author:** [@Schrader](https://discuss.elastic.co/u/Schrader)\
**Replies:** 1\
**Last updated:** [March 13, 2018, 4:34pm UTC](https://discuss.elastic.co/t/elasticsearch-net-datetime-parse-failed/123757 "2018-03-13T16:34:49Z")

</div>

I want to parse my Json-Log into Logstash -\> ElasticSearch and use it in my .Net-Core Application with NEST / ElasticSearch.NET. My Log-File: {"LogDate:":"2018-01-07T16:17:00.171Z", "ID":"1","LogLevel":"WARNING"} My l…

---

## [NEST: S3 Repository server\_side\_encryption not an option](https://discuss.elastic.co/t/nest-s3-repository-server-side-encryption-not-an-option/123774)

<div class="topic-metadata">

**Author:** [@ChrisFord](https://discuss.elastic.co/u/ChrisFord)\
**Replies:** 0\
**Last updated:** [March 13, 2018, 4:21pm UTC](https://discuss.elastic.co/t/nest-s3-repository-server-side-encryption-not-an-option/123774 "2018-03-13T16:21:59Z")

</div>

Hi I am using NEST 6.0.1 for a solution I am building, one of the requirements is to create snapshots which we will store on S3. When creating the repository for the snapshots I was getting 403 errors "caused\_by": { "t…

---

## [RolloverStrategy in elasticsearch 5.6](https://discuss.elastic.co/t/rolloverstrategy-in-elasticsearch-5-6/123773)

<div class="topic-metadata">

**Author:** [@Hornov](https://discuss.elastic.co/u/Hornov)\
**Replies:** 0\
**Last updated:** [March 13, 2018, 4:13pm UTC](https://discuss.elastic.co/t/rolloverstrategy-in-elasticsearch-5-6/123773 "2018-03-13T16:13:01Z")

</div>

elasticsearch does well name my files with the date but it can't delete the older. Do you have any idea ? My /etc/elasticsearch/log4j2.properties : status = error log action execution errors for easier debugging logg…

---

## [Force external tokenization/lemmatization](https://discuss.elastic.co/t/force-external-tokenization-lemmatization/123761)

<div class="topic-metadata">

**Author:** [@levi-strauss](https://discuss.elastic.co/u/levi-strauss)\
**Replies:** 0\
**Last updated:** [March 13, 2018, 3:19pm UTC](https://discuss.elastic.co/t/force-external-tokenization-lemmatization/123761 "2018-03-13T15:19:02Z")

</div>

Hi, is there any other way to force custom tokenization and lemmatization besides writing a custom Token Filter plugin? I would like to synchronize products of custom analysis (done first) with data stored in elasticse…

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

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