coderfender commented on PR #2932:
URL:
https://github.com/apache/datafusion-comet/pull/2932#issuecomment-3668052704
```
================================================================================================
Running benchmark BooleanType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : BooleanType , ansi mode enabled : false:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : BOOLEAN , ansi mode enabled :
false 170 204 22 61.5 16.3
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : BOOLEAN , ansi mode enabled :
false 209 228 17 50.2 19.9
0.8X
================================================================================================
Running benchmark BooleanType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : BooleanType , ansi mode enabled : true:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : BOOLEAN , ansi mode enabled :
true 166 181 15 63.3 15.8
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : BOOLEAN , ansi mode enabled :
true 209 230 17 50.1 20.0
0.8X
================================================================================================
Running benchmark ByteType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : ByteType , ansi mode enabled : false:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : TINYINT , ansi mode enabled :
false 171 185 17 61.2 16.4
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : TINYINT , ansi mode enabled :
false 206 237 26 50.9 19.7
0.8X
================================================================================================
Running benchmark ByteType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : ByteType , ansi mode enabled : true:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : TINYINT , ansi mode enabled :
true 33 47 20 317.5 3.1
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : TINYINT , ansi mode enabled :
true 26 58 25 404.1 2.5
1.3X
================================================================================================
Running benchmark ShortType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : ShortType , ansi mode enabled : false:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : SMALLINT , ansi mode enabled
: false 168 187 23 62.2 16.1
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : SMALLINT , ansi mode enabled
: false 199 218 25 52.7 19.0
0.8X
================================================================================================
Running benchmark ShortType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : ShortType , ansi mode enabled : true:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : SMALLINT , ansi mode enabled
: true 40 57 21 260.3 3.8
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : SMALLINT , ansi mode enabled
: true 25 51 20 422.1 2.4
1.6X
================================================================================================
Running benchmark IntegerType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : IntegerType , ansi mode enabled : false:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : INT , ansi mode enabled :
false 173 183 13 60.5 16.5
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : INT , ansi mode enabled :
false 202 229 26 51.8 19.3
0.9X
================================================================================================
Running benchmark IntegerType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : IntegerType , ansi mode enabled : true:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : INT , ansi mode enabled :
true 40 56 19 264.5 3.8
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : INT , ansi mode enabled :
true 24 36 20 441.0 2.3
1.7X
================================================================================================
Running benchmark LongType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : LongType , ansi mode enabled : false:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : BIGINT , ansi mode enabled :
false 171 190 23 61.4 16.3
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : BIGINT , ansi mode enabled :
false 167 223 27 62.9 15.9
1.0X
================================================================================================
Running benchmark LongType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : LongType , ansi mode enabled : true:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
----------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : BIGINT , ansi mode enabled :
true 172 191 28 60.9 16.4
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : BIGINT , ansi mode enabled :
true 169 212 30 62.2 16.1
1.0X
================================================================================================
Running benchmark FloatType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : FloatType , ansi mode enabled : false:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
----------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : FLOAT , ansi mode enabled :
false 173 194 26 60.5 16.5
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : FLOAT , ansi mode enabled :
false 195 233 27 53.8 18.6
0.9X
================================================================================================
Running benchmark FloatType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : FloatType , ansi mode enabled : true:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
---------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : FLOAT , ansi mode enabled :
true 175 190 32 60.0 16.7
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : FLOAT , ansi mode enabled :
true 255 267 9 41.2 24.3
0.7X
================================================================================================
Running benchmark DoubleType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : DoubleType , ansi mode enabled : false:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : DOUBLE , ansi mode enabled :
false 173 174 1 60.6 16.5
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : DOUBLE , ansi mode enabled :
false 168 216 45 62.4 16.0
1.0X
================================================================================================
Running benchmark DoubleType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : DoubleType , ansi mode enabled : true:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
----------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : DOUBLE , ansi mode enabled :
true 175 177 4 60.0 16.7
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : DOUBLE , ansi mode enabled :
true 180 205 34 58.2 17.2
1.0X
================================================================================================
Running benchmark DecimalType(10,2))
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : DecimalType(10,2) , ansi mode enabled : false:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per
Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : DECIMAL(10,2) , ansi mode
enabled : false 562 615 36 18.7
53.6 1.0X
SQL Parquet - Comet Cast expr from BIGINT to : DECIMAL(10,2) , ansi mode
enabled : false 258 305 52 40.6
24.6 2.2X
================================================================================================
Running benchmark DecimalType(10,2))
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : DecimalType(10,2) , ansi mode enabled : true:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : DECIMAL(10,2) , ansi mode
enabled : true 35 43 11 298.6
3.3 1.0X
SQL Parquet - Comet Cast expr from BIGINT to : DECIMAL(10,2) , ansi mode
enabled : true 24 56 32 437.0
2.3 1.5X
================================================================================================
Running benchmark StringType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : StringType , ansi mode enabled : false:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : STRING , ansi mode enabled :
false 585 640 42 17.9 55.8
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : STRING , ansi mode enabled :
false 478 512 38 22.0 45.6
1.2X
================================================================================================
Running benchmark StringType)
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Mac OS X 16.0
Apple M2 Max
Cast function to : StringType , ansi mode enabled : true:
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
----------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Parquet - Spark Cast expr from BIGINT to : STRING , ansi mode enabled :
true 589 628 29 17.8 56.2
1.0X
SQL Parquet - Comet Cast expr from BIGINT to : STRING , ansi mode enabled :
true 477 515 41 22.0 45.5
1.2X
```
--
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]
