blob: 22d2463f33ef23ee9e3f3343b606cefdc1fd2035 [file] [log] [blame]
================================================================================================
UDF with mixed input types
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
long/nullable int/string to string: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
---------------------------------------------------------------------------------------------------------------------------------
long/nullable int/string to string wholestage off 114 125 15 0.9 1139.9 1.0X
long/nullable int/string to string wholestage on 57 68 9 1.8 571.0 2.0X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
long/nullable int/string to option: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
---------------------------------------------------------------------------------------------------------------------------------
long/nullable int/string to option wholestage off 40 47 9 2.5 402.6 1.0X
long/nullable int/string to option wholestage on 34 36 2 2.9 340.1 1.2X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
long/nullable int/string to primitive: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------------------
long/nullable int/string to primitive wholestage off 29 30 1 3.4 294.7 1.0X
long/nullable int/string to primitive wholestage on 25 28 3 3.9 254.4 1.2X
================================================================================================
UDF with primitive types
================================================================================================
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
long/nullable int to string: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
--------------------------------------------------------------------------------------------------------------------------
long/nullable int to string wholestage off 27 27 0 3.8 265.5 1.0X
long/nullable int to string wholestage on 28 28 1 3.6 275.1 1.0X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
long/nullable int to option: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
--------------------------------------------------------------------------------------------------------------------------
long/nullable int to option wholestage off 20 20 1 5.0 199.3 1.0X
long/nullable int to option wholestage on 20 22 2 5.0 199.3 1.0X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
long/nullable int to primitive: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-----------------------------------------------------------------------------------------------------------------------------
long/nullable int to primitive wholestage off 16 18 2 6.1 164.5 1.0X
long/nullable int to primitive wholestage on 19 20 1 5.4 185.4 0.9X
OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure
AMD EPYC 7763 64-Core Processor
UDF identity overhead: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Baseline 11 12 1 9.4 105.8 1.0X
With identity UDF 20 22 1 5.1 197.3 0.5X