DBeaver 22.2.0 - Can't parse numeric value [TRUE] using formatter

Tyson Biegler 0
Viewed 28

Im new to using DBeaver and have not found an answer to this question elsewhere.

I downloaded a CSV of police shootings from Kaggle.com and have been trying to import it into DBeaver but i keep getting this error. Can't parse numeric value [TRUE] using formatter

Initially I thought that it was having trouble with the BOOL data types because it changes them into 'tinyint(1)' automatically.

If I click "Skip" then I end up with a table of headers and no actual data.

SELECT *
FROM police_shootings_2015_2022;

enter image description here

DBeaver lets me inspect the csv before uploading it and this is what it looks like, enter image description here

dbeaver mysql sql
0 Answers
Related