Skip to content

Decimal and stringset import not working as expected #189

Description

@jayalakshmi-rm

Please run the below sample,
create table account(_id id, username string, salary int, balance decimal(2), account_type stringset);

BULK INSERT INTO account(_id, username, salary, balance, account_type) MAP(0 id, 1 STRING, 2 int, 3 decimal(2), 4 stringset) FROM '/home/account.csv' WITH BATCHSIZE 100000 FORMAT 'CSV' INPUT 'FILE';

account.csv
12,erin,85000,334.43,"checking" 12,erin,85000,334.43,"savings" 12,erin,85000,334.43,"test" 13,will,90000,111.13,"savings" 14,john,35000,999.22,"savings" 15,paul,50000,444.53,"checking,savings" 16,mary,40000,555.63,"checking,savings" 17,jack,95000,888.73,"savings" 19,dogg,85000,777.83,"checking,savings" 21,zoom,15000,222.93,"checking"

expected output for decimal(am showing first row alone)
12 | erin | 85,000 | 334.43 | checking, savings

but getting below result(Please check the decimal point of balance column)
12 | erin | 85,000 | 3.344 | checking, savings

Run below insert command to check the stringset issue
INSERT into account (_id, username, salary, balance, account_type) values (19, 'dogg', 25000,2.24, ['checking']);

expected output for stringset
19 | dogg | 85,000 | 7.778 | checking,savings

But getting below result
19 | dogg | 85,000 | 7.778 | checking, checking,savings

Kindly let us know how to frame stringset in single row in CSV file, Also please share how to import "2019-05-22T13:44" CSV data in timestamp bulk import

Thanks in advance

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions