yuxuan-luo commented on issue #15986:
URL: https://github.com/apache/doris/issues/15986#issuecomment-1385017752
复现方法：
建表语句及数据导入：
CREATE TABLE `doris_test_sink` (
`id` int(11) NULL,
`s_count` int(11) NULL,
`fee` DECIMALV3(15,4) NULL,
`skuname` varchar(40) NULL,
`skudesc` varchar(200) NULL
) ENGINE=OLAP
DUPLICATE KEY(`id`)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`id`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"in_memory" = "false",
"storage_format" = "V2",
"disable_auto_compaction" = "false"
);
curl -u admin -H "label:load_local_file_test" -H "column_separator:," -T
/root/test.csv http://10.0.0.xx:8040/api/xiaomi/doris_test_sink/_stream_load
csv:
10001,12,13.3, test1,this is atest
10002,100,15.3,test2,this is atest
10003,102,16.3,test3,this is atest
10004,120,17.3,test4,this is atest
10005,23,10.3, test5,this is atest
10006,24,112.3,test6,this is atest
10007,26,13.3, test7,this is atest
10008,29,145.3,test8,this is atest
10009,30,16.3, test9,this is atest
100010,32,18.3,test10,this is atest
100011,52,18.3,test11,this is atest
100012,62,10.3,test12,this is atest
-- 查询 sql
select *,if(1 = 2,
1.0*s_count - fee,
fee) as bug ,round(fee - s_count,6) as fe from doris_test_sink;
--
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]
