MariaDB [test]> create table `cs27`(`o_comment` varchar(79) default null) engine=columnstore default charset=latin1;
|
Query OK, 0 rows affected (0.86 sec)
|
|
root@c983d37cec14:/# find /usr/local/mariadb/columnstore/data1 -name 'FILE*' | wc -l
|
43
|
|
root@c983d37cec14:/# for i in $(seq 1 5); do cpimport -s '|' test cs27 /git/orders_rows.tbl; done
|
|
root@c983d37cec14:/# find /usr/local/mariadb/columnstore/data1 -name 'FILE*' | wc -l
|
45
|
|
MariaDB [test]> delete from cs27;
|
Query OK, 7500000 rows affected (19.31 sec)
|
|
root@c983d37cec14:/# for i in $(seq 1 5); do cpimport -s '|' test cs27 /git/orders_rows.tbl; done
|
|
root@c983d37cec14:/# find /usr/local/mariadb/columnstore/data1 -name 'FILE*' | wc -l
|
47
|