# Unable to parse csv over 20000 with Data Visualizer

**URL:** <https://discuss.elastic.co/t/unable-to-parse-csv-over-20000-with-data-visualizer/236208>\
**Category:** Kibana\
**Tags:** elastic-stack-machine-learning\
**Created:** [June 8, 2020, 5:07pm UTC](https://discuss.elastic.co/t/unable-to-parse-csv-over-20000-with-data-visualizer/236208 "2020-06-08T17:07:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thodoris\_Alexopoulos](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thodoris_alexopoulos/32/40764_2.png) [@Thodoris\_Alexopoulos](https://discuss.elastic.co/u/Thodoris_Alexopoulos)\
**Post date:** [June 8, 2020, 5:07pm UTC](https://discuss.elastic.co/t/unable-to-parse-csv-over-20000-with-data-visualizer/236208/1 "2020-06-08T17:07:25Z")

</div>

Hello everyone,

I am trying to parse a CSV file that is 22000 rows to Data visualizer and it fails with error , file could not be read. Unexpected token \< in JSON at position 0. But when I erase 3000 rows the file passes without a problem. I have tried with several files and the pattern is the same. The files do not exceed the 3 MB.

Do I have to change any parameter in my kibana.yml?

---

<div class="post-metadata">

**Author:** ![James\_Gowdy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/james_gowdy/32/74175_2.png) [@James\_Gowdy](https://discuss.elastic.co/u/James_Gowdy)\
**Post date:** [June 9, 2020, 12:41pm UTC](https://discuss.elastic.co/t/unable-to-parse-csv-over-20000-with-data-visualizer/236208/2 "2020-06-09T12:41:58Z")

</div>

Hi Thodoris,  
I imagine the `<` character is coming from an html based error response being return by the server rather than the expected JSON .  
Which version of elasticsearch are you using?  
Can you supply a sample of the data? just a few typical lines will be fine.

Regards,  
James

---

<div class="post-metadata">

**Author:** ![Thodoris\_Alexopoulos](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thodoris_alexopoulos/32/40764_2.png) [@Thodoris\_Alexopoulos](https://discuss.elastic.co/u/Thodoris_Alexopoulos)\
**Post date:** [June 11, 2020, 6:15am UTC](https://discuss.elastic.co/t/unable-to-parse-csv-over-20000-with-data-visualizer/236208/3 "2020-06-11T06:15:43Z")

</div>

Thanks for your respond James.

I am using the 7.6 version and I am also trying to parse the following CSV file from [https://covid19.who.int/](https://covid19.who.int/) :

Download Map Data (Click button to Download). Sorry but it is not permitted to upload the csv file.

Thanks

---

<div class="post-metadata">

**Author:** ![darnautov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/darnautov/32/70608_2.png) [@darnautov](https://discuss.elastic.co/u/darnautov)\
**Post date:** [June 18, 2020, 9:39am UTC](https://discuss.elastic.co/t/unable-to-parse-csv-over-20000-with-data-visualizer/236208/4 "2020-06-18T09:39:36Z")

</div>

Hi @Thodoris_Alexopoulos,

Let me to follow up on this one! I downloaded a CSV file you mentioned:  
WHO-COVID-19-global-data.csv  
sha1 621e103a66b15af0f9e5bc93e0f8ddea4c0e3d3f  
22374 rows

Tested on the stack version 7.6.0, both elasticsearch and kibana. Using default settings for both `kibana.yml` and `elasticsearch.yml`, single-node cluster. I managed to upload the file and create an index without overriding any settings.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/a/7ad750250ada7fd3818d59bc6cd38f65b6206756.png)  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/1/21464923e852df2eaf0014f167e52cb4676f023a.png)

Could you please confirm if the file and stack versions are the same as I mentioned? Also, more details on the configurations of elasticsearch and kibana you have might be useful for troubleshooting the issue.

Regards,  
Dima

---

<div class="post-metadata">

**Author:** ![James\_Gowdy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/james_gowdy/32/74175_2.png) [@James\_Gowdy](https://discuss.elastic.co/u/James_Gowdy)\
**Post date:** [June 23, 2020, 9:17am UTC](https://discuss.elastic.co/t/unable-to-parse-csv-over-20000-with-data-visualizer/236208/5 "2020-06-23T09:17:34Z")

</div>

Hi @Thodoris_Alexopoulos,

I've experimented with the who covid dataset on a cloud deployment running 7.6, I could not get a timeout when analysing the data, but I did occasionally see one when trying to import it.  
So i suspect it is a problem with the amount of data being sent over the network.  
Even though the file is not large, it still needs chopping up into chunks that should be small enough to be sent to the Kibana server.

In 7.8 we have made improvements in the parsing and uploading of data.  
[https://github.com/elastic/kibana/pull/62970](https://github.com/elastic/kibana/pull/62970)

I have tested the same csv file with a 7.8 deployment and with multiple attempts, I could not reproduce a timeout failure.

If possible, I would suggest upgrading to 7.8 as it should hopefully fix this issue for you.

Regards,  
James

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 21, 2020, 9:17am UTC](https://discuss.elastic.co/t/unable-to-parse-csv-over-20000-with-data-visualizer/236208/6 "2020-07-21T09:17:35Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.