Skip to content

Improve performance of translate expression #2976

@andygrove

Description

@andygrove

What is the problem the feature request solves?

CometStringExpressionBenchmark shows poor performance:

OpenJDK 64-Bit Server VM 11.0.22+7-LTS on Mac OS X 14.6.1
Apple M3 Max
translate:                                Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Spark                                                12             45          40          0.1       11898.4       1.0X
Comet (Scan)                                         14             82          39          0.1       13301.5       0.9X
Comet (Scan + Exec)                                  96            159          38          0.0       93534.9       0.1X

Describe the potential solution

Review benchmark to make sure it is valid, then try and optimize.

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions