# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=499 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 500 --- ## [More\_like\_this not using nested fields?](https://discuss.elastic.co/t/more-like-this-not-using-nested-fields/296311)
**Author:** [@ndtreviv](https://discuss.elastic.co/u/ndtreviv)\ **Replies:** 0\ **Last updated:** [February 4, 2022, 2:27pm UTC](https://discuss.elastic.co/t/more-like-this-not-using-nested-fields/296311 "2022-02-04T14:27:47Z")
I want to use the more like this query type to find similar documents without having to construct a bool. I like the minimum\_should\_match as a percent to identify %-similar documents. My document has lots of nested fiel… --- ## [Elasticsearch - monitoring query response times](https://discuss.elastic.co/t/elasticsearch-monitoring-query-response-times/296306)
**Author:** [@MSaneme](https://discuss.elastic.co/u/MSaneme)\ **Replies:** 0\ **Last updated:** [February 4, 2022, 2:00pm UTC](https://discuss.elastic.co/t/elasticsearch-monitoring-query-response-times/296306 "2022-02-04T14:00:57Z")
I would like to perform a study of the response time provided by Elasticsearch for different spatio-temporal queries. Is there any way to know the response times for each query executed on a given index? I am working w… --- ## [Elasticsearch authentication in Docker Swarm mode](https://discuss.elastic.co/t/elasticsearch-authentication-in-docker-swarm-mode/296293)
**Author:** [@FleaLes](https://discuss.elastic.co/u/FleaLes)\ **Replies:** 7\ **Last updated:** [February 4, 2022, 1:55pm UTC](https://discuss.elastic.co/t/elasticsearch-authentication-in-docker-swarm-mode/296293 "2022-02-04T13:55:28Z")
I have upgraded my Dev environment ELK stack to v 7.10.2 and I have authentication issues with connecting Kibana to Elasticsearch. Scenario The ELK stack is in Docker containers deployed in Swarm mode via a docker-comp… --- ## [Elastic migration](https://discuss.elastic.co/t/elastic-migration/296298)
**Author:** [@Petr\_Bucek](https://discuss.elastic.co/u/Petr_Bucek)\ **Replies:** 0\ **Last updated:** [February 4, 2022, 1:21pm UTC](https://discuss.elastic.co/t/elastic-migration/296298 "2022-02-04T13:21:47Z")
Hello, I have general question. I have elastic on-prem solution in old DC. (that DC will be decommissioned and we cannot move the physical servers) I need to migrate from one DC (on-prem solution) to another DC (virtu… --- ## [Local Storage Full](https://discuss.elastic.co/t/local-storage-full/296078)
**Author:** [@eprop-marc](https://discuss.elastic.co/u/eprop-marc)\ **Replies:** 6\ **Last updated:** [February 4, 2022, 11:43am UTC](https://discuss.elastic.co/t/local-storage-full/296078 "2022-02-04T11:43:18Z")
Hi, the local storage on my ELK stack is 95% full and I can no longer see logs in Elastic. I just wanted some advice on how best to reduce the storage on the local disk please and start using Elastic again. I don't reall… --- ## [Query on Elasticsearch license updates](https://discuss.elastic.co/t/query-on-elasticsearch-license-updates/294900)
**Author:** [@mohammed.sabil](https://discuss.elastic.co/u/mohammed.sabil)\ **Replies:** 4\ **Last updated:** [February 4, 2022, 10:13am UTC](https://discuss.elastic.co/t/query-on-elasticsearch-license-updates/294900 "2022-02-04T10:13:16Z")
Hello Team, I would like to know about the licencing changes in Elasticsearch. Currently I am using Elasticsearch 7.16.2 along with Filebeat. I heard that there some changes in lincencing of Elasticsearch. We are comp… --- ## [Using multiple similarity metrics on an existing index](https://discuss.elastic.co/t/using-multiple-similarity-metrics-on-an-existing-index/296274)
**Author:** [@mkaze](https://discuss.elastic.co/u/mkaze)\ **Replies:** 0\ **Last updated:** [February 4, 2022, 10:03am UTC](https://discuss.elastic.co/t/using-multiple-similarity-metrics-on-an-existing-index/296274 "2022-02-04T10:03:55Z")
I was wondering if it's possible to use multiple similarity metrics for an index in Elasticsearch. Let's assume I have already defined an index with a customized BM25 similarity metric (say, with b=1), and now I would li… --- ## [Alternative for Template Query in ES 7.x (Search template call/pass to another template)](https://discuss.elastic.co/t/alternative-for-template-query-in-es-7-x-search-template-call-pass-to-another-template/296265)
**Author:** [@mjwahyudi](https://discuss.elastic.co/u/mjwahyudi)\ **Replies:** 0\ **Last updated:** [February 4, 2022, 8:23am UTC](https://discuss.elastic.co/t/alternative-for-template-query-in-es-7-x-search-template-call-pass-to-another-template/296265 "2022-02-04T08:23:06Z")
Hi All, I have task to migrate old query from ES 5.x that built/migrated from ES 2.x (it is so old). In the query, it is using template query (Template Query | Elasticsearch Reference \[5.6\] | Elastic). When I try to us… --- ## [What if the number of shards and replicas is different in CCR?](https://discuss.elastic.co/t/what-if-the-number-of-shards-and-replicas-is-different-in-ccr/296141)
**Author:** [@True](https://discuss.elastic.co/u/True)\ **Replies:** 1\ **Last updated:** [February 3, 2022, 8:35pm UTC](https://discuss.elastic.co/t/what-if-the-number-of-shards-and-replicas-is-different-in-ccr/296141 "2022-02-03T20:35:40Z")
Hello. When setting CCR, does it not have to be the same setting as the leader index and follower index? For example, what if the number of shards and replicas is different because the cluster size is different? I want … --- ## [Elastic search Nest (.Net) Total and Documents don't match](https://discuss.elastic.co/t/elastic-search-nest-net-total-and-documents-dont-match/296218)
**Author:** [@kqgcm](https://discuss.elastic.co/u/kqgcm)\ **Replies:** 1\ **Last updated:** [February 3, 2022, 7:59pm UTC](https://discuss.elastic.co/t/elastic-search-nest-net-total-and-documents-dont-match/296218 "2022-02-03T19:59:41Z")
I'm having the following situation: the Total from the Valid Nest Response is equals 2 and the Documents count equal 0. I'm not sure how that is possible. In the code, I track down the total hits: result = base.\_elasti… --- ## [Geo\_shape query not returning any results in java api](https://discuss.elastic.co/t/geo-shape-query-not-returning-any-results-in-java-api/296213)
**Author:** [@jjc](https://discuss.elastic.co/u/jjc)\ **Replies:** 1\ **Last updated:** [February 3, 2022, 5:59pm UTC](https://discuss.elastic.co/t/geo-shape-query-not-returning-any-results-in-java-api/296213 "2022-02-03T17:59:41Z")
Hi guys, i'm trying to find if a point lies within a certain geographic boundary with the java api. i have a geo\_shape mapping for a field called citybounds (text below copied from kibana): { "mapping": { "prope… --- ## [Failed to start Elasticsearch \[7.16.3\] \[Ubuntu 20.04\]](https://discuss.elastic.co/t/failed-to-start-elasticsearch-7-16-3-ubuntu-20-04/295991)
**Author:** [@Arkoos62](https://discuss.elastic.co/u/Arkoos62)\ **Replies:** 18\ **Last updated:** [February 3, 2022, 5:56pm UTC](https://discuss.elastic.co/t/failed-to-start-elasticsearch-7-16-3-ubuntu-20-04/295991 "2022-02-03T17:56:58Z")
Hello there, I have installed Elasticsearch trough the apt on my vps ubuntu 20.04, i just followed the installation guide from here : Install Elasticsearch with Debian Package | Elasticsearch Guide \[7.17\] | Elastic I c… --- ## [Sizing of elastic cluster](https://discuss.elastic.co/t/sizing-of-elastic-cluster/296186)
**Author:** [@Rus](https://discuss.elastic.co/u/Rus)\ **Replies:** 1\ **Last updated:** [February 3, 2022, 4:07pm UTC](https://discuss.elastic.co/t/sizing-of-elastic-cluster/296186 "2022-02-03T16:07:30Z")
Currently I have a 3 node (DATA+MASTER). One node (CLIENT) with 24 gig RAM. The besic info of cluster now is JVM Heap 38.7 GB / 64.0 GB Documents 1281635203 Data1.1 TB Indices 636 Total shards 6032 re… --- ## [Can I replace a dead primary shard with the ok-replica?](https://discuss.elastic.co/t/can-i-replace-a-dead-primary-shard-with-the-ok-replica/296174)
**Author:** [@ndtreviv](https://discuss.elastic.co/u/ndtreviv)\ **Replies:** 2\ **Last updated:** [February 3, 2022, 3:16pm UTC](https://discuss.elastic.co/t/can-i-replace-a-dead-primary-shard-with-the-ok-replica/296174 "2022-02-03T15:16:50Z")
I had a situation last night where a node left the cluster and I lost some primary shards. It rejoined, and the shards are showing up as UNASSIGNED with no documents: { "index": "my-index", "shard": "0", "… --- ## [Counting each key of an array inside aggregation](https://discuss.elastic.co/t/counting-each-key-of-an-array-inside-aggregation/296060)
**Author:** [@hugomeloo](https://discuss.elastic.co/u/hugomeloo)\ **Replies:** 4\ **Last updated:** [February 3, 2022, 3:06pm UTC](https://discuss.elastic.co/t/counting-each-key-of-an-array-inside-aggregation/296060 "2022-02-03T15:06:41Z")
I am trying to make an aggregation in which I can count the number of times each key specific of an array is repeated. As an example: curl -XPUT "localhost:9200/products/\_mapping" -H 'Content-Type: application/json' -d'… --- ## [Can i export data from elasticsearch into mongodb database?](https://discuss.elastic.co/t/can-i-export-data-from-elasticsearch-into-mongodb-database/296118)
**Author:** [@alex\_vermex](https://discuss.elastic.co/u/alex_vermex)\ **Replies:** 3\ **Last updated:** [February 3, 2022, 3:03pm UTC](https://discuss.elastic.co/t/can-i-export-data-from-elasticsearch-into-mongodb-database/296118 "2022-02-03T15:03:17Z")
Hi, I would like to know can I export data from Elasticsearch to mongodb? or from Elasticsearch to another database? I prefer Mongodb but if it is not possible I would like to know which database can I use and how if th… --- ## [Snapshots not running as scheduled](https://discuss.elastic.co/t/snapshots-not-running-as-scheduled/295714)
**Author:** [@mwise29](https://discuss.elastic.co/u/mwise29)\ **Replies:** 5\ **Last updated:** [February 3, 2022, 2:26pm UTC](https://discuss.elastic.co/t/snapshots-not-running-as-scheduled/295714 "2022-02-03T14:26:50Z")
I configured a snapshot cron schedule and just recently it stopped running. We restarted Elasticsearch and that didn't fix it. We restarted the nodes and that also did not fix it. I re-created the policy and that also… --- ## [Unable to get all indices in the data folder that have been reindexed from 5.6 to 6.8 however I can see indices when I use query \_cat /indices](https://discuss.elastic.co/t/unable-to-get-all-indices-in-the-data-folder-that-have-been-reindexed-from-5-6-to-6-8-however-i-can-see-indices-when-i-use-query-cat-indices/295686)
**Author:** [@rutika\_kamble](https://discuss.elastic.co/u/rutika_kamble)\ **Replies:** 8\ **Last updated:** [February 3, 2022, 1:23pm UTC](https://discuss.elastic.co/t/unable-to-get-all-indices-in-the-data-folder-that-have-been-reindexed-from-5-6-to-6-8-however-i-can-see-indices-when-i-use-query-cat-indices/295686 "2022-02-03T13:23:21Z")
Unable to get all indices in the data folder that have been reindexed from 5.6 to 6.8 however I can see indices when I use query \_cat /indices PFA attachments please suggest here something --- ## [SQL metadata interface (SHOW TABLE) not showing DataStreams](https://discuss.elastic.co/t/sql-metadata-interface-show-table-not-showing-datastreams/288618)
**Author:** [@JPMoresmau](https://discuss.elastic.co/u/JPMoresmau)\ **Replies:** 1\ **Last updated:** [February 2, 2022, 5:25pm UTC](https://discuss.elastic.co/t/sql-metadata-interface-show-table-not-showing-datastreams/288618 "2022-02-02T17:25:33Z")
Hello, I have defined a data stream with backing indices and an index policy. So far so good. POST http://localhost:9200/\_sql?format=txt Content-Type: application/json { "query": "select \* from \\"my-data-stream\\"" } … --- ## [Regexp query for phrase](https://discuss.elastic.co/t/regexp-query-for-phrase/296026)
**Author:** [@Divyank\_Garg](https://discuss.elastic.co/u/Divyank_Garg)\ **Replies:** 6\ **Last updated:** [February 3, 2022, 12:50pm UTC](https://discuss.elastic.co/t/regexp-query-for-phrase/296026 "2022-02-03T12:50:27Z")
I need to search for two signature pattern with 'and' operator between two phrase. How to write the query for that. In these two phrase I as shown below the \* means any number or value between 0-9 can be taken into consi… --- ## [Ingest node doesn't process log](https://discuss.elastic.co/t/ingest-node-doesnt-process-log/296112)
**Author:** [@UweW](https://discuss.elastic.co/u/UweW)\ **Replies:** 2\ **Last updated:** [February 3, 2022, 12:31pm UTC](https://discuss.elastic.co/t/ingest-node-doesnt-process-log/296112 "2022-02-03T12:31:35Z")
Hi, logs per second are growing and I want to move the ingest load from the data nodes to ingest only nodes. I have added an additional Elasticsearch ingest only node but I can see in the ingest stats, that the processe… --- ## [Elastic Cloud IP Address](https://discuss.elastic.co/t/elastic-cloud-ip-address/296117)
**Author:** [@teamomni](https://discuss.elastic.co/u/teamomni)\ **Replies:** 2\ **Last updated:** [February 3, 2022, 11:45am UTC](https://discuss.elastic.co/t/elastic-cloud-ip-address/296117 "2022-02-03T11:45:07Z")
Our firewalls have been getting hit by several IP address that are from within the United States, and we would like to verify that it is not related to communication with our Elastic Agents and the Elastic Cloud. Is the… --- ## [I have a problem help me](https://discuss.elastic.co/t/i-have-a-problem-help-me/296088)
**Author:** [@slowup](https://discuss.elastic.co/u/slowup)\ **Replies:** 4\ **Last updated:** [February 3, 2022, 11:43am UTC](https://discuss.elastic.co/t/i-have-a-problem-help-me/296088 "2022-02-03T11:43:33Z")
It is an index where data is continuously flowing in. As a result, merges continue to occur, the query cache goes down, and as a result, I/O increases again. What should I do? below is 1 hour below is 3 hou… --- ## [Hot to get all results in the Dev Tools](https://discuss.elastic.co/t/hot-to-get-all-results-in-the-dev-tools/296178)
**Author:** [@ShayWeizman](https://discuss.elastic.co/u/ShayWeizman)\ **Replies:** 2\ **Last updated:** [February 3, 2022, 11:14am UTC](https://discuss.elastic.co/t/hot-to-get-all-results-in-the-dev-tools/296178 "2022-02-03T11:14:55Z")
Hi All, I'm using 7.16.2, When I run query in the dev tools I get only 10 first results... How can I get all the query results? Thanks, Shay --- ## [Error with \_sql query with curl](https://discuss.elastic.co/t/error-with-sql-query-with-curl/295232)
**Author:** [@rodri.gz](https://discuss.elastic.co/u/rodri.gz)\ **Replies:** 4\ **Last updated:** [February 3, 2022, 10:05am UTC](https://discuss.elastic.co/t/error-with-sql-query-with-curl/295232 "2022-02-03T10:05:57Z")
Hello ! I am trying to cast a query to my Elasticsearch cluster. When I use where with numeric fields, everything works correctly, but when I try to use it with text fields, problems appear. What would be the correct s… --- ## [How to nested and other field search](https://discuss.elastic.co/t/how-to-nested-and-other-field-search/296147)
**Author:** [@sramana235](https://discuss.elastic.co/u/sramana235)\ **Replies:** 1\ **Last updated:** [February 3, 2022, 7:11am UTC](https://discuss.elastic.co/t/how-to-nested-and-other-field-search/296147 "2022-02-03T07:11:59Z")
Hello! I want to know about the search conditions. { "query": { "nested": { "path": "others", "query": { "bool": { "must": \[ { "match": { "others.key": "0204key" } }, … --- ## [ELK Query For Percentage](https://discuss.elastic.co/t/elk-query-for-percentage/296149)
**Author:** [@Prasanth\_V](https://discuss.elastic.co/u/Prasanth_V)\ **Replies:** 2\ **Last updated:** [February 3, 2022, 6:58am UTC](https://discuss.elastic.co/t/elk-query-for-percentage/296149 "2022-02-03T06:58:52Z")
Hi Team, We have three fields like, system.memory.total: 8181809152 system.memory.actual.used.bytes: 1474260992 system.memory.actual.free: 6707548160 Is it possible to write a query for more than 80 percentage of … --- ## [How to pagination many data?(data count example 100,000)](https://discuss.elastic.co/t/how-to-pagination-many-data-data-count-example-100-000/295205)
**Author:** [@sramana235](https://discuss.elastic.co/u/sramana235)\ **Replies:** 2\ **Last updated:** [February 3, 2022, 5:58am UTC](https://discuss.elastic.co/t/how-to-pagination-many-data-data-count-example-100-000/295205 "2022-02-03T05:58:08Z")
I want to display more than 100,000 data on a 1page 10data. For example, when i press page 1023, Data from 10221 to 10230 should be displayed. In this case, should I use 'search after' instead of 'scroll'? If it is be… --- ## [Removing original index after split](https://discuss.elastic.co/t/removing-original-index-after-split/296073)
**Author:** [@kalikasan](https://discuss.elastic.co/u/kalikasan)\ **Replies:** 1\ **Last updated:** [February 2, 2022, 11:11pm UTC](https://discuss.elastic.co/t/removing-original-index-after-split/296073 "2022-02-02T23:11:57Z")
Hi, I've got a single shard index of 75GB taking 40% of my physical disk space (according to df) which I needed to split into two shards. After the split, the disk space taken by the new index is around the double of th… --- ## [How to update date field type to a string in ES?](https://discuss.elastic.co/t/how-to-update-date-field-type-to-a-string-in-es/296131)
**Author:** [@srk1](https://discuss.elastic.co/u/srk1)\ **Replies:** 3\ **Last updated:** [February 2, 2022, 10:57pm UTC](https://discuss.elastic.co/t/how-to-update-date-field-type-to-a-string-in-es/296131 "2022-02-02T22:57:41Z")
Hi ES team, I am trying to build a custom ES template where one field would occasionally passes a string that matches with date format causing mapping conflicts and dropping of data by logstash. If i try to disable a… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=498) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=500)