Facing an issue while downloading csv file in Kibana. Followed below steps :
This CSV file has only 10K records and size is always ~10MB even if the number of records returned by search are 100K or 50K.
Is there a way to download this report of all the records returned by a query?
It's possible you are running into the maximum file size for the CSV export: https://www.elastic.co/guide/en/kibana/current/reporting-settings-kb.html#reporting-csv-settings
You can configure it via a kibana.yml setting.
Thank you Joe. I made the change and works for files ~30MB but it failed to generate report for records ~108K. Threw an error "too large file"
You are probably hitting the next limit - the CSV is stored in your Elasticsearch cluster, but there is a limit on Elasticsearch side how much you can upload at once - http.max_content_length (https://www.elastic.co/guide/en/elasticsearch/reference/current/modules-http.html)
Thank you, will try that out. But that brings one more point, as you said the CSV is stored in ES cluster, it will have impact on storage. How can we delete this csv from cluster?
is it
POST /.reporting-<yyyy.mm.dd>/_delete_by_query
{ "query": { "match_all": {} } }
Exactly, it will be part of the reporting index. You can also do it via the UI by going to Management > Reporting > Selecting the report and clicking the delete button.
Is this delete button introduced in version after v 7.2.0 or only for enterprise edition? I can't see it in my basic kibana 7.2.
They got added recently (7.7): https://github.com/elastic/kibana/pull/60077
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
© 2020. All Rights Reserved - Elasticsearch
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.
