# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=637 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 638 --- ## [Aggregeations with different keys and values (label and ID)](https://discuss.elastic.co/t/aggregeations-with-different-keys-and-values-label-and-id/274218)
**Author:** [@Julian\_Klotz](https://discuss.elastic.co/u/Julian_Klotz)\ **Replies:** 2\ **Last updated:** [May 31, 2021, 8:39am UTC](https://discuss.elastic.co/t/aggregeations-with-different-keys-and-values-label-and-id/274218 "2021-05-31T08:39:38Z")
Dear ES community, I hope someone can help me out with a (honestly) very basic question. I’m posting this because I couldn’t find a simple answer, to my surprise. Let’s say I have a blog post indexed in ES (example bel… --- ## [How to create temporary tables in beeline SparkSQL for ElasticSearch. ElasticSearch is behind HAProxy](https://discuss.elastic.co/t/how-to-create-temporary-tables-in-beeline-sparksql-for-elasticsearch-elasticsearch-is-behind-haproxy/274461)
**Author:** [@Chilaka\_Ramakrishna](https://discuss.elastic.co/u/Chilaka_Ramakrishna)\ **Replies:** 2\ **Last updated:** [May 31, 2021, 8:20am UTC](https://discuss.elastic.co/t/how-to-create-temporary-tables-in-beeline-sparksql-for-elasticsearch-elasticsearch-is-behind-haproxy/274461 "2021-05-31T08:20:36Z")
How to connect beeline to elasticsearch via HAPROXY. CREATE TEMPORARY TABLE temp\_table USING org.elasticsearch.spark.sql OPTIONS (resource 'temp\_index/\_doc', nodes 'preview.abc.com', mapping.date.rich 'false', nodes.pat… --- ## [Update index by query error large index](https://discuss.elastic.co/t/update-index-by-query-error-large-index/274079)
**Author:** [@Roy\_Levy](https://discuss.elastic.co/u/Roy_Levy)\ **Replies:** 1\ **Last updated:** [May 31, 2021, 8:06am UTC](https://discuss.elastic.co/t/update-index-by-query-error-large-index/274079 "2021-05-31T08:06:52Z")
Hey, I'm trying to update my index by query like so: POST my\_index/\_update\_by\_query?pipeline=my\_pipeline&conflicts=proceed Because my index has alot of docs (nearly 40mil) the update stops after some thousand docs and… --- ## [Similarly module code not working in Node.Js](https://discuss.elastic.co/t/similarly-module-code-not-working-in-node-js/274114)
**Author:** [@appydam](https://discuss.elastic.co/u/appydam)\ **Replies:** 1\ **Last updated:** [May 31, 2021, 7:55am UTC](https://discuss.elastic.co/t/similarly-module-code-not-working-in-node-js/274114 "2021-05-31T07:55:30Z")
I have some data and I have to apply similarity module on it in settings part. I did that in Node.Js I sent data to Elasticsearch Kibana with Bulk API but similarity module is not working. I need help like how to integ… --- ## [Update boost value in index mapping is not taking effect](https://discuss.elastic.co/t/update-boost-value-in-index-mapping-is-not-taking-effect/274158)
**Author:** [@Anand\_Bhagwat](https://discuss.elastic.co/u/Anand_Bhagwat)\ **Replies:** 1\ **Last updated:** [May 31, 2021, 7:54am UTC](https://discuss.elastic.co/t/update-boost-value-in-index-mapping-is-not-taking-effect/274158 "2021-05-31T07:54:34Z")
Hi, I have index configuration mapping file which I am using to create an index. The mapping contains dynamic mappings with boost value in it. Json snippet is given below: "mappings": { "dynamic\_templates":… --- ## [Elastic search wildcard search space issue](https://discuss.elastic.co/t/elastic-search-wildcard-search-space-issue/274263)
**Author:** [@Mithoon](https://discuss.elastic.co/u/Mithoon)\ **Replies:** 1\ **Last updated:** [May 31, 2021, 7:53am UTC](https://discuss.elastic.co/t/elastic-search-wildcard-search-space-issue/274263 "2021-05-31T07:53:26Z")
Consider index field " ProductName " having the value " dove 3.75oz " and when user searches for "dove 3.75oz" text below bool query is working fine to retreive the document: {"bool":{"must":\[{"wildcard":{"ProductName":… --- ## [License is expired](https://discuss.elastic.co/t/license-is-expired/274464)
**Author:** [@kmz161](https://discuss.elastic.co/u/kmz161)\ **Replies:** 4\ **Last updated:** [May 31, 2021, 7:52am UTC](https://discuss.elastic.co/t/license-is-expired/274464 "2021-05-31T07:52:31Z")
I use free version of ELK stack and I receive message "Your trial license is expired". What needs to be done to renew the license? How I can resolve this issues? --- ## [Speed Up Query of huge indices](https://discuss.elastic.co/t/speed-up-query-of-huge-indices/274424)
**Author:** [@arkash20](https://discuss.elastic.co/u/arkash20)\ **Replies:** 6\ **Last updated:** [May 31, 2021, 7:24am UTC](https://discuss.elastic.co/t/speed-up-query-of-huge-indices/274424 "2021-05-31T07:24:09Z")
Hi, I would like to have your opinion about the next challenge I face: We have an index with about 200M records. We would like get all the records periodically, and send it to a service for some internal purpose. I t… --- ## [Elasticsearch Ram recommendation](https://discuss.elastic.co/t/elasticsearch-ram-recommendation/274300)
**Author:** [@godisdj007](https://discuss.elastic.co/u/godisdj007)\ **Replies:** 1\ **Last updated:** [May 31, 2021, 7:23am UTC](https://discuss.elastic.co/t/elasticsearch-ram-recommendation/274300 "2021-05-31T07:23:50Z")
I'm deploying an Elasticsearch cluster with roughly 40GB a day with a time-to-live of 365 days. Write speed would be around 50 msgs/sec. Reads would be mostly driven by user dashboards, so the read frequency won't be hig… --- ## [Watcher 7.8 Do I have to modify the range of my query to match the timezone?](https://discuss.elastic.co/t/watcher-7-8-do-i-have-to-modify-the-range-of-my-query-to-match-the-timezone/274103)
**Author:** [@ElasticLiver](https://discuss.elastic.co/u/ElasticLiver)\ **Replies:** 3\ **Last updated:** [May 31, 2021, 7:21am UTC](https://discuss.elastic.co/t/watcher-7-8-do-i-have-to-modify-the-range-of-my-query-to-match-the-timezone/274103 "2021-05-31T07:21:15Z")
Hi, I have create an alert whenever match a field, and Im having problems to make it work. the query works well in devs tools when I query for now-7d, but in the watch is never executed. this is my range "… --- ## [Watcher @timestamp timezone](https://discuss.elastic.co/t/watcher-timestamp-timezone/274167)
**Author:** [@toms130](https://discuss.elastic.co/u/toms130)\ **Replies:** 1\ **Last updated:** [May 31, 2021, 7:19am UTC](https://discuss.elastic.co/t/watcher-timestamp-timezone/274167 "2021-05-31T07:19:07Z")
Hi there, I can't figure how t change timestamp timezone in watcher output I got . Below is my watcher alert { "trigger": { "schedule": { "interval": "15m" } }, "input": { "search": { "re… --- ## [Sending data from elasticsearch to mixpanel](https://discuss.elastic.co/t/sending-data-from-elasticsearch-to-mixpanel/274455)
**Author:** [@faizanammar](https://discuss.elastic.co/u/faizanammar)\ **Replies:** 2\ **Last updated:** [May 31, 2021, 7:18am UTC](https://discuss.elastic.co/t/sending-data-from-elasticsearch-to-mixpanel/274455 "2021-05-31T07:18:13Z")
Hello, I wanna know and have guidance on any mechanism to send the data stored in ElasticSearch to MixPanel. Is there any way to accomplish this.? Thanks. F. --- ## [Relevant data not coming in elasticsearch](https://discuss.elastic.co/t/relevant-data-not-coming-in-elasticsearch/274456)
**Author:** [@vikramdayma](https://discuss.elastic.co/u/vikramdayma)\ **Replies:** 1\ **Last updated:** [May 31, 2021, 6:40am UTC](https://discuss.elastic.co/t/relevant-data-not-coming-in-elasticsearch/274456 "2021-05-31T06:40:25Z")
Hi, I am building a search with edge ngram. Here is my mapping: PUT xyz { "settings": { "analysis": { "filter": { "autocomplete": { "type": "edge\_ngram", "min\_gram": 2, "max\_g… --- ## [All fields should at least contain one term and all terms should be present](https://discuss.elastic.co/t/all-fields-should-at-least-contain-one-term-and-all-terms-should-be-present/272426)
**Author:** [@My-project-repositor](https://discuss.elastic.co/u/My-project-repositor)\ **Replies:** 6\ **Last updated:** [May 31, 2021, 5:43am UTC](https://discuss.elastic.co/t/all-fields-should-at-least-contain-one-term-and-all-terms-should-be-present/272426 "2021-05-31T05:43:47Z")
Hello, How can I query documents where all fields should at least contain one term and all terms should be present ? Suppose I have this index PUT /test\_query { "mappings": { "properties": { "firstname": { … --- ## [Updating from 7.10 to 7.13](https://discuss.elastic.co/t/updating-from-7-10-to-7-13/274163)
**Author:** [@ethical20](https://discuss.elastic.co/u/ethical20)\ **Replies:** 3\ **Last updated:** [May 30, 2021, 10:11pm UTC](https://discuss.elastic.co/t/updating-from-7-10-to-7-13/274163 "2021-05-30T22:11:18Z")
Hi, I have a single node environment: On Server: Elasticsearch 7.10 Kibana 7.10 logstash 7.10 On Clients: packetbeat and winlogbeat both 7.10 versions. 1- How can I update to the latest version? Is there a single w… --- ## [Reindex API for split a field](https://discuss.elastic.co/t/reindex-api-for-split-a-field/274012)
**Author:** [@Farid\_N](https://discuss.elastic.co/u/Farid_N)\ **Replies:** 3\ **Last updated:** [May 30, 2021, 6:29am UTC](https://discuss.elastic.co/t/reindex-api-for-split-a-field/274012 "2021-05-30T06:29:15Z")
Hi I've created an index template, and now trying to reindex my logs according to that index template. This is a log just for instance: "\_score": null, "\_source": { "@timestamp": "2021-05-25T08:38:36", "ho… --- ## ["Key" and "docCount" are missing when serializing BucketAggregate to string with Nest client](https://discuss.elastic.co/t/key-and-doccount-are-missing-when-serializing-bucketaggregate-to-string-with-nest-client/274389)
**Author:** [@jthoni](https://discuss.elastic.co/u/jthoni)\ **Replies:** 3\ **Last updated:** [May 30, 2021, 3:42am UTC](https://discuss.elastic.co/t/key-and-doccount-are-missing-when-serializing-bucketaggregate-to-string-with-nest-client/274389 "2021-05-30T03:42:57Z")
I am working on upgrading a service from ES 5.0 to 6.8. I have a bucket aggregate that in v5 serializes to this: "items": \[ { "key": "random+topic", "docCount": 27919, "aggreg… --- ## [Backup (snapshot) strategy for a two data node cluster](https://discuss.elastic.co/t/backup-snapshot-strategy-for-a-two-data-node-cluster/274404)
**Author:** [@parthmaniar](https://discuss.elastic.co/u/parthmaniar)\ **Replies:** 4\ **Last updated:** [May 29, 2021, 5:15pm UTC](https://discuss.elastic.co/t/backup-snapshot-strategy-for-a-two-data-node-cluster/274404 "2021-05-29T17:15:26Z")
Hello, I hope you and your loved ones are safe and healthy. I have a three node cluster with 2 data nodes and 1 voting node running Elastic Stack 7.13 on Ubuntu 20.04.2. All of the node are on a single physical worksta… --- ## [NEST API for Snapshot and Restore](https://discuss.elastic.co/t/nest-api-for-snapshot-and-restore/273586)
**Author:** [@Abhishek\_Shinde](https://discuss.elastic.co/u/Abhishek_Shinde)\ **Replies:** 1\ **Last updated:** [May 29, 2021, 1:40pm UTC](https://discuss.elastic.co/t/nest-api-for-snapshot-and-restore/273586 "2021-05-29T13:40:56Z")
Hi Team, We are planning to integrate Elasticsearch in one of our Enterprise product for indexing and search purpose. Our application is on-prem software gets deployed at customer end on the windows machine. We are plan… --- ## [Snapshot](https://discuss.elastic.co/t/snapshot/273692)
**Author:** [@Abhishek\_Shinde](https://discuss.elastic.co/u/Abhishek_Shinde)\ **Replies:** 5\ **Last updated:** [May 29, 2021, 12:46pm UTC](https://discuss.elastic.co/t/snapshot/273692 "2021-05-29T12:46:26Z")
Hi team, is there any sizing guidelines for snapshots and restore? If I wanted take snapshot of upto 10 TB of indexing data. Is there any limitations on the number of CPU and memory for better performance? --- ## [Machine Configuration for elasticsearch as a database](https://discuss.elastic.co/t/machine-configuration-for-elasticsearch-as-a-database/273735)
**Author:** [@Anirudhan](https://discuss.elastic.co/u/Anirudhan)\ **Replies:** 2\ **Last updated:** [May 29, 2021, 11:33am UTC](https://discuss.elastic.co/t/machine-configuration-for-elasticsearch-as-a-database/273735 "2021-05-29T11:33:59Z")
Hi I am trying to move the SQL database into elasticsearch. Successfully flattened the data from SQL into elasticsearch. These is the details of the index which was created from SQL to elastic Doc'sCount : 49201833, S… --- ## [Index rotation](https://discuss.elastic.co/t/index-rotation/274150)
**Author:** [@humartinez](https://discuss.elastic.co/u/humartinez)\ **Replies:** 2\ **Last updated:** [May 29, 2021, 8:41am UTC](https://discuss.elastic.co/t/index-rotation/274150 "2021-05-29T08:41:54Z")
Hello, I would like to know if there is a way to rotate an index for a period of time. I have an app that writes to a fix ES index name and I need to to rotate the index lets say after one day "app-index-0001", the next… --- ## [Update API - Async on server-side](https://discuss.elastic.co/t/update-api-async-on-server-side/274388)
**Author:** [@Leuteris](https://discuss.elastic.co/u/Leuteris)\ **Replies:** 3\ **Last updated:** [May 29, 2021, 8:03am UTC](https://discuss.elastic.co/t/update-api-async-on-server-side/274388 "2021-05-29T08:03:23Z")
Is it possible to execute the following request asynchronously on the server side? POST test/\_update/1 { "script" : "ctx.\_source.new\_field = 'value\_of\_new\_field'" } By "server side", I mean server should write the re… --- ## [Search by all variants of a value](https://discuss.elastic.co/t/search-by-all-variants-of-a-value/274023)
**Author:** [@Carina\_Sirbu](https://discuss.elastic.co/u/Carina_Sirbu)\ **Replies:** 1\ **Last updated:** [May 28, 2021, 9:33pm UTC](https://discuss.elastic.co/t/search-by-all-variants-of-a-value/274023 "2021-05-28T21:33:49Z")
Hello, I have an application where the user can search for beauty products. Let's say the user wants to find all products from L'Oréal company. So when he goes to the search, he might type: LOREAL, L'OREAL, L'oreal, L'o… --- ## [Problem with fuction\_score and field\_value\_factor](https://discuss.elastic.co/t/problem-with-fuction-score-and-field-value-factor/274330)
**Author:** [@Biiru](https://discuss.elastic.co/u/Biiru)\ **Replies:** 1\ **Last updated:** [May 28, 2021, 9:17pm UTC](https://discuss.elastic.co/t/problem-with-fuction-score-and-field-value-factor/274330 "2021-05-28T21:17:49Z")
Hi all, I have a problem with a query GET score-score-score/\_search { "query": { "function\_score": { "query": { "bool": { "must": \[ {"term": { "validity": true }}, … --- ## [API Endpoint for Elastic Stack Monitoring?](https://discuss.elastic.co/t/api-endpoint-for-elastic-stack-monitoring/274373)
**Author:** [@Sumit\_Gupta2](https://discuss.elastic.co/u/Sumit_Gupta2)\ **Replies:** 0\ **Last updated:** [May 28, 2021, 7:30pm UTC](https://discuss.elastic.co/t/api-endpoint-for-elastic-stack-monitoring/274373 "2021-05-28T19:30:28Z")
Which is the API Endpoint for Elastic Stack Monitoring? --- ## [Matching patterns from existing older templates ... will take precedence during new index creation](https://discuss.elastic.co/t/matching-patterns-from-existing-older-templates-will-take-precedence-during-new-index-creation/273764)
**Author:** [@6NMgfDwZ3](https://discuss.elastic.co/u/6NMgfDwZ3)\ **Replies:** 2\ **Last updated:** [May 28, 2021, 4:38pm UTC](https://discuss.elastic.co/t/matching-patterns-from-existing-older-templates-will-take-precedence-during-new-index-creation/273764 "2021-05-28T16:38:27Z")
Hello, Environment: Elasticsearch 7.12.1 (Basic License) Kibana 7.12.1 (Basic License) Filebeat 7.12.1 (Basic License) Ubuntu 21.04 I have an index template named myapp the index pattern myapp-\*. This index template… --- ## [How does elasticsearch rank matching results?](https://discuss.elastic.co/t/how-does-elasticsearch-rank-matching-results/274325)
**Author:** [@Later](https://discuss.elastic.co/u/Later)\ **Replies:** 5\ **Last updated:** [May 28, 2021, 3:36pm UTC](https://discuss.elastic.co/t/how-does-elasticsearch-rank-matching-results/274325 "2021-05-28T15:36:35Z")
Hello. Can you explain lucidly (My knowledge in this field is almost zero) how the search engine rank matching results when a user performs a search (I think this is called search engine algorithm)? What are ranking fac… --- ## [Import data from the TheDude server softweare to elastiscearch](https://discuss.elastic.co/t/import-data-from-the-thedude-server-softweare-to-elastiscearch/273977)
**Author:** [@Adriann](https://discuss.elastic.co/u/Adriann)\ **Replies:** 1\ **Last updated:** [May 28, 2021, 2:27pm UTC](https://discuss.elastic.co/t/import-data-from-the-thedude-server-softweare-to-elastiscearch/273977 "2021-05-28T14:27:01Z")
Hello, I wonder If anyone managed to connect/fetch data capture by TheDude server into elasticserach. I do not see much about that on the internet. --- ## [Index problem after using curator](https://discuss.elastic.co/t/index-problem-after-using-curator/273827)
**Author:** [@Weathmious](https://discuss.elastic.co/u/Weathmious)\ **Replies:** 2\ **Last updated:** [May 28, 2021, 1:51pm UTC](https://discuss.elastic.co/t/index-problem-after-using-curator/273827 "2021-05-28T13:51:52Z")
Hello, I use a graylog server, with elasticsearch and kibana installed on it. I recently used curator to send indexes to aws S3, then to delete them, in order to save space on my server. All of this works fine, but I h… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=636) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=638)