# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1204 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1205 --- ## [Workaround for broken pgp signature on es 1.7.6 debian repo](https://discuss.elastic.co/t/workaround-for-broken-pgp-signature-on-es-1-7-6-debian-repo/193547)
**Author:** [@jillesvangurp](https://discuss.elastic.co/u/jillesvangurp)\ **Replies:** 0\ **Last updated:** [August 2, 2019, 1:43pm UTC](https://discuss.elastic.co/t/workaround-for-broken-pgp-signature-on-es-1-7-6-debian-repo/193547 "2019-08-02T13:43:11Z")
I just tried to rebuild some AMIs for our very outdated 1.7 cluster and discovered that our ansible scripts now fail with a signature error on the elastic repo which used to work as documented here: https://www.elastic.… --- ## [Sorting on nested fields containing null values in elasticsearch](https://discuss.elastic.co/t/sorting-on-nested-fields-containing-null-values-in-elasticsearch/193544)
**Author:** [@sakshi\_malik](https://discuss.elastic.co/u/sakshi_malik)\ **Replies:** 0\ **Last updated:** [August 2, 2019, 1:40pm UTC](https://discuss.elastic.co/t/sorting-on-nested-fields-containing-null-values-in-elasticsearch/193544 "2019-08-02T13:40:21Z")
I am trying to sort on nested field in elasticsearch, but it is always showing docs with null valued nested field at the top of the sorted list while sorting in ascending order. I want to sort (in ascending as well as de… --- ## [Creating replica though replica creatin set to 0](https://discuss.elastic.co/t/creating-replica-though-replica-creatin-set-to-0/193255)
**Author:** [@rockykarhe](https://discuss.elastic.co/u/rockykarhe)\ **Replies:** 1\ **Last updated:** [August 2, 2019, 1:18pm UTC](https://discuss.elastic.co/t/creating-replica-though-replica-creatin-set-to-0/193255 "2019-08-02T13:18:27Z")
Hello, I have 3-node cluster setup of ElasticSearch. I want to try out how replication works and in order to test the same I have created a sample index using query given below. Here idea is to create 0 replicas, howeve… --- ## [Match on different fields](https://discuss.elastic.co/t/match-on-different-fields/192362)
**Author:** [@likeElastic](https://discuss.elastic.co/u/likeElastic)\ **Replies:** 1\ **Last updated:** [August 2, 2019, 12:45pm UTC](https://discuss.elastic.co/t/match-on-different-fields/192362 "2019-08-02T12:45:04Z")
I would like to search on different fields: here is my search query: { "index":"ats", "type":"candidate", "body":{ "query":{ "bool":{ "must":{ "term":{ "skill":"python", "location":"romania" } } } } } } … --- ## [Elasticsearch still running off of the included java even after JAVA\_HOME is set](https://discuss.elastic.co/t/elasticsearch-still-running-off-of-the-included-java-even-after-java-home-is-set/192252)
**Author:** [@hursto75](https://discuss.elastic.co/u/hursto75)\ **Replies:** 1\ **Last updated:** [August 2, 2019, 12:17pm UTC](https://discuss.elastic.co/t/elasticsearch-still-running-off-of-the-included-java-even-after-java-home-is-set/192252 "2019-08-02T12:17:38Z")
Elasticsearch still running off of the included java even after JAVA\_HOME is set. Change the Java home and every other program is finding the correct version of JAVA. Where is the config that sets java. Everything I have… --- ## [Elasticsearch SAML2.0 and ADFS - Signature validation issue with single logout](https://discuss.elastic.co/t/elasticsearch-saml2-0-and-adfs-signature-validation-issue-with-single-logout/190666)
**Author:** [@jptp](https://discuss.elastic.co/u/jptp)\ **Replies:** 4\ **Last updated:** [August 2, 2019, 12:08pm UTC](https://discuss.elastic.co/t/elasticsearch-saml2-0-and-adfs-signature-validation-issue-with-single-logout/190666 "2019-08-02T12:08:12Z")
Hello, I am trying to implement a federation server for testing purposes. Currently, the applications and the users are in the same domain. I will try to explain the issue I ran into and what I've troubleshot so far as… --- ## [I broke ES while upgrading from 2.3 to 5.6 :(](https://discuss.elastic.co/t/i-broke-es-while-upgrading-from-2-3-to-5-6/192544)
**Author:** [@tryptych](https://discuss.elastic.co/u/tryptych)\ **Replies:** 1\ **Last updated:** [August 2, 2019, 12:05pm UTC](https://discuss.elastic.co/t/i-broke-es-while-upgrading-from-2-3-to-5-6/192544 "2019-08-02T12:05:51Z")
I'm on CentOS7, using Elastic Search for Graylog. I'm a rookie, learning as I go. I upgraded ES from 2.3 to 5.6 using yum. When I start ES now it fails and doesn't give me any useful feedback. \[root@locker2 ~\]# systemc… --- ## [Show just one document on exact match](https://discuss.elastic.co/t/show-just-one-document-on-exact-match/193525)
**Author:** [@mihalikv](https://discuss.elastic.co/u/mihalikv)\ **Replies:** 0\ **Last updated:** [August 2, 2019, 11:54am UTC](https://discuss.elastic.co/t/show-just-one-document-on-exact-match/193525 "2019-08-02T11:54:04Z")
Hello, I want to ask if it is possible to show just top results with score bigger than x(some integer value). For example: Query: { "query": { "bool": { "should": \[ { "multi\_match": { … --- ## [Ignoring punctuation for sorting](https://discuss.elastic.co/t/ignoring-punctuation-for-sorting/193520)
**Author:** [@spunto](https://discuss.elastic.co/u/spunto)\ **Replies:** 0\ **Last updated:** [August 2, 2019, 11:45am UTC](https://discuss.elastic.co/t/ignoring-punctuation-for-sorting/193520 "2019-08-02T11:45:51Z")
Hello, When sorting on the field "Title", my client is unhappy that records with a title in quotes, or with leading spaces, will be at the top. I've thought of a few ways around this, but they all have problems. One of … --- ## [Which version of Elasticsearch works with NEST and Elasticsearch.Net version 7.1.0](https://discuss.elastic.co/t/which-version-of-elasticsearch-works-with-nest-and-elasticsearch-net-version-7-1-0/193426)
**Author:** [@jxz](https://discuss.elastic.co/u/jxz)\ **Replies:** 1\ **Last updated:** [August 2, 2019, 11:35am UTC](https://discuss.elastic.co/t/which-version-of-elasticsearch-works-with-nest-and-elasticsearch-net-version-7-1-0/193426 "2019-08-02T11:35:13Z")
i just installed NEST and Elasticsearch.NET version 7.1.0 into Visual Studio through NuGet. Now, I am wondering what version(s) of Elasticsearch this version of NEST and Elasticsearch.NET work with. --- ## [Elastic Stack Production deployment](https://discuss.elastic.co/t/elastic-stack-production-deployment/192361)
**Author:** [@singh.piyush862](https://discuss.elastic.co/u/singh.piyush862)\ **Replies:** 2\ **Last updated:** [August 2, 2019, 11:30am UTC](https://discuss.elastic.co/t/elastic-stack-production-deployment/192361 "2019-08-02T11:30:33Z")
We need to deploy elastic stack in production to consume syslog data (amount of data is moderate) During POC we deployed all ELK component in a single VM. In production how should we deploy ELK stack to ensure our envir… --- ## [Filtering a large products base by user history](https://discuss.elastic.co/t/filtering-a-large-products-base-by-user-history/193510)
**Author:** [@Sodium](https://discuss.elastic.co/u/Sodium)\ **Replies:** 0\ **Last updated:** [August 2, 2019, 10:53am UTC](https://discuss.elastic.co/t/filtering-a-large-products-base-by-user-history/193510 "2019-08-02T10:53:27Z")
Hello, This subject has probably been discussed many times but i can't figure out what to type in Google to find answers so fill free to send me a link to a different discussion and close this one if that's the case. M… --- ## [Is Elastic Search suitable for searching text in all tables?](https://discuss.elastic.co/t/is-elastic-search-suitable-for-searching-text-in-all-tables/193492)
**Author:** [@Yasir\_Arafat](https://discuss.elastic.co/u/Yasir_Arafat)\ **Replies:** 2\ **Last updated:** [August 2, 2019, 10:41am UTC](https://discuss.elastic.co/t/is-elastic-search-suitable-for-searching-text-in-all-tables/193492 "2019-08-02T10:41:57Z")
I have question about Elastic Search is that I have Sql Server Database and i have to Search all tables for text for this purpose Elastic search feature is good enough or i have to go with other option. --- ## [I want to access kibana from different machine or should i say server](https://discuss.elastic.co/t/i-want-to-access-kibana-from-different-machine-or-should-i-say-server/193500)
**Author:** [@Ayush\_Verma](https://discuss.elastic.co/u/Ayush_Verma)\ **Replies:** 0\ **Last updated:** [August 2, 2019, 9:54am UTC](https://discuss.elastic.co/t/i-want-to-access-kibana-from-different-machine-or-should-i-say-server/193500 "2019-08-02T09:54:23Z")
I installed kibana on a google cloud platform but I want it run on my machine using a browser, what changes do I have to make in kibana.yml file, this is my kibana.yml file:- # Kibana is served by a back end server. Thi… --- ## [Elasticsearch stop output new log information](https://discuss.elastic.co/t/elasticsearch-stop-output-new-log-information/193495)
**Author:** [@web\_it\_web\_it](https://discuss.elastic.co/u/web_it_web_it)\ **Replies:** 1\ **Last updated:** [August 2, 2019, 10:27am UTC](https://discuss.elastic.co/t/elasticsearch-stop-output-new-log-information/193495 "2019-08-02T10:27:50Z")
Hello. We install Kibana+Elasticsearch+logstash and monitoring apache logs. One day Kibana stop to output new log\`s information and logstash log has an error: \]\[logstash.outputs.elasticsearch\] Could not index event to E… --- ## [AutoComplete Feature in Elastic Search](https://discuss.elastic.co/t/autocomplete-feature-in-elastic-search/193449)
**Author:** [@Adi\_Ti](https://discuss.elastic.co/u/Adi_Ti)\ **Replies:** 2\ **Last updated:** [August 2, 2019, 10:20am UTC](https://discuss.elastic.co/t/autocomplete-feature-in-elastic-search/193449 "2019-08-02T10:20:51Z")
want to implement autocomplete with elasticsearch and I'm unable to do it. I want something like this question here. I tried the suggested answers but in vain. I want to have something like the following : I have used c… --- ## [Error when do sql query from table name with special character](https://discuss.elastic.co/t/error-when-do-sql-query-from-table-name-with-special-character/193383)
**Author:** [@jasmineL](https://discuss.elastic.co/u/jasmineL)\ **Replies:** 1\ **Last updated:** [August 2, 2019, 10:12am UTC](https://discuss.elastic.co/t/error-when-do-sql-query-from-table-name-with-special-character/193383 "2019-08-02T10:12:05Z")
I am on Kibana and Elasticsearch 6.8. And I am trying to use sql from dev tools. Our tables name are all like 'stores.us\_returnattempt' which contains some special characters like . or \_. I got below error. "error":… --- ## [Cardinality aggregation with set up time range](https://discuss.elastic.co/t/cardinality-aggregation-with-set-up-time-range/193314)
**Author:** [@Vladpov](https://discuss.elastic.co/u/Vladpov)\ **Replies:** 4\ **Last updated:** [August 2, 2019, 9:39am UTC](https://discuss.elastic.co/t/cardinality-aggregation-with-set-up-time-range/193314 "2019-08-02T09:39:24Z")
Hello, I have this query GET /my\_index3/\_search { "size": 0, "aggs": { "num1": { "terms": { "field": "num1.keyword", "order": { "\_count": "desc" } }, "aggs": … --- ## [Can we index incremental data for files using FSCrawler?](https://discuss.elastic.co/t/can-we-index-incremental-data-for-files-using-fscrawler/193031)
**Author:** [@pyerunka](https://discuss.elastic.co/u/pyerunka)\ **Replies:** 11\ **Last updated:** [August 2, 2019, 8:10am UTC](https://discuss.elastic.co/t/can-we-index-incremental-data-for-files-using-fscrawler/193031 "2019-08-02T08:10:19Z")
Hello, Currently i am using url parameter from .settings.yaml file. in url i have mentioned the path of the drive from which files are getting indexed. if any new file is added into the file system and if i want to ind… --- ## [Elastic Unit Test Case](https://discuss.elastic.co/t/elastic-unit-test-case/192909)
**Author:** [@Antriksh\_Jain](https://discuss.elastic.co/u/Antriksh_Jain)\ **Replies:** 1\ **Last updated:** [August 2, 2019, 9:07am UTC](https://discuss.elastic.co/t/elastic-unit-test-case/192909 "2019-08-02T09:07:38Z")
https://www.elastic.co/guide/en/elasticsearch/reference/current/unit-tests.html Can we have a sample code representing how to use ESTestCase? --- ## [Alerting is not working for unexisting \_doc type](https://discuss.elastic.co/t/alerting-is-not-working-for-unexisting-doc-type/193367)
**Author:** [@evalufran](https://discuss.elastic.co/u/evalufran)\ **Replies:** 6\ **Last updated:** [August 2, 2019, 9:06am UTC](https://discuss.elastic.co/t/alerting-is-not-working-for-unexisting-doc-type/193367 "2019-08-02T09:06:13Z")
Hi everyone, i noticed that alerting is not working if i use a costum dynamic template. After having created a query on a watcher i'm not able to create a trigger, here's the message from extraction query: Failed to pa… --- ## [Watcher: Multiple transforms](https://discuss.elastic.co/t/watcher-multiple-transforms/193476)
**Author:** [@victor.nilsson](https://discuss.elastic.co/u/victor.nilsson)\ **Replies:** 1\ **Last updated:** [August 2, 2019, 8:43am UTC](https://discuss.elastic.co/t/watcher-multiple-transforms/193476 "2019-08-02T08:43:39Z")
Hi, I was wondering if it is possible to use multiple transforms in a watch? For example, i want to convert two values to GB from Bytes. "transform" : { "script" : "return \[ 'max\_queue\_size' : (ctx.payload.pipelin… --- ## [Elasticsearch query\_andvanced\_multi\_match](https://discuss.elastic.co/t/elasticsearch-query-andvanced-multi-match/193471)
**Author:** [@Youssfi\_Mohamed](https://discuss.elastic.co/u/Youssfi_Mohamed)\ **Replies:** 3\ **Last updated:** [August 2, 2019, 8:40am UTC](https://discuss.elastic.co/t/elasticsearch-query-andvanced-multi-match/193471 "2019-08-02T08:40:34Z")
i have an advanced query with elsticsearch. i want to search for all document that mets a specific requirements. Document: field1, field2, timestamp i have also a list of value for field1 and filed2 listField1=\[v1,v2,… --- ## [How to set Query search settings](https://discuss.elastic.co/t/how-to-set-query-search-settings/193481)
**Author:** [@Thomas-G](https://discuss.elastic.co/u/Thomas-G)\ **Replies:** 0\ **Last updated:** [August 2, 2019, 8:34am UTC](https://discuss.elastic.co/t/how-to-set-query-search-settings/193481 "2019-08-02T08:34:06Z")
Hello, I work since few days on a project that was created by unavailable people, it's a symfony 4, sylius & Elastic Search project. I've never touch ElasticSearch or Sylius so I'm a little lost about the configuration … --- ## [Elasticsearch client link problem](https://discuss.elastic.co/t/elasticsearch-client-link-problem/193430)
**Author:** [@JokerIry](https://discuss.elastic.co/u/JokerIry)\ **Replies:** 1\ **Last updated:** [August 2, 2019, 8:14am UTC](https://discuss.elastic.co/t/elasticsearch-client-link-problem/193430 "2019-08-02T08:14:34Z")
I use the ES version of 5.2.2, and when I look at my host point log, the error shown in the following log occurs several times every hour。 \[2019-08-02T04:37:01,338\]\[WARN \]\[o.e.t.n.Netty4Transport \] \[nodeMaster\] excepti… --- ## [Elasticsearch clustering indices problem](https://discuss.elastic.co/t/elasticsearch-clustering-indices-problem/193034)
**Author:** [@Mozart4242](https://discuss.elastic.co/u/Mozart4242)\ **Replies:** 4\ **Last updated:** [August 2, 2019, 8:12am UTC](https://discuss.elastic.co/t/elasticsearch-clustering-indices-problem/193034 "2019-08-02T08:12:52Z")
hello everyone, i'm using two node cluster : 1- master node 2- data node but when the cluster formed , all indices from master transported to the other node, and the index size are the same on each one, even though th… --- ## [Remove a Text field while being indexing over ES](https://discuss.elastic.co/t/remove-a-text-field-while-being-indexing-over-es/192860)
**Author:** [@flyboyacsrao](https://discuss.elastic.co/u/flyboyacsrao)\ **Replies:** 4\ **Last updated:** [August 2, 2019, 8:03am UTC](https://discuss.elastic.co/t/remove-a-text-field-while-being-indexing-over-es/192860 "2019-08-02T08:03:55Z")
Hi Team We are trying to ingest an index with 10 fields, while we see that the message field has very large data, so we want to either skip this field entirely from writing to ES, is this possible through any mapping se… --- ## [Having trouble understand Watcher condition](https://discuss.elastic.co/t/having-trouble-understand-watcher-condition/193376)
**Author:** [@victor.nilsson](https://discuss.elastic.co/u/victor.nilsson)\ **Replies:** 3\ **Last updated:** [August 2, 2019, 6:12am UTC](https://discuss.elastic.co/t/having-trouble-understand-watcher-condition/193376 "2019-08-02T06:12:18Z")
Hi, I've recently begun testing the Watcher functionality and have been testing out a simple alert that will send an email to me whenever a persistent queue of Logstash exceeds over 1GB in Bytes. However, i'm having tr… --- ## [Query in Elastic Search](https://discuss.elastic.co/t/query-in-elastic-search/193470)
**Author:** [@Palak\_Agarwal](https://discuss.elastic.co/u/Palak_Agarwal)\ **Replies:** 0\ **Last updated:** [August 2, 2019, 7:38am UTC](https://discuss.elastic.co/t/query-in-elastic-search/193470 "2019-08-02T07:38:11Z")
Hi, Can you please tell me how to do the mapping in Elastic Search ? I am facing issue in doing visualization in Kibana . I am having the following mapping in my application: PUT /error\_radius\_stats { "mappings": { … --- ## [Normalize query score before boost\_mode when using function\_score](https://discuss.elastic.co/t/normalize-query-score-before-boost-mode-when-using-function-score/193462)
**Author:** [@hangu\_choi](https://discuss.elastic.co/u/hangu_choi)\ **Replies:** 0\ **Last updated:** [August 2, 2019, 6:54am UTC](https://discuss.elastic.co/t/normalize-query-score-before-boost-mode-when-using-function-score/193462 "2019-08-02T06:54:33Z")
This topic seems appear before, but I couldn't find useful answer for that. With function\_score query, Is there any way to normalize query score before calculate with function score by boost\_mode? The intention here i… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1203) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1205)