blob: 746babff4bf4f8ca6147e89dd11dc64cfb0e2f54 [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 124 149 34 0.8 1243.3 1.0X
long/nullable int/string to string wholestage on 67 81 9 1.5 667.5 1.9X
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 43 50 9 2.3 431.5 1.0X
long/nullable int/string to option wholestage on 38 42 3 2.6 378.6 1.1X
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 30 31 1 3.3 304.0 1.0X
long/nullable int/string to primitive wholestage on 31 37 5 3.2 308.7 1.0X
================================================================================================
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 31 31 1 3.3 306.2 1.0X
long/nullable int to string wholestage on 30 33 2 3.3 303.4 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 32 32 0 3.1 320.4 1.0X
long/nullable int to option wholestage on 21 25 5 4.7 213.7 1.5X
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 20 22 2 4.9 202.8 1.0X
long/nullable int to primitive wholestage on 17 18 1 5.8 172.3 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
UDF identity overhead: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Baseline 11 13 3 9.1 109.9 1.0X
With identity UDF 16 17 1 6.1 164.9 0.7X