# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1221 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1222 --- ## [Can't save a List\ on Elasticsearch 5.6.5](https://discuss.elastic.co/t/cant-save-a-list-int-on-elasticsearch-5-6-5/191267)
**Author:** [@CSharpBender](https://discuss.elastic.co/u/CSharpBender)\ **Replies:** 3\ **Last updated:** [July 19, 2019, 10:10am UTC](https://discuss.elastic.co/t/cant-save-a-list-int-on-elasticsearch-5-6-5/191267 "2019-07-19T10:10:58Z")
I've been playing with NEST 5.6.5 to see how it's treating the Nullable types in Elasticsearch. While serializing a NEST request I've noticed that for int? it's just a number and when it's null the value is not sent. W… --- ## [Query on number of attribues/fields in an index](https://discuss.elastic.co/t/query-on-number-of-attribues-fields-in-an-index/191347)
**Author:** [@vin0d](https://discuss.elastic.co/u/vin0d)\ **Replies:** 4\ **Last updated:** [July 19, 2019, 9:43am UTC](https://discuss.elastic.co/t/query-on-number-of-attribues-fields-in-an-index/191347 "2019-07-19T09:43:13Z")
Is there any limitation of number of attributes/fields added for a index ? Planning to use filtered aliases to avoid multiple indices, however have to add more attributes and all these attributes will not be populated e… --- ## [AWS Elasticsearch EC2 instance cannot see each other when xpack security turned on](https://discuss.elastic.co/t/aws-elasticsearch-ec2-instance-cannot-see-each-other-when-xpack-security-turned-on/191168)
**Author:** [@duc](https://discuss.elastic.co/u/duc)\ **Replies:** 1\ **Last updated:** [July 19, 2019, 8:30am UTC](https://discuss.elastic.co/t/aws-elasticsearch-ec2-instance-cannot-see-each-other-when-xpack-security-turned-on/191168 "2019-07-19T08:30:15Z")
Hello, Im working on EC2 instances and deploying elasticsearch v6.8 on them. My config is as follow: Node1: cluster.name: \ node.name: \ node.master: true node.data: true node.ingest: true … --- ## [ClassCastException with nested array in hive over elasticsearch](https://discuss.elastic.co/t/classcastexception-with-nested-array-in-hive-over-elasticsearch/191344)
**Author:** [@varun\_r](https://discuss.elastic.co/u/varun_r)\ **Replies:** 0\ **Last updated:** [July 19, 2019, 8:21am UTC](https://discuss.elastic.co/t/classcastexception-with-nested-array-in-hive-over-elasticsearch/191344 "2019-07-19T08:21:03Z")
I am using elasticsearch-hadoop-hive-7.2.0.jar to use elasticsearch tables on hive. However couldn't get it work with nested column. CREATE EXTERNAL TABLE test2019197 (fault\_details struct\ **Author:** [@KrishK](https://discuss.elastic.co/u/KrishK)\ **Replies:** 4\ **Last updated:** [July 19, 2019, 7:48am UTC](https://discuss.elastic.co/t/how-to-use-pagination-in-elastic-search-sql/191135 "2019-07-19T07:48:49Z") Hi We are using elastic search SQL REST API. POST /\_sql?format=json { "query": "SELECT \* FROM library limit 100" } If i use limit 0,100, its not working. And, i want to use pagination in application. is there any … --- ## [How to purge old documents or any better options to use rollover for dynamic index](https://discuss.elastic.co/t/how-to-purge-old-documents-or-any-better-options-to-use-rollover-for-dynamic-index/190872)
**Author:** [@Jasper\_B](https://discuss.elastic.co/u/Jasper_B)\ **Replies:** 17\ **Last updated:** [July 19, 2019, 7:47am UTC](https://discuss.elastic.co/t/how-to-purge-old-documents-or-any-better-options-to-use-rollover-for-dynamic-index/190872 "2019-07-19T07:47:01Z")
Hi guys, we have one request to purge the old data old than 7 days, when we saw this requirement the first choice what we think about is to use the index rollover function with time based index, for example create a new… --- ## [Shards unassigned after datanode addition](https://discuss.elastic.co/t/shards-unassigned-after-datanode-addition/191130)
**Author:** [@viratag26](https://discuss.elastic.co/u/viratag26)\ **Replies:** 6\ **Last updated:** [July 19, 2019, 7:35am UTC](https://discuss.elastic.co/t/shards-unassigned-after-datanode-addition/191130 "2019-07-19T07:35:35Z")
Hi, I have added a data node to my cluster. Shards are unassigned after the that. 2 primary and 2 replica shards are shown to be UNASSIGNED. Output of GET { "index": "other-administrator-2017.03.09", "shard": 3, … --- ## [How to view unique sum in grafana using elasticsearch data source](https://discuss.elastic.co/t/how-to-view-unique-sum-in-grafana-using-elasticsearch-data-source/191330)
**Author:** [@quangvublog](https://discuss.elastic.co/u/quangvublog)\ **Replies:** 1\ **Last updated:** [July 19, 2019, 7:27am UTC](https://discuss.elastic.co/t/how-to-view-unique-sum-in-grafana-using-elasticsearch-data-source/191330 "2019-07-19T07:27:47Z")
Hello everyone! I am having some problems when visualizing data in grafana. How can I get the only one metric which is newest? --- ## [Problem with cluster.max\_shards\_per\_node setting](https://discuss.elastic.co/t/problem-with-cluster-max-shards-per-node-setting/190933)
**Author:** [@ness1602](https://discuss.elastic.co/u/ness1602)\ **Replies:** 10\ **Last updated:** [July 19, 2019, 7:18am UTC](https://discuss.elastic.co/t/problem-with-cluster-max-shards-per-node-setting/190933 "2019-07-19T07:18:57Z")
Hi,i have a problem with testing ES 7.2(or any 7.x) and configuration for cluster.max\_shards\_per\_node. When i set it to lets say 30000 in elasticsearch.yml(Centos6), i think ES somehow overrides that with default settin… --- ## [Upgrade elasticsearch from 6.5 to 6.8.1](https://discuss.elastic.co/t/upgrade-elasticsearch-from-6-5-to-6-8-1/191182)
**Author:** [@Hitesh\_Malhotra](https://discuss.elastic.co/u/Hitesh_Malhotra)\ **Replies:** 3\ **Last updated:** [July 19, 2019, 7:16am UTC](https://discuss.elastic.co/t/upgrade-elasticsearch-from-6-5-to-6-8-1/191182 "2019-07-19T07:16:46Z")
Hi , I am trying to upgrade elastic from 6.5 to 6.8.1 by using sudo yum install elasticsearch command but no luck Loaded plugins: fastestmirror, product-id, search-disabled-repos, subscription-manager This syst… --- ## [Upgrading Elasticsearch 6.2 to 6.8](https://discuss.elastic.co/t/upgrading-elasticsearch-6-2-to-6-8/191316)
**Author:** [@chanakagl](https://discuss.elastic.co/u/chanakagl)\ **Replies:** 2\ **Last updated:** [July 19, 2019, 6:36am UTC](https://discuss.elastic.co/t/upgrading-elasticsearch-6-2-to-6-8/191316 "2019-07-19T06:36:22Z")
Hi, We have 6.2.4 cluster with GOLD licence and i want to upgrade it to 6.8. Since versions 6.3 and later, X-Pack is included with the default distributions of Elastic Stack, with all free features enabled by default. S… --- ## [SIGTERM on master](https://discuss.elastic.co/t/sigterm-on-master/191157)
**Author:** [@Bukhtawar\_Khan](https://discuss.elastic.co/u/Bukhtawar_Khan)\ **Replies:** 6\ **Last updated:** [July 19, 2019, 5:38am UTC](https://discuss.elastic.co/t/sigterm-on-master/191157 "2019-07-19T05:38:54Z")
Would a SIGTERM on master handle automatic exclusion from voting configuration --- ## [New to elasticsearch : Context : Oracle database contain records with JSON and different datastruct, Using command line i need to connect the database and combine datastruct and JSON and create a output as JSON file to post on elasticsearch index](https://discuss.elastic.co/t/new-to-elasticsearch-context-oracle-database-contain-records-with-json-and-different-datastruct-using-command-line-i-need-to-connect-the-database-and-combine-datastruct-and-json-and-create-a-output-as-json-file-to-post-on-elasticsearch-index/191279)
**Author:** [@trisha\_1212](https://discuss.elastic.co/u/trisha_1212)\ **Replies:** 1\ **Last updated:** [July 18, 2019, 11:57pm UTC](https://discuss.elastic.co/t/new-to-elasticsearch-context-oracle-database-contain-records-with-json-and-different-datastruct-using-command-line-i-need-to-connect-the-database-and-combine-datastruct-and-json-and-create-a-output-as-json-file-to-post-on-elasticsearch-index/191279 "2019-07-18T23:57:06Z")
New to elastic search: Context: Oracle database contains records with JSON and different data struct, Using command line I need to connect the database and combine data struct and JSON and create an output as JSON file t… --- ## [Unable to use Parent Child relation properly in elastic search](https://discuss.elastic.co/t/unable-to-use-parent-child-relation-properly-in-elastic-search/191273)
**Author:** [@sridharspeaks](https://discuss.elastic.co/u/sridharspeaks)\ **Replies:** 0\ **Last updated:** [July 18, 2019, 8:21pm UTC](https://discuss.elastic.co/t/unable-to-use-parent-child-relation-properly-in-elastic-search/191273 "2019-07-18T20:21:28Z")
I have a requirement to filter sub-objects of activities attribute in my user object based on its type. My User Object Model { userId, fistName, lastName, activities: \[ {mode: 'Typ1', name: … --- ## [How to copy boolQueryBuilder?](https://discuss.elastic.co/t/how-to-copy-boolquerybuilder/191271)
**Author:** [@pvsmpraveen](https://discuss.elastic.co/u/pvsmpraveen)\ **Replies:** 0\ **Last updated:** [July 18, 2019, 7:57pm UTC](https://discuss.elastic.co/t/how-to-copy-boolquerybuilder/191271 "2019-07-18T19:57:12Z")
I have a usecase where I have a boolQueryBuilder which is common across different type of queries. Now for different queries, I need to add a different must() to the boolQueryBuilder. basically, say i have a common boo… --- ## [How to group same value](https://discuss.elastic.co/t/how-to-group-same-value/191269)
**Author:** [@Ahmet\_Kartal](https://discuss.elastic.co/u/Ahmet_Kartal)\ **Replies:** 0\ **Last updated:** [July 18, 2019, 7:17pm UTC](https://discuss.elastic.co/t/how-to-group-same-value/191269 "2019-07-18T19:17:40Z")
Hello. I made a query which is this: body = { "aggs": { "Group1": { "terms": { "field": "method.keyword", … --- ## [Changing mapping type to IP](https://discuss.elastic.co/t/changing-mapping-type-to-ip/191262)
**Author:** [@userelastic](https://discuss.elastic.co/u/userelastic)\ **Replies:** 1\ **Last updated:** [July 18, 2019, 6:42pm UTC](https://discuss.elastic.co/t/changing-mapping-type-to-ip/191262 "2019-07-18T18:42:39Z")
Hi everyone; I have a Cisco ASA Firewall sending logs to ES through Logstash; I noticed that couple of fields are defined as text. Can you please guide me how can I can them into IP type? Following is the mapping and I n… --- ## [Failed to parse value \[1\] as only \[true\] or \[false\] are allowed."}\] Error when upgrade from 5.6 to 6.8](https://discuss.elastic.co/t/failed-to-parse-value-1-as-only-true-or-false-are-allowed-error-when-upgrade-from-5-6-to-6-8/191069)
**Author:** [@jasmineL](https://discuss.elastic.co/u/jasmineL)\ **Replies:** 4\ **Last updated:** [July 18, 2019, 5:41pm UTC](https://discuss.elastic.co/t/failed-to-parse-value-1-as-only-true-or-false-are-allowed-error-when-upgrade-from-5-6-to-6-8/191069 "2019-07-18T17:41:50Z")
Hi Elastic Team, We are trying to upgrade our Elasticsearch from 5.6 to 6.8.1. We first migrated our ES cluster from 5.6 to 6.8.1 and when we are trying to create new index from curl command we alway get error saying … --- ## [Returning too many results?](https://discuss.elastic.co/t/returning-too-many-results/191243)
**Author:** [@linus](https://discuss.elastic.co/u/linus)\ **Replies:** 3\ **Last updated:** [July 18, 2019, 5:25pm UTC](https://discuss.elastic.co/t/returning-too-many-results/191243 "2019-07-18T17:25:48Z")
Hi All. I'm new to ElasticSearch so am still trying to understand how it handles match queries. I have a bunch of docs in my index that have a array field, called keywordSearchTags" for keyword searching. So a documen… --- ## [Terms aggregation bucket for other documents](https://discuss.elastic.co/t/terms-aggregation-bucket-for-other-documents/191258)
**Author:** [@bogdan-srk](https://discuss.elastic.co/u/bogdan-srk)\ **Replies:** 0\ **Last updated:** [July 18, 2019, 5:13pm UTC](https://discuss.elastic.co/t/terms-aggregation-bucket-for-other-documents/191258 "2019-07-18T17:13:30Z")
Hi guys I use aggregation to collect data from nested field and stuck a little ES allows group data by rectangle.attributes.\_id, but is there any way to get some 'other' bucket to put there documents that were not adde… --- ## [GCP plugin for snapshot & backup](https://discuss.elastic.co/t/gcp-plugin-for-snapshot-backup/191251)
**Author:** [@Barrow\_Kwan](https://discuss.elastic.co/u/Barrow_Kwan)\ **Replies:** 0\ **Last updated:** [July 18, 2019, 4:40pm UTC](https://discuss.elastic.co/t/gcp-plugin-for-snapshot-backup/191251 "2019-07-18T16:40:27Z")
Does the plugin work behind the proxy? I didn't seem to see setting for proxy but for S3 plugin, it has the setting for proxy. thanks --- ## [Programmatically configure ILM](https://discuss.elastic.co/t/programmatically-configure-ilm/190594)
**Author:** [@cuzzo333](https://discuss.elastic.co/u/cuzzo333)\ **Replies:** 3\ **Last updated:** [July 18, 2019, 4:01pm UTC](https://discuss.elastic.co/t/programmatically-configure-ilm/190594 "2019-07-18T16:01:31Z")
Please forgive me if this specific topic has already been discussed elsewhere, I couldn't find much information matching what I'm looking for. I'm managing EFK stacks across multiple Kubernetes clusters and while the de… --- ## [Row and match count in elasticsearch](https://discuss.elastic.co/t/row-and-match-count-in-elasticsearch/191238)
**Author:** [@mansirajora01](https://discuss.elastic.co/u/mansirajora01)\ **Replies:** 0\ **Last updated:** [July 18, 2019, 3:55pm UTC](https://discuss.elastic.co/t/row-and-match-count-in-elasticsearch/191238 "2019-07-18T15:55:44Z")
Suppose I have a data in this format . POST /bookdb\_index/book/\_bulk { "index": { "\_id": 1 }} { "title": "Elasticsearch: The Definitive Guide", "authors": \["clinton gormley", "zachary tong"\], "summary" : "A distibute… --- ## [ES Rest High Level Client throws SocketTimeoutException after being idle for sometime](https://discuss.elastic.co/t/es-rest-high-level-client-throws-sockettimeoutexception-after-being-idle-for-sometime/188188)
**Author:** [@0b3d953a632983bedb48](https://discuss.elastic.co/u/0b3d953a632983bedb48)\ **Replies:** 1\ **Last updated:** [July 1, 2019, 11:25am UTC](https://discuss.elastic.co/t/es-rest-high-level-client-throws-sockettimeoutexception-after-being-idle-for-sometime/188188 "2019-07-01T11:25:17Z")
RestHighLevelClient is used to connect to ES 6.4(hosted on AWS) in a spring-boot app. When the app goes idle for some time, and request arrives, then the RestHighLevelClient throws SocketTimeoutException: \[Request proce… --- ## [Log DELETE commands from DevTools?](https://discuss.elastic.co/t/log-delete-commands-from-devtools/191213)
**Author:** [@sdberts](https://discuss.elastic.co/u/sdberts)\ **Replies:** 1\ **Last updated:** [July 18, 2019, 3:00pm UTC](https://discuss.elastic.co/t/log-delete-commands-from-devtools/191213 "2019-07-18T15:00:31Z")
I have a use case where I need to log when a user runs the DELETE REST command from DevTools to delete an index. Ideally, I'd want to store username, timestamp, and the command that was run. Does Elasticsearch or Kiban… --- ## [Minimizing / Avoiding churn due to relocation and rebalancing during nodal-outages in cluster](https://discuss.elastic.co/t/minimizing-avoiding-churn-due-to-relocation-and-rebalancing-during-nodal-outages-in-cluster/190924)
**Author:** [@Muthukumaran\_Kothand](https://discuss.elastic.co/u/Muthukumaran_Kothand)\ **Replies:** 5\ **Last updated:** [July 18, 2019, 2:47pm UTC](https://discuss.elastic.co/t/minimizing-avoiding-churn-due-to-relocation-and-rebalancing-during-nodal-outages-in-cluster/190924 "2019-07-18T14:47:49Z")
We are running a 3 node Elasticsearch 7.0.1 cluster and looking for options to handle the single-node outage scenario. Since we are using the default configuration options, when single node goes down from healthy 3-node … --- ## [Try to define an admin role (used setting similar to superuser) but not work](https://discuss.elastic.co/t/try-to-define-an-admin-role-used-setting-similar-to-superuser-but-not-work/190791)
**Author:** [@xujohn](https://discuss.elastic.co/u/xujohn)\ **Replies:** 2\ **Last updated:** [July 16, 2019, 11:34pm UTC](https://discuss.elastic.co/t/try-to-define-an-admin-role-used-setting-similar-to-superuser-but-not-work/190791 "2019-07-16T23:34:10Z")
In elasticsearch 7.2.0, I try to define in roles.yml the following role: admin\_role: cluster: \[ "all" \] indices: - names : \[ " \* " \] priviledges: \[ "all" \] allow\_restricted\_indices: true run\_as: \[ " \* " \] applica… --- ## [Max Number os Statemens in Painless loop](https://discuss.elastic.co/t/max-number-os-statemens-in-painless-loop/190104)
**Author:** [@BrunoSdeMenezes](https://discuss.elastic.co/u/BrunoSdeMenezes)\ **Replies:** 2\ **Last updated:** [July 18, 2019, 1:57pm UTC](https://discuss.elastic.co/t/max-number-os-statemens-in-painless-loop/190104 "2019-07-18T13:57:44Z")
Hello, I'm trying to run this scripted field: /\* Calcula a multa assumida para tarefas cumpridas fora do prazo, considerando os dias se passaram desde o vencimento e a periodicidade da multa\*/ if (doc\['obrigacao\_prazo\_c… --- ## [How to filter data using two indexes](https://discuss.elastic.co/t/how-to-filter-data-using-two-indexes/191193)
**Author:** [@lakmina\_chathurya](https://discuss.elastic.co/u/lakmina_chathurya)\ **Replies:** 4\ **Last updated:** [July 18, 2019, 1:51pm UTC](https://discuss.elastic.co/t/how-to-filter-data-using-two-indexes/191193 "2019-07-18T13:51:37Z")
hi team, I want to select all the users from user index and filter software engineers from user\_job index and result should display in bucket aggregation --- ## [How to query phrase with a few missing words](https://discuss.elastic.co/t/how-to-query-phrase-with-a-few-missing-words/191211)
**Author:** [@Sergey\_Efimov](https://discuss.elastic.co/u/Sergey_Efimov)\ **Replies:** 0\ **Last updated:** [July 18, 2019, 1:46pm UTC](https://discuss.elastic.co/t/how-to-query-phrase-with-a-few-missing-words/191211 "2019-07-18T13:46:41Z")
Hello guys, I'm looking for a request shape to find a phrase without some words, e.g. "Good morning \*\* would \* me. Thanks" where \* is one missed word. Such request works in many search engines. E.g.: Good morning, \*\*. … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1220) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1222)