Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
1.2.1
-
None
Description
NULL is imported as 0 from csv file by cpimport
[root@um1 mcsimport]# cat /root/t8.csv
|
|||||||NULL
|
|||||||NULL|
|
||||||||
|
|||||||
|
NULL|NULL||||||
|
|
[root@um1 ~]# cpimport tt t7 t8.csv
|
2018-11-13 17:35:34 (15525) INFO : Running distributed import (mode 1) on all PMs...
|
2018-11-13 17:35:35 (15525) INFO : For table tt.t7: 5 rows processed and 5 rows inserted.
|
2018-11-13 17:35:35 (15525) INFO : Bulk load completed, total run time : 0.626437 seconds
|
[root@um1 ~]# ./mcsimport tt t7 t8.csv -c /usr/local/mariadb/columnstore/etc/Columnstore.xml^C
|
[root@um1 ~]# mcsmysql -u root -p1
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 133191
|
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 tt.t7 ;
|
+------+------+------+------+------+------+------+-------+
|
| a | b | c | d | e | f | g | h |
|
+------+------+------+------+------+------+------+-------+
|
| NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0.000 |
|
| NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0.000 |
|
| NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|
| NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|
| 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL |
|
+------+------+------+------+------+------+------+-------+
|
5 rows in set, 1 warning (0.104 sec)
|
|
MariaDB [(none)]>
|
|
|
|
|
MariaDB [(none)]> show create table tt.t7 ;
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| t7 | CREATE TABLE `t7` (
|
`a` tinyint(1) DEFAULT NULL,
|
`b` tinyint(4) DEFAULT NULL,
|
`c` smallint(6) DEFAULT NULL,
|
`d` int(11) DEFAULT NULL,
|
`e` bigint(20) DEFAULT NULL,
|
`f` float DEFAULT NULL,
|
`g` double DEFAULT NULL,
|
`h` decimal(10,3) DEFAULT NULL
|
) ENGINE=Columnstore DEFAULT CHARSET=latin1 |
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
|