# \#none **URL:** https://discuss.elastic.co/tag/none.md?page=1976 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1977 --- ## [Jdbc input plugin and a null value to a output jdbc plugin](https://discuss.elastic.co/t/jdbc-input-plugin-and-a-null-value-to-a-output-jdbc-plugin/192962)
**Author:** [@Henrique\_Santiago](https://discuss.elastic.co/u/Henrique_Santiago)\ **Replies:** 1\ **Last updated:** [August 6, 2019, 4:16pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-and-a-null-value-to-a-output-jdbc-plugin/192962 "2019-08-06T16:16:45Z")
I'm using a jdbc input(sqlserver) to input data in a postgresql with jdbc output. input { jdbc { jdbc\_connection\_string =\> "\*\*\*" jdbc\_driver\_library =\> "\*\*\*" jdbc\_user =\> "\*\*\*" jdbc\_p… --- ## [Elastic certification references](https://discuss.elastic.co/t/elastic-certification-references/193463)
**Author:** [@460](https://discuss.elastic.co/u/460)\ **Replies:** 4\ **Last updated:** [August 6, 2019, 1:40pm UTC](https://discuss.elastic.co/t/elastic-certification-references/193463 "2019-08-06T13:40:09Z")
Hi, I had completed my training in Elastic Engineer 1 and 2. Currently I am preparing for my Elastic certification. I had watched the elastic webinar in elastic.co. When I try to search for the tasks or sample use case… --- ## [Where should I move proxy nodes in ECE?](https://discuss.elastic.co/t/where-should-i-move-proxy-nodes-in-ece/193860)
**Author:** [@daniel\_a](https://discuss.elastic.co/u/daniel_a)\ **Replies:** 10\ **Last updated:** [August 6, 2019, 4:07pm UTC](https://discuss.elastic.co/t/where-should-i-move-proxy-nodes-in-ece/193860 "2019-08-06T16:07:17Z")
I just noticed Kibana was kind of slow in my current deployment, and I wasn't sure why. Maybe, I should have moved proxy nodes from coordinators to allocators. Any thoughts? If I don't want to deploy a dedicate node/s f… --- ## [Field 'tags' is backed by an array but the associated Spark Schema does not reflect this](https://discuss.elastic.co/t/field-tags-is-backed-by-an-array-but-the-associated-spark-schema-does-not-reflect-this/194049)
**Author:** [@basha5](https://discuss.elastic.co/u/basha5)\ **Replies:** 0\ **Last updated:** [August 6, 2019, 3:58pm UTC](https://discuss.elastic.co/t/field-tags-is-backed-by-an-array-but-the-associated-spark-schema-does-not-reflect-this/194049 "2019-08-06T15:58:42Z")
Hi, I am trying to read the data from index in ES using pyspark. I am able to load the data into the dataframe. Used this code reader = spark.read.format("es").option("es.read.metadata", True).option("es.port","9200").… --- ## [How to get the best performance with index update](https://discuss.elastic.co/t/how-to-get-the-best-performance-with-index-update/193776)
**Author:** [@Henrique\_Brasileiro](https://discuss.elastic.co/u/Henrique_Brasileiro)\ **Replies:** 6\ **Last updated:** [August 6, 2019, 3:57pm UTC](https://discuss.elastic.co/t/how-to-get-the-best-performance-with-index-update/193776 "2019-08-06T15:57:56Z")
I have a index with length greater than 1 TB and I want to update a field but update by query is very slow, mor slow that delete all and insert all. How best alternative to mass update? --- ## [Date Not Recognized](https://discuss.elastic.co/t/date-not-recognized/193796)
**Author:** [@Jim\_Palazzolo](https://discuss.elastic.co/u/Jim_Palazzolo)\ **Replies:** 11\ **Last updated:** [August 6, 2019, 3:56pm UTC](https://discuss.elastic.co/t/date-not-recognized/193796 "2019-08-06T15:56:27Z")
I have json documents that are going into ES just fine, but Kibana doesn't seem to recognize this field; but it records it... "fields": { "Event.date": \[ "2016-03-14T00:00:00.000Z" I'm sure it's just a config… --- ## [Centralised rufus scheduling for all configuration files ( JDBC plugin)](https://discuss.elastic.co/t/centralised-rufus-scheduling-for-all-configuration-files-jdbc-plugin/194047)
**Author:** [@Duella](https://discuss.elastic.co/u/Duella)\ **Replies:** 0\ **Last updated:** [August 6, 2019, 3:55pm UTC](https://discuss.elastic.co/t/centralised-rufus-scheduling-for-all-configuration-files-jdbc-plugin/194047 "2019-08-06T15:55:22Z")
I would like to centralise my Rufus schedule for my Logstash configuration files, all of them are currently using the JDBC plugin to pull information out of my database. I was wondering if anyone has done this before? --- ## [Scaling Number of Coordinator Nodes](https://discuss.elastic.co/t/scaling-number-of-coordinator-nodes/194044)
**Author:** [@sirsteve](https://discuss.elastic.co/u/sirsteve)\ **Replies:** 0\ **Last updated:** [August 6, 2019, 3:52pm UTC](https://discuss.elastic.co/t/scaling-number-of-coordinator-nodes/194044 "2019-08-06T15:52:26Z")
Hi, I'm looking at how to scale out ES clusters and have been thinking about how to go about deciding on the number of dedicated coordinator nodes to be used. I've noticed that coordinator nodes are useful in shielding… --- ## [Issues with filtered aliases in Kibana](https://discuss.elastic.co/t/issues-with-filtered-aliases-in-kibana/193897)
**Author:** [@mj2019](https://discuss.elastic.co/u/mj2019)\ **Replies:** 2\ **Last updated:** [August 6, 2019, 3:51pm UTC](https://discuss.elastic.co/t/issues-with-filtered-aliases-in-kibana/193897 "2019-08-06T15:51:42Z")
Hi Experts, I have created a filtered alias and trying to create index pattern based on the alias. However i cannot see the filtered alias when i try to create index pattern in Kibana. Also if i query the ElastiSearch d… --- ## [Get response after recorded](https://discuss.elastic.co/t/get-response-after-recorded/193936)
**Author:** [@masterThomas](https://discuss.elastic.co/u/masterThomas)\ **Replies:** 1\ **Last updated:** [August 6, 2019, 3:46pm UTC](https://discuss.elastic.co/t/get-response-after-recorded/193936 "2019-08-06T15:46:03Z")
Hi team. i need to get response from elastic that data is written and then return success, but now endpoint returns success when data is sent for recording. how to do that? server.route({ method: 'POST', path: '/a… --- ## [Any way to add a Sum Total to a Horizontal Chart?](https://discuss.elastic.co/t/any-way-to-add-a-sum-total-to-a-horizontal-chart/193886)
**Author:** [@silentfilm](https://discuss.elastic.co/u/silentfilm)\ **Replies:** 3\ **Last updated:** [August 6, 2019, 3:45pm UTC](https://discuss.elastic.co/t/any-way-to-add-a-sum-total-to-a-horizontal-chart/193886 "2019-08-06T15:45:54Z")
I've got a horizontal bar chart visualization that I've built in Kibana as below. The Y-Axis is an aggregation of Count. The Y-Axis is a Split Series of Terms. Is there any way to create an extra bar that shows the S… --- ## [How to remove duplicate values in logstash](https://discuss.elastic.co/t/how-to-remove-duplicate-values-in-logstash/193769)
**Author:** [@Sajal](https://discuss.elastic.co/u/Sajal)\ **Replies:** 1\ **Last updated:** [August 6, 2019, 3:45pm UTC](https://discuss.elastic.co/t/how-to-remove-duplicate-values-in-logstash/193769 "2019-08-06T15:45:24Z")
Hi . Unable to remove duplicate values from logstash . "src" =\> \[ \[0\] "10.207.73.1", \[1\] "10.207.73.1" \], "agentName" =\> \[ \[0\] "sl73tdsdb1q01 ", \[1\] "sl73tdsdb1q01 " \], "StoredProc" =\> \[ \[0\] "False", \[1\] "Fal… --- ## [Is there any method to set content security policy only in Kibana plugin code?](https://discuss.elastic.co/t/is-there-any-method-to-set-content-security-policy-only-in-kibana-plugin-code/193899)
**Author:** [@sunminxuan](https://discuss.elastic.co/u/sunminxuan)\ **Replies:** 1\ **Last updated:** [August 6, 2019, 3:40pm UTC](https://discuss.elastic.co/t/is-there-any-method-to-set-content-security-policy-only-in-kibana-plugin-code/193899 "2019-08-06T15:40:08Z")
Currently, I am developing a kibana plugin that uses iframe to load remote website. Here is the content of plugins/query\_ai/public/components/main/main.js: import React from 'react'; export class Main extends React.Co… --- ## [Custom filter based on a field range](https://discuss.elastic.co/t/custom-filter-based-on-a-field-range/190752)
**Author:** [@datawrangler](https://discuss.elastic.co/u/datawrangler)\ **Replies:** 4\ **Last updated:** [August 6, 2019, 3:35pm UTC](https://discuss.elastic.co/t/custom-filter-based-on-a-field-range/190752 "2019-08-06T15:35:27Z")
Hello All, In the Discover Panel, to view all traffic a specific subnet is genrated you can do a filter such as: source.ip: 10.0.1.0/24 source.ip: 10.0.2.0/24 source.ip: 10.0.3.0/24 Is there a way to create a user-fri… --- ## [WHY ES-2.4.6 IS EASILY BINDING WITH LOCALHOST TO IP but ES-7.3/7.1 IS NOT BINDING](https://discuss.elastic.co/t/why-es-2-4-6-is-easily-binding-with-localhost-to-ip-but-es-7-3-7-1-is-not-binding/193834)
**Author:** [@rameshkr1994](https://discuss.elastic.co/u/rameshkr1994)\ **Replies:** 5\ **Last updated:** [August 6, 2019, 3:26pm UTC](https://discuss.elastic.co/t/why-es-2-4-6-is-easily-binding-with-localhost-to-ip-but-es-7-3-7-1-is-not-binding/193834 "2019-08-06T15:26:26Z")
Dear All. Facing some issue while binding Localhost to IP in elastic search:- Case 01:-1: when i try bind localhost to IP in Elastic search 2.4.6 that is working very fine:- network.host:localhost Case 02:slight\_smi… --- ## [Logstash shutsdown without error](https://discuss.elastic.co/t/logstash-shutsdown-without-error/193873)
**Author:** [@Kevin\_Juliano](https://discuss.elastic.co/u/Kevin_Juliano)\ **Replies:** 3\ **Last updated:** [August 5, 2019, 8:28pm UTC](https://discuss.elastic.co/t/logstash-shutsdown-without-error/193873 "2019-08-05T20:28:41Z")
I am still learning about elasticsearch and logstash, I am trying to index a table from postgresDB but every time I run it, it keeps shutting down here's my logstash config: # file: index1.conf input { jdbc { … --- ## [Discover: unknown error](https://discuss.elastic.co/t/discover-unknown-error/193881)
**Author:** [@Jim\_Palazzolo](https://discuss.elastic.co/u/Jim_Palazzolo)\ **Replies:** 3\ **Last updated:** [August 6, 2019, 3:09pm UTC](https://discuss.elastic.co/t/discover-unknown-error/193881 "2019-08-06T15:09:46Z")
Discover: unknown error Less Info OK SearchError: unknown error at http://IP:5601/bundles/commons.bundle.js:4:383522 at processQueue (http://IP:5601/built\_assets/dlls/vendors.bundle.dll.js:450:199687) at http://IP:… --- ## [Elasticsearch-query-for-distinct-fields-in-documents-of-same-index](https://discuss.elastic.co/t/elasticsearch-query-for-distinct-fields-in-documents-of-same-index/193998)
**Author:** [@sahadevan](https://discuss.elastic.co/u/sahadevan)\ **Replies:** 1\ **Last updated:** [August 6, 2019, 3:03pm UTC](https://discuss.elastic.co/t/elasticsearch-query-for-distinct-fields-in-documents-of-same-index/193998 "2019-08-06T15:03:06Z")
Document 1: { \_id = 1, \_index = "desktop\_apps" chrome\_app\_name: "chrome", chrome\_app\_version: "1.2", user: "user1" } Document 2: { \_id = 2, \_index = "desktop\_apps" firefox\_app\_name: "firefox", firefo… --- ## [Kibana doesn't see the indices](https://discuss.elastic.co/t/kibana-doesnt-see-the-indices/193339)
**Author:** [@arseni-lipinski](https://discuss.elastic.co/u/arseni-lipinski)\ **Replies:** 10\ **Last updated:** [August 6, 2019, 2:59pm UTC](https://discuss.elastic.co/t/kibana-doesnt-see-the-indices/193339 "2019-08-06T14:59:07Z")
Hi there. I've been experiencing a problem with Kibana - the indices don't show in index patterns menu even though all the indexes are present in index management menu. The whole thing runs under proxy. Request: http:/… --- ## [Gathering RabbitMQ payload when it has a filed message](https://discuss.elastic.co/t/gathering-rabbitmq-payload-when-it-has-a-filed-message/194009)
**Author:** [@pszemesy](https://discuss.elastic.co/u/pszemesy)\ **Replies:** 3\ **Last updated:** [August 6, 2019, 2:44pm UTC](https://discuss.elastic.co/t/gathering-rabbitmq-payload-when-it-has-a-filed-message/194009 "2019-08-06T14:44:11Z")
Hi All, I'm trying to store the original RabbitMQ payload to orig\_msg field with Logstash, but the payload itself contains a filed called message. Logstash add\_field mutate { add\_field =\> { "orig\_msg" =\> "%{message}" } … --- ## [Failed to find metadata for existing index .kibana\_task\_manager \[location: Yi\_UxiceTwS093xLAQJpzw, generation: 30\]](https://discuss.elastic.co/t/failed-to-find-metadata-for-existing-index-kibana-task-manager-location-yi-uxicetws093xlaqjpzw-generation-30/194023)
**Author:** [@Felipe\_Cabral\_Jeroni](https://discuss.elastic.co/u/Felipe_Cabral_Jeroni)\ **Replies:** 4\ **Last updated:** [August 6, 2019, 2:39pm UTC](https://discuss.elastic.co/t/failed-to-find-metadata-for-existing-index-kibana-task-manager-location-yi-uxicetws093xlaqjpzw-generation-30/194023 "2019-08-06T14:39:50Z")
Hi all, Due to a disk space problem, I've deleted the indexes and now I'm getting the following error: java.io.IOException: failed to find metadata for existing index .kibana\_task\_manager \[location: Yi\_UxiceTwS093xLAQJ… --- ## [Nested aggregation crashes cluster all the time](https://discuss.elastic.co/t/nested-aggregation-crashes-cluster-all-the-time/194034)
**Author:** [@zatom](https://discuss.elastic.co/u/zatom)\ **Replies:** 0\ **Last updated:** [August 6, 2019, 2:26pm UTC](https://discuss.elastic.co/t/nested-aggregation-crashes-cluster-all-the-time/194034 "2019-08-06T14:26:39Z")
I have had working queries with nested aggregation before with size of millions for field and ids. But, this time I am having issue with similar nested aggregation for 2 different fields. It is crashing the cluster all t… --- ## [Nested terms aggregations - min\_doc\_count isn't returning key-wise(field in terms) 0 for empty buckets](https://discuss.elastic.co/t/nested-terms-aggregations-min-doc-count-isnt-returning-key-wise-field-in-terms-0-for-empty-buckets/194027)
**Author:** [@saurabh-bhosale](https://discuss.elastic.co/u/saurabh-bhosale)\ **Replies:** 0\ **Last updated:** [August 6, 2019, 2:13pm UTC](https://discuss.elastic.co/t/nested-terms-aggregations-min-doc-count-isnt-returning-key-wise-field-in-terms-0-for-empty-buckets/194027 "2019-08-06T14:13:09Z")
{ "size": 0, "aggs" : { "level\_one\_aggregation": { "date\_range": { "field": "index\_field\_one", "format": "yyyy-MM-dd", "ranges": \[{ "from": "2019-01-01", … --- ## [Kibana did not load properly. Check the server output for more information - Kibana not working](https://discuss.elastic.co/t/kibana-did-not-load-properly-check-the-server-output-for-more-information-kibana-not-working/186224)
**Author:** [@Susmit07](https://discuss.elastic.co/u/Susmit07)\ **Replies:** 17\ **Last updated:** [August 6, 2019, 1:45pm UTC](https://discuss.elastic.co/t/kibana-did-not-load-properly-check-the-server-output-for-more-information-kibana-not-working/186224 "2019-08-06T13:45:44Z")
Getting this error not able to view Kibana outside VM. Did a F12 on the browser and found the below logs Refused to execute inline script because it violates the following Content Security Policy directive: "script-src … --- ## [Inverted full text search](https://discuss.elastic.co/t/inverted-full-text-search/194014)
**Author:** [@Aleksandr\_Ivannikov](https://discuss.elastic.co/u/Aleksandr_Ivannikov)\ **Replies:** 1\ **Last updated:** [August 6, 2019, 1:28pm UTC](https://discuss.elastic.co/t/inverted-full-text-search/194014 "2019-08-06T13:28:31Z")
Hi, When it comes to full text search, use case we usually mean is: there are documents with more or less long text (articles) and we want to find certain comparatively short phrase matches inside those articles. Is it… --- ## [Multiple custom grok patterns not matching, but they successfully match alone?](https://discuss.elastic.co/t/multiple-custom-grok-patterns-not-matching-but-they-successfully-match-alone/193175)
**Author:** [@kmiklas](https://discuss.elastic.co/u/kmiklas)\ **Replies:** 2\ **Last updated:** [August 6, 2019, 1:28pm UTC](https://discuss.elastic.co/t/multiple-custom-grok-patterns-not-matching-but-they-successfully-match-alone/193175 "2019-08-06T13:28:20Z")
Grok matches single custom patterns, but does match when custom patterns are combined. Complete, working, an verifiable example Sample data: OK 05/20 20:12:10:067 ABC\_02~~DE\_02 FGH\_IJK jsmith \_A0011 Custom patterns: … --- ## [Hide page from results](https://discuss.elastic.co/t/hide-page-from-results/194008)
**Author:** [@mccWeb](https://discuss.elastic.co/u/mccWeb)\ **Replies:** 0\ **Last updated:** [August 6, 2019, 12:30pm UTC](https://discuss.elastic.co/t/hide-page-from-results/194008 "2019-08-06T12:30:34Z")
Greetings, How do I hide a section of the website temporarily, until approved, from search results? Thank you, L. --- ## [Sql last value can only store timestamp?](https://discuss.elastic.co/t/sql-last-value-can-only-store-timestamp/193926)
**Author:** [@pyerunka](https://discuss.elastic.co/u/pyerunka)\ **Replies:** 1\ **Last updated:** [August 6, 2019, 12:27pm UTC](https://discuss.elastic.co/t/sql-last-value-can-only-store-timestamp/193926 "2019-08-06T12:27:24Z")
Hello, Can anyone help me in this? can sql last value stores only timestamp? I am trying to use one number column using jdbc plugin and comparing it with sql last value. I am getting an error, SQLSyntaxErrorException… --- ## [Logstash input kafka 7.1.1](https://discuss.elastic.co/t/logstash-input-kafka-7-1-1/194007)
**Author:** [@Erik\_Parienty1](https://discuss.elastic.co/u/Erik_Parienty1)\ **Replies:** 0\ **Last updated:** [August 6, 2019, 12:26pm UTC](https://discuss.elastic.co/t/logstash-input-kafka-7-1-1/194007 "2019-08-06T12:26:07Z")
kafka Client Not Following Broker IP Change if i will kill a broker ( 10.20.60.45 and bring up the same broker with different ip ( 10.20.43.170 ) i see in the logs Initiating connection to node 10.20.43.170:9092 (id: … --- ## [Kafka ingest performance issues](https://discuss.elastic.co/t/kafka-ingest-performance-issues/193639)
**Author:** [@ethrbunny](https://discuss.elastic.co/u/ethrbunny)\ **Replies:** 5\ **Last updated:** [August 6, 2019, 12:19pm UTC](https://discuss.elastic.co/t/kafka-ingest-performance-issues/193639 "2019-08-06T12:19:04Z")
Im sending all my beat\* data into kafka and reading it from there via logstash (running on kubernetes). I use kafka for lots of other purposes and I know we can read 1M records a second using a simple consumer. When I lo… [Previous page](https://discuss.elastic.co/tag/none.md?no_tags=true&page=1975) [Next page](https://discuss.elastic.co/tag/none.md?no_tags=true&page=1977)