Skip to content

Decimal and stringset import not working as expected #189

@jayalakshmi-rm

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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions