MariaDB [(none)]> use test
Database changed
MariaDB [test]> drop table if exists nation;
edprice decimal(12,2),       
Query OK, 0 rows affected, 1 warning (0.021 sec)

MariaDB [test]> create table nation (
    ->         n_nationkey int,
    ->         n_name char (25),
    ->         n_regionkey int,
    ->         n_comment varchar (152)
    -> ) engine=columnstore
    -> ;
1
Query OK, 0 rows affected (0.264 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists region;
 
Query OK, 0 rows affected, 1 warning (0.019 sec)

MariaDB [test]> create table region (
    ->         r_regionkey int,
    ->         r_name char (25),
    ->         r_comment varchar (152)
    -> ) engine=columnstore
    -> ;
 
Query OK, 0 rows affected (0.260 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists customer;
 
Query OK, 0 rows affected, 1 warning (0.019 sec)

MariaDB [test]> create table customer (
    ->         c_custkey int,
    ->         c_name varchar (25),
    ->         c_address varchar (40),
    ->         c_nationkey int,
    ->         c_phone char (15),
    ->         c_acctbal decimal(12,2),
    ->         c_mktsegment char (10),
    ->         c_comment varchar (117)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.292 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists orders;
Query OK, 0 rows affected, 1 warning (0.019 sec)

MariaDB [test]> create table orders (
    ->         o_orderkey int,
    ->         o_custkey int,
    ->         o_orderstatus char (1),
    ->         o_totalprice decimal(12,2),
    ->         o_orderdate date,
    ->         o_orderpriority char (15),
    ->         o_clerk char (15),
    ->         o_shippriority int,
    ->         o_comment varchar (79)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.259 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists supplier;
Query OK, 0 rows affected, 1 warning (0.019 sec)

MariaDB [test]> create table supplier (
    ->         s_suppkey int,
    ->         s_name char (25),
    ->         s_address varchar (40),
    ->         s_nationkey int,
    ->         s_phone char (15),
    ->         s_acctbal decimal(12,2),
    ->         s_comment varchar (101)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.294 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists partsupp;
Query OK, 0 rows affected, 1 warning (0.020 sec)

MariaDB [test]> create table partsupp (
    ->         ps_partkey int,
    ->         ps_suppkey int,
    ->         ps_availqty int,
    ->         ps_supplycost decimal(12,2),
    ->         ps_comment varchar (199)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.269 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists part;
Query OK, 0 rows affected, 1 warning (0.019 sec)

MariaDB [test]> create table part (
    ->         p_partkey int,
    ->         p_name varchar (55),
    ->         p_mfgr char (25),
    ->         p_brand char (10),
    ->         p_type varchar (25),
    ->         p_size int,
    ->         p_container char (10),
    ->         p_retailprice decimal(12,2),
    ->         p_comment varchar (23)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.307 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists lineitem;
Query OK, 0 rows affected, 1 warning (0.019 sec)

MariaDB [test]> create table lineitem (
    ->         l_orderkey int,
    ->         l_partkey int,
    ->         l_suppkey int,
    ->         l_linenumber bigint,
    ->         l_quantity decimal(12,2),
    ->         l_extendedprice decimal(12,2),
    ->         l_discount decimal(12,2),
    ->         l_tax decimal(12,2),
    ->         l_returnflag char (1),
    ->         l_linestatus char (1),
    ->         l_shipdate date,
    ->         l_commitdate date,
    ->         l_receiptdate date,
    ->         l_shipinstruct char (25),
    ->         l_shipmode char (10),
    ->         l_comment varchar (44)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.307 sec)

MariaDB [test]> show tables;
+----------------+
| Tables_in_test |
+----------------+
| customer       |
| lineitem       |
| lineitem2      |
| lineitem3      |
| lineitem4      |
| nation         |
| orders         |
| part           |
| partsupp       |
| region         |
| supplier       |
+----------------+
11 rows in set (0.000 sec)

MariaDB [test]> drop table if exists nation;
Query OK, 0 rows affected (0.162 sec)

MariaDB [test]> create table nation (
    ->         n_nationkey int,
    ->         n_name char (25),
    ->         n_regionkey int,
    ->         n_comment varchar (152)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.235 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists region;
Query OK, 0 rows affected (0.169 sec)

MariaDB [test]> create table region (
    ->         r_regionkey int,
    ->         r_name char (25),
    ->         r_comment varchar (152)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.224 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists customer;
Query OK, 0 rows affected (0.168 sec)

MariaDB [test]> create table customer (
    ->         c_custkey int,
    ->         c_name varchar (25),
    ->         c_address varchar (40),
    ->         c_nationkey int,
    ->         c_phone char (15),
    ->         c_acctbal decimal(12,2),
    ->         c_mktsegment char (10),
    ->         c_comment varchar (117)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.276 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists orders;
Query OK, 0 rows affected (0.169 sec)

MariaDB [test]> create table orders (
    ->         o_orderkey int,
    ->         o_custkey int,
    ->         o_orderstatus char (1),
    ->         o_totalprice decimal(12,2),
    ->         o_orderdate date,
    ->         o_orderpriority char (15),
    ->         o_clerk char (15),
    ->         o_shippriority int,
    ->         o_comment varchar (79)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.267 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists supplier;
Query OK, 0 rows affected (0.165 sec)

MariaDB [test]> create table supplier (
    ->         s_suppkey int,
    ->         s_name char (25),
    ->         s_address varchar (40),
    ->         s_nationkey int,
    ->         s_phone char (15),
    ->         s_acctbal decimal(12,2),
    ->         s_comment varchar (101)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.262 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists partsupp;
Query OK, 0 rows affected (0.164 sec)

MariaDB [test]> create table partsupp (
    ->         ps_partkey int,
    ->         ps_suppkey int,
    ->         ps_availqty int,
    ->         ps_supplycost decimal(12,2),
    ->         ps_comment varchar (199)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.233 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists part;
Query OK, 0 rows affected (0.168 sec)

MariaDB [test]> create table part (
    ->         p_partkey int,
    ->         p_name varchar (55),
    ->         p_mfgr char (25),
    ->         p_brand char (10),
    ->         p_type varchar (25),
    ->         p_size int,
    ->         p_container char (10),
    ->         p_retailprice decimal(12,2),
    ->         p_comment varchar (23)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.288 sec)

MariaDB [test]> 
MariaDB [test]> drop table if exists lineitem;
Query OK, 0 rows affected (0.173 sec)

MariaDB [test]> create table lineitem (
    ->         l_orderkey int,
    ->         l_partkey int,
    ->         l_suppkey int,
    ->         l_linenumber bigint,
    ->         l_quantity decimal(12,2),
    ->         l_extendedprice decimal(12,2),
    ->         l_discount decimal(12,2),
    ->         l_tax decimal(12,2),
    ->         l_returnflag char (1),
    ->         l_linestatus char (1),
    ->         l_shipdate date,
    ->         l_commitdate date,
    ->         l_receiptdate date,
    ->         l_shipinstruct char (25),
    ->         l_shipmode char (10),
    ->         l_comment varchar (44)
    -> ) engine=columnstore
    -> ;
Query OK, 0 rows affected (0.297 sec)

MariaDB [test]> exit
Bye
[root@ip-172-30-0-23 centos]# cpimport test customer testData/tpch/1g/customer.tbl
Locale = en_US.UTF-8
Using table OID 3218 as the default JOB ID
Input file(s) will be read from : /home/centos
Job description file : /var/lib/columnstore/data/bulk/tmpjob/3218_D20201210_T141800_S479010_Job_3218.xml
Log file for this job: /var/lib/columnstore/data/bulk/log/Job_3218.log
2020-12-10 14:18:00 (10874) INFO : successfully loaded job file /var/lib/columnstore/data/bulk/tmpjob/3218_D20201210_T141800_S479010_Job_3218.xml
2020-12-10 14:18:00 (10874) INFO : Job file loaded, run time for this step : 0.0406411 seconds
2020-12-10 14:18:00 (10874) INFO : PreProcessing check starts
2020-12-10 14:18:00 (10874) INFO : input data file /home/centos/testData/tpch/1g/customer.tbl
2020-12-10 14:18:01 (10874) INFO : PreProcessing check completed
2020-12-10 14:18:01 (10874) INFO : preProcess completed, run time for this step : 0.842124 seconds
2020-12-10 14:18:01 (10874) INFO : No of Read Threads Spawned = 1
2020-12-10 14:18:01 (10874) INFO : No of Parse Threads Spawned = 3
2020-12-10 14:18:01 (10874) INFO : For table test.customer: 150000 rows processed and 150000 rows inserted.
2020-12-10 14:18:02 (10874) INFO : Bulk load completed, total run time : 1.88312 seconds

[root@ip-172-30-0-23 centos]# cpimport test lineitem testData/tpch/1g/lineitem.tbl
Locale = en_US.UTF-8
Using table OID 3280 as the default JOB ID
Input file(s) will be read from : /home/centos
Job description file : /var/lib/columnstore/data/bulk/tmpjob/3280_D20201210_T141802_S446793_Job_3280.xml
Log file for this job: /var/lib/columnstore/data/bulk/log/Job_3280.log
2020-12-10 14:18:02 (10922) INFO : successfully loaded job file /var/lib/columnstore/data/bulk/tmpjob/3280_D20201210_T141802_S446793_Job_3280.xml
2020-12-10 14:18:02 (10922) INFO : Job file loaded, run time for this step : 0.037894 seconds
2020-12-10 14:18:02 (10922) INFO : PreProcessing check starts
2020-12-10 14:18:02 (10922) INFO : input data file /home/centos/testData/tpch/1g/lineitem.tbl
2020-12-10 14:18:04 (10922) INFO : PreProcessing check completed
2020-12-10 14:18:04 (10922) INFO : preProcess completed, run time for this step : 1.59963 seconds
2020-12-10 14:18:04 (10922) INFO : No of Read Threads Spawned = 1
2020-12-10 14:18:04 (10922) INFO : No of Parse Threads Spawned = 3
2020-12-10 14:18:10 (10922) INFO : For table test.lineitem: 6001215 rows processed and 6001215 rows inserted.
2020-12-10 14:18:11 (10922) INFO : Bulk load completed, total run time : 8.63947 seconds

[root@ip-172-30-0-23 centos]# cpimport test nation testData/tpch/1g/nation.tbl
Locale = en_US.UTF-8
Using table OID 3205 as the default JOB ID
Input file(s) will be read from : /home/centos
Job description file : /var/lib/columnstore/data/bulk/tmpjob/3205_D20201210_T141811_S170090_Job_3205.xml
Log file for this job: /var/lib/columnstore/data/bulk/log/Job_3205.log
2020-12-10 14:18:11 (10951) INFO : successfully loaded job file /var/lib/columnstore/data/bulk/tmpjob/3205_D20201210_T141811_S170090_Job_3205.xml
2020-12-10 14:18:11 (10951) INFO : Job file loaded, run time for this step : 0.03496 seconds
2020-12-10 14:18:11 (10951) INFO : PreProcessing check starts
2020-12-10 14:18:11 (10951) INFO : input data file /home/centos/testData/tpch/1g/nation.tbl
2020-12-10 14:18:11 (10951) INFO : PreProcessing check completed
2020-12-10 14:18:11 (10951) INFO : preProcess completed, run time for this step : 0.40819 seconds
2020-12-10 14:18:11 (10951) INFO : No of Read Threads Spawned = 1
2020-12-10 14:18:11 (10951) INFO : No of Parse Threads Spawned = 3
2020-12-10 14:18:11 (10951) INFO : For table test.nation: 25 rows processed and 25 rows inserted.
2020-12-10 14:18:12 (10951) INFO : Bulk load completed, total run time : 1.44357 seconds

[root@ip-172-30-0-23 centos]# cpimport test orders testData/tpch/1g/orders.tbl
Locale = en_US.UTF-8
Using table OID 3232 as the default JOB ID
Input file(s) will be read from : /home/centos
Job description file : /var/lib/columnstore/data/bulk/tmpjob/3232_D20201210_T141812_S698081_Job_3232.xml
Log file for this job: /var/lib/columnstore/data/bulk/log/Job_3232.log
2020-12-10 14:18:12 (10980) INFO : successfully loaded job file /var/lib/columnstore/data/bulk/tmpjob/3232_D20201210_T141812_S698081_Job_3232.xml
2020-12-10 14:18:12 (10980) INFO : Job file loaded, run time for this step : 0.0376079 seconds
2020-12-10 14:18:12 (10980) INFO : PreProcessing check starts
2020-12-10 14:18:12 (10980) INFO : input data file /home/centos/testData/tpch/1g/orders.tbl
2020-12-10 14:18:13 (10980) INFO : PreProcessing check completed
2020-12-10 14:18:13 (10980) INFO : preProcess completed, run time for this step : 0.748333 seconds
2020-12-10 14:18:13 (10980) INFO : No of Read Threads Spawned = 1
2020-12-10 14:18:13 (10980) INFO : No of Parse Threads Spawned = 3
2020-12-10 14:18:14 (10980) INFO : For table test.orders: 1500000 rows processed and 1500000 rows inserted.
2020-12-10 14:18:15 (10980) INFO : Bulk load completed, total run time : 2.78667 seconds

[root@ip-172-30-0-23 centos]# cpimport test partsupp testData/tpch/1g/partsupp.tbl
Locale = en_US.UTF-8
Using table OID 3257 as the default JOB ID
Input file(s) will be read from : /home/centos
Job description file : /var/lib/columnstore/data/bulk/tmpjob/3257_D20201210_T141815_S568688_Job_3257.xml
Log file for this job: /var/lib/columnstore/data/bulk/log/Job_3257.log
2020-12-10 14:18:15 (11009) INFO : successfully loaded job file /var/lib/columnstore/data/bulk/tmpjob/3257_D20201210_T141815_S568688_Job_3257.xml
2020-12-10 14:18:15 (11009) INFO : Job file loaded, run time for this step : 0.0357749 seconds
2020-12-10 14:18:15 (11009) INFO : PreProcessing check starts
2020-12-10 14:18:15 (11009) INFO : input data file /home/centos/testData/tpch/1g/partsupp.tbl
2020-12-10 14:18:16 (11009) INFO : PreProcessing check completed
2020-12-10 14:18:16 (11009) INFO : preProcess completed, run time for this step : 1.14986 seconds
2020-12-10 14:18:16 (11009) INFO : No of Read Threads Spawned = 1
2020-12-10 14:18:16 (11009) INFO : No of Parse Threads Spawned = 3
2020-12-10 14:18:17 (11009) INFO : For table test.partsupp: 800000 rows processed and 800000 rows inserted.
2020-12-10 14:18:17 (11009) INFO : Bulk load completed, total run time : 2.18643 seconds

[root@ip-172-30-0-23 centos]# cpimport test part testData/tpch/1g/part.tbl
Locale = en_US.UTF-8
Using table OID 3264 as the default JOB ID
Input file(s) will be read from : /home/centos
Job description file : /var/lib/columnstore/data/bulk/tmpjob/3264_D20201210_T141817_S858375_Job_3264.xml
Log file for this job: /var/lib/columnstore/data/bulk/log/Job_3264.log
2020-12-10 14:18:17 (11038) INFO : successfully loaded job file /var/lib/columnstore/data/bulk/tmpjob/3264_D20201210_T141817_S858375_Job_3264.xml
2020-12-10 14:18:17 (11038) INFO : Job file loaded, run time for this step : 0.04229 seconds
2020-12-10 14:18:17 (11038) INFO : PreProcessing check starts
2020-12-10 14:18:17 (11038) INFO : input data file /home/centos/testData/tpch/1g/part.tbl
2020-12-10 14:18:18 (11038) INFO : PreProcessing check completed
2020-12-10 14:18:18 (11038) INFO : preProcess completed, run time for this step : 1.00087 seconds
2020-12-10 14:18:18 (11038) INFO : No of Read Threads Spawned = 1
2020-12-10 14:18:18 (11038) INFO : No of Parse Threads Spawned = 3
2020-12-10 14:18:19 (11038) INFO : For table test.part: 200000 rows processed and 200000 rows inserted.
2020-12-10 14:18:19 (11038) INFO : Bulk load completed, total run time : 2.0441 seconds

[root@ip-172-30-0-23 centos]# cpimport test region testData/tpch/1g/region.tbl
Locale = en_US.UTF-8
Using table OID 3212 as the default JOB ID
Input file(s) will be read from : /home/centos
Job description file : /var/lib/columnstore/data/bulk/tmpjob/3212_D20201210_T141819_S982095_Job_3212.xml
Log file for this job: /var/lib/columnstore/data/bulk/log/Job_3212.log
2020-12-10 14:18:19 (11067) INFO : successfully loaded job file /var/lib/columnstore/data/bulk/tmpjob/3212_D20201210_T141819_S982095_Job_3212.xml
2020-12-10 14:18:19 (11067) INFO : Job file loaded, run time for this step : 0.0350101 seconds
2020-12-10 14:18:19 (11067) INFO : PreProcessing check starts
2020-12-10 14:18:19 (11067) INFO : input data file /home/centos/testData/tpch/1g/region.tbl
2020-12-10 14:18:20 (11067) INFO : PreProcessing check completed
2020-12-10 14:18:20 (11067) INFO : preProcess completed, run time for this step : 0.535257 seconds
2020-12-10 14:18:20 (11067) INFO : No of Read Threads Spawned = 1
2020-12-10 14:18:20 (11067) INFO : No of Parse Threads Spawned = 3
2020-12-10 14:18:20 (11067) INFO : For table test.region: 5 rows processed and 5 rows inserted.
2020-12-10 14:18:21 (11067) INFO : Bulk load completed, total run time : 1.57077 seconds

[root@ip-172-30-0-23 centos]# cpimport test supplier testData/tpch/1g/supplier.tbl
Locale = en_US.UTF-8
Using table OID 3245 as the default JOB ID
Input file(s) will be read from : /home/centos
Job description file : /var/lib/columnstore/data/bulk/tmpjob/3245_D20201210_T141821_S635656_Job_3245.xml
Log file for this job: /var/lib/columnstore/data/bulk/log/Job_3245.log
2020-12-10 14:18:21 (11096) INFO : successfully loaded job file /var/lib/columnstore/data/bulk/tmpjob/3245_D20201210_T141821_S635656_Job_3245.xml
2020-12-10 14:18:21 (11096) INFO : Job file loaded, run time for this step : 0.0362089 seconds
2020-12-10 14:18:21 (11096) INFO : PreProcessing check starts
2020-12-10 14:18:21 (11096) INFO : input data file /home/centos/testData/tpch/1g/supplier.tbl
2020-12-10 14:18:22 (11096) INFO : PreProcessing check completed
2020-12-10 14:18:22 (11096) INFO : preProcess completed, run time for this step : 0.640176 seconds
2020-12-10 14:18:22 (11096) INFO : No of Read Threads Spawned = 1
2020-12-10 14:18:22 (11096) INFO : No of Parse Threads Spawned = 3
2020-12-10 14:18:22 (11096) INFO : For table test.supplier: 10000 rows processed and 10000 rows inserted.
2020-12-10 14:18:23 (11096) INFO : Bulk load completed, total run time : 1.67675 seconds

[root@ip-172-30-0-23 centos]#