DenineLu commented on PR #48470: URL: https://github.com/apache/spark/pull/48470#issuecomment-2641848389
> Please investigate more databases, then we make the decision which is the more suitable behavior. For the split(str, regex, limit) function, the limit parameter controls the number of times regex is applied. I checked the related functions of mainstream databases. Except for presto and trino, there are basically no similar functions. | Database/SQLEngine | Behavior of this function | |--------|--------| | PostgreSQL | There is no similar function | | MySQL | There is no similar function | | Oracle | There is no similar function | | MariaDB | There is no similar function | | Microsoft SQL Server | There is no similar function | | Hive | There is no similar function | | PrestoDB | The behavior is consistent with this PR, and the functionality is implemented earlier than Spark | | Trino | The behavior is consistent with this PR, and the functionality is implemented earlier than Spark | -- 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]
