srowen commented on a change in pull request #31442:
URL: https://github.com/apache/spark/pull/31442#discussion_r569467189
##########
File path: docs/sql-migration-guide.md
##########
@@ -24,6 +24,8 @@ license: |
## Upgrading from Spark SQL 3.1 to 3.2
+ - In Spark 3.2, money type in PostgreSQL table is converted to `StringType`
and money[] type is not supported due to the JDBC driver for PostgreSQL can't
handle those types properly.
Review comment:
Yeah, DecimalType fixes the accuracy problem with money, but can't
account for units. I suppose we could one day support it as a struct of
DecimalType and StringType for currency, but string seems fine now.
Why not a string array for a money array?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
