# Elasticsearch

**URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1901

[Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md)

**Page:** 1902

---

## [RestHighLevelClient and termvectors](https://discuss.elastic.co/t/resthighlevelclient-and-termvectors/105829)

<div class="topic-metadata">

**Author:** [@sean](https://discuss.elastic.co/u/sean)\
**Replies:** 1\
**Last updated:** [November 3, 2017, 9:13am UTC](https://discuss.elastic.co/t/resthighlevelclient-and-termvectors/105829 "2017-11-03T09:13:28Z")

</div>

I have some termvectors code working using the TransportClient, but I am trying to do a migration to the new RestHighLevelClient (since transport is being deprecated) and I can't find any docs on it. I am pretty sure I …

---

## [How to push json data from spark to elastic search](https://discuss.elastic.co/t/how-to-push-json-data-from-spark-to-elastic-search/106288)

<div class="topic-metadata">

**Author:** [@BleedCode](https://discuss.elastic.co/u/BleedCode)\
**Replies:** 0\
**Last updated:** [November 3, 2017, 8:52am UTC](https://discuss.elastic.co/t/how-to-push-json-data-from-spark-to-elastic-search/106288 "2017-11-03T08:52:48Z")

</div>

Hi m new elasticsearch and m trying to push json data to elastic search, But when i execute following code: JavaDStream\<Map\<String, Object\>\> facts =lines.map(json-\>{ HashMap\<String, Object\> factMap = new HashMap\<\>…

---

## [How to delete data by id in spark](https://discuss.elastic.co/t/how-to-delete-data-by-id-in-spark/106282)

<div class="topic-metadata">

**Author:** [@hyitclj](https://discuss.elastic.co/u/hyitclj)\
**Replies:** 0\
**Last updated:** [November 3, 2017, 8:21am UTC](https://discuss.elastic.co/t/how-to-delete-data-by-id-in-spark/106282 "2017-11-03T08:21:15Z")

</div>

I use spark sql to search ES data,that is OK, but ,in my new business I want delete by id in my spark task,how to solve it ?

---

## [How to update about JavaEsSpark.saveToEs](https://discuss.elastic.co/t/how-to-update-about-javaesspark-savetoes/106279)

<div class="topic-metadata">

**Author:** [@hyitclj](https://discuss.elastic.co/u/hyitclj)\
**Replies:** 0\
**Last updated:** [November 3, 2017, 8:09am UTC](https://discuss.elastic.co/t/how-to-update-about-javaesspark-savetoes/106279 "2017-11-03T08:09:37Z")

</div>

Issue description Description My test ES data: #! Deprecation: query malformed, empty clause found at \[2:13\] { "took": 1, "timed\_out": false, "\_shards": { "total": 5, "successful": 5, "failed": 0 }, "hits": { …

---

## [How to search ES data in java spark's mapPartitionsToPair](https://discuss.elastic.co/t/how-to-search-es-data-in-java-sparks-mappartitionstopair/106281)

<div class="topic-metadata">

**Author:** [@hyitclj](https://discuss.elastic.co/u/hyitclj)\
**Replies:** 0\
**Last updated:** [November 3, 2017, 8:15am UTC](https://discuss.elastic.co/t/how-to-search-es-data-in-java-sparks-mappartitionstopair/106281 "2017-11-03T08:15:01Z")

</div>

in my code imsiRdd.mapPartitionsToPair(new PairFlatMapFunction\<Iterator, String, List\>() { @Override public Iterator\<Tuple2\<String, List\>\> call(Iterator rowIterator) throws Exception { xx…

---

## [Using a detector field value as an influencer](https://discuss.elastic.co/t/using-a-detector-field-value-as-an-influencer/106184)

<div class="topic-metadata">

**Author:** [@anomalyml](https://discuss.elastic.co/u/anomalyml)\
**Replies:** 2\
**Last updated:** [November 3, 2017, 6:45am UTC](https://discuss.elastic.co/t/using-a-detector-field-value-as-an-influencer/106184 "2017-11-03T06:45:29Z")

</div>

Hi, I have a data with following field name and values: \<Metric\_1\> \<Metric\_2\> \<Metric\_3\> \<Server\_Name\> 1-01-2017 10 20 30 Sever\_1 2-01-2017 50 60 70 Server\_2 . . etc. In the mapping I declare "Server\_Name" field…

---

## [Not getting exact match first in the elastic search](https://discuss.elastic.co/t/not-getting-exact-match-first-in-the-elastic-search/106269)

<div class="topic-metadata">

**Author:** [@pavani](https://discuss.elastic.co/u/pavani)\
**Replies:** 2\
**Last updated:** [November 3, 2017, 5:46am UTC](https://discuss.elastic.co/t/not-getting-exact-match-first-in-the-elastic-search/106269 "2017-11-03T05:46:37Z")

</div>

I am newbie to elastic search.So i have a scenario like i have a values like... cricket, cricketab, cricketbcd, cricketcd, crazy, my fav game is cricket, cricket king, cricbuzzz, cricket is universal game, anu likes cr…

---

## [Difference in Results in Kibana and API](https://discuss.elastic.co/t/difference-in-results-in-kibana-and-api/106187)

<div class="topic-metadata">

**Author:** [@akash.01](https://discuss.elastic.co/u/akash.01)\
**Replies:** 2\
**Last updated:** [November 3, 2017, 3:58am UTC](https://discuss.elastic.co/t/difference-in-results-in-kibana-and-api/106187 "2017-11-03T03:58:23Z")

</div>

Hi there, I am learning to use Python API to query Elasticsearch. I was trying to run some queries in Kibana, I copied the same json request from the json blob of Kibana and used the same to query using python. Both r…

---

## [Can i set vm.max\_map\_count at creation?](https://discuss.elastic.co/t/can-i-set-vm-max-map-count-at-creation/105456)

<div class="topic-metadata">

**Author:** [@DStorck](https://discuss.elastic.co/u/DStorck)\
**Replies:** 1\
**Last updated:** [November 3, 2017, 1:38am UTC](https://discuss.elastic.co/t/can-i-set-vm-max-map-count-at-creation/105456 "2017-11-03T01:38:15Z")

</div>

I am getting this error: max virtual memory areas vm.max\_map\_count \[65530\] is too low, increase to at least \[262144\] The research I've done shows that once elasticsearch is running, I could go in and raise the limit by u…

---

## [ES - SQL query equivalent](https://discuss.elastic.co/t/es-sql-query-equivalent/105284)

<div class="topic-metadata">

**Author:** [@Dallas\_Toth](https://discuss.elastic.co/u/Dallas_Toth)\
**Replies:** 2\
**Last updated:** [November 2, 2017, 11:49pm UTC](https://discuss.elastic.co/t/es-sql-query-equivalent/105284 "2017-11-02T23:49:24Z")

</div>

SQL Query Select \* from posts where userid in (Select userid from users where username like 'Mr%') I am wanting to get the results from posts for those userid's. Userid exists in both index's but the username only exi…

---

## [Azure Template support for Elastic 5.X](https://discuss.elastic.co/t/azure-template-support-for-elastic-5-x/106198)

<div class="topic-metadata">

**Author:** [@Narmatha](https://discuss.elastic.co/u/Narmatha)\
**Replies:** 1\
**Last updated:** [November 2, 2017, 11:33pm UTC](https://discuss.elastic.co/t/azure-template-support-for-elastic-5-x/106198 "2017-11-02T23:33:31Z")

</div>

Does Azure market place supports elastic 5.0 Version ? Would i be able to launch VM with elastic template image ?

---

## [Workaround for 'JOIN' in Kibana/ES](https://discuss.elastic.co/t/workaround-for-join-in-kibana-es/105929)

<div class="topic-metadata">

**Author:** [@seth.yes](https://discuss.elastic.co/u/seth.yes)\
**Replies:** 1\
**Last updated:** [November 2, 2017, 11:25pm UTC](https://discuss.elastic.co/t/workaround-for-join-in-kibana-es/105929 "2017-11-02T23:25:32Z")

</div>

I use Elasticsearch to document URLs requested by users. I know that since this is a NoSQL database, there are issues with performing joins. I've read up on nested queries as well as parent/child aggregations, but am un…

---

## [How to create field without norms when creating an index](https://discuss.elastic.co/t/how-to-create-field-without-norms-when-creating-an-index/106250)

<div class="topic-metadata">

**Author:** [@EuclideanSearch](https://discuss.elastic.co/u/EuclideanSearch)\
**Replies:** 1\
**Last updated:** [November 2, 2017, 11:00pm UTC](https://discuss.elastic.co/t/how-to-create-field-without-norms-when-creating-an-index/106250 "2017-11-02T23:00:23Z")

</div>

Hi, I am trying to create an index like so: { "my\_new\_index": { "mappings": { "my\_mapping": { "properties": { "my\_id": { "type": "keyword", "norms": false } }}} But when I use the API to get the index I do no…

---

## [ELK gathering logs from all Azure regions - is it possible?](https://discuss.elastic.co/t/elk-gathering-logs-from-all-azure-regions-is-it-possible/103983)

<div class="topic-metadata">

**Author:** [@przemolb](https://discuss.elastic.co/u/przemolb)\
**Replies:** 6\
**Last updated:** [November 2, 2017, 9:16pm UTC](https://discuss.elastic.co/t/elk-gathering-logs-from-all-azure-regions-is-it-possible/103983 "2017-11-02T21:16:08Z")

</div>

Hi all, we are thinking of deploying ELK stack for our cloud only based company (azure). We are in several Azure regions and would like to have a look at all logs from all these regions. Because in Azure there is no pee…

---

## [ElasticSearch 2.3.5 and Bitbucket failes to start](https://discuss.elastic.co/t/elasticsearch-2-3-5-and-bitbucket-failes-to-start/104283)

<div class="topic-metadata">

**Author:** [@Kris\_Boultbee](https://discuss.elastic.co/u/Kris_Boultbee)\
**Replies:** 11\
**Last updated:** [November 2, 2017, 8:17pm UTC](https://discuss.elastic.co/t/elasticsearch-2-3-5-and-bitbucket-failes-to-start/104283 "2017-11-02T20:17:34Z")

</div>

I'm attempting to configure Elasticsearch 2.3.5 to work with our Bitbucket Sever install. I'm using this older version because it is the newest version supported by Bitbucket Server. However, trying to configure Elastics…

---

## [Query scores are different when search on the same title](https://discuss.elastic.co/t/query-scores-are-different-when-search-on-the-same-title/106082)

<div class="topic-metadata">

**Author:** [@niceliubing](https://discuss.elastic.co/u/niceliubing)\
**Replies:** 3\
**Last updated:** [November 2, 2017, 7:15pm UTC](https://discuss.elastic.co/t/query-scores-are-different-when-search-on-the-same-title/106082 "2017-11-02T19:15:36Z")

</div>

I have two records with same book titles. PUT books/book/2 { "title" : "Nineteen Eighty-Four", "reader\_rating" : 4.0, "author" : "John Steinbeck" } PUT books/book/3 { "title" : "Nineteen Eighty-Four", "reader\_r…

---

## [AWS Elasticsearch Service + Spark + proxy](https://discuss.elastic.co/t/aws-elasticsearch-service-spark-proxy/105960)

<div class="topic-metadata">

**Author:** [@java8964](https://discuss.elastic.co/u/java8964)\
**Replies:** 1\
**Last updated:** [November 2, 2017, 6:31pm UTC](https://discuss.elastic.co/t/aws-elasticsearch-service-spark-proxy/105960 "2017-11-02T18:31:25Z")

</div>

Hi, We are testing pushing some of the data from our on premise bigdata cluster to the Elasticsearch service running on AWS. The version is 5.5.2. We want to do a POC project of using Spark + ElasticsearchHadoop. Our Sp…

---

## [Search with wildcard](https://discuss.elastic.co/t/search-with-wildcard/106214)

<div class="topic-metadata">

**Author:** [@wshatford](https://discuss.elastic.co/u/wshatford)\
**Replies:** 0\
**Last updated:** [November 2, 2017, 3:30pm UTC](https://discuss.elastic.co/t/search-with-wildcard/106214 "2017-11-02T15:30:23Z")

</div>

\*\* Never mind. Figured it out. Was being limited to 10 results, duh \*\* This search should include "Santa Monica", but I only get results with "Ma...". If I change the search to "Santa Mo\*" it works fine. Windows 10…

---

## [Sense chrome extension disabled](https://discuss.elastic.co/t/sense-chrome-extension-disabled/106156)

<div class="topic-metadata">

**Author:** [@apakshabhat](https://discuss.elastic.co/u/apakshabhat)\
**Replies:** 4\
**Last updated:** [November 2, 2017, 6:21pm UTC](https://discuss.elastic.co/t/sense-chrome-extension-disabled/106156 "2017-11-02T18:21:38Z")

</div>

hello , we were using sense chrome extension for search index and maping..That has been disabled.We are using Elastic version 1.7.3..Can anyone suggest any good alternative for sense or is there any way to enable it

---

## [Extend aggregation calculation to previous time range](https://discuss.elastic.co/t/extend-aggregation-calculation-to-previous-time-range/106000)

<div class="topic-metadata">

**Author:** [@shaharmor](https://discuss.elastic.co/u/shaharmor)\
**Replies:** 2\
**Last updated:** [November 2, 2017, 4:04pm UTC](https://discuss.elastic.co/t/extend-aggregation-calculation-to-previous-time-range/106000 "2017-11-02T16:04:09Z")

</div>

Hi, I want to do a Derivative aggregation, but because derivative is using 2 data point for calculation, the first bucket doesn't have a value. Is there any way to tell ES to query for the previous bucket as well so th…

---

## [Predefined Synonym for elastic](https://discuss.elastic.co/t/predefined-synonym-for-elastic/106199)

<div class="topic-metadata">

**Author:** [@Narmatha](https://discuss.elastic.co/u/Narmatha)\
**Replies:** 1\
**Last updated:** [November 2, 2017, 4:03pm UTC](https://discuss.elastic.co/t/predefined-synonym-for-elastic/106199 "2017-11-02T16:03:41Z")

</div>

Do we have predefined dictionary of synonyms for elastic search ? So that i can download and use it for my application.

---

## [Alternative for sql join in elastic stack?](https://discuss.elastic.co/t/alternative-for-sql-join-in-elastic-stack/106211)

<div class="topic-metadata">

**Author:** [@asp](https://discuss.elastic.co/u/asp)\
**Replies:** 1\
**Last updated:** [November 2, 2017, 3:59pm UTC](https://discuss.elastic.co/t/alternative-for-sql-join-in-elastic-stack/106211 "2017-11-02T15:59:45Z")

</div>

Hi, I need to trace and aggregate requests of user sessions. following fields I get on a login request: - timestamp - session id - function (login) - username - client version number Following fields I get on a get-d…

---

## [Choosing the Correct AWS EC2 Servers](https://discuss.elastic.co/t/choosing-the-correct-aws-ec2-servers/105902)

<div class="topic-metadata">

**Author:** [@MPurcell](https://discuss.elastic.co/u/MPurcell)\
**Replies:** 5\
**Last updated:** [November 2, 2017, 2:03pm UTC](https://discuss.elastic.co/t/choosing-the-correct-aws-ec2-servers/105902 "2017-11-02T14:03:54Z")

</div>

Hello everyone. I'm in the process of creating my newest cluster that will eventually be the basis for my production cluster. My question, what types of servers would you recommend to run the master nodes, data nodes, an…

---

## [Flume to elastic data transfer avro conversion](https://discuss.elastic.co/t/flume-to-elastic-data-transfer-avro-conversion/106110)

<div class="topic-metadata">

**Author:** [@putharekulu](https://discuss.elastic.co/u/putharekulu)\
**Replies:** 0\
**Last updated:** [November 2, 2017, 2:26am UTC](https://discuss.elastic.co/t/flume-to-elastic-data-transfer-avro-conversion/106110 "2017-11-02T02:26:26Z")

</div>

Hello, I am trying to use flume to send data to elastic . Flume collects the logs from kafka and sinks it to elastic. log format in kafka is in avro. Data that goes to elastic has to be in json format. can anyone sugge…

---

## [Using graphs in java : cient creation error](https://discuss.elastic.co/t/using-graphs-in-java-cient-creation-error/105422)

<div class="topic-metadata">

**Author:** [@knights](https://discuss.elastic.co/u/knights)\
**Replies:** 4\
**Last updated:** [November 2, 2017, 1:18pm UTC](https://discuss.elastic.co/t/using-graphs-in-java-cient-creation-error/105422 "2017-11-02T13:18:35Z")

</div>

Hello, I'm currently testing the graph api offered by X-pack. I could toy a bit with it using kibana, and wanted to test using it in my java application However, I'm stuck at the creation of the PreBuiltXPackTransport…

---

## [Get direct hit first using fuzzy query in autocompletion suggester](https://discuss.elastic.co/t/get-direct-hit-first-using-fuzzy-query-in-autocompletion-suggester/106201)

<div class="topic-metadata">

**Author:** [@Varsha\_Rao](https://discuss.elastic.co/u/Varsha_Rao)\
**Replies:** 0\
**Last updated:** [November 2, 2017, 1:03pm UTC](https://discuss.elastic.co/t/get-direct-hit-first-using-fuzzy-query-in-autocompletion-suggester/106201 "2017-11-02T13:03:09Z")

</div>

I'm using Elasticsearch to provide auto suggestions to names in a database, and I want it to be fuzzy to allow for minor spelling errors. Now I have two names that sound similar, JohnA and JohnB indexed. This is my query…

---

## [How to speed up elasticsearch startup?](https://discuss.elastic.co/t/how-to-speed-up-elasticsearch-startup/106180)

<div class="topic-metadata">

**Author:** [@asp](https://discuss.elastic.co/u/asp)\
**Replies:** 4\
**Last updated:** [November 2, 2017, 12:37pm UTC](https://discuss.elastic.co/t/how-to-speed-up-elasticsearch-startup/106180 "2017-11-02T12:37:44Z")

</div>

Hi, We are still using ES 5.1.2 in production as single instance. Is there any way to speed up the startup time? I restarted because I updated the used jre. Startup takes about 40 minutes until all indices are at stat…

---

## ["View By' field in 'Anomaly Explorer' window](https://discuss.elastic.co/t/view-by-field-in-anomaly-explorer-window/106152)

<div class="topic-metadata">

**Author:** [@anomalyml](https://discuss.elastic.co/u/anomalyml)\
**Replies:** 2\
**Last updated:** [November 2, 2017, 12:08pm UTC](https://discuss.elastic.co/t/view-by-field-in-anomaly-explorer-window/106152 "2017-11-02T12:08:25Z")

</div>

Hi, In the 'Anomaly Explorer' window under 'Anomaly Timeline' section there is a field called "View By". It displays all influencer names along with the 'job ID' value. This is used to filter and display the anomaly ana…

---

## [Elasticsearch cluster state is yellow](https://discuss.elastic.co/t/elasticsearch-cluster-state-is-yellow/106173)

<div class="topic-metadata">

**Author:** [@raja\_gopal](https://discuss.elastic.co/u/raja_gopal)\
**Replies:** 2\
**Last updated:** [November 2, 2017, 12:06pm UTC](https://discuss.elastic.co/t/elasticsearch-cluster-state-is-yellow/106173 "2017-11-02T12:06:24Z")

</div>

I have a 3 node cluster and i have set minimum master node to 1. My cluster was working fine these days. But now i am a find a issue, that whatever new index i create other than .kibana all are in yellow state. When i tr…

---

## ['View examples' for mlcategory detector hangs browser (6.0.0-rc1)](https://discuss.elastic.co/t/view-examples-for-mlcategory-detector-hangs-browser-6-0-0-rc1/104270)

<div class="topic-metadata">

**Author:** [@Badger](https://discuss.elastic.co/u/Badger)\
**Replies:** 7\
**Last updated:** [November 2, 2017, 10:06am UTC](https://discuss.elastic.co/t/view-examples-for-mlcategory-detector-hangs-browser-6-0-0-rc1/104270 "2017-11-02T10:06:47Z")

</div>

I have created a job using count by mlcategory on a message field. In the Anomaly Explorer I get anomalies, and in the links column there is an Open link / View examples link. In the next column we have category examples…

[Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1900)

[Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1902)
