Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1881

NULL is imported as 0 from csv file by cpimport

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.2.1
    • Icebox
    • cpimport
    • 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)
       
      
      

      Attachments

        Activity

          People

            LinuxJedi Andrew Hutchings (Inactive)
            winstone Zdravelina Sokolovska (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.