# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1800 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1801 --- ## [Convert query from Mysql to curl](https://discuss.elastic.co/t/convert-query-from-mysql-to-curl/118643)
**Author:** [@devil\_srj7](https://discuss.elastic.co/u/devil_srj7)\ **Replies:** 0\ **Last updated:** [February 6, 2018, 12:34pm UTC](https://discuss.elastic.co/t/convert-query-from-mysql-to-curl/118643 "2018-02-06T12:34:13Z")
SELECT st.branch\_id branch\_id, st.branch\_name branch\_name, st.dept\_id dept\_id, st.dept\_name dept\_name, ROUND(SUM(IFNULL(st.work\_allotment,0.0)/10000000)) work\_allotment, ROUND(SUM(IFNULL(st.progMonth\_Exp,0.0)… --- ## [Get inner object in the query result- multi nested](https://discuss.elastic.co/t/get-inner-object-in-the-query-result-multi-nested/118631)
**Author:** [@SreeAnnait](https://discuss.elastic.co/u/SreeAnnait)\ **Replies:** 0\ **Last updated:** [February 6, 2018, 11:39am UTC](https://discuss.elastic.co/t/get-inner-object-in-the-query-result-multi-nested/118631 "2018-02-06T11:39:35Z")
https://pastebin.com/fTCsDEHj From the above structure, I want to get the tab\_fields.id where tab\_fields.is\_primary=true. Is there any option to return specific field? --- ## [Courier Fetch: 1 of 5 shards failed](https://discuss.elastic.co/t/courier-fetch-1-of-5-shards-failed/118605)
**Author:** [@bvnages](https://discuss.elastic.co/u/bvnages)\ **Replies:** 1\ **Last updated:** [February 6, 2018, 12:06pm UTC](https://discuss.elastic.co/t/courier-fetch-1-of-5-shards-failed/118605 "2018-02-06T12:06:21Z")
Hi All, I am installed elastic search new version 6.1.2. We are getting below error in kibana. Please help . Courier Fetch: 1 of 5 shards failed. --- ## [How to increase shard size and limit](https://discuss.elastic.co/t/how-to-increase-shard-size-and-limit/118635)
**Author:** [@gudipudiswaroop](https://discuss.elastic.co/u/gudipudiswaroop)\ **Replies:** 1\ **Last updated:** [February 6, 2018, 11:57am UTC](https://discuss.elastic.co/t/how-to-increase-shard-size-and-limit/118635 "2018-02-06T11:57:54Z")
Hi, I have setup elastic search on my server with default settings (single node and no clusters). I have enabled logstash to read my application logs and then I am trying to run aggregation query on top of indexed logs.… --- ## [Force an object type into a text field?](https://discuss.elastic.co/t/force-an-object-type-into-a-text-field/118609)
**Author:** [@TheBronx](https://discuss.elastic.co/u/TheBronx)\ **Replies:** 4\ **Last updated:** [February 6, 2018, 11:27am UTC](https://discuss.elastic.co/t/force-an-object-type-into-a-text-field/118609 "2018-02-06T11:27:14Z")
I have a problem. We store http requests in elastic, and it turns out we are using the same parameter name in two different requests with different types. Request A is sending a parameter named "operation" as a JSON obj… --- ## [Confused!Different types of data are stored in the same field](https://discuss.elastic.co/t/confused-different-types-of-data-are-stored-in-the-same-field/118618)
**Author:** [@eboy](https://discuss.elastic.co/u/eboy)\ **Replies:** 0\ **Last updated:** [February 6, 2018, 10:47am UTC](https://discuss.elastic.co/t/confused-different-types-of-data-are-stored-in-the-same-field/118618 "2018-02-06T10:47:43Z")
Dynamically added data, the same field originally stored as long type, now stored text, can not store, Is there anyone have encountered such problems, how to deal with. I have used "ignore\_malformed", but he cannot be s… --- ## [Elasticsearch on CentOS 7.4.1708, bootstrap.memory\_lock problems when starting on boot, but no problems on manual start](https://discuss.elastic.co/t/elasticsearch-on-centos-7-4-1708-bootstrap-memory-lock-problems-when-starting-on-boot-but-no-problems-on-manual-start/118476)
**Author:** [@digirave](https://discuss.elastic.co/u/digirave)\ **Replies:** 3\ **Last updated:** [February 6, 2018, 10:30am UTC](https://discuss.elastic.co/t/elasticsearch-on-centos-7-4-1708-bootstrap-memory-lock-problems-when-starting-on-boot-but-no-problems-on-manual-start/118476 "2018-02-06T10:30:13Z")
I am trying to run elasticsearch-5.6.6-1 on startup on CentOS 7.4.1708. I have no problems with almost the exact setup on CentOS 6.x. The server has 64 GB of ram with most of it not used. When I set bootstrap.memory\_… --- ## [Search for documents matching all terms in a nested array](https://discuss.elastic.co/t/search-for-documents-matching-all-terms-in-a-nested-array/118577)
**Author:** [@mayur822](https://discuss.elastic.co/u/mayur822)\ **Replies:** 2\ **Last updated:** [February 6, 2018, 10:28am UTC](https://discuss.elastic.co/t/search-for-documents-matching-all-terms-in-a-nested-array/118577 "2018-02-06T10:28:40Z")
I am learning to use Elasticsearch as a basic recommender engine. My elasticsearch document contains records with nested entities as follows PUT recs/user/1 { "name" : "Brad Pitt", "movies\_liked": \[ { "nam… --- ## [Can not start esrally after installed](https://discuss.elastic.co/t/can-not-start-esrally-after-installed/118593)
**Author:** [@imqishi](https://discuss.elastic.co/u/imqishi)\ **Replies:** 1\ **Last updated:** [February 6, 2018, 10:23am UTC](https://discuss.elastic.co/t/can-not-start-esrally-after-installed/118593 "2018-02-06T10:23:58Z")
After installed I try to run it but there's some errors... \[root@NETLOGS ~\]# esrally configure \_\_\_\_ \_\_\_\_ / \_\_ \\\_\_\_\_ \_/ / /\_ \_\_ / /\_/ / \_\_ \`/ / / / / / / \_, \_/ /\_/ / / / /\_/ / /\_/ |\_|\\\_\_,\_/\_/\_/\\\_\_, / … --- ## [Forced Shardawareness question](https://discuss.elastic.co/t/forced-shardawareness-question/118195)
**Author:** [@ludovic\_jerome](https://discuss.elastic.co/u/ludovic_jerome)\ **Replies:** 5\ **Last updated:** [February 6, 2018, 10:20am UTC](https://discuss.elastic.co/t/forced-shardawareness-question/118195 "2018-02-06T10:20:07Z")
Hello, I am testing the forced shard awareness configuration following this section https://www.elastic.co/guide/en/elasticsearch/reference/current/allocation-awareness.html. Please see below my setup: 3 dedicated ma… --- ## [Multiply dis\_max query score](https://discuss.elastic.co/t/multiply-dis-max-query-score/118607)
**Author:** [@Amir\_P](https://discuss.elastic.co/u/Amir_P)\ **Replies:** 0\ **Last updated:** [February 6, 2018, 10:12am UTC](https://discuss.elastic.co/t/multiply-dis-max-query-score/118607 "2018-02-06T10:12:21Z")
Hello, Until now I used multi\_match query and multiply the regular score (not the ngram) by 3: GET index/type { "query": { "bool": { "must": \[ { "multi\_match": { … --- ## [Combine Context Suggester with multiple weight inputs](https://discuss.elastic.co/t/combine-context-suggester-with-multiple-weight-inputs/118606)
**Author:** [@JanSp](https://discuss.elastic.co/u/JanSp)\ **Replies:** 0\ **Last updated:** [February 6, 2018, 10:09am UTC](https://discuss.elastic.co/t/combine-context-suggester-with-multiple-weight-inputs/118606 "2018-02-06T10:09:54Z")
Hey guys, elsatic version 6.1 i want to combine the context suggestor with multiple inputs like this example PUT place/doc/3 { "suggest": \[ { "input": "Berlin", "weight": 10 … --- ## [Elasticsearch cluster is taking much time to get the response](https://discuss.elastic.co/t/elasticsearch-cluster-is-taking-much-time-to-get-the-response/118601)
**Author:** [@srikanth\_nagineni](https://discuss.elastic.co/u/srikanth_nagineni)\ **Replies:** 0\ **Last updated:** [February 6, 2018, 10:01am UTC](https://discuss.elastic.co/t/elasticsearch-cluster-is-taking-much-time-to-get-the-response/118601 "2018-02-06T10:01:09Z")
I have ES cluster of 16 nodes. The total data size in the cluster has 750GB. I used replication factor as 1. So the data size is 1.5TB. Each node is having the following specification: 500GB SSD raid 1 64GB ram 8 core… --- ## [Reindexing Elasticsearch 2.x to 5.x](https://discuss.elastic.co/t/reindexing-elasticsearch-2-x-to-5-x/117425)
**Author:** [@atom](https://discuss.elastic.co/u/atom)\ **Replies:** 6\ **Last updated:** [February 6, 2018, 9:36am UTC](https://discuss.elastic.co/t/reindexing-elasticsearch-2-x-to-5-x/117425 "2018-02-06T09:36:48Z")
Hi there, i am upgrading our elasticsearch instance from 2.x to 5.6. The upgrade itself with full cluster restart went fine. Now i need to reindex all indices in order to upgrade to version 6.x. I do not understand wha… --- ## [High system load causing performance issues](https://discuss.elastic.co/t/high-system-load-causing-performance-issues/118078)
**Author:** [@Ant](https://discuss.elastic.co/u/Ant)\ **Replies:** 3\ **Last updated:** [February 6, 2018, 9:32am UTC](https://discuss.elastic.co/t/high-system-load-causing-performance-issues/118078 "2018-02-06T09:32:56Z")
Hi I'm noticing a latency spike on my elastic cluster when system interupts go over 8k a second. My knowledge of what that is is limited to me googling of the last hour and what I've come to realise is I don't really k… --- ## [Filter elasticsearch nested objects based on other objects](https://discuss.elastic.co/t/filter-elasticsearch-nested-objects-based-on-other-objects/118589)
**Author:** [@Mukul\_Jain](https://discuss.elastic.co/u/Mukul_Jain)\ **Replies:** 0\ **Last updated:** [February 6, 2018, 9:14am UTC](https://discuss.elastic.co/t/filter-elasticsearch-nested-objects-based-on-other-objects/118589 "2018-02-06T09:14:11Z")
HI, I am facing a problem trying to find a solution for days. What I want is to filter/query nested objects based on nested objects belonging to different path/same path. I would be really helpful if someone can help … --- ## [Unable to create an index with parent child relationship using .net NEST](https://discuss.elastic.co/t/unable-to-create-an-index-with-parent-child-relationship-using-net-nest/116057)
**Author:** [@raja11](https://discuss.elastic.co/u/raja11)\ **Replies:** 15\ **Last updated:** [February 6, 2018, 8:55am UTC](https://discuss.elastic.co/t/unable-to-create-an-index-with-parent-child-relationship-using-net-nest/116057 "2018-02-06T08:55:36Z")
I m trying to run the following code in .net var descriptor = new CreateIndexDescriptor("raja") .Mappings(ms =\> ms .Map("employee", m =\> m.AutoMap()) .Map("employeeskillset", m =\> m.AutoMap().Parent())); client.Crea… --- ## [TransportError when executing rollover action via curator](https://discuss.elastic.co/t/transporterror-when-executing-rollover-action-via-curator/117198)
**Author:** [@allansene](https://discuss.elastic.co/u/allansene)\ **Replies:** 1\ **Last updated:** [February 6, 2018, 8:49am UTC](https://discuss.elastic.co/t/transporterror-when-executing-rollover-action-via-curator/117198 "2018-02-06T08:49:30Z")
Guys, I'm getting this error when executing a rollover action via curator: Failed to complete action: rollover. \: TransportError(400, 'illegal\_argument\_exception', '\[elast… --- ## [\[RESOLVED\] SearchGuard: ElasticSearch "failed to execute multi\_get for \[config\]/\[5.5.2\]" error](https://discuss.elastic.co/t/resolved-searchguard-elasticsearch-failed-to-execute-multi-get-for-config-5-5-2-error/118456)
**Author:** [@tsvet](https://discuss.elastic.co/u/tsvet)\ **Replies:** 1\ **Last updated:** [February 6, 2018, 7:54am UTC](https://discuss.elastic.co/t/resolved-searchguard-elasticsearch-failed-to-execute-multi-get-for-config-5-5-2-error/118456 "2018-02-06T07:54:35Z")
I am getting some error if I try to run Kibana 5.5.2 against ES secured by SearchGuard. I've deleted my .kibana index .. Recreated it. Please let me know if you need more information. Below you can find my log from ES: … --- ## [Is it possible to create a loop around a challenge](https://discuss.elastic.co/t/is-it-possible-to-create-a-loop-around-a-challenge/117892)
**Author:** [@dipanjan44](https://discuss.elastic.co/u/dipanjan44)\ **Replies:** 6\ **Last updated:** [February 6, 2018, 7:26am UTC](https://discuss.elastic.co/t/is-it-possible-to-create-a-loop-around-a-challenge/117892 "2018-02-06T07:26:49Z")
I would like to loop through my challenge using rally. I have a create, insert and delete operation inside the challenge. I would like to loop through it 10 times or say for 24 hrs. Is there a provision of doing it witho… --- ## [Elasticsearch Curator not install with Error](https://discuss.elastic.co/t/elasticsearch-curator-not-install-with-error/118562)
**Author:** [@omid](https://discuss.elastic.co/u/omid)\ **Replies:** 2\ **Last updated:** [February 6, 2018, 7:11am UTC](https://discuss.elastic.co/t/elasticsearch-curator-not-install-with-error/118562 "2018-02-06T07:11:17Z")
im would install Elasticsearch Curator ... but error im step by step with this link and install " sudo apt-get install python-pip " success ! but not install " pip install elasticsearch-curator " When I get this … --- ## [Elasticsearch dead recently without modify anything](https://discuss.elastic.co/t/elasticsearch-dead-recently-without-modify-anything/116839)
**Author:** [@kiwi0217](https://discuss.elastic.co/u/kiwi0217)\ **Replies:** 5\ **Last updated:** [February 6, 2018, 7:00am UTC](https://discuss.elastic.co/t/elasticsearch-dead-recently-without-modify-anything/116839 "2018-02-06T07:00:07Z")
i use kibana in Ubuntu16.04 and it shows： Elasticsearch plugin is red Unable to connect to Elasticsearch at http://127.0.0.1:9200 and i check about service and elasticsearch already dead. If I use command "service el… --- ## [Xpack issues](https://discuss.elastic.co/t/xpack-issues/118103)
**Author:** [@noelgeorgi](https://discuss.elastic.co/u/noelgeorgi)\ **Replies:** 4\ **Last updated:** [February 6, 2018, 5:03am UTC](https://discuss.elastic.co/t/xpack-issues/118103 "2018-02-06T05:03:25Z")
Well I have created a 2 node master and a single data node cluster: master:-config cluster.name: elasticsearch bootstrap.memory\_lock: false network.host: 0.0.0.0 xpack.security.authc.anonymous.username: anonymous\_user … --- ## [How to use pfx file with certutil](https://discuss.elastic.co/t/how-to-use-pfx-file-with-certutil/118023)
**Author:** [@stephenpatten](https://discuss.elastic.co/u/stephenpatten)\ **Replies:** 3\ **Last updated:** [February 6, 2018, 4:40am UTC](https://discuss.elastic.co/t/how-to-use-pfx-file-with-certutil/118023 "2018-02-06T04:40:25Z")
Hello, I have a pfx file from my IT dept to use in one of our environments, can I use that, or convert it to a format suitable for use with certutil? Total noob question, sorry Thank you, Stephen --- ## [Some questions with regards to index.translog.durability's interaction with replica shards](https://discuss.elastic.co/t/some-questions-with-regards-to-index-translog-durabilitys-interaction-with-replica-shards/118098)
**Author:** [@Wisgary](https://discuss.elastic.co/u/Wisgary)\ **Replies:** 4\ **Last updated:** [February 6, 2018, 3:23am UTC](https://discuss.elastic.co/t/some-questions-with-regards-to-index-translog-durabilitys-interaction-with-replica-shards/118098 "2018-02-06T03:23:18Z")
From documentation, I see "async" - fsync and commit in the background every sync\_interval. In the event of hardware failure, all acknowledged writes since the last automatic commit will be discarded. So a few questi… --- ## [Elasticsearch: Not enough master nodes discovered during pinging](https://discuss.elastic.co/t/elasticsearch-not-enough-master-nodes-discovered-during-pinging/118546)
**Author:** [@hiteshs](https://discuss.elastic.co/u/hiteshs)\ **Replies:** 2\ **Last updated:** [February 6, 2018, 3:19am UTC](https://discuss.elastic.co/t/elasticsearch-not-enough-master-nodes-discovered-during-pinging/118546 "2018-02-06T03:19:52Z")
I'm trying to setup a cluster with 4 Master nodes. After restarting the service, I've been getting the following error: \[2018-02-05T21:29:41,040\]\[WARN \]\[o.e.d.z.ZenDiscovery \] \[Elasticsearch-Master\] not enough master no… --- ## [Working of ES as a daemon](https://discuss.elastic.co/t/working-of-es-as-a-daemon/118528)
**Author:** [@fhalde](https://discuss.elastic.co/u/fhalde)\ **Replies:** 2\ **Last updated:** [February 6, 2018, 12:51am UTC](https://discuss.elastic.co/t/working-of-es-as-a-daemon/118528 "2018-02-06T00:51:17Z")
Our cluster sizes are getting bigger and bigger \[40-50machines\] & there are times when we need to do a full cluster restart It is really painful to log into each machines and restart ES processes running on them For mi… --- ## [Required plugins for ES-5.6.3](https://discuss.elastic.co/t/required-plugins-for-es-5-6-3/118500)
**Author:** [@dzyubanv](https://discuss.elastic.co/u/dzyubanv)\ **Replies:** 6\ **Last updated:** [February 5, 2018, 11:36pm UTC](https://discuss.elastic.co/t/required-plugins-for-es-5-6-3/118500 "2018-02-05T23:36:10Z")
I'm running es-5.6.3 on rhel. It works well with single and multi node configuration and basic attributes in elasticsearch.yml (cluster.name, node.name, node.master, node.data, network.host, etc.). But when I added the… --- ## [JSON technically allows for duplicate keys - do Elasticsearch documents?](https://discuss.elastic.co/t/json-technically-allows-for-duplicate-keys-do-elasticsearch-documents/118526)
**Author:** [@Chris\_Fraschetti](https://discuss.elastic.co/u/Chris_Fraschetti)\ **Replies:** 3\ **Last updated:** [February 5, 2018, 10:35pm UTC](https://discuss.elastic.co/t/json-technically-allows-for-duplicate-keys-do-elasticsearch-documents/118526 "2018-02-05T22:35:35Z")
I'm looking for an official answer with regards to whether or not this is supported functionality as opposed to "well.. it seems to work that way.. for now" A quick example: { "make" : "Ford", "make" : "Totoya", "ma… --- ## [Convert elasticsearch query to PHP low-level client](https://discuss.elastic.co/t/convert-elasticsearch-query-to-php-low-level-client/118532)
**Author:** [@bk10](https://discuss.elastic.co/u/bk10)\ **Replies:** 0\ **Last updated:** [February 5, 2018, 10:19pm UTC](https://discuss.elastic.co/t/convert-elasticsearch-query-to-php-low-level-client/118532 "2018-02-05T22:19:17Z")
Dear, Is there any converter that can convert elasticsearch query (for example copied from Kibana visualization) to PHP oriented query that can be used in official PHP low-level client for elasticsearch? Cheers [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1799) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1801)