# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1266 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1267 --- ## [Date with long value not working](https://discuss.elastic.co/t/date-with-long-value-not-working/185368)
**Author:** [@umeshmishra099](https://discuss.elastic.co/u/umeshmishra099)\ **Replies:** 1\ **Last updated:** [June 12, 2019, 12:45pm UTC](https://discuss.elastic.co/t/date-with-long-value-not-working/185368 "2019-06-12T12:45:43Z")
I have below mapping { "indexTest": { "mappings": { "indexTest\_type": { "properties": { "date22": { "type": "dateColumn", "format": "yyyy-MM-dd||yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.S… --- ## [Custom scoring mode for nested query?](https://discuss.elastic.co/t/custom-scoring-mode-for-nested-query/185417)
**Author:** [@Alexander\_Sviridov](https://discuss.elastic.co/u/Alexander_Sviridov)\ **Replies:** 0\ **Last updated:** [June 12, 2019, 12:38pm UTC](https://discuss.elastic.co/t/custom-scoring-mode-for-nested-query/185417 "2019-06-12T12:38:22Z")
Is it possible to use custom scoring mode on inner\_hits? Let's say I want to multiply max score by sum of scores. (Related to this https://discuss.elastic.co/t/function-score-and-nested-query-use-hit-count-in-score/1853… --- ## [ES crashing multiple times, over 1Billion docs a day, indexing rate falling from 25k/s to 2k/s](https://discuss.elastic.co/t/es-crashing-multiple-times-over-1billion-docs-a-day-indexing-rate-falling-from-25k-s-to-2k-s/184628)
**Author:** [@yvreddy](https://discuss.elastic.co/u/yvreddy)\ **Replies:** 9\ **Last updated:** [June 12, 2019, 12:20pm UTC](https://discuss.elastic.co/t/es-crashing-multiple-times-over-1billion-docs-a-day-indexing-rate-falling-from-25k-s-to-2k-s/184628 "2019-06-12T12:20:44Z")
GET / output: { "name": "es-ingest-3", "cluster\_name": "ct", "cluster\_uuid": "IED4OO5CR6ur7ZCRNmfWEg", "version": { "number": "6.1.2", "build\_hash": "5b1fea5", "build\_date": "2018-01-10T02:35:59.208… --- ## [HAProxy over Elasticsearch Cluster](https://discuss.elastic.co/t/haproxy-over-elasticsearch-cluster/185403)
**Author:** [@Ashish\_Patel](https://discuss.elastic.co/u/Ashish_Patel)\ **Replies:** 0\ **Last updated:** [June 12, 2019, 11:55am UTC](https://discuss.elastic.co/t/haproxy-over-elasticsearch-cluster/185403 "2019-06-12T11:55:36Z")
Hi, We have currently single node ES server and need to put 2 more servers (making total 3) - forming 3 node ES Cluster - all having master and data node capabilities. As we don't want our applications to change host n… --- ## [How we can use RBAC in elasticserach7.1](https://discuss.elastic.co/t/how-we-can-use-rbac-in-elasticserach7-1/185086)
**Author:** [@Tek\_Chand](https://discuss.elastic.co/u/Tek_Chand)\ **Replies:** 13\ **Last updated:** [June 12, 2019, 11:10am UTC](https://discuss.elastic.co/t/how-we-can-use-rbac-in-elasticserach7-1/185086 "2019-06-12T11:10:06Z")
Hello Teamt , Currently we are using ELK Version 6.4.4. All things are working fine as expected. We are not using any feature of xpac because we are using basic license. But few days back elasticsearch7.1 come with fre… --- ## [Elastic Search Certificate](https://discuss.elastic.co/t/elastic-search-certificate/185302)
**Author:** [@Meet](https://discuss.elastic.co/u/Meet)\ **Replies:** 3\ **Last updated:** [June 12, 2019, 8:40am UTC](https://discuss.elastic.co/t/elastic-search-certificate/185302 "2019-06-12T08:40:35Z")
Hi, Is there any way to give absolute path to the certificate and key instead of config folder? xpack.security.transport.ssl.key: absolutepath/ca.key xpack.security.transport.ssl.certificate: absolutepath/ca.crt --- ## [Update a field](https://discuss.elastic.co/t/update-a-field/185336)
**Author:** [@saramali](https://discuss.elastic.co/u/saramali)\ **Replies:** 5\ **Last updated:** [June 12, 2019, 8:35am UTC](https://discuss.elastic.co/t/update-a-field/185336 "2019-06-12T08:35:11Z")
Hi, I have an index which has documents of all the commits of my repo. There is a field in the document which has different format therefore while aggregating on that field yields different result. The field name is A… --- ## [Monitoring-es indices more than 10g a day](https://discuss.elastic.co/t/monitoring-es-indices-more-than-10g-a-day/185114)
**Author:** [@logger](https://discuss.elastic.co/u/logger)\ **Replies:** 6\ **Last updated:** [June 12, 2019, 8:31am UTC](https://discuss.elastic.co/t/monitoring-es-indices-more-than-10g-a-day/185114 "2019-06-12T08:31:16Z")
Hello, I have a question. I have several cluster running and everything works except one cluster. The monitoring for elasticsearch is enabled with all default values, but my 3 node Cluster (7.1.0) uses 10g a day. My o… --- ## [Term query on multiple fields based on a wildcard notation](https://discuss.elastic.co/t/term-query-on-multiple-fields-based-on-a-wildcard-notation/183620)
**Author:** [@marb](https://discuss.elastic.co/u/marb)\ **Replies:** 4\ **Last updated:** [June 12, 2019, 8:20am UTC](https://discuss.elastic.co/t/term-query-on-multiple-fields-based-on-a-wildcard-notation/183620 "2019-06-12T08:20:19Z")
Hi all, I'm trying to do an exact match on an unknown number of fields. I know that we can do a fulltext search on a set of fields using a multi\_match like: { "multi\_match": { "fields":"fieldprefix\_\* ", "query": "f… --- ## [Difference between Lucene used in ElasticSearch and Kibana?](https://discuss.elastic.co/t/difference-between-lucene-used-in-elasticsearch-and-kibana/185207)
**Author:** [@saravananselvamohan](https://discuss.elastic.co/u/saravananselvamohan)\ **Replies:** 5\ **Last updated:** [June 12, 2019, 7:27am UTC](https://discuss.elastic.co/t/difference-between-lucene-used-in-elasticsearch-and-kibana/185207 "2019-06-12T07:27:38Z")
What is the difference between Lucene used in ElasticSearch and Lucene used for Kibana? Or whether both work on top of single Lucene application code by integrating Elasticsearch and Kibana. --- ## [Include 6 Month record counts in buckets with monthly counts](https://discuss.elastic.co/t/include-6-month-record-counts-in-buckets-with-monthly-counts/185347)
**Author:** [@pramod.kumar2](https://discuss.elastic.co/u/pramod.kumar2)\ **Replies:** 0\ **Last updated:** [June 12, 2019, 7:20am UTC](https://discuss.elastic.co/t/include-6-month-record-counts-in-buckets-with-monthly-counts/185347 "2019-06-12T07:20:09Z")
Hi, I am using ElasticSearch 6.2 and I have one query to get record counts for Monthly data for particular period. I want to include 6 Month data record count in same bucket whereas 6 Months should not consider current … --- ## [Deep nesting and recommendation for its usage](https://discuss.elastic.co/t/deep-nesting-and-recommendation-for-its-usage/185321)
**Author:** [@abhigyan](https://discuss.elastic.co/u/abhigyan)\ **Replies:** 3\ **Last updated:** [June 12, 2019, 7:14am UTC](https://discuss.elastic.co/t/deep-nesting-and-recommendation-for-its-usage/185321 "2019-06-12T07:14:39Z")
Hello ES community! We are building cloud application which is going to have high scaling data store inside an RDBMS. What we are trying to do is moving the relational data which are searchable to the ES which everyone … --- ## [How to retain only one record from duplicate records?](https://discuss.elastic.co/t/how-to-retain-only-one-record-from-duplicate-records/185178)
**Author:** [@sana1](https://discuss.elastic.co/u/sana1)\ **Replies:** 5\ **Last updated:** [June 12, 2019, 7:13am UTC](https://discuss.elastic.co/t/how-to-retain-only-one-record-from-duplicate-records/185178 "2019-06-12T07:13:02Z")
I have a database with duplicate results, i need to delete all other results and retain one. I have the query to find duplicate records POST /data\_12/\_search { "size": 0, "aggs": { "duplicateCount": { "terms": { … --- ## [Function score and nested query: use hit count in score?](https://discuss.elastic.co/t/function-score-and-nested-query-use-hit-count-in-score/185345)
**Author:** [@Alexander\_Sviridov](https://discuss.elastic.co/u/Alexander_Sviridov)\ **Replies:** 0\ **Last updated:** [June 12, 2019, 7:06am UTC](https://discuss.elastic.co/t/function-score-and-nested-query-use-hit-count-in-score/185345 "2019-06-12T07:06:56Z")
Hello! I have an object with array of children objects. I'm using nested queries to retrieve relevant children objects along with parents. What I want to do is calculate final score for objects by function, using 1. \_s… --- ## [Delete indices now working](https://discuss.elastic.co/t/delete-indices-now-working/183718)
**Author:** [@Bhargav\_Patel](https://discuss.elastic.co/u/Bhargav_Patel)\ **Replies:** 4\ **Last updated:** [June 12, 2019, 6:59am UTC](https://discuss.elastic.co/t/delete-indices-now-working/183718 "2019-06-12T06:59:39Z")
I tried following command with curator cli curator\_cli --host ray-elasticsearch-service delete\_indices --filter\_list '{"filtertype":"age","source":"name","timestring":"%Y.%m.%d","unit":"days","unit\_count" :1,"direction"… --- ## [Coordinator node requirements](https://discuss.elastic.co/t/coordinator-node-requirements/185337)
**Author:** [@michal1](https://discuss.elastic.co/u/michal1)\ **Replies:** 0\ **Last updated:** [June 12, 2019, 6:34am UTC](https://discuss.elastic.co/t/coordinator-node-requirements/185337 "2019-06-12T06:34:19Z")
Hi, I would like to use a cross-cluster-search. In the setup i will need - the coordinator node will be a separate server which will only be used to query the clusters and not store data itself (due to security limitatio… --- ## [Get https://localhost:9200/\_xpack/security/\_authenticate?pretty: x509: certificate signed by unknown authority](https://discuss.elastic.co/t/get-https-localhost-9200-xpack-security-authenticate-pretty-x509-certificate-signed-by-unknown-authority/185256)
**Author:** [@krithb](https://discuss.elastic.co/u/krithb)\ **Replies:** 2\ **Last updated:** [June 12, 2019, 6:30am UTC](https://discuss.elastic.co/t/get-https-localhost-9200-xpack-security-authenticate-pretty-x509-certificate-signed-by-unknown-authority/185256 "2019-06-12T06:30:38Z")
Hi I am getting below error "x509: certificate signed by unknown authority " when running the program. Steps I have followed to generate server-certificates: openssl req -x509 -newkey rsa:4096 -keyout server\_key.pem … --- ## [Passing parameters to script dynamically in Elastic Search](https://discuss.elastic.co/t/passing-parameters-to-script-dynamically-in-elastic-search/185331)
**Author:** [@nikita.jain](https://discuss.elastic.co/u/nikita.jain)\ **Replies:** 0\ **Last updated:** [June 12, 2019, 6:17am UTC](https://discuss.elastic.co/t/passing-parameters-to-script-dynamically-in-elastic-search/185331 "2019-06-12T06:17:09Z")
Hello, I want to run a script on documents that match a particular query, to boost those results which are accessed recently by user. The IDs of recently accessed documents are available as a list. I want to know how I … --- ## [Ask a question about multiple hosts alarms](https://discuss.elastic.co/t/ask-a-question-about-multiple-hosts-alarms/185304)
**Author:** [@lightlevin](https://discuss.elastic.co/u/lightlevin)\ **Replies:** 2\ **Last updated:** [June 12, 2019, 4:07am UTC](https://discuss.elastic.co/t/ask-a-question-about-multiple-hosts-alarms/185304 "2019-06-12T04:07:04Z")
I need to monitor memory usage rate for multiple hosts, get data every five minutes, if the set threshold is exceeded, the alarm is triggered and a separate warning message is sent according to the host name. Hopefully … --- ## [Approach for incorporating recency in search](https://discuss.elastic.co/t/approach-for-incorporating-recency-in-search/185209)
**Author:** [@nikita.jain](https://discuss.elastic.co/u/nikita.jain)\ **Replies:** 1\ **Last updated:** [June 12, 2019, 1:09am UTC](https://discuss.elastic.co/t/approach-for-incorporating-recency-in-search/185209 "2019-06-12T01:09:47Z")
Hi, I'm trying to improve the relevance of search results using user's recent activity, in order to personalize the search experience. I have the data of the user's recent activity, in addition to an exhaustive databas… --- ## [How to start Elasticsearch 7.0.0 in global mode in a docker swarm cluster?](https://discuss.elastic.co/t/how-to-start-elasticsearch-7-0-0-in-global-mode-in-a-docker-swarm-cluster/178712)
**Author:** [@shazChaudhry](https://discuss.elastic.co/u/shazChaudhry)\ **Replies:** 5\ **Last updated:** [June 11, 2019, 11:05pm UTC](https://discuss.elastic.co/t/how-to-start-elasticsearch-7-0-0-in-global-mode-in-a-docker-swarm-cluster/178712 "2019-06-11T23:05:01Z")
I have a 6 node docker swarm cluster in which I would like to have 3 elasticsearch masters. The remaining nodes will be data nodes. The elasticsearch cluster will be behind a reverse proxy. What elasticsearch configura… --- ## [Searchphaseexecutionexception](https://discuss.elastic.co/t/searchphaseexecutionexception/183464)
**Author:** [@Vipin\_MS](https://discuss.elastic.co/u/Vipin_MS)\ **Replies:** 3\ **Last updated:** [June 11, 2019, 10:41pm UTC](https://discuss.elastic.co/t/searchphaseexecutionexception/183464 "2019-06-11T22:41:01Z")
{ "error": { "root\_cause": , "type": "search\_phase\_execution\_exception", "reason": "all shards failed", "phase": "query", "grouped": true, "failed\_shards": }, "status": 503 } How do i fix this exception showi… --- ## [Running Rally against AWS Elasticsearch](https://discuss.elastic.co/t/running-rally-against-aws-elasticsearch/185059)
**Author:** [@Gaurav\_Deshmukh](https://discuss.elastic.co/u/Gaurav_Deshmukh)\ **Replies:** 2\ **Last updated:** [June 11, 2019, 10:17pm UTC](https://discuss.elastic.co/t/running-rally-against-aws-elasticsearch/185059 "2019-06-11T22:17:50Z")
I created a simple challenge and a operation with custom Parameter Source. The idea behind this implementation is to hit an AWS managed Elasticsearch cluster with the defined challenge which says run the operation for 20… --- ## [Adding node locally for dev on macos](https://discuss.elastic.co/t/adding-node-locally-for-dev-on-macos/185228)
**Author:** [@Gruido](https://discuss.elastic.co/u/Gruido)\ **Replies:** 1\ **Last updated:** [June 11, 2019, 7:15pm UTC](https://discuss.elastic.co/t/adding-node-locally-for-dev-on-macos/185228 "2019-06-11T19:15:24Z")
I'm trying to run a local dev cluster with two nodes. I know ideally three is recommended but I'm troubleshooting the network errors that I'm getting. I may be confusing myself with the transport ssl certs for the cluste… --- ## [Elasticsearch Cluster Rebalance](https://discuss.elastic.co/t/elasticsearch-cluster-rebalance/184947)
**Author:** [@jigar4u2](https://discuss.elastic.co/u/jigar4u2)\ **Replies:** 1\ **Last updated:** [June 11, 2019, 7:07pm UTC](https://discuss.elastic.co/t/elasticsearch-cluster-rebalance/184947 "2019-06-11T19:07:24Z")
I have all indices has primary shards are going to node: data02 only after cluster restart, how can I rebalance cluster and how to make primary shards go to different node with default setting? ES is 5.6.3. Below is res… --- ## [How to check for 1 of 2 fields to exist in record](https://discuss.elastic.co/t/how-to-check-for-1-of-2-fields-to-exist-in-record/185246)
**Author:** [@cjokinen](https://discuss.elastic.co/u/cjokinen)\ **Replies:** 2\ **Last updated:** [June 11, 2019, 6:37pm UTC](https://discuss.elastic.co/t/how-to-check-for-1-of-2-fields-to-exist-in-record/185246 "2019-06-11T18:37:37Z")
I am having an issue getting a result where 1 or 2 fields exist. either is fine but the best I can figure is how to require both using the below query for ES6.5. { "version":"2017-02-28", "operation":"GET", "path"… --- ## [Content-type for importing tab delimited file into Elasticsearch](https://discuss.elastic.co/t/content-type-for-importing-tab-delimited-file-into-elasticsearch/185249)
**Author:** [@KathyTheGreat](https://discuss.elastic.co/u/KathyTheGreat)\ **Replies:** 2\ **Last updated:** [June 11, 2019, 5:51pm UTC](https://discuss.elastic.co/t/content-type-for-importing-tab-delimited-file-into-elasticsearch/185249 "2019-06-11T17:51:26Z")
I'm trying to import tab-delimited logs into Elasticsearch and I don't want to use logstash. Would the content-type header be text/tab-separated-values? I tried application/text and it gave an error, "content-type applic… --- ## [Elasticsearch trigger functions when index changes](https://discuss.elastic.co/t/elasticsearch-trigger-functions-when-index-changes/185257)
**Author:** [@vncsalencar](https://discuss.elastic.co/u/vncsalencar)\ **Replies:** 1\ **Last updated:** [June 11, 2019, 5:47pm UTC](https://discuss.elastic.co/t/elasticsearch-trigger-functions-when-index-changes/185257 "2019-06-11T17:47:43Z")
Hello! As a beginner regarding Elasticsearch, I'd like to know whether it is possible to have Elasticsearch watch for index changes and trigger functions to replicate data to another database. Is this possible with "wat… --- ## [Understanding Index and Type](https://discuss.elastic.co/t/understanding-index-and-type/185248)
**Author:** [@ashokchinna](https://discuss.elastic.co/u/ashokchinna)\ **Replies:** 1\ **Last updated:** [June 11, 2019, 5:45pm UTC](https://discuss.elastic.co/t/understanding-index-and-type/185248 "2019-06-11T17:45:58Z")
In general comparison of Elastic Search with Relational Database, Database (Relational Database) is Index (Elastic Search) Table (Relational Database) is Document Type (Elastic Search) So, a database can have multipl… --- ## [Docker-compose installation](https://discuss.elastic.co/t/docker-compose-installation/185107)
**Author:** [@rdaimler](https://discuss.elastic.co/u/rdaimler)\ **Replies:** 2\ **Last updated:** [June 11, 2019, 5:33pm UTC](https://discuss.elastic.co/t/docker-compose-installation/185107 "2019-06-11T17:33:53Z")
Hello! I just got an elasticsearch license and am curious about the latest installation options. The docker-compose example here worked with 6.x. It seems to stumble a bit on 7.x security config. It's is for an on prem … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1265) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1267)