# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1601 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1602 --- ## [Improving relevancy of suggestions](https://discuss.elastic.co/t/improving-relevancy-of-suggestions/141922)
**Author:** [@manubhogal19](https://discuss.elastic.co/u/manubhogal19)\ **Replies:** 0\ **Last updated:** [July 27, 2018, 10:44am UTC](https://discuss.elastic.co/t/improving-relevancy-of-suggestions/141922 "2018-07-27T10:44:50Z")
I have a case where I need to find suggestions based on a given text. My basic need is to get suggestions, in an order that the ones matching exactly need to be first, and the the fuzzy ones. I have attached the solutio… --- ## [Managing queries in Elasticsearch Logstash filter plugin](https://discuss.elastic.co/t/managing-queries-in-elasticsearch-logstash-filter-plugin/141888)
**Author:** [@espogian](https://discuss.elastic.co/u/espogian)\ **Replies:** 4\ **Last updated:** [July 27, 2018, 11:44am UTC](https://discuss.elastic.co/t/managing-queries-in-elasticsearch-logstash-filter-plugin/141888 "2018-07-27T11:44:33Z")
Hi, I'm opening this topic as a follow-up to this one: Elasticsearch query sort order index My main documentation reference for using Elasticsearch queries in Logstash is https://www.elastic.co/guide/en/logstash/curren… --- ## [Stateless master nodes](https://discuss.elastic.co/t/stateless-master-nodes/141112)
**Author:** [@darefilz](https://discuss.elastic.co/u/darefilz)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 11:32am UTC](https://discuss.elastic.co/t/stateless-master-nodes/141112 "2018-07-27T11:32:50Z")
Hi there, we're planning to switch from data+master design to dedicated data and dedicated master design as a lot of people already did. The data nodes are on physical machines, the master nodes go to docker containers… --- ## [Restoring version number](https://discuss.elastic.co/t/restoring-version-number/140714)
**Author:** [@frankshad](https://discuss.elastic.co/u/frankshad)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 11:27am UTC](https://discuss.elastic.co/t/restoring-version-number/140714 "2018-07-27T11:27:33Z")
I have a backup script which basically just dumps data as JSON and creates a corresponding bulk load script for that data. I am starting to use (internal) version numbers in my app, so I looked at having my backup scrip… --- ## [Unable to access Elasticsearch 6.3.1 outside server](https://discuss.elastic.co/t/unable-to-access-elasticsearch-6-3-1-outside-server/140667)
**Author:** [@Ravi\_Kumar1](https://discuss.elastic.co/u/Ravi_Kumar1)\ **Replies:** 7\ **Last updated:** [July 27, 2018, 11:18am UTC](https://discuss.elastic.co/t/unable-to-access-elasticsearch-6-3-1-outside-server/140667 "2018-07-27T11:18:27Z")
Hi, I have Elasticsearch 6.3.1 installed on Digitalocean droplet running Ubuntu 14.04.5 LTS. I am able to curl Elasticsearch on localhost, but unable to access it from outside network. Here is the snapshot of my netst… --- ## [Which is the best way to index the data from relational database](https://discuss.elastic.co/t/which-is-the-best-way-to-index-the-data-from-relational-database/141870)
**Author:** [@girishts](https://discuss.elastic.co/u/girishts)\ **Replies:** 3\ **Last updated:** [July 27, 2018, 10:52am UTC](https://discuss.elastic.co/t/which-is-the-best-way-to-index-the-data-from-relational-database/141870 "2018-07-27T10:52:31Z")
Hi , Can you please let me know which is the best way to index the records in elastic search for my scenario. My Scenario is : Need to index around 40 million records from oracle table which has entries having one t… --- ## [Filtering while searching](https://discuss.elastic.co/t/filtering-while-searching/141912)
**Author:** [@Anton\_Garakh](https://discuss.elastic.co/u/Anton_Garakh)\ **Replies:** 5\ **Last updated:** [July 27, 2018, 10:50am UTC](https://discuss.elastic.co/t/filtering-while-searching/141912 "2018-07-27T10:50:13Z")
Hi all Let's say I have documents of the following structure: Product { organization; supplier; name; } and there are billions of documents, a lot of organizations, and each organization has approximately 100000 produ… --- ## [Try to run elasticsearch but keeps stopping immediately](https://discuss.elastic.co/t/try-to-run-elasticsearch-but-keeps-stopping-immediately/141886)
**Author:** [@shreym03](https://discuss.elastic.co/u/shreym03)\ **Replies:** 5\ **Last updated:** [July 27, 2018, 9:55am UTC](https://discuss.elastic.co/t/try-to-run-elasticsearch-but-keeps-stopping-immediately/141886 "2018-07-27T09:55:16Z")
I'm using elasticsearch 6.3 on Ubuntu. Whenever I start it up, it runs for a couple of minutes and then immediately fails. I get this error when checking satus Loaded: loaded (/usr/lib/systemd/system/elasticsearch.se… --- ## [Which Free JRE we can use? Oracle JavaSE or OpenJDK](https://discuss.elastic.co/t/which-free-jre-we-can-use-oracle-javase-or-openjdk/141158)
**Author:** [@Bruce\_Wong](https://discuss.elastic.co/u/Bruce_Wong)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 9:51am UTC](https://discuss.elastic.co/t/which-free-jre-we-can-use-oracle-javase-or-openjdk/141158 "2018-07-27T09:51:05Z")
Hello, I am going to use Elasticsearch 6.3.x for a commercial software, but I am confused on the license issue of JRE, from this link http://www.oracle.com/technetwork/articles/javase/faqs-jsp-136696.html , it looks li… --- ## [Elastic remote node adding fails in cross cluster search](https://discuss.elastic.co/t/elastic-remote-node-adding-fails-in-cross-cluster-search/141917)
**Author:** [@Sabith\_T\_H](https://discuss.elastic.co/u/Sabith_T_H)\ **Replies:** 0\ **Last updated:** [July 27, 2018, 9:42am UTC](https://discuss.elastic.co/t/elastic-remote-node-adding-fails-in-cross-cluster-search/141917 "2018-07-27T09:42:28Z")
I am trying to add remote node as a gateway/seed for cross cluster search. I am able to add one cluster but for the other I get connect timeout exception. I ran Transport Tracer on all the involved nodes. Cross Cluster … --- ## [Upgraded 1.0 to 6.0](https://discuss.elastic.co/t/upgraded-1-0-to-6-0/141915)
**Author:** [@samomin46](https://discuss.elastic.co/u/samomin46)\ **Replies:** 0\ **Last updated:** [July 27, 2018, 9:29am UTC](https://discuss.elastic.co/t/upgraded-1-0-to-6-0/141915 "2018-07-27T09:29:25Z")
Hello, "I am newer to Elastic Search", I have upgraded client to 6.0 from 1.0). Now I have resolved the conflicts and features which are deprecated in newer version(Plenty of changes). Its C#. Previously we were usin… --- ## [Unexpected Error in Scheduled Task](https://discuss.elastic.co/t/unexpected-error-in-scheduled-task/141914)
**Author:** [@Applesauce](https://discuss.elastic.co/u/Applesauce)\ **Replies:** 0\ **Last updated:** [July 27, 2018, 9:24am UTC](https://discuss.elastic.co/t/unexpected-error-in-scheduled-task/141914 "2018-07-27T09:24:50Z")
Hello. I am running a setup using elasticsearch 5.5.3. We've just migrated from a different server using 2.3.4 and are in the process of getting everything finalized. During this I encountered a parsing error (non-relate… --- ## [Date-range based sharding](https://discuss.elastic.co/t/date-range-based-sharding/141908)
**Author:** [@chits](https://discuss.elastic.co/u/chits)\ **Replies:** 3\ **Last updated:** [July 27, 2018, 9:22am UTC](https://discuss.elastic.co/t/date-range-based-sharding/141908 "2018-07-27T09:22:20Z")
Hi, I want to implement custom, time stamp based sharding in my elastic search index, for e.g: records with time \> t1 and \< t2 should go in one shard and records with time \>t2 and \< t3 should go in the second shard. … --- ## [Help with 'or' filter needed](https://discuss.elastic.co/t/help-with-or-filter-needed/141829)
**Author:** [@Jevgenij](https://discuss.elastic.co/u/Jevgenij)\ **Replies:** 2\ **Last updated:** [July 27, 2018, 9:17am UTC](https://discuss.elastic.co/t/help-with-or-filter-needed/141829 "2018-07-27T09:17:15Z")
Days are passing, but still can't get used to the syntax of queries. My current query structure: { "query":{ "bool":{ "must":{ /\* --- Here is my full-text search query --- \*/ "… --- ## [Question on the backup snapshot](https://discuss.elastic.co/t/question-on-the-backup-snapshot/141876)
**Author:** [@ahrtr](https://discuss.elastic.co/u/ahrtr)\ **Replies:** 7\ **Last updated:** [July 27, 2018, 9:07am UTC](https://discuss.elastic.co/t/question-on-the-backup-snapshot/141876 "2018-07-27T09:07:58Z")
Based on the following guide, only the first snapshot is a complete copy of data, and all subsequent snapshots will save the delta between the existing snapshots and the new data. https://www.elastic.co/guide/en/elastic… --- ## [Cannot find correct ctx.payload path to use](https://discuss.elastic.co/t/cannot-find-correct-ctx-payload-path-to-use/141494)
**Author:** [@Sjaak01](https://discuss.elastic.co/u/Sjaak01)\ **Replies:** 5\ **Last updated:** [July 27, 2018, 8:19am UTC](https://discuss.elastic.co/t/cannot-find-correct-ctx-payload-path-to-use/141494 "2018-07-27T08:19:39Z")
Hi, I made this watch but I'm unable to find the right values. The query returns various locations (key) and their usage (value). For each key that exceeds the gte I want to create an alert but I'm struggling to even ge… --- ## [Xsd to mapping](https://discuss.elastic.co/t/xsd-to-mapping/141903)
**Author:** [@JPelastic](https://discuss.elastic.co/u/JPelastic)\ **Replies:** 0\ **Last updated:** [July 27, 2018, 8:08am UTC](https://discuss.elastic.co/t/xsd-to-mapping/141903 "2018-07-27T08:08:06Z")
Hello Is there any tool or way to transform an xsd to ES mapping? Thank you Johan --- ## [I'm not able to load the data to elastic search with template](https://discuss.elastic.co/t/im-not-able-to-load-the-data-to-elastic-search-with-template/141898)
**Author:** [@Prasanna\_Kumar55kt](https://discuss.elastic.co/u/Prasanna_Kumar55kt)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 7:57am UTC](https://discuss.elastic.co/t/im-not-able-to-load-the-data-to-elastic-search-with-template/141898 "2018-07-27T07:57:01Z")
I can able to load the data into indices in ES with logstash but i've added template later data is not loading into indices . But indices are creating with no data . CAn u help me to resolve this issue . template : PUT… --- ## [Is there a way to influence phrase suggester candidates by specifying weights for tokens / docs?](https://discuss.elastic.co/t/is-there-a-way-to-influence-phrase-suggester-candidates-by-specifying-weights-for-tokens-docs/141899)
**Author:** [@varadharajan](https://discuss.elastic.co/u/varadharajan)\ **Replies:** 0\ **Last updated:** [July 27, 2018, 7:54am UTC](https://discuss.elastic.co/t/is-there-a-way-to-influence-phrase-suggester-candidates-by-specifying-weights-for-tokens-docs/141899 "2018-07-27T07:54:09Z")
We have loaded a few million documents into an elasticsearch cluster, where the documents are frequently occurring phrases in our master set of documents. We are trying to build a context sensitive spell corrector on top… --- ## [Insert the json into elastic using java](https://discuss.elastic.co/t/insert-the-json-into-elastic-using-java/140674)
**Author:** [@srinivasthouti](https://discuss.elastic.co/u/srinivasthouti)\ **Replies:** 29\ **Last updated:** [July 27, 2018, 7:52am UTC](https://discuss.elastic.co/t/insert-the-json-into-elastic-using-java/140674 "2018-07-27T07:52:52Z")
hi i am having below json obect i need to push this data into elasticserach index i already creadted index in elastic ,can any one help me in this . "data" { "counter":"0", "create\_ts":"12-12-2018", "email":"sriniv… --- ## [License Expired](https://discuss.elastic.co/t/license-expired/141872)
**Author:** [@Sulaiman](https://discuss.elastic.co/u/Sulaiman)\ **Replies:** 12\ **Last updated:** [July 27, 2018, 7:46am UTC](https://discuss.elastic.co/t/license-expired/141872 "2018-07-27T07:46:27Z")
Recently I have faced issue with ElasticSearch License, I am getting below listed error while restarting, I had basic account. 2018-07-27T10:01:57,936\]\[ERROR\]\[o.e.x.s.a.f.SecurityActionFilter\] \[aYBc70q\] blocking \[cluste… --- ## [Default sorting order in ElasticSearch 1.7](https://discuss.elastic.co/t/default-sorting-order-in-elasticsearch-1-7/141890)
**Author:** [@satish2](https://discuss.elastic.co/u/satish2)\ **Replies:** 0\ **Last updated:** [July 27, 2018, 7:29am UTC](https://discuss.elastic.co/t/default-sorting-order-in-elasticsearch-1-7/141890 "2018-07-27T07:29:55Z")
When we query the elastic search 1.7 with paginated result and not setting any sort option, We are always getting different results for each page. So We had modified query with preference =\_primary and, its starting giv… --- ## [Is there a way to integrate Elastic and AzureML?](https://discuss.elastic.co/t/is-there-a-way-to-integrate-elastic-and-azureml/141879)
**Author:** [@Dhiwakar\_Kusuma](https://discuss.elastic.co/u/Dhiwakar_Kusuma)\ **Replies:** 0\ **Last updated:** [July 27, 2018, 6:22am UTC](https://discuss.elastic.co/t/is-there-a-way-to-integrate-elastic-and-azureml/141879 "2018-07-27T06:22:32Z")
Hey Guys, Can AzureML consume Elastic search directly? We have multiple Azure MLs - Each getting executed at different times. I'm planning to store the output of one model in Elastic; so that the next model can consume … --- ## [Esrally stuck Running large\_terms](https://discuss.elastic.co/t/esrally-stuck-running-large-terms/141541)
**Author:** [@Andrew\_Yu](https://discuss.elastic.co/u/Andrew_Yu)\ **Replies:** 6\ **Last updated:** [July 27, 2018, 4:48am UTC](https://discuss.elastic.co/t/esrally-stuck-running-large-terms/141541 "2018-07-27T04:48:56Z")
Hi, I was running esrally to test the performance of an elasticsearch cluster of version 5.6.10. Esrally version is 1.0.0. It stucks when running large\_terms at percentage 3% for a very long time( more than 4 hours). He… --- ## [Getting inconsistent records while using From + Size pagination approach](https://discuss.elastic.co/t/getting-inconsistent-records-while-using-from-size-pagination-approach/141820)
**Author:** [@Chitresh](https://discuss.elastic.co/u/Chitresh)\ **Replies:** 0\ **Last updated:** [July 26, 2018, 4:59pm UTC](https://discuss.elastic.co/t/getting-inconsistent-records-while-using-from-size-pagination-approach/141820 "2018-07-26T16:59:30Z")
Hi, We are using From + Size approach (Ref.) for pagination without any explicit sort field. While using it, we noticed discrepancies in the records returned by the query. Sometimes, the records are getting overlapped … --- ## [How encrypt es data or which storge encryption method can support with es?](https://discuss.elastic.co/t/how-encrypt-es-data-or-which-storge-encryption-method-can-support-with-es/141862)
**Author:** [@zqc0512](https://discuss.elastic.co/u/zqc0512)\ **Replies:** 1\ **Last updated:** [July 27, 2018, 3:02am UTC](https://discuss.elastic.co/t/how-encrypt-es-data-or-which-storge-encryption-method-can-support-with-es/141862 "2018-07-27T03:02:59Z")
how encrypt es data or which storge encryption method can support with es? i know one ,but can't think now .. --- ## [How to add date range to query?](https://discuss.elastic.co/t/how-to-add-date-range-to-query/141861)
**Author:** [@Sjaak01](https://discuss.elastic.co/u/Sjaak01)\ **Replies:** 0\ **Last updated:** [July 27, 2018, 2:47am UTC](https://discuss.elastic.co/t/how-to-add-date-range-to-query/141861 "2018-07-27T02:47:10Z")
Hi, How can I add a range filter to the usage\_offset part of this query? I want usage\_current to return the last known value andusage\_offset the return the last known value for 1 hour or more ago. I tried adding range … --- ## [Hive-Elasticsearch connectivity, RESOLVED](https://discuss.elastic.co/t/hive-elasticsearch-connectivity-resolved/139849)
**Author:** [@hsk04](https://discuss.elastic.co/u/hsk04)\ **Replies:** 0\ **Last updated:** [July 12, 2018, 10:46pm UTC](https://discuss.elastic.co/t/hive-elasticsearch-connectivity-resolved/139849 "2018-07-12T22:46:33Z")
Hello all, I am trying to create a external table from hive. The table will be created in Elasticsearch, but it is giving me connection refused error. Hive - Present in Cloudera Quickstart VM Elasticsearch and Kibana … --- ## [Data duplicated in Elasticsearch when added from Hive - RESOLVED](https://discuss.elastic.co/t/data-duplicated-in-elasticsearch-when-added-from-hive-resolved/140400)
**Author:** [@hsk04](https://discuss.elastic.co/u/hsk04)\ **Replies:** 2\ **Last updated:** [July 26, 2018, 10:44pm UTC](https://discuss.elastic.co/t/data-duplicated-in-elasticsearch-when-added-from-hive-resolved/140400 "2018-07-26T22:44:58Z")
Hi all, I have a table in Hive and it has: 1,412,444 records with following fields: timestamp TIMESTAMP, clientid STRING, kitnumber STRING, sessionid STRING, sessionduration INT, countofsession INT, dayssincelastsessi… --- ## [Using ES Java Rest Client version 6.3 with Elasticsearch version 6.2](https://discuss.elastic.co/t/using-es-java-rest-client-version-6-3-with-elasticsearch-version-6-2/141830)
**Author:** [@BrobaFett](https://discuss.elastic.co/u/BrobaFett)\ **Replies:** 3\ **Last updated:** [July 26, 2018, 8:20pm UTC](https://discuss.elastic.co/t/using-es-java-rest-client-version-6-3-with-elasticsearch-version-6-2/141830 "2018-07-26T20:20:10Z")
Hi everyone, I am trying to decide which Java client to use (its between Jest and the Elasticsearch Java Rest Client and I'd prefer to use the latter). I was comparing the supported APIs between 6.3 and 6.2 for the Elas… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1600) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1602)