# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1401 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1402 --- ## [How to combine Latitude and Longitude columns into one Location Column and make it's type to geo\_point in Elasticsearch and Hive Integration - Elasticsearch & Hive Integration](https://discuss.elastic.co/t/how-to-combine-latitude-and-longitude-columns-into-one-location-column-and-make-its-type-to-geo-point-in-elasticsearch-and-hive-integration-elasticsearch-hive-integration/167595)
**Author:** [@shivakumar\_kasha](https://discuss.elastic.co/u/shivakumar_kasha)\ **Replies:** 0\ **Last updated:** [February 8, 2019, 9:16am UTC](https://discuss.elastic.co/t/how-to-combine-latitude-and-longitude-columns-into-one-location-column-and-make-its-type-to-geo-point-in-elasticsearch-and-hive-integration-elasticsearch-hive-integration/167595 "2019-02-08T09:16:32Z")
Hi Everyone, I'm trying to integrate ES-Hadoop plugin to connect Hive and Elasticsearch. I'm able to connect the Hive and Elasticsearch. The data i'm getting in My elasticsearch index is having lat and long columns se… --- ## [Filtered top hit per group, plus unfiltered members of group](https://discuss.elastic.co/t/filtered-top-hit-per-group-plus-unfiltered-members-of-group/167609)
**Author:** [@Bob\_Gregory](https://discuss.elastic.co/u/Bob_Gregory)\ **Replies:** 0\ **Last updated:** [February 8, 2019, 10:56am UTC](https://discuss.elastic.co/t/filtered-top-hit-per-group-plus-unfiltered-members-of-group/167609 "2019-02-08T10:56:22Z")
Hi all, I'm working on a complex e-commerce application that uses Elasticsearch as its backend. We have something that works, but we're trying to optimise some of our queries. Essentially, we have "groups" of products,… --- ## [How to create Elasticsearch docker container, create indexes and seed data in one step?](https://discuss.elastic.co/t/how-to-create-elasticsearch-docker-container-create-indexes-and-seed-data-in-one-step/167561)
**Author:** [@rpm1984](https://discuss.elastic.co/u/rpm1984)\ **Replies:** 3\ **Last updated:** [February 8, 2019, 10:39am UTC](https://discuss.elastic.co/t/how-to-create-elasticsearch-docker-container-create-indexes-and-seed-data-in-one-step/167561 "2019-02-08T10:39:25Z")
Hi there! So i'm using the Elasticsearch docker image to develop locally. Works great. Now what i'd like to do as part of a docker-compose script is to: Create an instance of Elasticsearch via docker image Create ind… --- ## [Java api or docs](https://discuss.elastic.co/t/java-api-or-docs/167573)
**Author:** [@examin](https://discuss.elastic.co/u/examin)\ **Replies:** 1\ **Last updated:** [February 8, 2019, 10:38am UTC](https://discuss.elastic.co/t/java-api-or-docs/167573 "2019-02-08T10:38:33Z")
I need complete java doc or Elasticsearch java api doc . Yes is have seen Java api . But it do not list all avilable functions and their complete doc. Please tell me where i can find it --- ## [How to lock all data files into memory?](https://discuss.elastic.co/t/how-to-lock-all-data-files-into-memory/167460)
**Author:** [@John16](https://discuss.elastic.co/u/John16)\ **Replies:** 4\ **Last updated:** [February 8, 2019, 10:38am UTC](https://discuss.elastic.co/t/how-to-lock-all-data-files-into-memory/167460 "2019-02-08T10:38:22Z")
Hello, I want all index data files to be locked into RAM so queries execute fast regardless of HDD usage. I added index.store.preload: \["\*"\] bootstrap.memory\_lock: true to elasticsearch.yml. But when I execute quer… --- ## [Unable to create index and insert data?](https://discuss.elastic.co/t/unable-to-create-index-and-insert-data/166286)
**Author:** [@Abdul\_Gaffar\_Shaikh](https://discuss.elastic.co/u/Abdul_Gaffar_Shaikh)\ **Replies:** 1\ **Last updated:** [February 8, 2019, 9:18am UTC](https://discuss.elastic.co/t/unable-to-create-index-and-insert-data/166286 "2019-02-08T09:18:34Z")
hey Guys , I am trying to index data from hive into elasticsearch , however when i ran the below query , there is no error and index is not created in elasticsearch. create external table es\_names\_text (employeeid int,… --- ## [Design of data structure: one big index vs many smaller indexes](https://discuss.elastic.co/t/design-of-data-structure-one-big-index-vs-many-smaller-indexes/166131)
**Author:** [@esseti](https://discuss.elastic.co/u/esseti)\ **Replies:** 13\ **Last updated:** [February 8, 2019, 8:47am UTC](https://discuss.elastic.co/t/design-of-data-structure-one-big-index-vs-many-smaller-indexes/166131 "2019-02-08T08:47:12Z")
Hi there, we are facing a design problem in the place I work. Let's say that we have many data structures that contain documents, this data structure can be of different forms, with fields that are generated by the user… --- ## [Independant monitoring cluster](https://discuss.elastic.co/t/independant-monitoring-cluster/167444)
**Author:** [@NerdSec](https://discuss.elastic.co/u/NerdSec)\ **Replies:** 4\ **Last updated:** [February 8, 2019, 6:02am UTC](https://discuss.elastic.co/t/independant-monitoring-cluster/167444 "2019-02-08T06:02:15Z")
Unable to create a separate cluster for Monitoring the Elastic stack. I have tried configuring it via both MetricBeat as well as HTTP exporters, but I do not see the monitoring information for my production cluster. All… --- ## [\[Solved\] Create() got an unexpected keyword argument 'include\_type\_name'](https://discuss.elastic.co/t/solved-create-got-an-unexpected-keyword-argument-include-type-name/167522)
**Author:** [@cecoke](https://discuss.elastic.co/u/cecoke)\ **Replies:** 2\ **Last updated:** [February 8, 2019, 7:46am UTC](https://discuss.elastic.co/t/solved-create-got-an-unexpected-keyword-argument-include-type-name/167522 "2019-02-08T07:46:07Z")
Hi, I am getting an error when running "esrally --track http\_logs --target-hosts 172.31.13.142:9200 --pipeline benchmark-only --test-mode" Running delete-index … --- ## [Advises for index](https://discuss.elastic.co/t/advises-for-index/167134)
**Author:** [@Thibaut603](https://discuss.elastic.co/u/Thibaut603)\ **Replies:** 8\ **Last updated:** [February 8, 2019, 7:45am UTC](https://discuss.elastic.co/t/advises-for-index/167134 "2019-02-08T07:45:17Z")
Hello guys, i need advises because i'm a little bit lost i've a elk with one elasticsearch server one logstash server one kibana server 4 winlogbeat on 4 server(one per server) so i've many questions, in this c… --- ## [How can disable X-pack in V 6.5](https://discuss.elastic.co/t/how-can-disable-x-pack-in-v-6-5/167574)
**Author:** [@nuwan](https://discuss.elastic.co/u/nuwan)\ **Replies:** 1\ **Last updated:** [February 8, 2019, 5:58am UTC](https://discuss.elastic.co/t/how-can-disable-x-pack-in-v-6-5/167574 "2019-02-08T05:58:52Z")
How Can I Disable X-pack . Please help me to do this --- ## [Unable to uninstall X-pack](https://discuss.elastic.co/t/unable-to-uninstall-x-pack/167315)
**Author:** [@nuwan](https://discuss.elastic.co/u/nuwan)\ **Replies:** 4\ **Last updated:** [February 8, 2019, 5:56am UTC](https://discuss.elastic.co/t/unable-to-uninstall-x-pack/167315 "2019-02-08T05:56:31Z")
Hi Team, I have installed X-Pack in a curiosity to know how it works. Now I want to uninstall it. But I cannot uninstall. When I try uninstalling with these commands: bin/elasticsearch-plugin remove x-pack \[root@915… --- ## [Overhead, spent collecting in the last](https://discuss.elastic.co/t/overhead-spent-collecting-in-the-last/167567)
**Author:** [@Abdur\_Raqeeb2](https://discuss.elastic.co/u/Abdur_Raqeeb2)\ **Replies:** 0\ **Last updated:** [February 8, 2019, 3:30am UTC](https://discuss.elastic.co/t/overhead-spent-collecting-in-the-last/167567 "2019-02-08T03:30:58Z")
Hi, When i load the dashboard i get the below message on elasticsearch log and unable to load the dashboard.And at the same time logstash connection gets disconnect with elasticsearch Myself using 16GB instance with 8G… --- ## [Initial OL7 Configuration Issues](https://discuss.elastic.co/t/initial-ol7-configuration-issues/167503)
**Author:** [@dotcomelastic](https://discuss.elastic.co/u/dotcomelastic)\ **Replies:** 2\ **Last updated:** [February 8, 2019, 1:02am UTC](https://discuss.elastic.co/t/initial-ol7-configuration-issues/167503 "2019-02-08T01:02:03Z")
I'm trying to setup Graylog and before you install Graylog, Elasticsearch is required. The basic configuration seems to be all that is necessary but I cannot get this to start and continue to run. See errors below: Gray… --- ## [GeoHash grid aggregation error](https://discuss.elastic.co/t/geohash-grid-aggregation-error/167264)
**Author:** [@Dp24](https://discuss.elastic.co/u/Dp24)\ **Replies:** 1\ **Last updated:** [February 7, 2019, 10:52pm UTC](https://discuss.elastic.co/t/geohash-grid-aggregation-error/167264 "2019-02-07T22:52:34Z")
I want to do GeoHash grid aggregation on data avalilable in elastic search. I write the query like POST geoindex/geodata/\_search?size=0 { "aggregations" : { "large-grid" : { "geohash\_grid" : { "field" : "geometry", … --- ## [Can I use routing only for one index in multi index search?](https://discuss.elastic.co/t/can-i-use-routing-only-for-one-index-in-multi-index-search/167524)
**Author:** [@ramkishore31](https://discuss.elastic.co/u/ramkishore31)\ **Replies:** 3\ **Last updated:** [February 7, 2019, 10:52pm UTC](https://discuss.elastic.co/t/can-i-use-routing-only-for-one-index-in-multi-index-search/167524 "2019-02-07T22:52:07Z")
Hi, I have documents split up into 2 indices. Index1 has a custom routing option(with 24 shards in total) while index2 doesn't(with 8 shards in total). When I make a search request, I want to search both the indices but… --- ## [Curator s3 endpoint](https://discuss.elastic.co/t/curator-s3-endpoint/167547)
**Author:** [@Tulika\_Bhatt](https://discuss.elastic.co/u/Tulika_Bhatt)\ **Replies:** 1\ **Last updated:** [February 7, 2019, 10:35pm UTC](https://discuss.elastic.co/t/curator-s3-endpoint/167547 "2019-02-07T22:35:54Z")
Hello, I am using a non AWS s3 bucket to store my snapshots. I want to automate this process using curator but I did not find any settings for endpoint in the curator.yml. How can I achieve this? Thanks --- ## [FORBIDDEN/12/index read-only / allow delete (api)\] errors](https://discuss.elastic.co/t/forbidden-12-index-read-only-allow-delete-api-errors/167529)
**Author:** [@Roshni\_Jain](https://discuss.elastic.co/u/Roshni_Jain)\ **Replies:** 1\ **Last updated:** [February 7, 2019, 9:50pm UTC](https://discuss.elastic.co/t/forbidden-12-index-read-only-allow-delete-api-errors/167529 "2019-02-07T21:50:06Z")
\[elasticsearch-document-worker\] document updated in elasticsearch, {"index":{"\_index":"document\_search","\_type":"document","\_id":"6","status":403,"error":{"type":"cluster\_block\_exception","reason":"blocked by: \[FORBIDDEN… --- ## [How to multiply two columns and then sum the result in ElasticSQL?](https://discuss.elastic.co/t/how-to-multiply-two-columns-and-then-sum-the-result-in-elasticsql/167201)
**Author:** [@Miguel\_Plazas](https://discuss.elastic.co/u/Miguel_Plazas)\ **Replies:** 2\ **Last updated:** [February 7, 2019, 9:26pm UTC](https://discuss.elastic.co/t/how-to-multiply-two-columns-and-then-sum-the-result-in-elasticsql/167201 "2019-02-07T21:26:06Z")
Hi I would like to subtrac one value to one column, then multiply two columns, and finally sum the result: SELECT SUM(column\_a\*(column\_b-1)) AS result FROM table\_1 WHERE column\_c='G' AND column\_d='H' AND column\_b\>1.00 b… --- ## [How do I start Elasticsearch 2.0?](https://discuss.elastic.co/t/how-do-i-start-elasticsearch-2-0/167531)
**Author:** [@johnyom](https://discuss.elastic.co/u/johnyom)\ **Replies:** 1\ **Last updated:** [February 7, 2019, 9:15pm UTC](https://discuss.elastic.co/t/how-do-i-start-elasticsearch-2-0/167531 "2019-02-07T21:15:48Z")
I've followed the instructions for upgrading to 2.0 (from 1.3.9) via a full cluster restart (per these instructions: https://www.elastic.co/guide/en/elasticsearch/reference/2.0/restart-upgrade.html) but I'm having trou… --- ## [Using Curator to reindex multiple dailies into a single daily?](https://discuss.elastic.co/t/using-curator-to-reindex-multiple-dailies-into-a-single-daily/167502)
**Author:** [@rj-reilly](https://discuss.elastic.co/u/rj-reilly)\ **Replies:** 3\ **Last updated:** [February 7, 2019, 7:16pm UTC](https://discuss.elastic.co/t/using-curator-to-reindex-multiple-dailies-into-a-single-daily/167502 "2019-02-07T19:16:28Z")
Hi, I have 5 indexes created daily, on the following day I would like to combine them into a single index using curator. I am not sure on how to setup the filter to only do based on name and date for just the one day. i… --- ## [\_reindex with Validation Failed: 1: id is too long](https://discuss.elastic.co/t/reindex-with-validation-failed-1-id-is-too-long/167509)
**Author:** [@Serial](https://discuss.elastic.co/u/Serial)\ **Replies:** 0\ **Last updated:** [February 7, 2019, 6:56pm UTC](https://discuss.elastic.co/t/reindex-with-validation-failed-1-id-is-too-long/167509 "2019-02-07T18:56:51Z")
Hello, I'm using ES 5.6.14 and I'm trying to use \_reindex to migrate from v2 index to v5 index, and I have this error. {"type":"action\_request\_validation\_exception","reason":"Validation Failed: 1: id is too long, must … --- ## [Enabling Fielddata for all fields in all documents of all indices](https://discuss.elastic.co/t/enabling-fielddata-for-all-fields-in-all-documents-of-all-indices/167500)
**Author:** [@hasherbaba](https://discuss.elastic.co/u/hasherbaba)\ **Replies:** 0\ **Last updated:** [February 7, 2019, 6:12pm UTC](https://discuss.elastic.co/t/enabling-fielddata-for-all-fields-in-all-documents-of-all-indices/167500 "2019-02-07T18:12:40Z")
I have an elasticsearch query which fails when executed via Node app within a kubernetes pod. Query: "size":9999,"aggs":{"x":{"terms":{"field":"c\_5.number","size":9999,"missing":"-99"},"aggs":{"y1a":{"filter":{"bool":{… --- ## [Dynamic JSON – Can’t get text on a START\_OBJECT](https://discuss.elastic.co/t/dynamic-json-can-t-get-text-on-a-start-object/167494)
**Author:** [@brandondash](https://discuss.elastic.co/u/brandondash)\ **Replies:** 0\ **Last updated:** [February 7, 2019, 5:47pm UTC](https://discuss.elastic.co/t/dynamic-json-can-t-get-text-on-a-start-object/167494 "2019-02-07T17:47:17Z")
(Link to original post that wasn't getting responses: Dynamic JSON -- Can't get text on a START\_OBJECT) I know the error means it is expecting a string but gets an object, but I have no idea why only this field breaks. … --- ## [Preventing to send logs from /var/log/messages and /var/log/secure](https://discuss.elastic.co/t/preventing-to-send-logs-from-var-log-messages-and-var-log-secure/167473)
**Author:** [@Anonymous2](https://discuss.elastic.co/u/Anonymous2)\ **Replies:** 0\ **Last updated:** [February 7, 2019, 3:05pm UTC](https://discuss.elastic.co/t/preventing-to-send-logs-from-var-log-messages-and-var-log-secure/167473 "2019-02-07T15:05:26Z")
Hello, I have installed and configured Elasticsearch, Logstash, Filebeat and Kibana. I'm sending logs from Filebeat to Logstash and to Elasticsearch. I have deleted the /var/log/messages path in filebeat.yml file, but … --- ## [Estimating RAM requirements for new deployment](https://discuss.elastic.co/t/estimating-ram-requirements-for-new-deployment/167373)
**Author:** [@keithag](https://discuss.elastic.co/u/keithag)\ **Replies:** 4\ **Last updated:** [February 7, 2019, 2:58pm UTC](https://discuss.elastic.co/t/estimating-ram-requirements-for-new-deployment/167373 "2019-02-07T14:58:29Z")
I have a new deployment to plan and I need to estimate the hardware requirements. On my test deployment the index size is about 180 GB. I was planning on deploying on machines with 64 GB RAM and allocating 31 GB RAM fo… --- ## [Does update\_by\_query always reindex entire document](https://discuss.elastic.co/t/does-update-by-query-always-reindex-entire-document/166363)
**Author:** [@ahummel25](https://discuss.elastic.co/u/ahummel25)\ **Replies:** 8\ **Last updated:** [February 7, 2019, 2:46pm UTC](https://discuss.elastic.co/t/does-update-by-query-always-reindex-entire-document/166363 "2019-02-07T14:46:58Z")
I'm trying to figure out if the \_update\_by\_query elasticsearch endpoint reindexes entire documents. I ran a batch process that generated and ran thousands of update\_by\_query statements. My CPU escalated after some time s… --- ## [Elasticsearch backup failing](https://discuss.elastic.co/t/elasticsearch-backup-failing/167438)
**Author:** [@Sukanta\_Saha](https://discuss.elastic.co/u/Sukanta_Saha)\ **Replies:** 2\ **Last updated:** [February 7, 2019, 2:25pm UTC](https://discuss.elastic.co/t/elasticsearch-backup-failing/167438 "2019-02-07T14:25:36Z")
Our elasticsearch backup are failing with below error , In some index its saying this { "index" : "bm\_brand\_prop\_433", "index\_uuid" : "bm\_brand\_prop\_433", "shard\_id" : 0, "reason" : "RepositoryMissingException\[\[spr… --- ## [Need to connect to Elasticsearch 6.x with Graylog installed](https://discuss.elastic.co/t/need-to-connect-to-elasticsearch-6-x-with-graylog-installed/167462)
**Author:** [@Blason](https://discuss.elastic.co/u/Blason)\ **Replies:** 0\ **Last updated:** [February 7, 2019, 1:48pm UTC](https://discuss.elastic.co/t/need-to-connect-to-elasticsearch-6-x-with-graylog-installed/167462 "2019-02-07T13:48:33Z")
Hi there, I have elastic search installed and currently I am using Graylog to connect and manage indices. Can someone please confirm if Kibana can be used to manage the dashbaords? Has anyone ever succeeded implementin… --- ## [Elasticsearch/templates/configmap.yaml:51:16: executing "elasticsearch/templates/configmap.yaml" at \<.Values.appVersion\>: appVersion is not a method but has arguments](https://discuss.elastic.co/t/elasticsearch-templates-configmap-yaml16-executing-elasticsearch-templates-configmap-yaml-at-values-appversion-appversion-is-not-a-method-but-has-arguments/167458)
**Author:** [@murtaza1983](https://discuss.elastic.co/u/murtaza1983)\ **Replies:** 0\ **Last updated:** [February 7, 2019, 1:18pm UTC](https://discuss.elastic.co/t/elasticsearch-templates-configmap-yaml16-executing-elasticsearch-templates-configmap-yaml-at-values-appversion-appversion-is-not-a-method-but-has-arguments/167458 "2019-02-07T13:18:44Z")
I deployed 6.6.0 version using helm stable chart using below command:- helm install -f values.yml --name=elasticsearch --namespace=development stable/elasticsearch Then deleted the deployed chart. Cleaned up all the pe… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1400) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1402)