drop table if exists ebi1236;
create table if not exists ebi1236 (
incidentResult json
)  ENGINE=Columnstore  DEFAULT CHARSET=utf8mb4;

truncate table ebi1236;
LOAD DATA LOCAL INFILE '/tmp/EBI-1236/input2.csv' INTO TABLE ebi1236 CHARACTER SET UTF8MB4 FIELDS TERMINATED BY ';';