qphien edited a comment on pull request #1612: URL: https://github.com/apache/iceberg/pull/1612#issuecomment-719405800
``` hive (iceberg)> desc decimal_table; OK col_name data_type comment val decimal(7,2) from deserializer hive (iceberg)> select * from decimal_table where val > 100.1; OK decimal_table.val Failed with exception java.io.IOException:org.apache.iceberg.exceptions.ValidationException: Invalid value for conversion to type decimal(7, 2): 100.1 (java.math.BigDecimal) ``` This PR throws exception when scale specified in filter is different with iceberg. ``` hive (iceberg)> select * from decimal_table where val > cast(100.1 as decimal(7,2)); OK decimal_table.val Failed with exception java.io.IOException:org.apache.iceberg.exceptions.ValidationException: Invalid value for conversion to type decimal(7, 2): 100.1 (java.math.BigDecimal) ``` Even if 100.1 is cast as decimal(7, 2), hive still throws the same exception. ---------------------------------------------------------------- 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]
