# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1419 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1420 --- ## [Sort Date for different value of particular field in Single Query](https://discuss.elastic.co/t/sort-date-for-different-value-of-particular-field-in-single-query/165023)
**Author:** [@smidev11](https://discuss.elastic.co/u/smidev11)\ **Replies:** 2\ **Last updated:** [January 22, 2019, 5:21am UTC](https://discuss.elastic.co/t/sort-date-for-different-value-of-particular-field-in-single-query/165023 "2019-01-22T05:21:55Z")
Lets say I have following content on index. { date : 2019-01-21T08:20:18.962Z , student : "A", "City": "city1" } { date : 2019-01-21T08:20:55.962Z , student : "A", "City": "city1" } { date : 2019-01-21T08:29:20.962Z ,… --- ## [Python - tracking how many documents and indexes are in a node](https://discuss.elastic.co/t/python-tracking-how-many-documents-and-indexes-are-in-a-node/165149)
**Author:** [@Tree1](https://discuss.elastic.co/u/Tree1)\ **Replies:** 0\ **Last updated:** [January 22, 2019, 5:07am UTC](https://discuss.elastic.co/t/python-tracking-how-many-documents-and-indexes-are-in-a-node/165149 "2019-01-22T05:07:18Z")
I am trying to make a manager that tracks how many indexes are currently active and how many documents are in each index. I am using the python wrapper. Is there any efficient way to do this? Thanks for the help --- ## [Elaticsearch log "submitting async flush request" very frequency](https://discuss.elastic.co/t/elaticsearch-log-submitting-async-flush-request-very-frequency/165044)
**Author:** [@chenchuangc](https://discuss.elastic.co/u/chenchuangc)\ **Replies:** 2\ **Last updated:** [January 22, 2019, 4:02am UTC](https://discuss.elastic.co/t/elaticsearch-log-submitting-async-flush-request-very-frequency/165044 "2019-01-22T04:02:36Z")
Elasticsearch version (bin/elasticsearch --version): 6.0.0 Plugins installed: JVM version (java -version): java version "1.8.0\_91" Java(TM) SE Runtime Environment (build 1.8.0\_91-b14) Java HotSpot(TM) 64-Bit Serve… --- ## [Kibana 6.4 prompting basic authentication after upgrading Elasticsearch from 5.6 to 6.4](https://discuss.elastic.co/t/kibana-6-4-prompting-basic-authentication-after-upgrading-elasticsearch-from-5-6-to-6-4/165086)
**Author:** [@preddy75](https://discuss.elastic.co/u/preddy75)\ **Replies:** 3\ **Last updated:** [January 22, 2019, 1:54am UTC](https://discuss.elastic.co/t/kibana-6-4-prompting-basic-authentication-after-upgrading-elasticsearch-from-5-6-to-6-4/165086 "2019-01-22T01:54:09Z")
Hi, We have a large Kubernetes setup that uses ELK for logging. Filebeat-\>Logstash-\>Elasticsearch-\>Kibana (searchguard turned on). After upgrading Elasticsearch to 6.4 from 5.6 (Kibana still at 5.6) Kibana started prom… --- ## [Aliases across many indices and default scoring function](https://discuss.elastic.co/t/aliases-across-many-indices-and-default-scoring-function/165122)
**Author:** [@PierreC](https://discuss.elastic.co/u/PierreC)\ **Replies:** 1\ **Last updated:** [January 22, 2019, 1:52am UTC](https://discuss.elastic.co/t/aliases-across-many-indices-and-default-scoring-function/165122 "2019-01-22T01:52:54Z")
I could not find many explanations about querying and alias that sit in front of many indices and its implication regarding relevance scoring. If we take a simple TFIDF approach, will each document be scored using a TF… --- ## [Error: Unsupported/Unknown Elasticsearch version 6.X.X](https://discuss.elastic.co/t/error-unsupported-unknown-elasticsearch-version-6-x-x/164846)
**Author:** [@spagano](https://discuss.elastic.co/u/spagano)\ **Replies:** 1\ **Last updated:** [January 22, 2019, 12:08am UTC](https://discuss.elastic.co/t/error-unsupported-unknown-elasticsearch-version-6-x-x/164846 "2019-01-22T00:08:35Z")
Hi, I saw the same problem on too many places. I have Hortonworks 2.6.4, Hadoop 2.7.3.2.6.4.0-91, Hive 1.2.1000.2.6.4.0-91, and, on the same host, I have installed Elasticsearch 6.4.3. Then, I do the following by com… --- ## [Systemctl status elasticsearch : failed (on GCP)](https://discuss.elastic.co/t/systemctl-status-elasticsearch-failed-on-gcp/165136)
**Author:** [@mugdha](https://discuss.elastic.co/u/mugdha)\ **Replies:** 0\ **Last updated:** [January 22, 2019, 12:25am UTC](https://discuss.elastic.co/t/systemctl-status-elasticsearch-failed-on-gcp/165136 "2019-01-22T00:25:21Z")
I need help for the below status of the service: ● elasticsearch.service - Elasticsearch Loaded: loaded (/usr/lib/systemd/system/elasticsearch.service; disabled; vendor preset: enabled) Active: failed (Result: exit-c… --- ## [Create nested type during index creation (Dynamic)](https://discuss.elastic.co/t/create-nested-type-during-index-creation-dynamic/165134)
**Author:** [@ramchjob](https://discuss.elastic.co/u/ramchjob)\ **Replies:** 0\ **Last updated:** [January 22, 2019, 12:19am UTC](https://discuss.elastic.co/t/create-nested-type-during-index-creation-dynamic/165134 "2019-01-22T00:19:56Z")
Hey Gurus, i am sure most of the ppl might have came across this. I am looking to have a nested type defined during index creation (Dynamic mapping). below are the options have explored. Option 1: Push a document to… --- ## [Watcher for email notification is in error state](https://discuss.elastic.co/t/watcher-for-email-notification-is-in-error-state/164591)
**Author:** [@Gaurav\_Emani](https://discuss.elastic.co/u/Gaurav_Emani)\ **Replies:** 0\ **Last updated:** [January 17, 2019, 8:56am UTC](https://discuss.elastic.co/t/watcher-for-email-notification-is-in-error-state/164591 "2019-01-17T08:56:46Z")
My watcher is in error state and keeps showing this exception even though the actual flow is working fine. GeneralScriptException\[Failed to compile inline script \[SOMETEXT\_{{ctx.vars.type}} not available at {{ctx.trigge… --- ## [Java IndexRequest Default value of type](https://discuss.elastic.co/t/java-indexrequest-default-value-of-type/165094)
**Author:** [@gormanst](https://discuss.elastic.co/u/gormanst)\ **Replies:** 2\ **Last updated:** [January 21, 2019, 7:01pm UTC](https://discuss.elastic.co/t/java-indexrequest-default-value-of-type/165094 "2019-01-21T19:01:12Z")
If I do not specify "\_doc" as my type in an IndexRequest like so, \`new IndexRequest(esIndex, "\_doc",record.getIndex()) .source(esRecord.getData().toString(), XContentType.JSON)\` I get the exception, … --- ## [Query having firsts five elements in the array](https://discuss.elastic.co/t/query-having-firsts-five-elements-in-the-array/165106)
**Author:** [@m.fayazahammed](https://discuss.elastic.co/u/m.fayazahammed)\ **Replies:** 1\ **Last updated:** [January 21, 2019, 6:10pm UTC](https://discuss.elastic.co/t/query-having-firsts-five-elements-in-the-array/165106 "2019-01-21T18:10:18Z")
Hi, Do you know any query that can be used to get first five elements in the array of the document if the array has more than 20 elements. Basically 5 is a parameter and it can vary. please advice on this. ex: itemID,… --- ## [Something wrong with type float search](https://discuss.elastic.co/t/something-wrong-with-type-float-search/165103)
**Author:** [@drsaison](https://discuss.elastic.co/u/drsaison)\ **Replies:** 0\ **Last updated:** [January 21, 2019, 5:40pm UTC](https://discuss.elastic.co/t/something-wrong-with-type-float-search/165103 "2019-01-21T17:40:27Z")
Could someone tell me anything wrong with the following query, which should return one result instead of two? Thanks. I created two records { "lat": 33.7479148, "lon": -84.1234567 } and { "lat": 33.7479149, "lon": -… --- ## [Elasticsearch GROK pattern failing even though it passes the debugger](https://discuss.elastic.co/t/elasticsearch-grok-pattern-failing-even-though-it-passes-the-debugger/164167)
**Author:** [@mdiorio](https://discuss.elastic.co/u/mdiorio)\ **Replies:** 1\ **Last updated:** [January 21, 2019, 4:04pm UTC](https://discuss.elastic.co/t/elasticsearch-grok-pattern-failing-even-though-it-passes-the-debugger/164167 "2019-01-21T16:04:38Z")
I've got an Elasticsearch pipeline grok processor to pull the timestamp out of a log file. Super simple. I tested it in the grok debugger and it works fine. The pipeline is super simple: { "description" : "Parse Dat… --- ## [Path Hierarchy Tokenization - Exclude results below certain depth](https://discuss.elastic.co/t/path-hierarchy-tokenization-exclude-results-below-certain-depth/164856)
**Author:** [@francisb](https://discuss.elastic.co/u/francisb)\ **Replies:** 2\ **Last updated:** [January 21, 2019, 4:03pm UTC](https://discuss.elastic.co/t/path-hierarchy-tokenization-exclude-results-below-certain-depth/164856 "2019-01-21T16:03:04Z")
Hi all, I'm attempting to search for all items at the current path level of my search and nothing lower. I have created an index like so: { "settings": { "analysis": { "analyzer": { "occupation\_hierarchy\_anal… --- ## [Query based string to match a regular expression](https://discuss.elastic.co/t/query-based-string-to-match-a-regular-expression/165077)
**Author:** [@maxime\_houe](https://discuss.elastic.co/u/maxime_houe)\ **Replies:** 0\ **Last updated:** [January 21, 2019, 3:26pm UTC](https://discuss.elastic.co/t/query-based-string-to-match-a-regular-expression/165077 "2019-01-21T15:26:01Z")
Hello, I know it is possible to make a regular expression query to match any string in a string based document on elasticsearch. But is it possible the other way around ? Can I make a query based on a string and match a… --- ## [Multi-region Elastic Cloud cluster?](https://discuss.elastic.co/t/multi-region-elastic-cloud-cluster/165060)
**Author:** [@xtrc](https://discuss.elastic.co/u/xtrc)\ **Replies:** 1\ **Last updated:** [January 21, 2019, 3:30pm UTC](https://discuss.elastic.co/t/multi-region-elastic-cloud-cluster/165060 "2019-01-21T15:30:17Z")
HI all, Does Elasticsearch provide support for multi-region clusters? Say I deploy 2 clusters (one in each region) would I then be able to utilize both and have the cluster replicate the data between the two? I was not… --- ## [How to get count along with parent in elastic search 6?](https://discuss.elastic.co/t/how-to-get-count-along-with-parent-in-elastic-search-6/165066)
**Author:** [@karan.j.shah](https://discuss.elastic.co/u/karan.j.shah)\ **Replies:** 0\ **Last updated:** [January 21, 2019, 2:35pm UTC](https://discuss.elastic.co/t/how-to-get-count-along-with-parent-in-elastic-search-6/165066 "2019-01-21T14:35:33Z")
Hi, I am using elastic search 6.3.0 and I have set up a parent-child relationship and I would like to be able to return a list of parents but also include the count of children per parent. Is there an easy way to do … --- ## [Query inner object without knowing parent key path](https://discuss.elastic.co/t/query-inner-object-without-knowing-parent-key-path/165030)
**Author:** [@Ijas\_ahamed](https://discuss.elastic.co/u/Ijas_ahamed)\ **Replies:** 3\ **Last updated:** [January 21, 2019, 2:06pm UTC](https://discuss.elastic.co/t/query-inner-object-without-knowing-parent-key-path/165030 "2019-01-21T14:06:18Z")
I have a items with below structure { "user\_id" : "unique id for the user", "minutes": { "2019-1-11T14:41:00.000Z": { "interest\_1" : { "count" : 2, "ob… --- ## [Nest : Bulk insert or update](https://discuss.elastic.co/t/nest-bulk-insert-or-update/165058)
**Author:** [@srikanthkadem](https://discuss.elastic.co/u/srikanthkadem)\ **Replies:** 0\ **Last updated:** [January 21, 2019, 2:01pm UTC](https://discuss.elastic.co/t/nest-bulk-insert-or-update/165058 "2019-01-21T14:01:10Z")
Hi , Can any one provide sample code to insertorupdate document into ES index. I tried below code but it is creating single document (i have 300 rows in sql). I want to have single method to insert or update as I am not… --- ## [Sorting on Sorting](https://discuss.elastic.co/t/sorting-on-sorting/164319)
**Author:** [@akhilsai1499](https://discuss.elastic.co/u/akhilsai1499)\ **Replies:** 5\ **Last updated:** [January 21, 2019, 1:32pm UTC](https://discuss.elastic.co/t/sorting-on-sorting/164319 "2019-01-21T13:32:01Z")
Hi Elastic Search Team, Thanks for the opportunity you gave us to ask the questions. I have one query on the sorting. Lets say we have sample data below: Name Date Rank A … --- ## [Unable to add List of string in a elastic document](https://discuss.elastic.co/t/unable-to-add-list-of-string-in-a-elastic-document/165052)
**Author:** [@sunilgjagtap](https://discuss.elastic.co/u/sunilgjagtap)\ **Replies:** 0\ **Last updated:** [January 21, 2019, 1:16pm UTC](https://discuss.elastic.co/t/unable-to-add-list-of-string-in-a-elastic-document/165052 "2019-01-21T13:16:34Z")
Using below code Index and document is created but List field is added in document. In elastic search plugin head Id, name are presents but list of tags field is missing. Please suggest how to store list data in elas… --- ## [Value Count Aggregation Documentation & example?](https://discuss.elastic.co/t/value-count-aggregation-documentation-example/165029)
**Author:** [@Wassim\_Ben\_Amor](https://discuss.elastic.co/u/Wassim_Ben_Amor)\ **Replies:** 1\ **Last updated:** [January 21, 2019, 12:39pm UTC](https://discuss.elastic.co/t/value-count-aggregation-documentation-example/165029 "2019-01-21T12:39:56Z")
Hello, I'm looking for more details of Value Count Aggregation because the existing doc dosen't really make it clear. I'm looking for a real example please. Thank you --- ## [Compression ratio](https://discuss.elastic.co/t/compression-ratio/164603)
**Author:** [@amitavmohanty01](https://discuss.elastic.co/u/amitavmohanty01)\ **Replies:** 7\ **Last updated:** [January 21, 2019, 12:18pm UTC](https://discuss.elastic.co/t/compression-ratio/164603 "2019-01-21T12:18:37Z")
Is there any way of getting the current compression ratio of an index? --- ## [Get doc count where two columns value are same](https://discuss.elastic.co/t/get-doc-count-where-two-columns-value-are-same/165035)
**Author:** [@examin](https://discuss.elastic.co/u/examin)\ **Replies:** 1\ **Last updated:** [January 21, 2019, 11:57am UTC](https://discuss.elastic.co/t/get-doc-count-where-two-columns-value-are-same/165035 "2019-01-21T11:57:45Z")
How to get count of search , where year=2019 and "start\_date"="end\_date". Please guide me how can this be done in java. --- ## [ElasticSearch with Java API - Mapping a complicated class with from a class or existing object](https://discuss.elastic.co/t/elasticsearch-with-java-api-mapping-a-complicated-class-with-from-a-class-or-existing-object/164954)
**Author:** [@Zalman\_Goldstein](https://discuss.elastic.co/u/Zalman_Goldstein)\ **Replies:** 0\ **Last updated:** [January 20, 2019, 6:22pm UTC](https://discuss.elastic.co/t/elasticsearch-with-java-api-mapping-a-complicated-class-with-from-a-class-or-existing-object/164954 "2019-01-20T18:22:03Z")
My class - "Transaction", is complicated with a lot of nested objects. There is a way to define the mapping straight from the class or an existing object? note: I am using the rest API with High-Level client. if there i… --- ## [Dns and ip not seen in node certificate](https://discuss.elastic.co/t/dns-and-ip-not-seen-in-node-certificate/164944)
**Author:** [@li\_jessen2016](https://discuss.elastic.co/u/li_jessen2016)\ **Replies:** 2\ **Last updated:** [January 21, 2019, 10:24am UTC](https://discuss.elastic.co/t/dns-and-ip-not-seen-in-node-certificate/164944 "2019-01-21T10:24:19Z")
Using bin/elasticsearch-certutil to create node certificate, with --name, --dns, --ip, then using openssl pkcs12 -info -in \, I can only see the CN (common name) of the certificate, but no dns an… --- ## [Spark to Elasticsearch - NoRouteToHostException when ES node fails](https://discuss.elastic.co/t/spark-to-elasticsearch-noroutetohostexception-when-es-node-fails/164492)
**Author:** [@patadaptive](https://discuss.elastic.co/u/patadaptive)\ **Replies:** 7\ **Last updated:** [January 21, 2019, 9:49am UTC](https://discuss.elastic.co/t/spark-to-elasticsearch-noroutetohostexception-when-es-node-fails/164492 "2019-01-21T09:49:39Z")
I have a 3 node Elasticsearch cluster configured to be fault tolerant in that the cluster will continue working fine if any 1 of the 3 nodes fail (or is just shutdown to simulate a failure). This works fine. I have an s… --- ## [Exception: TransportService is closed stopped can't send request](https://discuss.elastic.co/t/exception-transportservice-is-closed-stopped-cant-send-request/165007)
**Author:** [@ninjaMajewski](https://discuss.elastic.co/u/ninjaMajewski)\ **Replies:** 1\ **Last updated:** [January 21, 2019, 9:44am UTC](https://discuss.elastic.co/t/exception-transportservice-is-closed-stopped-cant-send-request/165007 "2019-01-21T09:44:55Z")
Hi, I have a server with ELK installed and today I restarted whole server and ELK didn't start. I didn't change any configuration or anything else. It was just a normal reboot. This is my exception from logs: ...skipp… --- ## [Elasticsearch Version](https://discuss.elastic.co/t/elasticsearch-version/165013)
**Author:** [@cmcdowell03](https://discuss.elastic.co/u/cmcdowell03)\ **Replies:** 2\ **Last updated:** [January 21, 2019, 9:15am UTC](https://discuss.elastic.co/t/elasticsearch-version/165013 "2019-01-21T09:15:13Z")
Does anyone happen to know when the next version of Elasticsearch will be released or the timeline of release? I would like to rollup to 6.5.4 from 6.5.3 but I don't want to do it then 6.5.5 get released within the next … --- ## [Queries on setting up new AWS ES domain](https://discuss.elastic.co/t/queries-on-setting-up-new-aws-es-domain/164243)
**Author:** [@Eva](https://discuss.elastic.co/u/Eva)\ **Replies:** 6\ **Last updated:** [January 21, 2019, 9:08am UTC](https://discuss.elastic.co/t/queries-on-setting-up-new-aws-es-domain/164243 "2019-01-21T09:08:10Z")
Hello there, I'm trying to configure a new AWS ES domain for Prod and would need to migrate existing elk cluster (running on ec2 instance) logs to the new AWS ES domain. The elk cluster on Prod is currently up and runni… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1418) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1420)