# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=834 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 835 --- ## [Elasticsearch real time data sync with sql server](https://discuss.elastic.co/t/elasticsearch-real-time-data-sync-with-sql-server/244760)
**Author:** [@Coder\_Cub](https://discuss.elastic.co/u/Coder_Cub)\ **Replies:** 8\ **Last updated:** [August 16, 2020, 3:05am UTC](https://discuss.elastic.co/t/elasticsearch-real-time-data-sync-with-sql-server/244760 "2020-08-16T03:05:21Z")
I am new to Elastic Search and I am trying to figure it out below scenarios How/which tool to sync/insert data into Elastic search when new record is created in SQL Server?(Near Real time) How to transformation for leg… --- ## [Elasticsearch nodes not used for search](https://discuss.elastic.co/t/elasticsearch-nodes-not-used-for-search/245066)
**Author:** [@kidrik](https://discuss.elastic.co/u/kidrik)\ **Replies:** 7\ **Last updated:** [August 15, 2020, 9:06pm UTC](https://discuss.elastic.co/t/elasticsearch-nodes-not-used-for-search/245066 "2020-08-15T21:06:42Z")
We have an Elasticsearch 7.1 cluster (AWS) with 2 indexes. The parent index has one shard and two replicas, whereas the child index has 3 shards and 2 replicas. Right now we’re running on 8 data nodes and the shard all… --- ## [Querying dense\_vector from the High Level REST Java API](https://discuss.elastic.co/t/querying-dense-vector-from-the-high-level-rest-java-api/244956)
**Author:** [@MJB](https://discuss.elastic.co/u/MJB)\ **Replies:** 4\ **Last updated:** [August 15, 2020, 8:26pm UTC](https://discuss.elastic.co/t/querying-dense-vector-from-the-high-level-rest-java-api/244956 "2020-08-15T20:26:27Z")
All the examples I can find for querying dense vector mention script queries, eg. https://discuss.elastic.co/t/searching-with-dense-vector/213374 However, I have no idea on how to use those with the HL API. Is this pos… --- ## [Watcher results returning similar terms instead of specific one while using match query](https://discuss.elastic.co/t/watcher-results-returning-similar-terms-instead-of-specific-one-while-using-match-query/245005)
**Author:** [@suryanaj](https://discuss.elastic.co/u/suryanaj)\ **Replies:** 1\ **Last updated:** [August 15, 2020, 8:17pm UTC](https://discuss.elastic.co/t/watcher-results-returning-similar-terms-instead-of-specific-one-while-using-match-query/245005 "2020-08-15T20:17:38Z")
my watcher alert query is not returning the exact match of url it returns all similar search of http.url keyword. i am using 6.8.3. I want exact match or search of http.url. Please suggest . { "trigger": { "schedule"… --- ## [Master Node election not working](https://discuss.elastic.co/t/master-node-election-not-working/245097)
**Author:** [@jijo.john](https://discuss.elastic.co/u/jijo.john)\ **Replies:** 2\ **Last updated:** [August 15, 2020, 7:19pm UTC](https://discuss.elastic.co/t/master-node-election-not-working/245097 "2020-08-15T19:19:15Z")
Hi Team, We are running a POC on elastic search. We have three nodes Node 1: node.master: true node.data: true node.ingest: true node.ml: false cluster.initial\_master\_nodes: \["ibs-dc-siem-1", "ibs-dc-siem-backup"\] … --- ## [Help with aggregation query to calculate relative volume](https://discuss.elastic.co/t/help-with-aggregation-query-to-calculate-relative-volume/245103)
**Author:** [@JGor](https://discuss.elastic.co/u/JGor)\ **Replies:** 0\ **Last updated:** [August 15, 2020, 5:55pm UTC](https://discuss.elastic.co/t/help-with-aggregation-query-to-calculate-relative-volume/245103 "2020-08-15T17:55:31Z")
Relative Volume (often times called RVOL) is an indicator that tells traders how current trading volume is compared to past trading volume over a given period. Hello guys, I was wondering if someone can point me… --- ## [Jira-Elasticsearch Integration for Watcher](https://discuss.elastic.co/t/jira-elasticsearch-integration-for-watcher/244850)
**Author:** [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Replies:** 2\ **Last updated:** [August 15, 2020, 2:55pm UTC](https://discuss.elastic.co/t/jira-elasticsearch-integration-for-watcher/244850 "2020-08-15T14:55:36Z")
Hello Team, I am trying to Integrate Elastic Watcher With Jira Community Version. My Elasticsearch Config is But I am Facing the Error When I am trying to Test the Watcher. Can Someone Help me. Regards Shrikan… --- ## [Regarding Index Sorting](https://discuss.elastic.co/t/regarding-index-sorting/244984)
**Author:** [@dawiro](https://discuss.elastic.co/u/dawiro)\ **Replies:** 3\ **Last updated:** [August 14, 2020, 4:54pm UTC](https://discuss.elastic.co/t/regarding-index-sorting/244984 "2020-08-14T16:54:39Z")
Hi, When considering index sorting would it be correct to assume the following cost/benefits: Pros: faster searching for standard queries Better index compression Cons: Significantly reduced indexing throughput, s… --- ## [Does EdgeNGram autocomplete\_filter make sense with prefix search?](https://discuss.elastic.co/t/does-edgengram-autocomplete-filter-make-sense-with-prefix-search/245086)
**Author:** [@AleksandarT](https://discuss.elastic.co/u/AleksandarT)\ **Replies:** 0\ **Last updated:** [August 15, 2020, 9:22am UTC](https://discuss.elastic.co/t/does-edgengram-autocomplete-filter-make-sense-with-prefix-search/245086 "2020-08-15T09:22:44Z")
i have Elastic Search Index with around 1 million records. I want to do multi prefix search against 2 fields in the Elastic Search Index, Name and ID (there are around 10 total). Does creating EdgeNGram autocomplete fi… --- ## [Data node using different cluster id](https://discuss.elastic.co/t/data-node-using-different-cluster-id/244991)
**Author:** [@Shambu\_Pujar](https://discuss.elastic.co/u/Shambu_Pujar)\ **Replies:** 5\ **Last updated:** [August 15, 2020, 8:24am UTC](https://discuss.elastic.co/t/data-node-using-different-cluster-id/244991 "2020-08-15T08:24:42Z")
Hi For some of the maintenance exercise, I had to bring down the master. In that process, I made data node as master as well. Now with new master, I am not able to get data node join master Data node throws following … --- ## [OutOfMemoryError: unable to create new native thread](https://discuss.elastic.co/t/outofmemoryerror-unable-to-create-new-native-thread/245079)
**Author:** [@Goutham\_Pratapa](https://discuss.elastic.co/u/Goutham_Pratapa)\ **Replies:** 0\ **Last updated:** [August 15, 2020, 7:36am UTC](https://discuss.elastic.co/t/outofmemoryerror-unable-to-create-new-native-thread/245079 "2020-08-15T07:36:09Z")
Hi all, I am relatively new to ElasticSearch and I Am running into this issue almost every day in my machine. The following are details about my hardware. $ ulimit -a core file size (blocks, -c) 0 data seg si… --- ## [Questions regarding index.gc\_deletes](https://discuss.elastic.co/t/questions-regarding-index-gc-deletes/244452)
**Author:** [@lang1991](https://discuss.elastic.co/u/lang1991)\ **Replies:** 4\ **Last updated:** [August 15, 2020, 6:17am UTC](https://discuss.elastic.co/t/questions-regarding-index-gc-deletes/244452 "2020-08-15T06:17:51Z")
I have a few questions regarding "index.gc\_deletes", and I can't seem to find the answers in Elasticsearch documents. Context: We have a stream of events to be indexed by Elasticsearch, including "upsert" and "delete" … --- ## [Cannot get AD auth to work with Trial license](https://discuss.elastic.co/t/cannot-get-ad-auth-to-work-with-trial-license/244706)
**Author:** [@hazcod](https://discuss.elastic.co/u/hazcod)\ **Replies:** 3\ **Last updated:** [August 15, 2020, 6:08am UTC](https://discuss.elastic.co/t/cannot-get-ad-auth-to-work-with-trial-license/244706 "2020-08-15T06:08:11Z")
Hi, I am trying to setup Active Directory authentication for my elastic 7.80 stack. The steps i've taken: Enable trial license Put my ldaps certificate in /etc/elasticsearch/ad-ca.pem Configure ldaps realm in elastics… --- ## [Will elasticsearch create logs directory if not exist?](https://discuss.elastic.co/t/will-elasticsearch-create-logs-directory-if-not-exist/245003)
**Author:** [@RAM\_NATHAN](https://discuss.elastic.co/u/RAM_NATHAN)\ **Replies:** 2\ **Last updated:** [August 15, 2020, 4:14am UTC](https://discuss.elastic.co/t/will-elasticsearch-create-logs-directory-if-not-exist/245003 "2020-08-15T04:14:38Z")
Hi Will elasticsearch create logs directory I have given in path.logs, if not exist? It seems like service not starting up if log directory is not there. Is there anyway I can tell elasticsearch to create the direct… --- ## [Elasticsearch snapshot/restore](https://discuss.elastic.co/t/elasticsearch-snapshot-restore/245006)
**Author:** [@RAM\_NATHAN](https://discuss.elastic.co/u/RAM_NATHAN)\ **Replies:** 3\ **Last updated:** [August 15, 2020, 3:39am UTC](https://discuss.elastic.co/t/elasticsearch-snapshot-restore/245006 "2020-08-15T03:39:28Z")
Hi I want to take backup of existing data before upgrading elasticsearch, place it back after upgrade. What is the best way to do that? I read about snapshot & restore. Is this right one for a production environment wit… --- ## [Unable to view hosted elastic monitoring logs](https://discuss.elastic.co/t/unable-to-view-hosted-elastic-monitoring-logs/244209)
**Author:** [@Erica\_Case](https://discuss.elastic.co/u/Erica_Case)\ **Replies:** 2\ **Last updated:** [August 15, 2020, 2:33am UTC](https://discuss.elastic.co/t/unable-to-view-hosted-elastic-monitoring-logs/244209 "2020-08-15T02:33:19Z")
We are currently experiencing problems with hosted elastic cluster, and tried to look at the logs to troubleshoot. However, the logs only show one page, and state: logs 1 of NaN. This means we have transparency into a… --- ## [Recover a broken 3 node elasticsearch cluster that has only 1 node left](https://discuss.elastic.co/t/recover-a-broken-3-node-elasticsearch-cluster-that-has-only-1-node-left/244959)
**Author:** [@efan](https://discuss.elastic.co/u/efan)\ **Replies:** 5\ **Last updated:** [August 15, 2020, 2:00am UTC](https://discuss.elastic.co/t/recover-a-broken-3-node-elasticsearch-cluster-that-has-only-1-node-left/244959 "2020-08-15T02:00:50Z")
Hi, I have Elasticsearch cluster (7.6.1) that had 3 nodes. 2 of the nodes were accidentally dropped while all 3 servers were running. 1 of the 3 servers survived. I want to save the cluster and its data. How do I add new… --- ## [Elasticsearch - failed to turn off translog retention](https://discuss.elastic.co/t/elasticsearch-failed-to-turn-off-translog-retention/245060)
**Author:** [@gferrette](https://discuss.elastic.co/u/gferrette)\ **Replies:** 0\ **Last updated:** [August 14, 2020, 7:37pm UTC](https://discuss.elastic.co/t/elasticsearch-failed-to-turn-off-translog-retention/245060 "2020-08-14T19:37:32Z")
Hello! I've made an upgrade from ES 7.0.1 to ES 7.6.1 and after that, on nodes startup, its appearing on the logs the message below: \[2020-08-14T10:54:21,893\]\[WARN \]\[o.e.i.s.IndexShard \] \[machine\] \[.tasks\]\[0\] fai… --- ## [How to open Kibana discover url with filters from the elastic REST API](https://discuss.elastic.co/t/how-to-open-kibana-discover-url-with-filters-from-the-elastic-rest-api/245051)
**Author:** [@aravind.pk](https://discuss.elastic.co/u/aravind.pk)\ **Replies:** 0\ **Last updated:** [August 14, 2020, 5:57pm UTC](https://discuss.elastic.co/t/how-to-open-kibana-discover-url-with-filters-from-the-elastic-rest-api/245051 "2020-08-14T17:57:31Z")
I am Elastic REST API to access the \_search and \_count for our own app to yield the logs and handle some app specific business functions (based on the logs and determine the performance etc.). From our app, we would like… --- ## [Doubt about complex query](https://discuss.elastic.co/t/doubt-about-complex-query/245048)
**Author:** [@bgsouza](https://discuss.elastic.co/u/bgsouza)\ **Replies:** 0\ **Last updated:** [August 14, 2020, 5:08pm UTC](https://discuss.elastic.co/t/doubt-about-complex-query/245048 "2020-08-14T17:08:22Z")
Hello everyone I am a beginner in kibana and I'm having trouble setting up a query to generate a metric in Kibana. But I don't know if I'm structuring it wrong or if the query isn't even possible Giving a little contex… --- ## [Uax\_url\_email for email get unexpected search result](https://discuss.elastic.co/t/uax-url-email-for-email-get-unexpected-search-result/245041)
**Author:** [@Jinlian\_Chen](https://discuss.elastic.co/u/Jinlian_Chen)\ **Replies:** 0\ **Last updated:** [August 14, 2020, 3:50pm UTC](https://discuss.elastic.co/t/uax-url-email-for-email-get-unexpected-search-result/245041 "2020-08-14T15:50:58Z")
Elasticsearch version: 7.8.0 Use uax\_url\_email and pattern\_capture to analyze emails, search email address get unexpected result. Two email address: hello-test hello-world@gmail.com hello-test-hello-world@gmail.com S… --- ## [DELETE documents documents that have field date1 in the given interval and the value of "date1 - date2" is greater than 1 hour](https://discuss.elastic.co/t/delete-documents-documents-that-have-field-date1-in-the-given-interval-and-the-value-of-date1-date2-is-greater-than-1-hour/245040)
**Author:** [@Rysiu](https://discuss.elastic.co/u/Rysiu)\ **Replies:** 0\ **Last updated:** [August 14, 2020, 3:39pm UTC](https://discuss.elastic.co/t/delete-documents-documents-that-have-field-date1-in-the-given-interval-and-the-value-of-date1-date2-is-greater-than-1-hour/245040 "2020-08-14T15:39:09Z")
We have a basic index with two fields: date1 and date2. PUT your\_index { "mappings": { "your\_type": { "properties": { "time1": { "type": "date", }, "time2": { "t… --- ## [Reindex with https](https://discuss.elastic.co/t/reindex-with-https/245031)
**Author:** [@dimm](https://discuss.elastic.co/u/dimm)\ **Replies:** 0\ **Last updated:** [August 14, 2020, 2:29pm UTC](https://discuss.elastic.co/t/reindex-with-https/245031 "2020-08-14T14:29:40Z")
Hi, I'm tryning to migrate data from my OLD\_ELASTIC server (version 6.2) to the NEW\_ELASTIC (version 7.8.1) using REINDEX approcach but with https connection. My NEW\_ELASTIC elasticsearch.yml contains: ... reindex.rem… --- ## [Boosting documents performance (Terms vs Should)](https://discuss.elastic.co/t/boosting-documents-performance-terms-vs-should/245018)
**Author:** [@Kushikawa](https://discuss.elastic.co/u/Kushikawa)\ **Replies:** 0\ **Last updated:** [August 14, 2020, 1:28pm UTC](https://discuss.elastic.co/t/boosting-documents-performance-terms-vs-should/245018 "2020-08-14T13:28:27Z")
Hi, I have something similar to the following document: { "title": "Alisha Solid Women's Cycling Shorts", "sku":\["54855","54856","54857","54858","54859"\] }, { "title": "Vishudh Printed Women's Anarkali Kurta", "… --- ## [ELASTICSEARCH - Count unique value with a condition](https://discuss.elastic.co/t/elasticsearch-count-unique-value-with-a-condition/244983)
**Author:** [@Miguel\_BA](https://discuss.elastic.co/u/Miguel_BA)\ **Replies:** 4\ **Last updated:** [August 14, 2020, 1:08pm UTC](https://discuss.elastic.co/t/elasticsearch-count-unique-value-with-a-condition/244983 "2020-08-14T13:08:20Z")
I would like a query which it returns the number of times a field is repeated, according to the unique value of another field I have this json: "name" : james, "city" : "chicago" \<----------- same … --- ## [New to ES some questions](https://discuss.elastic.co/t/new-to-es-some-questions/244895)
**Author:** [@DevOnTie](https://discuss.elastic.co/u/DevOnTie)\ **Replies:** 1\ **Last updated:** [August 14, 2020, 12:18pm UTC](https://discuss.elastic.co/t/new-to-es-some-questions/244895 "2020-08-14T12:18:32Z")
Hello, I'm new in using elastic search (well... and programming as well), and my boss created an instance @amazon and I'm not sure of how to use es from it, where should I look, here or amazon help (if outside, it's allo… --- ## [Continuous transform is "indexing", but no new destination records](https://discuss.elastic.co/t/continuous-transform-is-indexing-but-no-new-destination-records/244692)
**Author:** [@Mark\_Duncan](https://discuss.elastic.co/u/Mark_Duncan)\ **Replies:** 3\ **Last updated:** [August 14, 2020, 12:12pm UTC](https://discuss.elastic.co/t/continuous-transform-is-indexing-but-no-new-destination-records/244692 "2020-08-14T12:12:58Z")
My last record in the destination index is for the minute, 2020-08-11 20:05:00. It is a continuous transform and it's status=indexing, but no new destination logs are being generated. I have other transforms in continu… --- ## [ElasticSearch 7.7.1 plugin for custom score](https://discuss.elastic.co/t/elasticsearch-7-7-1-plugin-for-custom-score/245001)
**Author:** [@dimminbox](https://discuss.elastic.co/u/dimminbox)\ **Replies:** 0\ **Last updated:** [August 14, 2020, 11:32am UTC](https://discuss.elastic.co/t/elasticsearch-7-7-1-plugin-for-custom-score/245001 "2020-08-14T11:32:34Z")
Hi, Now i'm using ElasticSearch 5.3 with groovy script for calculationg of score. This script use \_doc\[field\].size() for get count of tokens for field by document. This logic i'm trying to apply in custom plugin for … --- ## [I use elasticsearch in java ,and i get some questions that i can't understand](https://discuss.elastic.co/t/i-use-elasticsearch-in-java-and-i-get-some-questions-that-i-cant-understand/244890)
**Author:** [@AnswerNo2](https://discuss.elastic.co/u/AnswerNo2)\ **Replies:** 2\ **Last updated:** [August 14, 2020, 11:31am UTC](https://discuss.elastic.co/t/i-use-elasticsearch-in-java-and-i-get-some-questions-that-i-cant-understand/244890 "2020-08-14T11:31:52Z")
when i create a doc，i need use : IndexRequest indexRequest = new IndexRequest(String indexName); the question is : indexRequest .type(type) ,this method is deprecated, and what method can replace it ？ i want know! --- ## [Exact match not apearing on top](https://discuss.elastic.co/t/exact-match-not-apearing-on-top/244986)
**Author:** [@ankitbhai](https://discuss.elastic.co/u/ankitbhai)\ **Replies:** 3\ **Last updated:** [August 14, 2020, 11:11am UTC](https://discuss.elastic.co/t/exact-match-not-apearing-on-top/244986 "2020-08-14T11:11:07Z")
Hello, I need to get results first exact match and then other match. I've tried it with boost and should but still it's not working for me. Please give your help/suggestion for the same. {"size":20,"query":{"bool":{"mu… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=833) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=835)