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: reviews-unsubscr...@spark.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
