# \#none **URL:** https://discuss.elastic.co/tag/none.md?page=1427 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1428 --- ## [How to do subqueries in Elastic search](https://discuss.elastic.co/t/how-to-do-subqueries-in-elastic-search/234311)
**Author:** [@Asha\_Lodhi](https://discuss.elastic.co/u/Asha_Lodhi)\ **Replies:** 0\ **Last updated:** [May 26, 2020, 10:46am UTC](https://discuss.elastic.co/t/how-to-do-subqueries-in-elastic-search/234311 "2020-05-26T10:46:09Z")
Hi, I have a sql query which has subquery, can any one help me how this could be done in Elastic search 5 and above. \> select sum(a.netamt) , \> (select sum(total\_amount) \> from ( \> select dis… --- ## [How to join 2 index using 2 common values](https://discuss.elastic.co/t/how-to-join-2-index-using-2-common-values/234248)
**Author:** [@aannee](https://discuss.elastic.co/u/aannee)\ **Replies:** 3\ **Last updated:** [May 26, 2020, 10:19am UTC](https://discuss.elastic.co/t/how-to-join-2-index-using-2-common-values/234248 "2020-05-26T10:19:55Z")
Hi, is it possible to join 2 index in elasticsearch? Maybe using query. Or I'm thinking if I could do a logstash pipeline that will query the two index and join them inside the pipeline. First time to face a request lik… --- ## [FSCrawler - windows - path does not exist](https://discuss.elastic.co/t/fscrawler-windows-path-does-not-exist/234230)
**Author:** [@Lisahtwy](https://discuss.elastic.co/u/Lisahtwy)\ **Replies:** 2\ **Last updated:** [May 26, 2020, 10:14am UTC](https://discuss.elastic.co/t/fscrawler-windows-path-does-not-exist/234230 "2020-05-26T10:14:26Z")
Hi, I am trying to index files from remote windows server using fsCrawler. I gave the path in \_settings file as c:\\\\ESFiles and c:/ESFiles. but below error is coming in logs. 03:12:56,586 INFO \[f.p.e.c.f.c.BootstrapCh… --- ## [Cannot Connect Elasticsearch in Docker](https://discuss.elastic.co/t/cannot-connect-elasticsearch-in-docker/233687)
**Author:** [@Vaibhav\_Saxena](https://discuss.elastic.co/u/Vaibhav_Saxena)\ **Replies:** 3\ **Last updated:** [May 26, 2020, 9:38am UTC](https://discuss.elastic.co/t/cannot-connect-elasticsearch-in-docker/233687 "2020-05-26T09:38:35Z")
I am trying to launch my app using docker that connects to elasticsearch but I am not able to do so. I get the following exception: vaibhavsaxena@Vaibhavs-MacBook-Pro Final Project % docker-compose up … --- ## [java.lang.OutOfMemoryError: Java heap space error in logstash conf file](https://discuss.elastic.co/t/java-lang-outofmemoryerror-java-heap-space-error-in-logstash-conf-file/233985)
**Author:** [@avneshkumar98](https://discuss.elastic.co/u/avneshkumar98)\ **Replies:** 2\ **Last updated:** [May 26, 2020, 9:35am UTC](https://discuss.elastic.co/t/java-lang-outofmemoryerror-java-heap-space-error-in-logstash-conf-file/233985 "2020-05-26T09:35:49Z")
hey, I'm facing this issue while importing logs in kibana using conf file. \[2020-05-23T13:55:37,084\]\[ERROR\]\[org.logstash.Logstash \] java.lang.OutOfMemoryError: Java heap space and my conf file : input { file{ pat… --- ## [Request Timeout sur toutes les requêtes avec Kibana](https://discuss.elastic.co/t/request-timeout-sur-toutes-les-requetes-avec-kibana/234282)
**Author:** [@jtachon](https://discuss.elastic.co/u/jtachon)\ **Replies:** 2\ **Last updated:** [May 26, 2020, 9:23am UTC](https://discuss.elastic.co/t/request-timeout-sur-toutes-les-requetes-avec-kibana/234282 "2020-05-26T09:23:56Z")
Bonjour, Je débute avec l'Elastic Stack et je viens de faire ma première installation : 3 data/master-eligible node avec 16Go de RAM (8Go pour la heap), 900Go de disque, 4CPU. 1 serveur avec Kibana + Grafana : 4Go de … --- ## [Error and Warning messages](https://discuss.elastic.co/t/error-and-warning-messages/232668)
**Author:** [@meneses.pt](https://discuss.elastic.co/u/meneses.pt)\ **Replies:** 2\ **Last updated:** [May 26, 2020, 9:10am UTC](https://discuss.elastic.co/t/error-and-warning-messages/232668 "2020-05-26T09:10:33Z")
Is it possible to disable error/warning messages in kibana dashboards, or to somehow give a more generic error message? I'm getting an error/warning "1 of 48 shards failed" and I was wondering if there is a way to make … --- ## [Logstash - pagerduty plugin \[severity level\]](https://discuss.elastic.co/t/logstash-pagerduty-plugin-severity-level/234284)
**Author:** [@Donatas\_Racys](https://discuss.elastic.co/u/Donatas_Racys)\ **Replies:** 0\ **Last updated:** [May 26, 2020, 9:09am UTC](https://discuss.elastic.co/t/logstash-pagerduty-plugin-severity-level/234284 "2020-05-26T09:09:20Z")
Hi, I have a use case with Logstash - Pagerduty plugin - we want to send different level alerts to Pagerduty, but severity parameter is missing. Is there a way to add severity parameter to Pagerduty plugin ? Severity - … --- ## [How to get list as term value in params for custom script plugin](https://discuss.elastic.co/t/how-to-get-list-as-term-value-in-params-for-custom-script-plugin/234279)
**Author:** [@Dahea\_Moon](https://discuss.elastic.co/u/Dahea_Moon)\ **Replies:** 0\ **Last updated:** [May 26, 2020, 8:30am UTC](https://discuss.elastic.co/t/how-to-get-list-as-term-value-in-params-for-custom-script-plugin/234279 "2020-05-26T08:30:20Z")
I'm making custom score script plugin for scoring based on payload value. I've done with scoring logic, but it's working properly when it receives only one term. I want to receive several analyzed terms in query. How c… --- ## [Send the same data to two outputs elasticsearch](https://discuss.elastic.co/t/send-the-same-data-to-two-outputs-elasticsearch/234274)
**Author:** [@am95](https://discuss.elastic.co/u/am95)\ **Replies:** 0\ **Last updated:** [May 26, 2020, 8:17am UTC](https://discuss.elastic.co/t/send-the-same-data-to-two-outputs-elasticsearch/234274 "2020-05-26T08:17:45Z")
Hi, I wanna send the same data from one logstash to two elasticsearch nodes ans i don't knwo how te set the pipeline, any help please ? i've set in the logstash output this : output { elasticsearch { hosts =\> \["node… --- ## [Add host name field](https://discuss.elastic.co/t/add-host-name-field/234044)
**Author:** [@ahiyaz](https://discuss.elastic.co/u/ahiyaz)\ **Replies:** 4\ **Last updated:** [May 26, 2020, 8:12am UTC](https://discuss.elastic.co/t/add-host-name-field/234044 "2020-05-26T08:12:46Z")
hi im shipping sflow data to Logz.io using logstash. due to multi-sites architecture im trying to add hostname (agent hostname) filed to my data that sent from my logstash but with no success. ive tried to add it to d… --- ## [Scaling logstash with s3 output doesnt work](https://discuss.elastic.co/t/scaling-logstash-with-s3-output-doesnt-work/234164)
**Author:** [@mctj](https://discuss.elastic.co/u/mctj)\ **Replies:** 5\ **Last updated:** [May 25, 2020, 6:39pm UTC](https://discuss.elastic.co/t/scaling-logstash-with-s3-output-doesnt-work/234164 "2020-05-25T18:39:03Z")
Hey all, I have multiple machines in my environment (lets say 100). On each of those machines I configured filebeat and metricbeat to send data to Kafka. Each machine has 2 dedicated topics in kafka(one for metricbe… --- ## [Append object to nested field but get overwritten](https://discuss.elastic.co/t/append-object-to-nested-field-but-get-overwritten/234268)
**Author:** [@Arnovdlaan](https://discuss.elastic.co/u/Arnovdlaan)\ **Replies:** 0\ **Last updated:** [May 26, 2020, 8:05am UTC](https://discuss.elastic.co/t/append-object-to-nested-field-but-get-overwritten/234268 "2020-05-26T08:05:47Z")
Hello, We've got a problem with a logstash JDBC configuration. We have a large tabel (~ 15 million records) which we want to insert into our elasticsearch. A source (MySQL) record has a domain column which is used as t… --- ## [Help writing a custom plugin to allow only GET requests](https://discuss.elastic.co/t/help-writing-a-custom-plugin-to-allow-only-get-requests/234266)
**Author:** [@rahulkarajgikar](https://discuss.elastic.co/u/rahulkarajgikar)\ **Replies:** 0\ **Last updated:** [May 26, 2020, 8:03am UTC](https://discuss.elastic.co/t/help-writing-a-custom-plugin-to-allow-only-get-requests/234266 "2020-05-26T08:03:15Z")
Hi, I'm trying to write an action plugin that will intercept REST requests using the getRestHandlerWrapper()method in the ActionPlugin class. However, it says that only one plugin can implement this method. How do I remo… --- ## [Агрегация по нескольким дочерним полям](https://discuss.elastic.co/t/topic/233680)
**Author:** [@Silicid](https://discuss.elastic.co/u/Silicid)\ **Replies:** 7\ **Last updated:** [May 26, 2020, 8:02am UTC](https://discuss.elastic.co/t/topic/233680 "2020-05-26T08:02:02Z")
Добрый день. Есть элементы с двумя дочерними элементами (тип join). Необходимо сделать агрегацию по минимальному значению child\_value для answer2. И, если answer2 отсутствует для родителя, то вместо него использовать a… --- ## [Sync Elasticsearch with MySQL Database](https://discuss.elastic.co/t/sync-elasticsearch-with-mysql-database/234032)
**Author:** [@Punj\_Shah](https://discuss.elastic.co/u/Punj_Shah)\ **Replies:** 14\ **Last updated:** [May 26, 2020, 7:54am UTC](https://discuss.elastic.co/t/sync-elasticsearch-with-mysql-database/234032 "2020-05-26T07:54:33Z")
Hello! As per our application requirement, we need to sync Elasticsearch with MySQL. We will apply the best optimal way according to your advice. Below is the DB EER Diagram just for the reference Now we need to app… --- ## [Why translog phase in recovery took a long time](https://discuss.elastic.co/t/why-translog-phase-in-recovery-took-a-long-time/234260)
**Author:** [@yc1024](https://discuss.elastic.co/u/yc1024)\ **Replies:** 0\ **Last updated:** [May 26, 2020, 7:47am UTC](https://discuss.elastic.co/t/why-translog-phase-in-recovery-took-a-long-time/234260 "2020-05-26T07:47:56Z")
Elasticsearch-version：7.6.0 Translog stage recovered is 0, but it took 5min.What settings can optimize it? my settings: indices.recovery.max\_concurrent\_file\_chunks : 5 indices.recovery.max\_bytes\_per\_sec : 50MB cluster… --- ## [How can i create secure websocket WSS client connection in logstash 7.4?](https://discuss.elastic.co/t/how-can-i-create-secure-websocket-wss-client-connection-in-logstash-7-4/234242)
**Author:** [@talbehat](https://discuss.elastic.co/u/talbehat)\ **Replies:** 1\ **Last updated:** [May 26, 2020, 7:47am UTC](https://discuss.elastic.co/t/how-can-i-create-secure-websocket-wss-client-connection-in-logstash-7-4/234242 "2020-05-26T07:47:41Z")
is there any way to use wss client in logstash? --- ## [Dissect Processor not working correctly in elastic search](https://discuss.elastic.co/t/dissect-processor-not-working-correctly-in-elastic-search/233738)
**Author:** [@saket\_gupta](https://discuss.elastic.co/u/saket_gupta)\ **Replies:** 8\ **Last updated:** [May 26, 2020, 7:20am UTC](https://discuss.elastic.co/t/dissect-processor-not-working-correctly-in-elastic-search/233738 "2020-05-26T07:20:29Z")
Hi Team, I am trying to parse logs using dissect processor in elastic search . However I dont get the appropriate output. When I run the log through logstash using dissect filter, it works fine. \` PUT \_ingest/pipeline… --- ## [Deploy ECK using private docker registry](https://discuss.elastic.co/t/deploy-eck-using-private-docker-registry/234246)
**Author:** [@kodo65](https://discuss.elastic.co/u/kodo65)\ **Replies:** 4\ **Last updated:** [May 26, 2020, 7:18am UTC](https://discuss.elastic.co/t/deploy-eck-using-private-docker-registry/234246 "2020-05-26T07:18:28Z")
Hi! We rely on a software supply chain in order to gain access to external components. My question is what I need to do in order to prepare ECK to pull the necessary image(s) from our private registry instead of docker.… --- ## [Mutliple file input not processed (or may be erased in elasticsearch)](https://discuss.elastic.co/t/mutliple-file-input-not-processed-or-may-be-erased-in-elasticsearch/234147)
**Author:** [@pmo](https://discuss.elastic.co/u/pmo)\ **Replies:** 2\ **Last updated:** [May 26, 2020, 7:18am UTC](https://discuss.elastic.co/t/mutliple-file-input-not-processed-or-may-be-erased-in-elasticsearch/234147 "2020-05-26T07:18:17Z")
Hi, I' ve to treat many json files. When I try to import file by file via logstash by putting the name of each file, it works. But when I use "\*", it seams that only 1 file is treated. Or may be there all but only the l… --- ## [Join two index using input elasticsearch/exec plugin in logstash](https://discuss.elastic.co/t/join-two-index-using-input-elasticsearch-exec-plugin-in-logstash/234256)
**Author:** [@aannee](https://discuss.elastic.co/u/aannee)\ **Replies:** 0\ **Last updated:** [May 26, 2020, 7:17am UTC](https://discuss.elastic.co/t/join-two-index-using-input-elasticsearch-exec-plugin-in-logstash/234256 "2020-05-26T07:17:35Z")
Hi, It's my first time facing request like this so I'm thinking if is it possible to join 2 elasticsearch index using logstash? Because I think its not possible to have a join query in elasticsearch. --- ## [How can I visualize each bucket data in one json file?](https://discuss.elastic.co/t/how-can-i-visualize-each-bucket-data-in-one-json-file/234255)
**Author:** [@111252](https://discuss.elastic.co/u/111252)\ **Replies:** 0\ **Last updated:** [May 26, 2020, 6:58am UTC](https://discuss.elastic.co/t/how-can-i-visualize-each-bucket-data-in-one-json-file/234255 "2020-05-26T06:58:55Z")
Hello, I am Youngmin. I have 100,000,000 data in my elasticsearch. Because of the large data, there are too many time visualizing the count data in Time Graph. So, I push the aggregation data in my elasticsearch. It … --- ## [Follow-up question to "Set relative time with timestamp"](https://discuss.elastic.co/t/follow-up-question-to-set-relative-time-with-timestamp/232944)
**Author:** [@jenw](https://discuss.elastic.co/u/jenw)\ **Replies:** 5\ **Last updated:** [May 26, 2020, 6:57am UTC](https://discuss.elastic.co/t/follow-up-question-to-set-relative-time-with-timestamp/232944 "2020-05-26T06:57:08Z")
I have exactly the same problem as this user specified in this post: He provided a solution, but it is not clear to me how to specify the Language, Type and format to make the script work. I assume that the Languag… --- ## [Need Architectural Support](https://discuss.elastic.co/t/need-architectural-support/234240)
**Author:** [@Rohit\_Kumbhar](https://discuss.elastic.co/u/Rohit_Kumbhar)\ **Replies:** 5\ **Last updated:** [May 26, 2020, 6:36am UTC](https://discuss.elastic.co/t/need-architectural-support/234240 "2020-05-26T06:36:47Z")
Hey, I need some support regarding Architecture for MY Elasticsearch setup I will be having logs from 120+ devices through UDP port and i have to parse them I would like your help for Hardware Configuration for my Ela… --- ## [SSL Connection Error with SQL Database](https://discuss.elastic.co/t/ssl-connection-error-with-sql-database/234253)
**Author:** [@vikramnr](https://discuss.elastic.co/u/vikramnr)\ **Replies:** 0\ **Last updated:** [May 26, 2020, 6:51am UTC](https://discuss.elastic.co/t/ssl-connection-error-with-sql-database/234253 "2020-05-26T06:51:06Z")
I just want to run logstash with using JDBC plugin but I'm unable to connect to the server. Below is error that I receive. I tried some ways suggested in github but my problem isn't being solved. Please let me know if … --- ## [Create a field based on the values from future log](https://discuss.elastic.co/t/create-a-field-based-on-the-values-from-future-log/234093)
**Author:** [@iammanmale](https://discuss.elastic.co/u/iammanmale)\ **Replies:** 16\ **Last updated:** [May 26, 2020, 6:49am UTC](https://discuss.elastic.co/t/create-a-field-based-on-the-values-from-future-log/234093 "2020-05-26T06:49:51Z")
My use case is like this: I have to create a data table from an index. The value of one of the column of the table is based on the data from another field of the same index in the next 5 seconds. Is it possible to do s… --- ## [Limit results per page per field](https://discuss.elastic.co/t/limit-results-per-page-per-field/234249)
**Author:** [@Adnan\_Khabbaz](https://discuss.elastic.co/u/Adnan_Khabbaz)\ **Replies:** 0\ **Last updated:** [May 26, 2020, 6:34am UTC](https://discuss.elastic.co/t/limit-results-per-page-per-field/234249 "2020-05-26T06:34:28Z")
Hello I have a case when I need to get only one or two documents per page that have the same field value I can use collapse for that but the problem I don't want to ignore other documents in the next pages, So suppose… --- ## [Dashboard Empty](https://discuss.elastic.co/t/dashboard-empty/233519)
**Author:** [@InfiniteLoops](https://discuss.elastic.co/u/InfiniteLoops)\ **Replies:** 1\ **Last updated:** [May 26, 2020, 6:32am UTC](https://discuss.elastic.co/t/dashboard-empty/233519 "2020-05-26T06:32:43Z")
Hi I can see my Dashboards and Visualizations in the management tab under saved objects. In Visualization tabs I can see all of them but when I click on the Dashboard tab it is showing nothing. I think they disappeared… --- ## [\[logstash.outputs.elasticsearch\] Could not index event to Elasticsearch](https://discuss.elastic.co/t/logstash-outputs-elasticsearch-could-not-index-event-to-elasticsearch/234241)
**Author:** [@Raj\_Techie](https://discuss.elastic.co/u/Raj_Techie)\ **Replies:** 7\ **Last updated:** [May 26, 2020, 6:16am UTC](https://discuss.elastic.co/t/logstash-outputs-elasticsearch-could-not-index-event-to-elasticsearch/234241 "2020-05-26T06:16:46Z")
Logstash version I am using -logstash 6.0.1 Elasticsearch version below are there in my system. /appserver/elk4pq/elasticsearch-2.3.2/config/elasticsearch.yml /data/software/elk/elasticsearch-2.4.5/config/elasticsearc… [Previous page](https://discuss.elastic.co/tag/none.md?no_tags=true&page=1426) [Next page](https://discuss.elastic.co/tag/none.md?no_tags=true&page=1428)