# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=958 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 959 --- ## [No mapping found for \[filedname\] in order to sort on](https://discuss.elastic.co/t/no-mapping-found-for-filedname-in-order-to-sort-on/227730)
**Author:** [@monica23334](https://discuss.elastic.co/u/monica23334)\ **Replies:** 1\ **Last updated:** [April 13, 2020, 6:27am UTC](https://discuss.elastic.co/t/no-mapping-found-for-filedname-in-order-to-sort-on/227730 "2020-04-13T06:27:59Z")
Hi,I am a new learner of Elastisearch.I use this api GET /logstash-kafka-2020.04.12/\_mapping/ in Kibana to search my index mapping ,and it returns contain: { "logstash-kafka-2020.04.12" : { "mappings" : { … --- ## [Scrolling using low-level .NET driver](https://discuss.elastic.co/t/scrolling-using-low-level-net-driver/227568)
**Author:** [@djmarcus](https://discuss.elastic.co/u/djmarcus)\ **Replies:** 1\ **Last updated:** [April 13, 2020, 6:23am UTC](https://discuss.elastic.co/t/scrolling-using-low-level-net-driver/227568 "2020-04-13T06:23:44Z")
I am a real newbie to elasticsearch :frowning: I'm at a the stage where I copy & paste and try to intelligently edit source code in examples I can find. I'm having a very hard time find .NET examples for scrolling thoug… --- ## [How to use ES for Content based search on Documents stored in Oracle Database](https://discuss.elastic.co/t/how-to-use-es-for-content-based-search-on-documents-stored-in-oracle-database/227727)
**Author:** [@Kumar\_Priyadarshi](https://discuss.elastic.co/u/Kumar_Priyadarshi)\ **Replies:** 1\ **Last updated:** [April 13, 2020, 6:06am UTC](https://discuss.elastic.co/t/how-to-use-es-for-content-based-search-on-documents-stored-in-oracle-database/227727 "2020-04-13T06:06:21Z")
Hi I am new to ES. I am trying to find out how ES can be used to search Contents(pdf,word file) Stored in Oracle Database.Can you please help me suggest how we can achieve this. --- ## [How to use time offset Counts into Watcher Script](https://discuss.elastic.co/t/how-to-use-time-offset-counts-into-watcher-script/227733)
**Author:** [@Pikapi](https://discuss.elastic.co/u/Pikapi)\ **Replies:** 0\ **Last updated:** [April 13, 2020, 6:02am UTC](https://discuss.elastic.co/t/how-to-use-time-offset-counts-into-watcher-script/227733 "2020-04-13T06:02:31Z")
I have a calculated metric in the form of a timelion script: {count today / \[(count offset7days/3) + (count offset14days/3) + (count offset21days/3)\]} \* 100 this shows me the % of count this week over average of last… --- ## [WHERE clause on ElasticSearch](https://discuss.elastic.co/t/where-clause-on-elasticsearch/227725)
**Author:** [@jeanpjm](https://discuss.elastic.co/u/jeanpjm)\ **Replies:** 0\ **Last updated:** [April 13, 2020, 4:26am UTC](https://discuss.elastic.co/t/where-clause-on-elasticsearch/227725 "2020-04-13T04:26:56Z")
Hello people, I'm starting to work on elasticsearch and I would like you to help me with the question below. I have a query on elasticsearch that searches for a keyword in three fields, (title, description and url) and… --- ## [Update by script with aggregated values](https://discuss.elastic.co/t/update-by-script-with-aggregated-values/226731)
**Author:** [@Bastian\_Jager](https://discuss.elastic.co/u/Bastian_Jager)\ **Replies:** 4\ **Last updated:** [April 13, 2020, 1:41am UTC](https://discuss.elastic.co/t/update-by-script-with-aggregated-values/226731 "2020-04-13T01:41:08Z")
Hi, could not found this in the documentation and only a closed ticket (Updating source with aggregation values) The task would be: get min of field\_a by customer and device and add those min values to each queried do… --- ## [Ignore\_above does not work](https://discuss.elastic.co/t/ignore-above-does-not-work/227710)
**Author:** [@Guerreiro\_Sousa](https://discuss.elastic.co/u/Guerreiro_Sousa)\ **Replies:** 2\ **Last updated:** [April 13, 2020, 1:37am UTC](https://discuss.elastic.co/t/ignore-above-does-not-work/227710 "2020-04-13T01:37:20Z")
I'm trying to use "ignore\_above" for a "keyword" type field without success. My mapping: { "settings": { "index": { "number\_of\_shards": 1, "number\_of\_replicas": 1 } }, "mappings": { "properties": { "n… --- ## [How to iterate getting the next data using scroll](https://discuss.elastic.co/t/how-to-iterate-getting-the-next-data-using-scroll/227692)
**Author:** [@djmarcus](https://discuss.elastic.co/u/djmarcus)\ **Replies:** 1\ **Last updated:** [April 13, 2020, 1:37am UTC](https://discuss.elastic.co/t/how-to-iterate-getting-the-next-data-using-scroll/227692 "2020-04-13T01:37:18Z")
I have the following low level request (.Net): var scroll = client.LowLevel.Search\(SearchIndex, queryText, new SearchRequestParameters() { Scroll = TimeSpan.FromMinutes(… --- ## [Springboots + Elastic search 7.6.2 Integration failing](https://discuss.elastic.co/t/springboots-elastic-search-7-6-2-integration-failing/227698)
**Author:** [@Satya\_Tipathy](https://discuss.elastic.co/u/Satya_Tipathy)\ **Replies:** 1\ **Last updated:** [April 13, 2020, 1:34am UTC](https://discuss.elastic.co/t/springboots-elastic-search-7-6-2-integration-failing/227698 "2020-04-13T01:34:39Z")
Hi Experts, I am new to EL. Trying to integrate a middle layer between consumer and ELS7.6.2 using spring boots. Looks like after several try I am unable to run the spring boots application as the Application context is… --- ## [Case-insensitive search of a substring in many (or all) fields](https://discuss.elastic.co/t/case-insensitive-search-of-a-substring-in-many-or-all-fields/227650)
**Author:** [@jfschaff](https://discuss.elastic.co/u/jfschaff)\ **Replies:** 7\ **Last updated:** [April 13, 2020, 1:17am UTC](https://discuss.elastic.co/t/case-insensitive-search-of-a-substring-in-many-or-all-fields/227650 "2020-04-13T01:17:10Z")
Hi everyone, I'm new to Elasticsearch, and have been playing with the query language and reading the doc lately. And I find it hard to construct the right query for my need... I have simple documents, with only a few t… --- ## [How to reduce information in search results](https://discuss.elastic.co/t/how-to-reduce-information-in-search-results/227618)
**Author:** [@djmarcus](https://discuss.elastic.co/u/djmarcus)\ **Replies:** 7\ **Last updated:** [April 13, 2020, 1:01am UTC](https://discuss.elastic.co/t/how-to-reduce-information-in-search-results/227618 "2020-04-13T01:01:59Z")
When I get the results of am elasticsearch, the individual hits contain this information: { "\_index" : "xxxxxxx", "\_type" : "\_doc", "\_id" : "WRn-1W8Bh5qsL8eVO5Ao", "\_score" : 3.723252… --- ## [Search operation fails after restoring a snapshot](https://discuss.elastic.co/t/search-operation-fails-after-restoring-a-snapshot/227007)
**Author:** [@debasisc](https://discuss.elastic.co/u/debasisc)\ **Replies:** 24\ **Last updated:** [April 12, 2020, 9:06pm UTC](https://discuss.elastic.co/t/search-operation-fails-after-restoring-a-snapshot/227007 "2020-04-12T21:06:09Z")
Background - Using v7.3.2 on Windows 10 environment. (Had to downgrade version since the snapshot that I am interested in, was created using V7.3.2) I have restored a snapshot that was provided from another V7.3.2 env… --- ## [Watcher logs from ElasticSearch logs to Kibana](https://discuss.elastic.co/t/watcher-logs-from-elasticsearch-logs-to-kibana/227682)
**Author:** [@Roy\_Goldenberg](https://discuss.elastic.co/u/Roy_Goldenberg)\ **Replies:** 0\ **Last updated:** [April 12, 2020, 3:08pm UTC](https://discuss.elastic.co/t/watcher-logs-from-elasticsearch-logs-to-kibana/227682 "2020-04-12T15:08:25Z")
I've configured a watcher to log something as its action and that works fine. The problem is that I can only view the logs in the Logs tab in the ElasticSearch Service page. They aren't in any of the indices in Kibana. … --- ## [Role not get created](https://discuss.elastic.co/t/role-not-get-created/227668)
**Author:** [@Arpit\_Aggarwal](https://discuss.elastic.co/u/Arpit_Aggarwal)\ **Replies:** 2\ **Last updated:** [April 12, 2020, 12:08pm UTC](https://discuss.elastic.co/t/role-not-get-created/227668 "2020-04-12T12:08:33Z")
I am using Elasticsearch 7.6.1 and getting below error while creating role. { "error": { "root\_cause": \[ { "type": "security\_exception", "reason": " current license is non-compliant for \[field and document level se… --- ## [Elasticsearch off-heap memory usage and behavior on Windows Server](https://discuss.elastic.co/t/elasticsearch-off-heap-memory-usage-and-behavior-on-windows-server/227649)
**Author:** [@takhig](https://discuss.elastic.co/u/takhig)\ **Replies:** 0\ **Last updated:** [April 12, 2020, 8:23am UTC](https://discuss.elastic.co/t/elasticsearch-off-heap-memory-usage-and-behavior-on-windows-server/227649 "2020-04-12T08:23:19Z")
I'm using Elasticsearh 6.5.2 on Windows Server 2016. This memory of this server sometimes reaches 99% and I'm investigating the reason and risk of this phenomenon. The OS memory is 8GB, -Xmx4096m, and -Xms4096m. The a… --- ## [Fresh V7.5.2 installation - Windows 10](https://discuss.elastic.co/t/fresh-v7-5-2-installation-windows-10/227403)
**Author:** [@debasisc](https://discuss.elastic.co/u/debasisc)\ **Replies:** 8\ **Last updated:** [April 12, 2020, 3:11am UTC](https://discuss.elastic.co/t/fresh-v7-5-2-installation-windows-10/227403 "2020-04-12T03:11:29Z")
These are the steps I used. unzip elasticsearch.zip in folder, launch elasticsearch.bat from cmd window unzip kibana zip in separate folder and launch kibana.bat from cmd window Launched kibana console from Browser, u… --- ## [Parsing url in log](https://discuss.elastic.co/t/parsing-url-in-log/227640)
**Author:** [@thedraketaylor](https://discuss.elastic.co/u/thedraketaylor)\ **Replies:** 2\ **Last updated:** [April 12, 2020, 12:20am UTC](https://discuss.elastic.co/t/parsing-url-in-log/227640 "2020-04-12T00:20:55Z")
I'm storing urls in the format "http://domain.com/showthread.php?10357-thread-title-and-such/page22" as "text". However, when I try to match the page number It fails to find anything. If I try to match anything before th… --- ## [How to make random\_score more random?](https://discuss.elastic.co/t/how-to-make-random-score-more-random/227635)
**Author:** [@i333](https://discuss.elastic.co/u/i333)\ **Replies:** 0\ **Last updated:** [April 11, 2020, 9:15pm UTC](https://discuss.elastic.co/t/how-to-make-random-score-more-random/227635 "2020-04-11T21:15:01Z")
With this query to randomize the search results, is it possible to set how randomized the results will be from the original results? How can I increase or decrease the amount of randomness that the search results have? G… --- ## [Multiple disks on same node - shard allocation](https://discuss.elastic.co/t/multiple-disks-on-same-node-shard-allocation/227590)
**Author:** [@ItamarBenjamin](https://discuss.elastic.co/u/ItamarBenjamin)\ **Replies:** 3\ **Last updated:** [April 11, 2020, 4:22pm UTC](https://discuss.elastic.co/t/multiple-disks-on-same-node-shard-allocation/227590 "2020-04-11T16:22:34Z")
Hi, I have a cluster with 10 data nodes. some data nodes have multiple disks with different sizes (running on-prem, have to do with what i'm given). During the night my main index got locked due to 'flood stage disk wa… --- ## [Filter by a regexp inside a terms aggregation](https://discuss.elastic.co/t/filter-by-a-regexp-inside-a-terms-aggregation/227573)
**Author:** [@misterone](https://discuss.elastic.co/u/misterone)\ **Replies:** 2\ **Last updated:** [April 11, 2020, 4:05pm UTC](https://discuss.elastic.co/t/filter-by-a-regexp-inside-a-terms-aggregation/227573 "2020-04-11T16:05:42Z")
Hi, Is there a way to group by field1 only when field1 matches the following logic : field1 contains ALL of the keywords in this list : \[keyword1, keyword2, keyword3\] I have a working example for 1 keyword but I can't… --- ## [Querying 5.4 Billion JSON Documents occupying 2 TB - is it possible in Elasticsearch?](https://discuss.elastic.co/t/querying-5-4-billion-json-documents-occupying-2-tb-is-it-possible-in-elasticsearch/227617)
**Author:** [@somnath.choudhuri](https://discuss.elastic.co/u/somnath.choudhuri)\ **Replies:** 1\ **Last updated:** [April 11, 2020, 4:03pm UTC](https://discuss.elastic.co/t/querying-5-4-billion-json-documents-occupying-2-tb-is-it-possible-in-elasticsearch/227617 "2020-04-11T16:03:19Z")
Ingesting once a day (not real-time) 60 million JSON documents via a once run batch script Elasticsearch to query 90 days worth of data for a total of 5.4 billion documents Occupies about 2 TB of storage overall (23 GB … --- ## [Swift Library for Elasticsearch](https://discuss.elastic.co/t/swift-library-for-elasticsearch/227613)
**Author:** [@Adello](https://discuss.elastic.co/u/Adello)\ **Replies:** 0\ **Last updated:** [April 11, 2020, 3:12pm UTC](https://discuss.elastic.co/t/swift-library-for-elasticsearch/227613 "2020-04-11T15:12:35Z")
Hello everyone :slight\_smile: I am looking for an Elasticsearch Swift library. Any recommendations? --- ## [How to set password in Vagrantfile or script for Elasticsearch](https://discuss.elastic.co/t/how-to-set-password-in-vagrantfile-or-script-for-elasticsearch/227506)
**Author:** [@Amphagory](https://discuss.elastic.co/u/Amphagory)\ **Replies:** 0\ **Last updated:** [April 10, 2020, 1:12pm UTC](https://discuss.elastic.co/t/how-to-set-password-in-vagrantfile-or-script-for-elasticsearch/227506 "2020-04-10T13:12:41Z")
I would like to automate the creation of a 5 node Elasticsearch cluster + 1 Kibana node for development purposes (unable to use docker on the server I have currently). I will open the Elasticsearch to the internet, so I… --- ## [Performance degradation](https://discuss.elastic.co/t/performance-degradation/227508)
**Author:** [@Burga](https://discuss.elastic.co/u/Burga)\ **Replies:** 8\ **Last updated:** [April 11, 2020, 1:56pm UTC](https://discuss.elastic.co/t/performance-degradation/227508 "2020-04-11T13:56:50Z")
Hi Guys , I'm a new in EK , need your help I need to do performance review due to the slowness of the system How would you suggest to do this ? and what would you say regarding the amount of servers , do you sugg… --- ## [Net how to customize index and type](https://discuss.elastic.co/t/net-how-to-customize-index-and-type/227575)
**Author:** [@lzx538370](https://discuss.elastic.co/u/lzx538370)\ **Replies:** 5\ **Last updated:** [April 11, 2020, 1:34pm UTC](https://discuss.elastic.co/t/net-how-to-customize-index-and-type/227575 "2020-04-11T13:34:23Z")
Hi How to customize types? thanks --- ## [Is ElasticSearch a suitable tool to do time series comparison?](https://discuss.elastic.co/t/is-elasticsearch-a-suitable-tool-to-do-time-series-comparison/227533)
**Author:** [@Silverspur](https://discuss.elastic.co/u/Silverspur)\ **Replies:** 0\ **Last updated:** [April 10, 2020, 4:24pm UTC](https://discuss.elastic.co/t/is-elasticsearch-a-suitable-tool-to-do-time-series-comparison/227533 "2020-04-10T16:24:44Z")
Hi, The running of an industrial process I'm in charge of produces time series data (approximately several thousand parameters, each 1/8th of a second, during a month). My goal is to look at two month-long executions a… --- ## [I am trying to add ingore\_malformed to true on an existing field in elasticsearch 6.7 and see mapping type is missing error, How to handle this?](https://discuss.elastic.co/t/i-am-trying-to-add-ingore-malformed-to-true-on-an-existing-field-in-elasticsearch-6-7-and-see-mapping-type-is-missing-error-how-to-handle-this/227565)
**Author:** [@ssunkara](https://discuss.elastic.co/u/ssunkara)\ **Replies:** 4\ **Last updated:** [April 11, 2020, 12:52pm UTC](https://discuss.elastic.co/t/i-am-trying-to-add-ingore-malformed-to-true-on-an-existing-field-in-elasticsearch-6-7-and-see-mapping-type-is-missing-error-how-to-handle-this/227565 "2020-04-11T12:52:18Z")
PUT/\/\_mapping { "properties": { "max\_size":{ "type":"long", "ignore\_malformed": true } } } Response be like "error": { "root\_cause": \[ { "type": "action\_req… --- ## [Elasticsearch considerations for ingesting large files](https://discuss.elastic.co/t/elasticsearch-considerations-for-ingesting-large-files/227464)
**Author:** [@adityaPsl](https://discuss.elastic.co/u/adityaPsl)\ **Replies:** 6\ **Last updated:** [April 11, 2020, 11:33am UTC](https://discuss.elastic.co/t/elasticsearch-considerations-for-ingesting-large-files/227464 "2020-04-11T11:33:37Z")
Hello Team, Just wanted to understand the limits , scaling and performance of Elasticsearch, what should be the considerations while ingesting large files (40-50) GB, metadata and making it searchable. For examples mic… --- ## [Count by keyword](https://discuss.elastic.co/t/count-by-keyword/227595)
**Author:** [@sanjaye218](https://discuss.elastic.co/u/sanjaye218)\ **Replies:** 0\ **Last updated:** [April 11, 2020, 10:41am UTC](https://discuss.elastic.co/t/count-by-keyword/227595 "2020-04-11T10:41:14Z")
Hi, I am trying to get document count matching by each search term. Lets say am searching for terms vehicle & electric. I want to get document count where term matching anywhere in document and expecting result like veh… --- ## [Watcher output message](https://discuss.elastic.co/t/watcher-output-message/227591)
**Author:** [@Silver](https://discuss.elastic.co/u/Silver)\ **Replies:** 0\ **Last updated:** [April 11, 2020, 9:17am UTC](https://discuss.elastic.co/t/watcher-output-message/227591 "2020-04-11T09:17:16Z")
This is the output i am getting for my aggregation.. "aggregations": { "users": { "doc\_count\_error\_upper\_bound": 0, "sum\_other\_doc\_count": 0, "buckets": \[ { "doc\_count… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=957) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=959)