CREATE TABLE IF NOT EXISTS t1 (
  `ID` bigint DEFAULT NULL,
  `LOAD_TIME` datetime
) ENGINE=Columnstore DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS t2 (
  `ID` bigint DEFAULT NULL,
  `text` varchar(4) DEFAULT NULL  
) ENGINE=Columnstore DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS t3 (
  `ID` bigint DEFAULT NULL,
  `double_num` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS t4 (
  `ID` bigint DEFAULT NULL,
  `text` varchar(4) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;

truncate table t1;
LOAD DATA LOCAL INFILE '/tmp/t1.csv' INTO TABLE t1 CHARACTER SET UTF8 FIELDS TERMINATED BY ';';

truncate table t2;
LOAD DATA LOCAL INFILE '/tmp/t2.csv' INTO TABLE t2 CHARACTER SET UTF8 FIELDS TERMINATED BY ';';

truncate table t3;
LOAD DATA LOCAL INFILE '/tmp/t3.csv' INTO TABLE t3 CHARACTER SET UTF8 FIELDS TERMINATED BY ';';

truncate table t4;
LOAD DATA LOCAL INFILE '/tmp/t4.csv' INTO TABLE t4 CHARACTER SET UTF8 FIELDS TERMINATED BY ';';