# \#none **URL:** https://discuss.elastic.co/tag/none.md?page=1429 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1430 --- ## [Disabling date detection from Java API](https://discuss.elastic.co/t/disabling-date-detection-from-java-api/234180)
**Author:** [@dwaipayan](https://discuss.elastic.co/u/dwaipayan)\ **Replies:** 0\ **Last updated:** [May 25, 2020, 4:13pm UTC](https://discuss.elastic.co/t/disabling-date-detection-from-java-api/234180 "2020-05-25T16:13:52Z")
Hi, I am trying to index a large JSON file in Elasticsearch but, some malformed date variables (containing '\\n' inside date) is causing exception. I already came across this: https://www.elastic.co/guide/en/elasticsearc… --- ## [Elasticsearch tests not running againts system installed java jdk](https://discuss.elastic.co/t/elasticsearch-tests-not-running-againts-system-installed-java-jdk/231571)
**Author:** [@adpopescu-ibm](https://discuss.elastic.co/u/adpopescu-ibm)\ **Replies:** 1\ **Last updated:** [May 25, 2020, 3:40pm UTC](https://discuss.elastic.co/t/elasticsearch-tests-not-running-againts-system-installed-java-jdk/231571 "2020-05-25T15:40:18Z")
Hi, I was running the tests with: ./gradlew --continue test My environment variables are: JAVA\_HOME=/usr/local/jdk-13.0.2+8/ JAVA13\_HOME=/usr/local/jdk-13.0.2+8/ RUNTIME\_JAVA\_HOME is not set. I noticed that only whi… --- ## [How to extract a message JSON value using JSON Input under Kibana Visualization](https://discuss.elastic.co/t/how-to-extract-a-message-json-value-using-json-input-under-kibana-visualization/233690)
**Author:** [@Sameer\_Panicker](https://discuss.elastic.co/u/Sameer_Panicker)\ **Replies:** 3\ **Last updated:** [May 25, 2020, 3:36pm UTC](https://discuss.elastic.co/t/how-to-extract-a-message-json-value-using-json-input-under-kibana-visualization/233690 "2020-05-25T15:36:34Z")
Below is the message that is captured in my logs and, as of no values/fields are getting extracted. {"browser":"Edge","id":766415199,"status":"SessionCreated"} Can I use JSON Input under Kibana visualization to extract… --- ## [Is localhost self-signed certificate eligible to make trust connection to external OIDC identity provider?](https://discuss.elastic.co/t/is-localhost-self-signed-certificate-eligible-to-make-trust-connection-to-external-oidc-identity-provider/230998)
**Author:** [@KTH](https://discuss.elastic.co/u/KTH)\ **Replies:** 3\ **Last updated:** [May 25, 2020, 2:55pm UTC](https://discuss.elastic.co/t/is-localhost-self-signed-certificate-eligible-to-make-trust-connection-to-external-oidc-identity-provider/230998 "2020-05-25T14:55:13Z")
Hi, I managed to make localhost Kibana to be functioned in https environment.(The warning stated that it is not trusted). However my localhost elasticsearch node is still in http environment. The elasticsearch console … --- ## [Queries from visualize from selected fields don't appear to work](https://discuss.elastic.co/t/queries-from-visualize-from-selected-fields-dont-appear-to-work/231367)
**Author:** [@slmingol](https://discuss.elastic.co/u/slmingol)\ **Replies:** 3\ **Last updated:** [May 25, 2020, 2:51pm UTC](https://discuss.elastic.co/t/queries-from-visualize-from-selected-fields-dont-appear-to-work/231367 "2020-05-25T14:51:43Z")
Whenever I add selected fields from a discovery query and then attempt to visualize them they work fine. If I try to use the search box to refine these none of these queries appear to work properly. --- ## [Help with grok pattern Logstash](https://discuss.elastic.co/t/help-with-grok-pattern-logstash/234106)
**Author:** [@Amish](https://discuss.elastic.co/u/Amish)\ **Replies:** 2\ **Last updated:** [May 25, 2020, 2:27pm UTC](https://discuss.elastic.co/t/help-with-grok-pattern-logstash/234106 "2020-05-25T14:27:16Z")
I need help with creating a grok pattern to match the following data and create them as new fields. I have attempted to use the Grok debugger online and it matches my custom patterns but when I apply this in Logstash it … --- ## [SQL Query convert to ES query](https://discuss.elastic.co/t/sql-query-convert-to-es-query/231507)
**Author:** [@Ramesh\_balasubramani](https://discuss.elastic.co/u/Ramesh_balasubramani)\ **Replies:** 4\ **Last updated:** [May 25, 2020, 2:15pm UTC](https://discuss.elastic.co/t/sql-query-convert-to-es-query/231507 "2020-05-25T14:15:50Z")
Hi Guys, (message == "Accpted" OR message == "Password) OR (Hostname == "SSDESK-003) AND (( src\_ip != 10.100.7.102) AND (engine\_log\_id == "7")) How to convert above query to ES Query? Any quick help would be appreciat… --- ## [How to achieve sum(distinct(columnName)) in Elastic search with out using terms and cardinality in aggregation](https://discuss.elastic.co/t/how-to-achieve-sum-distinct-columnname-in-elastic-search-with-out-using-terms-and-cardinality-in-aggregation/233979)
**Author:** [@Asha\_Lodhi](https://discuss.elastic.co/u/Asha_Lodhi)\ **Replies:** 0\ **Last updated:** [May 23, 2020, 7:21am UTC](https://discuss.elastic.co/t/how-to-achieve-sum-distinct-columnname-in-elastic-search-with-out-using-terms-and-cardinality-in-aggregation/233979 "2020-05-23T07:21:32Z")
Suppose this is the record set in sql. number net amt total amount 229W0330014229 0.69 11.07 229W0330014229 0.05 11.07 21380365288472 26.25 44.02 21380365288472 1.2 44.02 64950353437733 19.95 57.39 649… --- ## [Adding Datasource from 3rd Party Applications](https://discuss.elastic.co/t/adding-datasource-from-3rd-party-applications/233714)
**Author:** [@Chad](https://discuss.elastic.co/u/Chad)\ **Replies:** 4\ **Last updated:** [May 25, 2020, 1:33pm UTC](https://discuss.elastic.co/t/adding-datasource-from-3rd-party-applications/233714 "2020-05-25T13:33:16Z")
Hi, i'm new in ELK, and i'm looking to get logs from my AD AuditPlus tool ( screenshot attached). How to do I go about it from setting it up , up to creation of dashboard. --- ## [Kibana 7.7.0 docker keeps crashing](https://discuss.elastic.co/t/kibana-7-7-0-docker-keeps-crashing/233973)
**Author:** [@tenet\_testuser1](https://discuss.elastic.co/u/tenet_testuser1)\ **Replies:** 4\ **Last updated:** [May 25, 2020, 1:21pm UTC](https://discuss.elastic.co/t/kibana-7-7-0-docker-keeps-crashing/233973 "2020-05-25T13:21:32Z")
Can someone please provide insights as to how to get it running? Elastic search docker is stable however. This is the 7.7.0 release which is constantly updated. I tried downloading a few times past 3 days. No success. … --- ## [Tif files in fscrawler](https://discuss.elastic.co/t/tif-files-in-fscrawler/231880)
**Author:** [@avishai.d](https://discuss.elastic.co/u/avishai.d)\ **Replies:** 24\ **Last updated:** [May 25, 2020, 1:11pm UTC](https://discuss.elastic.co/t/tif-files-in-fscrawler/231880 "2020-05-25T13:11:24Z")
Hello, I'm trying to index a tif file using fscrawler and don't get any contet while PDF works fine. Please assist --- ## [Requête terms limite de critères](https://discuss.elastic.co/t/requete-terms-limite-de-criteres/234107)
**Author:** [@lfourny](https://discuss.elastic.co/u/lfourny)\ **Replies:** 1\ **Last updated:** [May 25, 2020, 12:57pm UTC](https://discuss.elastic.co/t/requete-terms-limite-de-criteres/234107 "2020-05-25T12:57:47Z")
Bonjour à tous, Dans une appli web j'execute une requête "terms" pour récupérer une liste d'infos. GET /alerts/\_search { "query": { "terms": { "serial\_num.keyword":\[ "AABU123", "AABZ004", "ABCH009",… --- ## [Kibana crashes](https://discuss.elastic.co/t/kibana-crashes/234082)
**Author:** [@parthmaniar](https://discuss.elastic.co/u/parthmaniar)\ **Replies:** 1\ **Last updated:** [May 25, 2020, 12:54pm UTC](https://discuss.elastic.co/t/kibana-crashes/234082 "2020-05-25T12:54:16Z")
Hi I am running Kibana on a separate system over the network which connects to elasticearch. Architecture is attached. This usually occurs when there is I carry out a large search. Here is the error, I get. log \[05… --- ## [Dashboards/visualizations path](https://discuss.elastic.co/t/dashboards-visualizations-path/233783)
**Author:** [@ManuelF](https://discuss.elastic.co/u/ManuelF)\ **Replies:** 1\ **Last updated:** [May 25, 2020, 9:57am UTC](https://discuss.elastic.co/t/dashboards-visualizations-path/233783 "2020-05-25T09:57:22Z")
Hi, \*Running ELK 6.8.8. on premises I am looking for the path where Kibana stores my own visualizations and dashboards in the system files. My intention is to sync the folder(s) to a network location using a backup sol… --- ## [Deleting unassigned shard replicas](https://discuss.elastic.co/t/deleting-unassigned-shard-replicas/233896)
**Author:** [@olivierwa](https://discuss.elastic.co/u/olivierwa)\ **Replies:** 4\ **Last updated:** [May 25, 2020, 11:37am UTC](https://discuss.elastic.co/t/deleting-unassigned-shard-replicas/233896 "2020-05-25T11:37:46Z")
I have a 3 node cluster (i2a, i2b and i2c) with a replica factor of 2 (1 primary, 2 copies). We noticed the cluster became yellow, as we have UNASSIGNED shards. Reason is that a copy of the share already exists. When we… --- ## [How to remove multiple head lines in CSV with logstash configuration file](https://discuss.elastic.co/t/how-to-remove-multiple-head-lines-in-csv-with-logstash-configuration-file/233849)
**Author:** [@Ryan4](https://discuss.elastic.co/u/Ryan4)\ **Replies:** 1\ **Last updated:** [May 25, 2020, 11:32am UTC](https://discuss.elastic.co/t/how-to-remove-multiple-head-lines-in-csv-with-logstash-configuration-file/233849 "2020-05-25T11:32:55Z")
Hello All, I need handle CSV files from Windows File Resource manage. The file has multiple head lines that need to remove. How can I do it with setting logstash configuration file. The following is a sample. "Large F… --- ## [Rename variable field in json file using logstash](https://discuss.elastic.co/t/rename-variable-field-in-json-file-using-logstash/234003)
**Author:** [@Kush\_Wadhwa](https://discuss.elastic.co/u/Kush_Wadhwa)\ **Replies:** 1\ **Last updated:** [May 25, 2020, 11:27am UTC](https://discuss.elastic.co/t/rename-variable-field-in-json-file-using-logstash/234003 "2020-05-25T11:27:48Z")
Hi, I have a jason file which has event0,event1, event2......event50000. I would like to rename all of it to event in Logstash so that the field name is event and corresponding value of event0, event 1 are stored under … --- ## [Logstash crashes after some time](https://discuss.elastic.co/t/logstash-crashes-after-some-time/231958)
**Author:** [@kagashe](https://discuss.elastic.co/u/kagashe)\ **Replies:** 2\ **Last updated:** [May 25, 2020, 11:19am UTC](https://discuss.elastic.co/t/logstash-crashes-after-some-time/231958 "2020-05-25T11:19:59Z")
Hi all, I seem to have a problem with my logstash but but not sure what's causing it. I have 2 Elasticsearch machines in my cluster, one data and one client/master. Initially I had one logstash instance running on the c… --- ## [Kibana : Filter doc values in only one aggreation in data table](https://discuss.elastic.co/t/kibana-filter-doc-values-in-only-one-aggreation-in-data-table/234118)
**Author:** [@elisavet](https://discuss.elastic.co/u/elisavet)\ **Replies:** 1\ **Last updated:** [May 25, 2020, 11:04am UTC](https://discuss.elastic.co/t/kibana-filter-doc-values-in-only-one-aggreation-in-data-table/234118 "2020-05-25T11:04:50Z")
Hi! I want to create a data table that has 2 aggregations, but the first aggregation must filter all documents that have "unbillable:true", while the second aggregation doesn't have any filter. I thought that by addin… --- ## [Elastic engineer I and II training in India](https://discuss.elastic.co/t/elastic-engineer-i-and-ii-training-in-india/233934)
**Author:** [@adityaPsl](https://discuss.elastic.co/u/adityaPsl)\ **Replies:** 4\ **Last updated:** [May 25, 2020, 9:44am UTC](https://discuss.elastic.co/t/elastic-engineer-i-and-ii-training-in-india/233934 "2020-05-25T09:44:50Z")
Hello Team, Is Elastic engineer I and II training available in India or IST zone. Thank You, Aditya --- ## [Search query for a contents in the file](https://discuss.elastic.co/t/search-query-for-a-contents-in-the-file/234110)
**Author:** [@Anirudhan](https://discuss.elastic.co/u/Anirudhan)\ **Replies:** 1\ **Last updated:** [May 25, 2020, 9:43am UTC](https://discuss.elastic.co/t/search-query-for-a-contents-in-the-file/234110 "2020-05-25T09:43:48Z")
I indexing the contents of PDF files using FSCrawler.Now the content of the whole PDF file is stored in the content key in elastic. Below is a sample record. { "content": "\\n\\n\\n WHY TRAVEL INSURANCE?\\n\\… --- ## [Export kibana report to outer world!](https://discuss.elastic.co/t/export-kibana-report-to-outer-world/232918)
**Author:** [@inandi](https://discuss.elastic.co/u/inandi)\ **Replies:** 2\ **Last updated:** [May 25, 2020, 9:41am UTC](https://discuss.elastic.co/t/export-kibana-report-to-outer-world/232918 "2020-05-25T09:41:58Z")
what I am trying to do here is to export one particular graph to my project. my Kibana-dashboard: I just want to add "\[Logs\] File Type Scatter Plot" box to my project (PHP). my sample mock-up is like this I am ho… --- ## [Changing styling of breadcrumb in Header](https://discuss.elastic.co/t/changing-styling-of-breadcrumb-in-header/233670)
**Author:** [@ravi\_yadav2](https://discuss.elastic.co/u/ravi_yadav2)\ **Replies:** 1\ **Last updated:** [May 25, 2020, 9:30am UTC](https://discuss.elastic.co/t/changing-styling-of-breadcrumb-in-header/233670 "2020-05-25T09:30:02Z")
Hi Team, Please help me to change styling of header breadcrumb. Screenshot attached. I want to apply custom style to breadcrumb text --- ## [Getting nested values in Multi Indices approach](https://discuss.elastic.co/t/getting-nested-values-in-multi-indices-approach/234116)
**Author:** [@Muna](https://discuss.elastic.co/u/Muna)\ **Replies:** 0\ **Last updated:** [May 25, 2020, 9:24am UTC](https://discuss.elastic.co/t/getting-nested-values-in-multi-indices-approach/234116 "2020-05-25T09:24:02Z")
Hi, i am trying to get the nested value in multi indices approach. used below query but didn't help. please advise. GET \_all,/\_search { "query": { "bool": { "should": \[ { "nested": { "path": "\_index.student\_obj… --- ## [Cisco Umbrella Ingest](https://discuss.elastic.co/t/cisco-umbrella-ingest/234068)
**Author:** [@jasonmull](https://discuss.elastic.co/u/jasonmull)\ **Replies:** 1\ **Last updated:** [May 25, 2020, 9:23am UTC](https://discuss.elastic.co/t/cisco-umbrella-ingest/234068 "2020-05-25T09:23:57Z")
Hello, I'm trying to integrate multi-tenant Cisco Umbrella DNS logs into Elastic SIEM and I'm running into a few issues. These logs are located in an AWS S3 bucket. Individual log files are generated as csv and gzippe… --- ## [Sync mongodb and elastic using logstash](https://discuss.elastic.co/t/sync-mongodb-and-elastic-using-logstash/234075)
**Author:** [@farshid](https://discuss.elastic.co/u/farshid)\ **Replies:** 2\ **Last updated:** [May 25, 2020, 9:17am UTC](https://discuss.elastic.co/t/sync-mongodb-and-elastic-using-logstash/234075 "2020-05-25T09:17:33Z")
I have same problem with logstash issue https://discuss.elastic.co/t/sync-mongodb-data-to-elasticsearch-update-if-exists-or-insert-using-logstash/206897/2 https://discuss.elastic.co/t/sync-mongodb-data-to-elasticsearc… --- ## [How to sort the indices through it's property in multi Indices approach](https://discuss.elastic.co/t/how-to-sort-the-indices-through-its-property-in-multi-indices-approach/234113)
**Author:** [@Muna](https://discuss.elastic.co/u/Muna)\ **Replies:** 0\ **Last updated:** [May 25, 2020, 9:20am UTC](https://discuss.elastic.co/t/how-to-sort-the-indices-through-its-property-in-multi-indices-approach/234113 "2020-05-25T09:20:39Z")
Hi, below is my query multi Indices approach. here i want to sort the 'abc\_class' by it's "classId" . tried applying sort at the beginning it's not working. please advise. GET \_all/\_search { "query": { "bool": { "… --- ## [Filter buckets after top\_hits aggregation](https://discuss.elastic.co/t/filter-buckets-after-top-hits-aggregation/231913)
**Author:** [@ajonat](https://discuss.elastic.co/u/ajonat)\ **Replies:** 11\ **Last updated:** [May 25, 2020, 9:12am UTC](https://discuss.elastic.co/t/filter-buckets-after-top-hits-aggregation/231913 "2020-05-25T09:12:17Z")
Hi, I have an index with documents that only have 3 fields: id, timestamp and status. I want to retrieve the newest document for each id, but: if that document's status is equals to "something", then I would like to ig… --- ## [Reindex gets stuck](https://discuss.elastic.co/t/reindex-gets-stuck/234108)
**Author:** [@nayestaran](https://discuss.elastic.co/u/nayestaran)\ **Replies:** 0\ **Last updated:** [May 25, 2020, 8:56am UTC](https://discuss.elastic.co/t/reindex-gets-stuck/234108 "2020-05-25T08:56:44Z")
Hello Elastic community, Context We have two Elasticsearch clusters with 6 and 3 nodes each. The cluster with 6 nodes is the one we use in production environment and we use the one with 3 nodes for testing purposes. (W… --- ## [Sql's AND like operation in elasticsearch java-api](https://discuss.elastic.co/t/sqls-and-like-operation-in-elasticsearch-java-api/234097)
**Author:** [@rohit.singh3](https://discuss.elastic.co/u/rohit.singh3)\ **Replies:** 1\ **Last updated:** [May 25, 2020, 8:43am UTC](https://discuss.elastic.co/t/sqls-and-like-operation-in-elasticsearch-java-api/234097 "2020-05-25T08:43:32Z")
can anyone suggest how to write AND like oparation in java [Previous page](https://discuss.elastic.co/tag/none.md?no_tags=true&page=1428) [Next page](https://discuss.elastic.co/tag/none.md?no_tags=true&page=1430)