LizZhang315 opened a new issue, #17273: URL: https://github.com/apache/doris/issues/17273
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version doris-0.0.0-trunk-91bf497 ### What's Wrong? load decimal type data error create table tbl1(k1 tinyint, k2 smallint, k3 int, k4 bigint, k5 decimal(9,3), k6 char(5), k10 date, k11 datetime, k7 varchar(20), k8 double max, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties(''storage_type''=''column''); load data with broker, src data : 1 1989 1001 11011902 123.123 true 1989-03-21 1989-03-21 13:00:00 wangjuoo4 0.1 6.333 2 1986 1001 11011903 1243.5 false 1901-12-31 1989-03-21 13:00:00 wangynnsf 20.268 789.25 3 1989 1002 11011905 24453.325 false 2012-03-14 2000-01-01 00:00:00 yunlj8@nk 78945 3654.0 4 1991 3021 -11011907 243243.325 false 3124-10-10 2015-03-13 10:30:00 yanvjldjlll 2.06 -0.001 5 1985 5014 -11011903 243.325 true 2015-01-01 2015-03-13 12:36:38 du3lnvl -0.000 -365 6 32767 3021 123456 604587.000 true 2014-11-11 2015-03-13 12:36:38 yanavnd 0.1 80699 7 -32767 1002 7210457 3.141 false 1988-03-21 1901-01-01 00:00:00 jiw3n4 0.0 6058 8 255 2147483647 11011920 -0.123 true 1989-03-21 9999-11-11 12:12:00 wangjuoo5 987456.123 12.14 9 1991 -2147483647 11011902 -654.654 true 1991-08-11 1989-03-21 13:11:00 wangjuoo4 0.000 69.123 10 1991 5014 9223372036854775807 -258.369 false 2015-04-02 2013-04-02 15:16:52 wangynnsf -123456.54 0.235 11 1989 25699 -9223372036854775807 0.666 true 2015-04-02 1989-03-21 13:11:00 yunlj8@nk -987.001 4.336 12 32767 -2147483647 9223372036854775807 243.325 false 1991-08-11 2013-04-02 15:16:52 lifsno -564.898 3.141592654 13 -32767 2147483647 -9223372036854775807 100.001 false 2015-04-02 2015-04-02 00:00:00 wenlsfnl 123.456 3.141592653 14 255 103 11011902 -0.000 false 2015-04-02 2015-04-02 00:00:00 3.141592654 2.036 15 1992 3021 11011920 0.00 true 9999-12-12 2015-04-02 00:00:00 3.141592653 20.456 ERROR MSG: Reason: column_name[k5], decimal value is not valid for definition, value=123.123, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=1243.5, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=24453.325, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=243243.325, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=243.325, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=604587, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=3.141, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=-0.123, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=-654.654, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=-258.369, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=0.666, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=243.325, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=100.001, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=0, precision=9, scale=3; . src line []; Reason: column_name[k5], decimal value is not valid for definition, value=0, precision=9, scale=3; . src line []; ### What You Expected? load success ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
