HyukjinKwon commented on a change in pull request #35831:
URL: https://github.com/apache/spark/pull/35831#discussion_r825587972
##########
File path:
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/expressions/numberFormatExpressions.scala
##########
@@ -52,6 +52,11 @@ import org.apache.spark.unsafe.types.UTF8String
> SELECT _FUNC_('12,454.8-', '99G999D9S');
-12454.8
""",
+ note = """
+ ToNumber has better compatibility with number format based on the
underlying implementation.
+ For example: to_number('1,11,6.11', '000,,0.00') works good and returns
1116.11. Please see
+ the implementation of NumberFormatter.
Review comment:
```suggestion
the implementation of
`org.apache.spark.sql.catalyst.util.NumberFormatter`.
```
--
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]