COLLATE Trouble with Columnstore

CREATE DATABASE IF NOT EXISTS test;

DROP TABLE IF EXISTS test.chinesecs;

CREATE TABLE test.chinesecs (english_name VARCHAR(50), chinese_name VARCHAR(50)) DEFAULT CHARACTER SET utf8 COLLATE utf8_nopad_bin ENGINE=columnstore;

LOAD DATA LOCAL INFILE '~/Downloads/MOCK_DATA.csv' INTO TABLE test.chinesecs FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES;

SELECT * FROM test.chinesecs ORDER BY chinese_name LIMIT 100;