liaoxin01 commented on issue #9208:
URL:
https://github.com/apache/incubator-doris/issues/9208#issuecomment-1120543707
**Performance test:**
The storage layer data is still decimalv2, which is calculated using
decimalv3.
Create a table and import 100 million pieces of data.
set enable_storage_vectorization = true.
```
CREATE TABLE IF NOT EXISTS decimal_data (
c_bigint bigint NOT NULL,
c_short_decimal decimal(5,2) NOT NULL,
c_mediam_decimal decimal(17,8) NOT NULL,
c_long_decimal decimal(27,9) NOT NULL
)
DUPLICATE KEY(c_bigint)
DISTRIBUTED BY HASH(c_bigint) BUCKETS 1
PROPERTIES (
"replication_num" = "1"
)
```
```
SELECT max(c_short_decimal + c_short_decimal) FROM decimal_data
doris decimalv2 : 7.993 sec
doris vectorized decimalv2 : 2.534 sec
doris vectorized decimalv3 : 1.972 sec
SELECT max(c_mediam_decimal + c_mediam_decimal) FROM decimal_data
doris decimalv2 : 7.616 sec
doris vectorized decimalv2 : 2.287 sec
doris vectorized decimalv3 : 1.788 sec
SELECT sum(c_long_decimal + c_long_decimal) FROM decimal_data
doris decimalv2 : 7.590 sec
doris vectorized decimalv2 : 2.119 sec
doris vectorized decimalv3 : 2.096 sec
```
--
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
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
