angelyouyou opened a new issue, #21986: URL: https://github.com/apache/doris/issues/21986
### 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 All version, include v1.2.4/v1.2.6/v2.0beta... ### What's Wrong? At present, the maximum number of Decimal type integers supported by Doris can only be 38. We hope to store the digital form of IPv6 addresses through Doris (the data type in Java language is BigInteger), which will cause the data to be stored incorrectly. After browsing the Decimal type of the ClickHouse database, the Decimal type can support up to [Decimal256(S),](https://clickhouse.com/docs/en/sql-reference/data-types/decimal) which can effectively solve the storage problem when the value is large. This problem affects many functions related to this precision, please help to fix and solve it as soon as possible! Thank you very much. ### What You Expected? The precision of the integer part of Decimal can at least support the length of the number corresponding to the IPv6 address. ### How to Reproduce? [Documentation](https://doris.apache.org/zh-CN/docs/dev/sql-manual/sql-reference/Data-Types/DECIMAL) and practice have confirmed that when the Decimal precision is specified as DECIMAL(38, 0), the value corresponding to the IPv6 address (2409:8087:574C:14:1000::49) cannot be saved. ### Anything Else? NA ### 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: [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]
