[root@cps mcsimport]# cat nulls.csv
|
,,
|
||NULL
|
NULL||NULL
|
NULL|NULL|NULL
|
|NULL|
|
,,
|
|
|
[root@cps mcsimport]# ./mcsimport a ff nulls.csv -ignore_malformed_csv -err_log
|
Execution time: 0.836845s
|
Rows inserted: 2
|
Truncation count: 0
|
Saturated count: 0
|
Invalid count: 0
|
Ignored malformed csv count: 4
|
[root@cps mcsimport]# mcsmysql -u root -p1
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 48696
|
Server version: 10.3.10-MariaDB-log Columnstore 1.2.1-1
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> select * from a.ff ;
|
+------+------+------+
|
| a | b | c |
|
+------+------+------+
|
| NULL | NULL | NULL |
|
| NULL | NULL | NULL |
|
+------+------+------+
|
2 rows in set, 1 warning (0.298 sec)
|
|
|
[root@cps mcsimport]# cat nulls.csv.1542122024432.err
|
error_type, column_nr, parsed_raw_row_values
|
MALFORMED_CSV_LINE, -1, ||NULL
|
MALFORMED_CSV_LINE, -1, NULL||NULL
|
MALFORMED_CSV_LINE, -1, NULL|NULL|NULL
|
MALFORMED_CSV_LINE, -1, |NULL|
|
|