gohalo commented on issue #21453:
URL: https://github.com/apache/doris/issues/21453#issuecomment-1618101075
this can be reproduced by the following sql.
```
CREATE TABLE IF NOT EXISTS example(
`user_id` LARGEINT NOT NULL,
`date` DATE NOT NULL,
`city` VARCHAR(20),
`age` SMALLINT,
`sex` TINYINT,
`cost` DECIMALv3(20, 2) SUM DEFAULT "0"
)
AGGREGATE KEY(`user_id`, `date`, `city`, `age`, `sex`)
DISTRIBUTED BY HASH(`user_id`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);
```
save the following data as test.csv file.
```
10000,2017-10-01,BeiJing,20,0,0.123456e-60
```
and then load the data with following shell command.
```
curl --location-trusted -u root: -T test.csv -H "column_separator:,"
http://127.0.0.1:29980/api/test/example/_stream_load
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
