# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=809 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 810 --- ## [Instantiate TransportClient in ES 7.8 help](https://discuss.elastic.co/t/instantiate-transportclient-in-es-7-8-help/248620)
**Author:** [@Pete\_Watcharawit](https://discuss.elastic.co/u/Pete_Watcharawit)\ **Replies:** 5\ **Last updated:** [September 15, 2020, 11:59am UTC](https://discuss.elastic.co/t/instantiate-transportclient-in-es-7-8-help/248620 "2020-09-15T11:59:01Z")
I would like to replace the way I instantiate TransportClient in 7.8 since our application is heavily dependent on TransportClient at the moment. TransportClient will be migrated to RestHighLevelClient. Settings setting… --- ## [Elasticsearch.keystore location](https://discuss.elastic.co/t/elasticsearch-keystore-location/248575)
**Author:** [@ben-charles](https://discuss.elastic.co/u/ben-charles)\ **Replies:** 1\ **Last updated:** [September 15, 2020, 11:47am UTC](https://discuss.elastic.co/t/elasticsearch-keystore-location/248575 "2020-09-15T11:47:49Z")
Is it possible to configure where elasticsearch.keystore is created? We would like to have it in a separate directory from the config/ directory. --- ## [Error while xpack.security.enabled:true on ES 6.8](https://discuss.elastic.co/t/error-while-xpack-security-enabled-true-on-es-6-8/248296)
**Author:** [@analysteng](https://discuss.elastic.co/u/analysteng)\ **Replies:** 8\ **Last updated:** [September 15, 2020, 11:03am UTC](https://discuss.elastic.co/t/error-while-xpack-security-enabled-true-on-es-6-8/248296 "2020-09-15T11:03:43Z")
Hello, When I modify the file 'elasticsearch.yml' by adding the line 'xpack.security.enabled: true', then Kibana does not work. I have already read all the doc on the web but still did not get to solve it. Please, cou… --- ## [No handler for type \[string\] declared on field \[name\]](https://discuss.elastic.co/t/no-handler-for-type-string-declared-on-field-name/248661)
**Author:** [@shwesinhan](https://discuss.elastic.co/u/shwesinhan)\ **Replies:** 0\ **Last updated:** [September 15, 2020, 11:01am UTC](https://discuss.elastic.co/t/no-handler-for-type-string-declared-on-field-name/248661 "2020-09-15T11:01:19Z")
Hi community. We have one issue after rolling upgrade from version 5.x to version 6.x. The issue is happening when reindex. Please check this out below: { "took": 22, "timed\_out": false, "tot… --- ## [Hardcoded bouncycastle versions in plugin-cli](https://discuss.elastic.co/t/hardcoded-bouncycastle-versions-in-plugin-cli/248641)
**Author:** [@josephine-rueckert](https://discuss.elastic.co/u/josephine-rueckert)\ **Replies:** 0\ **Last updated:** [September 15, 2020, 9:24am UTC](https://discuss.elastic.co/t/hardcoded-bouncycastle-versions-in-plugin-cli/248641 "2020-09-15T09:24:04Z")
Hi elastic team! In https://github.com/elastic/elasticsearch/issues/55145 @ikakavas mentioned you're using bouncycastle version 1.64. This matches what I've found in https://github.com/elastic/elasticsearch/blob/v7.7.0/… --- ## [Fetching data from multiValued column](https://discuss.elastic.co/t/fetching-data-from-multivalued-column/248637)
**Author:** [@ThinkToday](https://discuss.elastic.co/u/ThinkToday)\ **Replies:** 0\ **Last updated:** [September 15, 2020, 9:18am UTC](https://discuss.elastic.co/t/fetching-data-from-multivalued-column/248637 "2020-09-15T09:18:56Z")
Hiii, I have an Index with ActionId , profileID and profileStatus fields and other action details... an single action can be mapped to multiple profileID and status. In relational database we can map this as foreign key… --- ## [Index rating is increasing but document count is constant](https://discuss.elastic.co/t/index-rating-is-increasing-but-document-count-is-constant/248628)
**Author:** [@RusseL](https://discuss.elastic.co/u/RusseL)\ **Replies:** 5\ **Last updated:** [September 15, 2020, 9:04am UTC](https://discuss.elastic.co/t/index-rating-is-increasing-but-document-count-is-constant/248628 "2020-09-15T09:04:06Z")
Hi guys, Index rating is increasing but document count is constant like this for days. What is the reason? --- ## [How to configure rate-limits?](https://discuss.elastic.co/t/how-to-configure-rate-limits/248613)
**Author:** [@Dmitriy\_Khodakovskyi](https://discuss.elastic.co/u/Dmitriy_Khodakovskyi)\ **Replies:** 4\ **Last updated:** [September 15, 2020, 8:18am UTC](https://discuss.elastic.co/t/how-to-configure-rate-limits/248613 "2020-09-15T08:18:04Z")
As I see , elasticsearch has support of rate limiting: Is it available only for elastic cloud ? or it can be configured for self-hosted elastic? (and how?) Thanks in advance --- ## [Problem with json bulk import to elasticsearch ( jq: error: orders/0 is not defined at \, line 1: )](https://discuss.elastic.co/t/problem-with-json-bulk-import-to-elasticsearch-jq-error-orders-0-is-not-defined-at-top-level-line-1/248625)
**Author:** [@Bahar\_Yilmaz](https://discuss.elastic.co/u/Bahar_Yilmaz)\ **Replies:** 0\ **Last updated:** [September 15, 2020, 8:00am UTC](https://discuss.elastic.co/t/problem-with-json-bulk-import-to-elasticsearch-jq-error-orders-0-is-not-defined-at-top-level-line-1/248625 "2020-09-15T08:00:58Z")
Hi, I have problem with json bulk importing to elasticsearch. I want to send json data to elasticsearch as bulk request. My json data looks like this And this is the command I'm trying to make a bulk request by conv… --- ## [Updating the Cloudflare - Elastic.co logpush integration](https://discuss.elastic.co/t/updating-the-cloudflare-elastic-co-logpush-integration/248618)
**Author:** [@Lukasdeboer](https://discuss.elastic.co/u/Lukasdeboer)\ **Replies:** 1\ **Last updated:** [September 15, 2020, 7:37am UTC](https://discuss.elastic.co/t/updating-the-cloudflare-elastic-co-logpush-integration/248618 "2020-09-15T07:37:43Z")
Hi! I have followed this documentation (https://developers.cloudflare.com/logs/analytics-integrations/elastic) to set up logpush from Cloudflare to an Elastic.co cluster. This uses https://github.com/cloudflare/cloudfla… --- ## [Finding which indices contain hits when making use of an alias in elasticsearch query](https://discuss.elastic.co/t/finding-which-indices-contain-hits-when-making-use-of-an-alias-in-elasticsearch-query/248465)
**Author:** [@sandeepkanabar](https://discuss.elastic.co/u/sandeepkanabar)\ **Replies:** 10\ **Last updated:** [September 15, 2020, 7:27am UTC](https://discuss.elastic.co/t/finding-which-indices-contain-hits-when-making-use-of-an-alias-in-elasticsearch-query/248465 "2020-09-15T07:27:49Z")
I've 1000s of day-wise (time-based) indices in my cluster. Is there a way to monitor or find out at the ES Server side which indices return data when a query makes use of an alias . E.g. consider the below query that my … --- ## [Searching on text fields using wildcard](https://discuss.elastic.co/t/searching-on-text-fields-using-wildcard/248270)
**Author:** [@vasek](https://discuss.elastic.co/u/vasek)\ **Replies:** 4\ **Last updated:** [September 15, 2020, 7:22am UTC](https://discuss.elastic.co/t/searching-on-text-fields-using-wildcard/248270 "2020-09-15T07:22:12Z")
Hello, I have simple question about searching on text field. Let's assume we have a text field message with value: This is example of search query. Can anyone help me? PUT index { "mappings": { "properties": { … --- ## [AWS MYSQL data push to elastic search via logstash and visualise through Kibana](https://discuss.elastic.co/t/aws-mysql-data-push-to-elastic-search-via-logstash-and-visualise-through-kibana/248609)
**Author:** [@justnj](https://discuss.elastic.co/u/justnj)\ **Replies:** 0\ **Last updated:** [September 15, 2020, 6:56am UTC](https://discuss.elastic.co/t/aws-mysql-data-push-to-elastic-search-via-logstash-and-visualise-through-kibana/248609 "2020-09-15T06:56:57Z")
I am looking for a clear step by step document on AWS to migrate data from existing MYSQL to elastic search using logstash and visulaizing the same on kibana --- ## [Count unique values inside primitive array](https://discuss.elastic.co/t/count-unique-values-inside-primitive-array/248550)
**Author:** [@UglyBarnacle](https://discuss.elastic.co/u/UglyBarnacle)\ **Replies:** 0\ **Last updated:** [September 14, 2020, 3:13pm UTC](https://discuss.elastic.co/t/count-unique-values-inside-primitive-array/248550 "2020-09-14T15:13:17Z")
Just wanted to know if there is an elegant solution for my problem: We sort of have an index that stores orders and on those orders is an array of zipcodes which the customer selected. { "identifier": "1574417821835",… --- ## [Elasticsearch: setting up cluster with two nodes](https://discuss.elastic.co/t/elasticsearch-setting-up-cluster-with-two-nodes/247994)
**Author:** [@Techmod](https://discuss.elastic.co/u/Techmod)\ **Replies:** 5\ **Last updated:** [September 15, 2020, 5:28am UTC](https://discuss.elastic.co/t/elasticsearch-setting-up-cluster-with-two-nodes/247994 "2020-09-15T05:28:54Z")
I've set two master nodes in my cluster but it only shows "elastic-master" not "elastic-slave".(second node is not shown).How can I resolve it? I've already followed Elasticsearch documents but nothing changed! #my host… --- ## [Dynamic mapping](https://discuss.elastic.co/t/dynamic-mapping/248598)
**Author:** [@Milan\_Suthar](https://discuss.elastic.co/u/Milan_Suthar)\ **Replies:** 2\ **Last updated:** [September 15, 2020, 5:58am UTC](https://discuss.elastic.co/t/dynamic-mapping/248598 "2020-09-15T05:58:07Z")
ES version 6.8.12 i want to make my index filed store anything regardless of its type im facing issue while storing string value in long type field can anyone help me --- ## [Circuit\_breaking\_exception](https://discuss.elastic.co/t/circuit-breaking-exception/247637)
**Author:** [@Sajeeva\_Lakmal](https://discuss.elastic.co/u/Sajeeva_Lakmal)\ **Replies:** 11\ **Last updated:** [September 15, 2020, 3:58am UTC](https://discuss.elastic.co/t/circuit-breaking-exception/247637 "2020-09-15T03:58:00Z")
We recently upgraded our elastic cloud deployment from 6.8.5 to 7.9 After the upgrade we are seeing the following error time to time. { "error" : { "root\_cause" : \[ { "type" : "circuit\_breaking\_exce… --- ## [High RAM Usage Across Cluster](https://discuss.elastic.co/t/high-ram-usage-across-cluster/248582)
**Author:** [@jcannell](https://discuss.elastic.co/u/jcannell)\ **Replies:** 7\ **Last updated:** [September 15, 2020, 1:44am UTC](https://discuss.elastic.co/t/high-ram-usage-across-cluster/248582 "2020-09-15T01:44:00Z")
Hello again, we are continuing to test out our new elasticsearch cluster. I'm trying to understand the following: Why is ram usage always so high? (it doesn't ever decrease, even when nobody is searching or indexing). … --- ## [Separate data and metadata](https://discuss.elastic.co/t/separate-data-and-metadata/248531)
**Author:** [@Oleg\_Ruchovets](https://discuss.elastic.co/u/Oleg_Ruchovets)\ **Replies:** 3\ **Last updated:** [September 14, 2020, 10:17pm UTC](https://discuss.elastic.co/t/separate-data-and-metadata/248531 "2020-09-14T22:17:02Z")
Hello. In Hadoop echo system and some other solution: data and metadata are stored separately. For Hadoop, there are master nodes to store metadata. Question: does Elasticsearch have similar architecture? I mean is th… --- ## [Unable to create architecture to get system logs from another server using metricbeat](https://discuss.elastic.co/t/unable-to-create-architecture-to-get-system-logs-from-another-server-using-metricbeat/248470)
**Author:** [@Shriram\_Wasule](https://discuss.elastic.co/u/Shriram_Wasule)\ **Replies:** 1\ **Last updated:** [September 14, 2020, 10:12pm UTC](https://discuss.elastic.co/t/unable-to-create-architecture-to-get-system-logs-from-another-server-using-metricbeat/248470 "2020-09-14T22:12:46Z")
I am completely new to ELK stack concept. i want to capture the system metric of my organizations servers which is of AWS using metricbeat and want to receive those logs on one central server where i have installed elast… --- ## [How to use manage\_own\_api\_key privilege in elk](https://discuss.elastic.co/t/how-to-use-manage-own-api-key-privilege-in-elk/248573)
**Author:** [@Ananya\_Chaurasia](https://discuss.elastic.co/u/Ananya_Chaurasia)\ **Replies:** 0\ **Last updated:** [September 14, 2020, 6:26pm UTC](https://discuss.elastic.co/t/how-to-use-manage-own-api-key-privilege-in-elk/248573 "2020-09-14T18:26:37Z")
Is it possible to have a user which has just read only privilege to Kibana dashboard and can also create its api key? Giving read only privilege to user does not allow user to create api key from kibana console. I read h… --- ## [Search distribution imbalance: Adaptive Replica Selection](https://discuss.elastic.co/t/search-distribution-imbalance-adaptive-replica-selection/247276)
**Author:** [@rsk0](https://discuss.elastic.co/u/rsk0)\ **Replies:** 7\ **Last updated:** [September 14, 2020, 9:38pm UTC](https://discuss.elastic.co/t/search-distribution-imbalance-adaptive-replica-selection/247276 "2020-09-14T21:38:02Z")
We had a node out of a 7.6 cluster for a day and after starting ES on it and having shards allocated to it the node and cluster started acting badly. The node's CPU rose to roughly twice as much as the rest of the clust… --- ## [Change in fuzzy + highlighting behavior between ES6 (6.7.2) and ES7 (7.9.0)](https://discuss.elastic.co/t/change-in-fuzzy-highlighting-behavior-between-es6-6-7-2-and-es7-7-9-0/248581)
**Author:** [@mdunn](https://discuss.elastic.co/u/mdunn)\ **Replies:** 0\ **Last updated:** [September 14, 2020, 9:18pm UTC](https://discuss.elastic.co/t/change-in-fuzzy-highlighting-behavior-between-es6-6-7-2-and-es7-7-9-0/248581 "2020-09-14T21:18:15Z")
We are currently in the process of upgrading from ES6 (6.7.2) to ES7 (7.9.0) and we have noticed a change in behavior with regards to highlighting when fuzzy search is turned on. We are using the unified highlighter as … --- ## [Elastic I/O Optimised Scaling](https://discuss.elastic.co/t/elastic-i-o-optimised-scaling/248361)
**Author:** [@Omair\_Malik](https://discuss.elastic.co/u/Omair_Malik)\ **Replies:** 5\ **Last updated:** [September 14, 2020, 8:03pm UTC](https://discuss.elastic.co/t/elastic-i-o-optimised-scaling/248361 "2020-09-14T20:03:51Z")
Hi All, We currently have the following setup at Elastic: x1 Data Configuration in 3 zones = 3 nodes in total x1 Kabana node x1 APM node Due to shards running low in the coming months, we want to add another node ie … --- ## [Elasticserach cluster in red state and a lot of unassigned shards](https://discuss.elastic.co/t/elasticserach-cluster-in-red-state-and-a-lot-of-unassigned-shards/248579)
**Author:** [@Sahishnu\_Maharjan](https://discuss.elastic.co/u/Sahishnu_Maharjan)\ **Replies:** 0\ **Last updated:** [September 14, 2020, 8:02pm UTC](https://discuss.elastic.co/t/elasticserach-cluster-in-red-state-and-a-lot-of-unassigned-shards/248579 "2020-09-14T20:02:19Z")
Greetings, I was given a broken graylog cluster to fix. Upon examination, elasticsearch cluster (7 node: 1 master 6 data) was red as its fs was 100%. After clearing older data, I started noticing unassigned shards error.… --- ## [Export specific fields from data](https://discuss.elastic.co/t/export-specific-fields-from-data/248578)
**Author:** [@zaeemmasood](https://discuss.elastic.co/u/zaeemmasood)\ **Replies:** 0\ **Last updated:** [September 14, 2020, 8:00pm UTC](https://discuss.elastic.co/t/export-specific-fields-from-data/248578 "2020-09-14T20:00:38Z")
Hi All, We need to export specific fields from a particular index. The export can be in any format. Problem is that the size of the index is large and on top of that we need information based on last 30 days. I did s… --- ## [Count the number of phrase hits in a specific document](https://discuss.elastic.co/t/count-the-number-of-phrase-hits-in-a-specific-document/248572)
**Author:** [@spyderman4g63](https://discuss.elastic.co/u/spyderman4g63)\ **Replies:** 0\ **Last updated:** [September 14, 2020, 6:23pm UTC](https://discuss.elastic.co/t/count-the-number-of-phrase-hits-in-a-specific-document/248572 "2020-09-14T18:23:33Z")
Is there a way to search for a document by id (\_doc) and then count the number of times a phrase is mentioned? Given the text in a field called 'message': "Bob Smith is a plumber. Bob Smith is also a racecar driver. Bob… --- ## [How to increase the speed of restoring snapshots using GCS](https://discuss.elastic.co/t/how-to-increase-the-speed-of-restoring-snapshots-using-gcs/248562)
**Author:** [@knagasri](https://discuss.elastic.co/u/knagasri)\ **Replies:** 0\ **Last updated:** [September 14, 2020, 4:29pm UTC](https://discuss.elastic.co/t/how-to-increase-the-speed-of-restoring-snapshots-using-gcs/248562 "2020-09-14T16:29:32Z")
Can this be "max\_restore\_bytes\_per\_sec" : "10gb" used to increase restoring snapshots on GKE elasticsearch using GCS bucket. Can anyone please answer this one --- ## [Tableau Connector with Elastic JDBC driver](https://discuss.elastic.co/t/tableau-connector-with-elastic-jdbc-driver/248344)
**Author:** [@otorih](https://discuss.elastic.co/u/otorih)\ **Replies:** 1\ **Last updated:** [September 14, 2020, 4:28pm UTC](https://discuss.elastic.co/t/tableau-connector-with-elastic-jdbc-driver/248344 "2020-09-14T16:28:54Z")
Hello, I couldn't find any satisfying solution on google and after double-checking that this hasn't already been answered here, I decided to write that post to seek for some help. I am currently trying to connect Table… --- ## [Scroll query performance regression upgrading to ES v7.9 from v6.8](https://discuss.elastic.co/t/scroll-query-performance-regression-upgrading-to-es-v7-9-from-v6-8/248556)
**Author:** [@rankida](https://discuss.elastic.co/u/rankida)\ **Replies:** 0\ **Last updated:** [September 14, 2020, 3:57pm UTC](https://discuss.elastic.co/t/scroll-query-performance-regression-upgrading-to-es-v7-9-from-v6-8/248556 "2020-09-14T15:57:19Z")
We have a query that returns a stupid amount of results (98k). I won't go into details as to why. To achieve this we use a scroll with 1,000 documents per batch. We recently (finally) upgraded to v7.x of ElasticSearch a… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=808) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=810)