# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1938 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1939 --- ## [Apply analyzer on Object fields](https://discuss.elastic.co/t/apply-analyzer-on-object-fields/101961)
**Author:** [@lea](https://discuss.elastic.co/u/lea)\ **Replies:** 0\ **Last updated:** [September 27, 2017, 9:35am UTC](https://discuss.elastic.co/t/apply-analyzer-on-object-fields/101961 "2017-09-27T09:35:40Z")
Hello! I have this analyzer: { "index": { "number\_of\_shards": 1, "analysis": { "filter": { "word\_joiner": { "type": "word\_delimiter", "catenate\_all": true, "preserv… --- ## [User impersonation does not work with Active directory realm, but it should](https://discuss.elastic.co/t/user-impersonation-does-not-work-with-active-directory-realm-but-it-should/100774)
**Author:** [@jetnet](https://discuss.elastic.co/u/jetnet)\ **Replies:** 4\ **Last updated:** [September 27, 2017, 9:34am UTC](https://discuss.elastic.co/t/user-impersonation-does-not-work-with-active-directory-realm-but-it-should/100774 "2017-09-27T09:34:43Z")
hi All, I'm following up the previous topic User impersonation does not work with Active directory realm, as the lastest x-pack version 5.6.0 should support bind\_dn parameter. I tried to setup the user impersonation, b… --- ## [\[Node-107\] disconnected from Loadbalancer due to explicit disconnect call](https://discuss.elastic.co/t/node-107-disconnected-from-loadbalancer-due-to-explicit-disconnect-call/101849)
**Author:** [@Ersoy\_Vatansever](https://discuss.elastic.co/u/Ersoy_Vatansever)\ **Replies:** 5\ **Last updated:** [September 27, 2017, 9:24am UTC](https://discuss.elastic.co/t/node-107-disconnected-from-loadbalancer-due-to-explicit-disconnect-call/101849 "2017-09-27T09:24:46Z")
Using v1.7.4 on 1 cluster 3 data node, 1 master and 1 loadbalancer. This issue fires from a week. I dont know what happend and start to fire this issue. Can any one help me ? LOG1 : \[2017-09-26 15:24:06,545\]\[DEBUG\]\[t… --- ## [Balancing searches on a cluster](https://discuss.elastic.co/t/balancing-searches-on-a-cluster/101887)
**Author:** [@wbehn](https://discuss.elastic.co/u/wbehn)\ **Replies:** 2\ **Last updated:** [September 27, 2017, 9:03am UTC](https://discuss.elastic.co/t/balancing-searches-on-a-cluster/101887 "2017-09-27T09:03:56Z")
Hi all, I have an elasticsearch cluster consisting of one client node and two data nodes as a part of an ELK stack. As we have configured 5 shards per index and 1 replica, every data node gets 2 primary shards and 3 rep… --- ## [Query with union and group in elasticsearch](https://discuss.elastic.co/t/query-with-union-and-group-in-elasticsearch/101954)
**Author:** [@jackl](https://discuss.elastic.co/u/jackl)\ **Replies:** 0\ **Last updated:** [September 27, 2017, 9:03am UTC](https://discuss.elastic.co/t/query-with-union-and-group-in-elasticsearch/101954 "2017-09-27T09:03:32Z")
select table.x, sum(table.y) from( select a x, sum(b) y from table1 group by a union all select c x, sum(d) y from table1 group by c ) I don't know how to implement the SQL above in elasticsearch(5.5)， Does anyone … --- ## [\[elasticserach performance\] match query very slowly!](https://discuss.elastic.co/t/elasticserach-performance-match-query-very-slowly/100743)
**Author:** [@laoyang360](https://discuss.elastic.co/u/laoyang360)\ **Replies:** 2\ **Last updated:** [September 27, 2017, 8:10am UTC](https://discuss.elastic.co/t/elasticserach-performance-match-query-very-slowly/100743 "2017-09-27T08:10:44Z")
Search the keyword "ladder" use matchQuery (java api) it will be very very very slowly! Time consuming as follows: { "took": 7778, "timed\_out": false, "\_shards": { "total": 5, "successful": 5, "failed": 0 }, … --- ## [Best Elkstack setup and system requirements](https://discuss.elastic.co/t/best-elkstack-setup-and-system-requirements/101844)
**Author:** [@FRoodt](https://discuss.elastic.co/u/FRoodt)\ **Replies:** 2\ **Last updated:** [September 27, 2017, 7:54am UTC](https://discuss.elastic.co/t/best-elkstack-setup-and-system-requirements/101844 "2017-09-27T07:54:46Z")
Hi there, I'm running a Elkstack (Elastic,Llogstash and Kibana) on one VM to process large log files. The resources are shared with another VM but that VM does not use a lot of the server resources. I constantly run in… --- ## [On the document multi-field search slow problem](https://discuss.elastic.co/t/on-the-document-multi-field-search-slow-problem/101922)
**Author:** [@smithyj](https://discuss.elastic.co/u/smithyj)\ **Replies:** 3\ **Last updated:** [September 27, 2017, 7:31am UTC](https://discuss.elastic.co/t/on-the-document-multi-field-search-slow-problem/101922 "2017-09-27T07:31:17Z")
Problem Description A document in the organization's index that contains all the department collections for this organization, such as { id：1， org\_name：'Google'， department\_list：\[ { id: 1, … --- ## [Pagination internal working using from/size](https://discuss.elastic.co/t/pagination-internal-working-using-from-size/101919)
**Author:** [@addhawan](https://discuss.elastic.co/u/addhawan)\ **Replies:** 1\ **Last updated:** [September 27, 2017, 7:30am UTC](https://discuss.elastic.co/t/pagination-internal-working-using-from-size/101919 "2017-09-27T07:30:05Z")
Hi, I was looking at the documentation for pagination here: Pagination | Elasticsearch: The Definitive Guide \[2.x\] | Elastic which mentions : Results are sorted before being returned. But remember that a search reque… --- ## [RestClient and HttpPipeline](https://discuss.elastic.co/t/restclient-and-httppipeline/99674)
**Author:** [@ananth](https://discuss.elastic.co/u/ananth)\ **Replies:** 2\ **Last updated:** [September 27, 2017, 7:09am UTC](https://discuss.elastic.co/t/restclient-and-httppipeline/99674 "2017-09-27T07:09:49Z")
Hi, We are migrating from node client to RestClient. Is ClosableAsyncHttpClient using Http Pipeline internally to manage requests and response ? Come across the following link Response should be sent from server i… --- ## [Elasticsearch changes are not reflecting in docker image pushed to docker hub](https://discuss.elastic.co/t/elasticsearch-changes-are-not-reflecting-in-docker-image-pushed-to-docker-hub/101931)
**Author:** [@RohanKumbhar](https://discuss.elastic.co/u/RohanKumbhar)\ **Replies:** 2\ **Last updated:** [September 27, 2017, 6:26am UTC](https://discuss.elastic.co/t/elasticsearch-changes-are-not-reflecting-in-docker-image-pushed-to-docker-hub/101931 "2017-09-27T06:26:12Z")
Hello Team, I have pushed docker image with elasticsearch changes like index setting , mapping and ingest pipeline etc. But when i pull the same image again , those changes are not reflecting in that image. Is there an… --- ## [Dividing counts of two different queries in kibana](https://discuss.elastic.co/t/dividing-counts-of-two-different-queries-in-kibana/101917)
**Author:** [@Jonny\_Doe](https://discuss.elastic.co/u/Jonny_Doe)\ **Replies:** 0\ **Last updated:** [September 27, 2017, 1:12am UTC](https://discuss.elastic.co/t/dividing-counts-of-two-different-queries-in-kibana/101917 "2017-09-27T01:12:06Z")
I am trying to create a lucene expression for displaying division on counts of two queries. Both queries contain textual information and both results are in message field. I am not sure how to write this correctly. So fa… --- ## [UI/Plugin for explain api scoring](https://discuss.elastic.co/t/ui-plugin-for-explain-api-scoring/101911)
**Author:** [@mkc\_user](https://discuss.elastic.co/u/mkc_user)\ **Replies:** 0\ **Last updated:** [September 27, 2017, 12:09am UTC](https://discuss.elastic.co/t/ui-plugin-for-explain-api-scoring/101911 "2017-09-27T00:09:31Z")
Do we have any UI /Plugin which can help to execute the explain api for every query/record. If so ,please let me know. --- ## [Search returns no results for partial string](https://discuss.elastic.co/t/search-returns-no-results-for-partial-string/101793)
**Author:** [@amiexc](https://discuss.elastic.co/u/amiexc)\ **Replies:** 2\ **Last updated:** [September 26, 2017, 11:57pm UTC](https://discuss.elastic.co/t/search-returns-no-results-for-partial-string/101793 "2017-09-26T23:57:08Z")
Hello, I have a document with field "name": "Hotel Relais Fontana Di Trevi", indexed using the default (standard) analyser. I am running a search on this field with the string "fontana di tre" and max expansions 100 an… --- ## [Why do I have term x and term x.raw, for my date fields?](https://discuss.elastic.co/t/why-do-i-have-term-x-and-term-x-raw-for-my-date-fields/101809)
**Author:** [@tomer](https://discuss.elastic.co/u/tomer)\ **Replies:** 1\ **Last updated:** [September 26, 2017, 11:17pm UTC](https://discuss.elastic.co/t/why-do-i-have-term-x-and-term-x-raw-for-my-date-fields/101809 "2017-09-26T23:17:52Z")
Hi, I have for my date fields the date in .raw format and the same field duplicated without.raw ending but as a String value. Why is this? --- ## [Beider\_morse phonetic encoder silently fails when languageset not specified](https://discuss.elastic.co/t/beider-morse-phonetic-encoder-silently-fails-when-languageset-not-specified/101581)
**Author:** [@bkazez](https://discuss.elastic.co/u/bkazez)\ **Replies:** 2\ **Last updated:** [September 26, 2017, 11:10pm UTC](https://discuss.elastic.co/t/beider-morse-phonetic-encoder-silently-fails-when-languageset-not-specified/101581 "2017-09-26T23:10:31Z")
Hi, I'm considering using ElasticSearch for a project and ran into an issue with beider\_morse phonetic encoding. I need Beider Morse language detection, so based on the docs at https://www.elastic.co/guide/en/elasticsear… --- ## [Elasticsearch python client](https://discuss.elastic.co/t/elasticsearch-python-client/101867)
**Author:** [@eng.behjati](https://discuss.elastic.co/u/eng.behjati)\ **Replies:** 1\ **Last updated:** [September 26, 2017, 11:02pm UTC](https://discuss.elastic.co/t/elasticsearch-python-client/101867 "2017-09-26T23:02:40Z")
Hi! I'm new in elasticsearch. we have a 7 node elasticsearch production state cluster and all of them are master, data and coordinator node. I'm wondering how to balance requests to avoid one server be the only gateway … --- ## [Lucene Geo spatial3d - Failure creating a 3 dot polygon](https://discuss.elastic.co/t/lucene-geo-spatial3d-failure-creating-a-3-dot-polygon/101601)
**Author:** [@lior-k](https://discuss.elastic.co/u/lior-k)\ **Replies:** 3\ **Last updated:** [September 26, 2017, 10:57pm UTC](https://discuss.elastic.co/t/lucene-geo-spatial3d-failure-creating-a-3-dot-polygon/101601 "2017-09-26T22:57:24Z")
Hi, I'm trying to create a polygon from 3 GeoPoints, but I get this exception: java.lang.IllegalArgumentException: Convex polygon has a side that is more than 180 degrees at org.apache.lucene.spatial3d.geom.GeoConvex… --- ## [Database access via plugins](https://discuss.elastic.co/t/database-access-via-plugins/101765)
**Author:** [@Ivan](https://discuss.elastic.co/u/Ivan)\ **Replies:** 7\ **Last updated:** [September 26, 2017, 9:50pm UTC](https://discuss.elastic.co/t/database-access-via-plugins/101765 "2017-09-26T21:50:06Z")
I am finally rebooting an old plugin that supports database access within Elasticsearch to 5.x. Was able to quickly get around the new plugin infrastructure, but I am failing to get past the new security features. Usi… --- ## [Automated log stash or curl input - json files](https://discuss.elastic.co/t/automated-log-stash-or-curl-input-json-files/101909)
**Author:** [@cxbarbosa](https://discuss.elastic.co/u/cxbarbosa)\ **Replies:** 0\ **Last updated:** [September 26, 2017, 9:36pm UTC](https://discuss.elastic.co/t/automated-log-stash-or-curl-input-json-files/101909 "2017-09-26T21:36:20Z")
I have read a lot of tutorials and I'm still not sure where to start so I want to just ask the question up front. I have large inventory data files being pulled down in JSON format using API calls. Ideally, I want to pa… --- ## [What is the recommend way to index data from Web App using SQL Server?](https://discuss.elastic.co/t/what-is-the-recommend-way-to-index-data-from-web-app-using-sql-server/101070)
**Author:** [@Dzyann](https://discuss.elastic.co/u/Dzyann)\ **Replies:** 10\ **Last updated:** [September 26, 2017, 7:13pm UTC](https://discuss.elastic.co/t/what-is-the-recommend-way-to-index-data-from-web-app-using-sql-server/101070 "2017-09-26T19:13:58Z")
We are currently working on an application with a large database and we want to use Elasticsearch as our search engine. We are rather new working with Elasticsearch and although we have been reading the documentation, s… --- ## [Save elasticsearch results](https://discuss.elastic.co/t/save-elasticsearch-results/101836)
**Author:** [@afonso.ribeiro](https://discuss.elastic.co/u/afonso.ribeiro)\ **Replies:** 6\ **Last updated:** [September 26, 2017, 4:03pm UTC](https://discuss.elastic.co/t/save-elasticsearch-results/101836 "2017-09-26T16:03:54Z")
Hi everyone, I'm taking the first steps in elasticsearch and I have a question. I have an index with the sales of my company and the respective sales days. I need to add up all the sales per month and make a chart to … --- ## [Set processor in NEST](https://discuss.elastic.co/t/set-processor-in-nest/101875)
**Author:** [@ESCoder](https://discuss.elastic.co/u/ESCoder)\ **Replies:** 0\ **Last updated:** [September 26, 2017, 3:03pm UTC](https://discuss.elastic.co/t/set-processor-in-nest/101875 "2017-09-26T15:03:57Z")
Hi, I'm using ES 5.1.2 and NEST 5.x, I'm trying add an ingest pipeline similar to the example given below. In my implementation I have a Base64DocumentContent field which has the base64 string. I want the extracted "… --- ## [What's the best for Eleasticsearch ? (managment of index)](https://discuss.elastic.co/t/whats-the-best-for-eleasticsearch-managment-of-index/101841)
**Author:** [@andrieuxa](https://discuss.elastic.co/u/andrieuxa)\ **Replies:** 2\ **Last updated:** [September 26, 2017, 2:47pm UTC](https://discuss.elastic.co/t/whats-the-best-for-eleasticsearch-managment-of-index/101841 "2017-09-26T14:47:25Z")
Hi, First of all, i'm sorry if my english is not totaly correct. I have a question on Elasticsearch about the management of index. My question : For Elasticsearch, it's better : manage a lot index with small size or m… --- ## [Shards Initializing Indefinitely?](https://discuss.elastic.co/t/shards-initializing-indefinitely/101204)
**Author:** [@corona](https://discuss.elastic.co/u/corona)\ **Replies:** 9\ **Last updated:** [September 26, 2017, 2:40pm UTC](https://discuss.elastic.co/t/shards-initializing-indefinitely/101204 "2017-09-26T14:40:32Z")
Hello, We are currently running version 2.4.0 in our production cluster. After node restarts I've noticed we have around 36 shards which seem to be stuck initializing. We have been having problems with nodes crashing d… --- ## [Aging Scheme for Time Based Indexes: Statistic Based Automated Index Generation](https://discuss.elastic.co/t/aging-scheme-for-time-based-indexes-statistic-based-automated-index-generation/101862)
**Author:** [@guardhunt](https://discuss.elastic.co/u/guardhunt)\ **Replies:** 0\ **Last updated:** [September 26, 2017, 2:15pm UTC](https://discuss.elastic.co/t/aging-scheme-for-time-based-indexes-statistic-based-automated-index-generation/101862 "2017-09-26T14:15:11Z")
Context: I am working on building out an aging scheme for time based indexes for log data. I know about closing/opening, snapshot/restore, flushing and deleting, however each of these methods functions off the presumpti… --- ## [Increase Snapshotting Speed while taking a snapshot in Amazon S3 Bucket](https://discuss.elastic.co/t/increase-snapshotting-speed-while-taking-a-snapshot-in-amazon-s3-bucket/101597)
**Author:** [@adityajindal](https://discuss.elastic.co/u/adityajindal)\ **Replies:** 8\ **Last updated:** [September 26, 2017, 2:26pm UTC](https://discuss.elastic.co/t/increase-snapshotting-speed-while-taking-a-snapshot-in-amazon-s3-bucket/101597 "2017-09-26T14:26:22Z")
Hi We are currently having a very large cluster with about 100 TB data in it. We want our snapshot in Amazon S3 Bucket to complete as fast as possible. With reference from this https://www.elastic.co/guide/en/elastics… --- ## [Get source text from suggester](https://discuss.elastic.co/t/get-source-text-from-suggester/101865)
**Author:** [@ebuildy](https://discuss.elastic.co/u/ebuildy)\ **Replies:** 0\ **Last updated:** [September 26, 2017, 2:18pm UTC](https://discuss.elastic.co/t/get-source-text-from-suggester/101865 "2017-09-26T14:18:01Z")
elasticsearch 2.4 We use phrase suggester to do spell checking, this is working fine, but the options returned are analyzed terms, is it possible to have the source tokens instead ? We are using filters: asciifoldin… --- ## [ElasticSearch Windows Service 100% CPU](https://discuss.elastic.co/t/elasticsearch-windows-service-100-cpu/101734)
**Author:** [@aleha84](https://discuss.elastic.co/u/aleha84)\ **Replies:** 13\ **Last updated:** [September 26, 2017, 1:12pm UTC](https://discuss.elastic.co/t/elasticsearch-windows-service-100-cpu/101734 "2017-09-26T13:12:01Z")
Also got similar SO question Using ElasticSearch 5.4.0 as Windows Service. Windows Server 2016 with 16 GB RAM. Installed via command: elasticsearch-service.bat manager Java options: -Xms8g -Xmx8g -XX:+UseConcMarkSwee… --- ## [Higher score to (boost) documents carrying a certain field value](https://discuss.elastic.co/t/higher-score-to-boost-documents-carrying-a-certain-field-value/101733)
**Author:** [@ParitoshBh](https://discuss.elastic.co/u/ParitoshBh)\ **Replies:** 4\ **Last updated:** [September 26, 2017, 1:05pm UTC](https://discuss.elastic.co/t/higher-score-to-boost-documents-carrying-a-certain-field-value/101733 "2017-09-26T13:05:35Z")
I am fairly new to ElasticSearch and getting my feet wet so please pardon if I missed any documentation and/or cannot see/understand the usage clearly. Now, on-to the problem. Following is a simple default mapping I am … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1937) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1939)