RussellSpitzer commented on issue #15427: URL: https://github.com/apache/iceberg/issues/15427#issuecomment-3953259024
@khjoshi94 your example with Athena shows no results for the strict equality? ``` Spark output Spark count with exact match: 0 Spark count with TRIM: 1 Athena output SELECT * FROM example WHERE batch_date = '20240201'; -- returns 0 rows SELECT * FROM example WHERE TRIM(batch_date) = '20240201'; -- returns expected rows ``` Both of these are correct and match the spark behavior "foo " does not exactly match "foo". If Athena did match "foo " on === "foo" I would consider that a bug in Athena. -- 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]
