Columnstore LDI doesn't support charsets, particularly utf8mb4

create table chineseCS (english varchar(20), chinese varchar(20)) engine=innodb DEFAULT CHARACTER SET utf8mb4 collate utf8mb4_unicode_520_ci engine=columnstore;

load data infile "/home/calpont/t.tbl" into table chineseCS character set utf8mb4 fields terminated by "|";

select * from chineseCS;
------------------+

------------------+

------------------+
5 rows in set (0.146 sec)

But using traditional insert, it works:

truncate table chineseCS;
insert into chineseCS values ("Abhorrent","可惡的"),("Adamant","精金"),("Agony","痛苦"),("Antsy","螞蟻"),("Appall","驚恐");

select * from chineseCS;
--------------------+

--------------------+

--------------------+
5 rows in set (0.157 sec)