blob: ce98b1b25814755d34b5d6a15a76879449dd1df3 [file] [log] [blame]
================================================================================================
UDF with mixed input types
================================================================================================
OpenJDK 64-Bit Server VM 21.0.8+9-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 80 97 23 1.2 802.9 1.0X
long/nullable int/string to string wholestage on 57 67 12 1.8 565.2 1.4X
OpenJDK 64-Bit Server VM 21.0.8+9-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 43 47 5 2.3 432.2 1.0X
long/nullable int/string to option wholestage on 50 54 2 2.0 496.6 0.9X
OpenJDK 64-Bit Server VM 21.0.8+9-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 36 37 1 2.8 362.6 1.0X
long/nullable int/string to primitive wholestage on 29 32 2 3.5 285.8 1.3X
================================================================================================
UDF with primitive types
================================================================================================
OpenJDK 64-Bit Server VM 21.0.8+9-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 29 29 1 3.5 286.3 1.0X
long/nullable int to string wholestage on 31 36 7 3.3 306.8 0.9X
OpenJDK 64-Bit Server VM 21.0.8+9-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 22 22 0 4.5 219.9 1.0X
long/nullable int to option wholestage on 23 29 7 4.4 229.3 1.0X
OpenJDK 64-Bit Server VM 21.0.8+9-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 18 18 0 5.7 176.3 1.0X
long/nullable int to primitive wholestage on 18 20 1 5.5 182.2 1.0X
OpenJDK 64-Bit Server VM 21.0.8+9-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 12 12 0 8.2 122.4 1.0X
With identity UDF 17 21 3 6.1 165.1 0.7X