# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=850 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 851 --- ## [Elasticsearch sub aggregation not working with max](https://discuss.elastic.co/t/elasticsearch-sub-aggregation-not-working-with-max/242852)
**Author:** [@Raza\_Jamil](https://discuss.elastic.co/u/Raza_Jamil)\ **Replies:** 0\ **Last updated:** [July 28, 2020, 7:48am UTC](https://discuss.elastic.co/t/elasticsearch-sub-aggregation-not-working-with-max/242852 "2020-07-28T07:48:24Z")
I have nested data of shape: albums have tracks, tracks have versions. album: { tracks: \[ { id: 1, mainTrackID: 1, // mainTrackID = id means main track versions: \[ { … --- ## [Elastic Stack performance](https://discuss.elastic.co/t/elastic-stack-performance/242653)
**Author:** [@ArousOussema](https://discuss.elastic.co/u/ArousOussema)\ **Replies:** 2\ **Last updated:** [July 28, 2020, 7:05am UTC](https://discuss.elastic.co/t/elastic-stack-performance/242653 "2020-07-28T07:05:41Z")
Greetings, I'm a student at the Hochschule Darmstadt in Germany. I'm currently working on a project for my university, where we’re trying to find a suitable Log management tool for our big data cluster. It will be so h… --- ## [Use 2 version ES on one server](https://discuss.elastic.co/t/use-2-version-es-on-one-server/242415)
**Author:** [@YURA](https://discuss.elastic.co/u/YURA)\ **Replies:** 4\ **Last updated:** [July 28, 2020, 6:50am UTC](https://discuss.elastic.co/t/use-2-version-es-on-one-server/242415 "2020-07-28T06:50:10Z")
I have server CentOS 7, there is running ES version "number" : "6.4.0", can I install new version (version 7\*) and use both of them at the same time on one server? I wanna use 2 differet verion on server, is it possib… --- ## [Some indexes have been deleted, now I see indexes called meow?](https://discuss.elastic.co/t/some-indexes-have-been-deleted-now-i-see-indexes-called-meow/242731)
**Author:** [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Replies:** 2\ **Last updated:** [July 28, 2020, 6:41am UTC](https://discuss.elastic.co/t/some-indexes-have-been-deleted-now-i-see-indexes-called-meow/242731 "2020-07-28T06:41:42Z")
If you have seen a number of your indices recently "disappear", and then when checking your logs you see they have been deleted, and you can also see other log entries that mention the term meow, like this; \[t19hfzgnp7-… --- ## [Issue while Integrating spring-data-elasticsearch](https://discuss.elastic.co/t/issue-while-integrating-spring-data-elasticsearch/239224)
**Author:** [@Punj\_Shah](https://discuss.elastic.co/u/Punj_Shah)\ **Replies:** 0\ **Last updated:** [June 30, 2020, 5:44am UTC](https://discuss.elastic.co/t/issue-while-integrating-spring-data-elasticsearch/239224 "2020-06-30T05:44:41Z")
(topic withdrawn by author, will be automatically deleted in 24 hours unless flagged) --- ## [Setting up three node elasticsearch with security enabled having issues](https://discuss.elastic.co/t/setting-up-three-node-elasticsearch-with-security-enabled-having-issues/242825)
**Author:** [@abhilashkom](https://discuss.elastic.co/u/abhilashkom)\ **Replies:** 0\ **Last updated:** [July 28, 2020, 4:37am UTC](https://discuss.elastic.co/t/setting-up-three-node-elasticsearch-with-security-enabled-having-issues/242825 "2020-07-28T04:37:52Z")
I am trying to setup thre node Elasticsearch(three nodes configured as master/data) security xpack enabled. started servers elasticsearch is accepting connections only on localhost:9300 port, discovery is failing. pleas… --- ## [Sharepoint online connector](https://discuss.elastic.co/t/sharepoint-online-connector/242722)
**Author:** [@adityaPsl](https://discuss.elastic.co/u/adityaPsl)\ **Replies:** 0\ **Last updated:** [July 27, 2020, 9:33am UTC](https://discuss.elastic.co/t/sharepoint-online-connector/242722 "2020-07-27T09:33:42Z")
Hello Team, we have multiple sources like database, csv,jms and sharepoint online , we also need to do data transformation and enrichment. so we were planning to use logstash , Could you please help me understand if the… --- ## [Rollover alias to new index](https://discuss.elastic.co/t/rollover-alias-to-new-index/242629)
**Author:** [@vicky0639](https://discuss.elastic.co/u/vicky0639)\ **Replies:** 15\ **Last updated:** [July 27, 2020, 10:38pm UTC](https://discuss.elastic.co/t/rollover-alias-to-new-index/242629 "2020-07-27T22:38:55Z")
hi, I created a rollover index and alias. The alias is pointing to new as well as old index when i try to read data from alias. how can i remove the old index from alias? Thanks Vicky --- ## [How to serializing json object to string in ingest node](https://discuss.elastic.co/t/how-to-serializing-json-object-to-string-in-ingest-node/242565)
**Author:** [@android.kc](https://discuss.elastic.co/u/android.kc)\ **Replies:** 6\ **Last updated:** [July 27, 2020, 9:56pm UTC](https://discuss.elastic.co/t/how-to-serializing-json-object-to-string-in-ingest-node/242565 "2020-07-27T21:56:37Z")
I am trying to convert json objects with certain key pattern to string by using ingest API. for example, { "myObject": { "toSerialize\_A": {"key\_a": "a"}, "toSerialize\_B": {"key\_b": "b"}, "toSerialize\_C": … --- ## [All (non-redundant) values of a list of fields](https://discuss.elastic.co/t/all-non-redundant-values-of-a-list-of-fields/242743)
**Author:** [@Florent\_Fauvin](https://discuss.elastic.co/u/Florent_Fauvin)\ **Replies:** 1\ **Last updated:** [July 27, 2020, 8:07pm UTC](https://discuss.elastic.co/t/all-non-redundant-values-of-a-list-of-fields/242743 "2020-07-27T20:07:19Z")
Hello, I would like to know which Elastic query can give me all (non-redundant) values ​​of a list of fields. For example, I would like to know all the possible values ​​contained in field: User, SubjectUser, UserName? … --- ## [REST API to fetch values based on Terms aggregation](https://discuss.elastic.co/t/rest-api-to-fetch-values-based-on-terms-aggregation/241188)
**Author:** [@Venkat\_Raj](https://discuss.elastic.co/u/Venkat_Raj)\ **Replies:** 2\ **Last updated:** [July 27, 2020, 7:55pm UTC](https://discuss.elastic.co/t/rest-api-to-fetch-values-based-on-terms-aggregation/241188 "2020-07-27T19:55:29Z")
Hi All, I have a requirement to fetch data from Elasticsearch based on Term aggregation. I need to build a request using terms aggregation where I need to groupby a particular field name and then fetch other fields corr… --- ## [ElasticSearch clone the cluster from existing](https://discuss.elastic.co/t/elasticsearch-clone-the-cluster-from-existing/242791)
**Author:** [@bhuvaneshdct](https://discuss.elastic.co/u/bhuvaneshdct)\ **Replies:** 3\ **Last updated:** [July 27, 2020, 6:08pm UTC](https://discuss.elastic.co/t/elasticsearch-clone-the-cluster-from-existing/242791 "2020-07-27T18:08:20Z")
I have 2 nodes ES cluster(on GCP platform), I want to clone this and need to create a new cluster. I have taken the image of the current Node1 and 2 then create the VMs. Then modified these settings as per the new clus… --- ## [X-pack and sql in python](https://discuss.elastic.co/t/x-pack-and-sql-in-python/242685)
**Author:** [@chezhian](https://discuss.elastic.co/u/chezhian)\ **Replies:** 2\ **Last updated:** [July 27, 2020, 5:57pm UTC](https://discuss.elastic.co/t/x-pack-and-sql-in-python/242685 "2020-07-27T17:57:21Z")
Trying to see how i can call the x-pack sql feature in python. Am I invoking xpack client correctly AttributeError: 'XPackClient' object has no attribute 'sql' from elasticsearch import Elasticsearch, RequestsHttpConne… --- ## [Fuzzy search on Name having multiple words in it](https://discuss.elastic.co/t/fuzzy-search-on-name-having-multiple-words-in-it/242777)
**Author:** [@meena](https://discuss.elastic.co/u/meena)\ **Replies:** 0\ **Last updated:** [July 27, 2020, 3:40pm UTC](https://discuss.elastic.co/t/fuzzy-search-on-name-having-multiple-words-in-it/242777 "2020-07-27T15:40:54Z")
HI, Am trying to do a fuzzy search on the name field which has 2 words in it like name : Residentie Verdé search text : "Residentie Verd" when i do the search i get all the matches of Residentie and all the matches o… --- ## [Use case to use Elasticsearch](https://discuss.elastic.co/t/use-case-to-use-elasticsearch/242620)
**Author:** [@maconportter](https://discuss.elastic.co/u/maconportter)\ **Replies:** 4\ **Last updated:** [July 27, 2020, 3:29pm UTC](https://discuss.elastic.co/t/use-case-to-use-elasticsearch/242620 "2020-07-27T15:29:33Z")
I need to create a system where the user creates dynamic filters based on our customer's attributes. There are more or less 30 possible filters and 30 millions of customers, but the number of customer increase every day … --- ## [ES 7.5 - Custom plugin, only calling local shards](https://discuss.elastic.co/t/es-7-5-custom-plugin-only-calling-local-shards/242757)
**Author:** [@JF2018](https://discuss.elastic.co/u/JF2018)\ **Replies:** 0\ **Last updated:** [July 27, 2020, 2:00pm UTC](https://discuss.elastic.co/t/es-7-5-custom-plugin-only-calling-local-shards/242757 "2020-07-27T14:00:08Z")
Hi I have written a custom plugin in ES 7.5.2. My problem is, when calling the plugin, it only looks in the local shards, and not in shards on other nodes. This means I have to have all shards on every node, to make i… --- ## [Boosting search results based on the number of items in a nested object](https://discuss.elastic.co/t/boosting-search-results-based-on-the-number-of-items-in-a-nested-object/242357)
**Author:** [@waynesmallman](https://discuss.elastic.co/u/waynesmallman)\ **Replies:** 1\ **Last updated:** [July 27, 2020, 1:33pm UTC](https://discuss.elastic.co/t/boosting-search-results-based-on-the-number-of-items-in-a-nested-object/242357 "2020-07-27T13:33:09Z")
Hi! I have an index that contains a nested object: "links\_to\_asset": { "type": "nested", "properties": { "note\_link\_id": { "type": "long" }, "user\_id": { "type": "long" }, "to\_asset": { "type": "in… --- ## [ES 6.5.1 Two nodes not connecting into cluster using ssl certificate](https://discuss.elastic.co/t/es-6-5-1-two-nodes-not-connecting-into-cluster-using-ssl-certificate/241997)
**Author:** [@MMH](https://discuss.elastic.co/u/MMH)\ **Replies:** 5\ **Last updated:** [July 27, 2020, 1:06pm UTC](https://discuss.elastic.co/t/es-6-5-1-two-nodes-not-connecting-into-cluster-using-ssl-certificate/241997 "2020-07-27T13:06:27Z")
I am trying to configure 2 node cluster for Elasticsearch 6.5.1 on Debian 10 machines. For each cluster I installed Elasticsearch instance from apt-get. I also generated certificate keys using ca.crt and ca.key files I… --- ## [Searching using NOT IN](https://discuss.elastic.co/t/searching-using-not-in/242403)
**Author:** [@mfwstchas](https://discuss.elastic.co/u/mfwstchas)\ **Replies:** 1\ **Last updated:** [July 27, 2020, 12:44pm UTC](https://discuss.elastic.co/t/searching-using-not-in/242403 "2020-07-27T12:44:19Z")
I'm using the below post in Akana and it returns all records with a paymentReasonCode of 426 or 427. "companyCode": \["10"\], "customerNumber":\["52526"\], "searchString":\["IN paymentReasonCode.keyword :426,427"\] Is ther… --- ## [All the names of fields, containing a specific value](https://discuss.elastic.co/t/all-the-names-of-fields-containing-a-specific-value/242745)
**Author:** [@Florent\_Fauvin](https://discuss.elastic.co/u/Florent_Fauvin)\ **Replies:** 1\ **Last updated:** [July 27, 2020, 12:30pm UTC](https://discuss.elastic.co/t/all-the-names-of-fields-containing-a-specific-value/242745 "2020-07-27T12:30:56Z")
Hello, I would like to know which Elastic query can give me all the names of fields, containing a specific value ? (I don't want the value of the fields, just their name) Thank you very much, Florent --- ## [Rollup Jobs and Limitations / Data Types](https://discuss.elastic.co/t/rollup-jobs-and-limitations-data-types/242728)
**Author:** [@michaelpietzsch](https://discuss.elastic.co/u/michaelpietzsch)\ **Replies:** 2\ **Last updated:** [July 27, 2020, 11:18am UTC](https://discuss.elastic.co/t/rollup-jobs-and-limitations-data-types/242728 "2020-07-27T11:18:23Z")
Hi Guys, I'm new to rollup jobs and I wanted to ask your opinion on some of the issues I'm encountering. Question One: How to handle different data types such as IP Here's my way of seeing it: Rollup jobs have to mai… --- ## [Elasticsearch: adding a second node to the cluster - \[node-1\] master not discovered yet: have discovered \[{node-1}](https://discuss.elastic.co/t/elasticsearch-adding-a-second-node-to-the-cluster-node-1-master-not-discovered-yet-have-discovered-node-1/242529)
**Author:** [@pauleccm](https://discuss.elastic.co/u/pauleccm)\ **Replies:** 7\ **Last updated:** [July 27, 2020, 10:37am UTC](https://discuss.elastic.co/t/elasticsearch-adding-a-second-node-to-the-cluster-node-1-master-not-discovered-yet-have-discovered-node-1/242529 "2020-07-27T10:37:44Z")
I am trying to obtain a two nodes cluster. First node, master (master-1): cluster.name: "admin\_system\_elk" network.host: 0.0.0.0 node.name: "master-1" discovery.seed\_hosts: "localhost:9300" cluster.initial\_master\_nodes… --- ## [Send out email alert when some index do not receive data anymore](https://discuss.elastic.co/t/send-out-email-alert-when-some-index-do-not-receive-data-anymore/242719)
**Author:** [@iammanmale](https://discuss.elastic.co/u/iammanmale)\ **Replies:** 1\ **Last updated:** [July 27, 2020, 10:24am UTC](https://discuss.elastic.co/t/send-out-email-alert-when-some-index-do-not-receive-data-anymore/242719 "2020-07-27T10:24:15Z")
Sometimes, some index in my ELK stop receiving data for some reasons, is there any way to notify me by email if something like that happen? --- ## [Overwriting new document?](https://discuss.elastic.co/t/overwriting-new-document/242729)
**Author:** [@Tuckson](https://discuss.elastic.co/u/Tuckson)\ **Replies:** 4\ **Last updated:** [July 27, 2020, 10:19am UTC](https://discuss.elastic.co/t/overwriting-new-document/242729 "2020-07-27T10:19:27Z")
Hi, Recently I did a fresh install of elk 7.7 . I did a successfull attempt of creaing a POC and now try to build up a full environment. However, When I send a log via filebeatand logstash to ES, somehow every new docum… --- ## [Elasticsearch query for 2 Parts without changing/splitting query in PHP](https://discuss.elastic.co/t/elasticsearch-query-for-2-parts-without-changing-splitting-query-in-php/242681)
**Author:** [@bastimm](https://discuss.elastic.co/u/bastimm)\ **Replies:** 0\ **Last updated:** [July 27, 2020, 4:37am UTC](https://discuss.elastic.co/t/elasticsearch-query-for-2-parts-without-changing-splitting-query-in-php/242681 "2020-07-27T04:37:23Z")
Hello, everyone, many years ago I built a search for a webshop with Elasticsearch. Now I like to update it. One question, if i.e. i search for "iphone 11 MWLT2ZD", i want to search for "iphone" or "11" or "MWLT2ZD". N… --- ## [I'm new and can you help me with the meaning](https://discuss.elastic.co/t/im-new-and-can-you-help-me-with-the-meaning/242724)
**Author:** [@fatih\_erol](https://discuss.elastic.co/u/fatih_erol)\ **Replies:** 1\ **Last updated:** [July 27, 2020, 9:52am UTC](https://discuss.elastic.co/t/im-new-and-can-you-help-me-with-the-meaning/242724 "2020-07-27T09:52:04Z")
Hello, my data is on Sql server and I want to use ElasticSearch. Does ElasticSearch mean that there will also be a copy of the data? Thank you --- ## [I need Help for sort ordering most words occurrence with Query string Search](https://discuss.elastic.co/t/i-need-help-for-sort-ordering-most-words-occurrence-with-query-string-search/242511)
**Author:** [@anup786saini](https://discuss.elastic.co/u/anup786saini)\ **Replies:** 2\ **Last updated:** [July 27, 2020, 9:26am UTC](https://discuss.elastic.co/t/i-need-help-for-sort-ordering-most-words-occurrence-with-query-string-search/242511 "2020-07-27T09:26:34Z")
{ "title":"javascript,seo,javascript,c#,html,javascript"} { "title":"javascript,wordpress,seo,javascript,c#,html"} { "title":"javascript,wordpress,seo,c#,html,wordpress,wordpress"} { "title":"javascript,wordpress,seo,… --- ## [How to determine if one of master gone from cluster?](https://discuss.elastic.co/t/how-to-determine-if-one-of-master-gone-from-cluster/241171)
**Author:** [@byumov](https://discuss.elastic.co/u/byumov)\ **Replies:** 12\ **Last updated:** [July 27, 2020, 9:08am UTC](https://discuss.elastic.co/t/how-to-determine-if-one-of-master-gone-from-cluster/241171 "2020-07-27T09:08:35Z")
Hi! I have a clean and simple installation os ES: 9 nodes: 6 data and 3 masters(without data). I want to determine situation when one of masters gone for some reason(power off). How I can do it on 7 ES? I looked at /\_… --- ## [Passing script\_fields to Perl elasticsearch client](https://discuss.elastic.co/t/passing-script-fields-to-perl-elasticsearch-client/242647)
**Author:** [@igorid70](https://discuss.elastic.co/u/igorid70)\ **Replies:** 1\ **Last updated:** [July 27, 2020, 8:27am UTC](https://discuss.elastic.co/t/passing-script-fields-to-perl-elasticsearch-client/242647 "2020-07-27T08:27:25Z")
Hi I use Elastic stack 6.8 and connect to extract certain documents based on parameters provided in input files with Elasticsearch official Perl client. All works well but I am unable to pass script\_fields parameter . … --- ## [java.sql.SQLException: This version of the JDBC driver is only compatible with Elasticsearch version vUnknown \[Unknown\], attempting to connect to a server version 7.5.1](https://discuss.elastic.co/t/java-sql-sqlexception-this-version-of-the-jdbc-driver-is-only-compatible-with-elasticsearch-version-vunknown-unknown-attempting-to-connect-to-a-server-version-7-5-1/242698)
**Author:** [@liujiehaobang](https://discuss.elastic.co/u/liujiehaobang)\ **Replies:** 2\ **Last updated:** [July 27, 2020, 7:51am UTC](https://discuss.elastic.co/t/java-sql-sqlexception-this-version-of-the-jdbc-driver-is-only-compatible-with-elasticsearch-version-vunknown-unknown-attempting-to-connect-to-a-server-version-7-5-1/242698 "2020-07-27T07:51:55Z")
java.sql.SQLException: This version of the JDBC driver is only compatible with Elasticsearch version vUnknown \[Unknown\], attempting to connect to a server version 7.5.1 [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=849) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=851)