JingsongLi opened a new issue, #736: URL: https://github.com/apache/incubator-paimon/issues/736
### Search before asking - [X] I searched in the [issues](https://github.com/apache/incubator-paimon/issues) and found nothing similar. ### Paimon version 0.4 ### Compute Engine flink ### Minimal reproduce step Use the following test data and SQL to reproduce this issue. gao.csv: 1.0,2.0,aaaaaaaaaaaaaaa 0.0,0.0,aaaaaaaaaaaaaaa 1.0,1.0,aaaaaaaaaaaaaaa 0.0,0.0,aaaaaaaaaaaaaaa 1.0,0.0,aaaaaaaaaaaaaaa 0.0,0.0,aaaaaaaaaaaaaaa -1.0,0.0,aaaaaaaaaaaaaaa 1.0,-1.0,aaaaaaaaaaaaaaa 1.0,-2.0,aaaaaaaaaaaaaaa Flink SQL: Flink SQL> create table T ( a double, b double, c string ) WITH ( 'connector' = 'filesystem', 'path' = '/tmp/gao.csv', 'format' = 'csv' ); [INFO] Execute statement succeed. Flink SQL> create table S ( a string, b double ) WITH ( 'path' = '/tmp/store' ); [INFO] Execute statement succeed. Flink SQL> insert into S select c, a / b from T; [INFO] Submitting SQL update statement to the cluster... [INFO] SQL update statement has been successfully submitted to the cluster: Job ID: 851d7b3c233061733bdabbf30f20d16f Flink SQL> select c, a / b from T; +-----------------+-----------+ | c | EXPR$1 | +-----------------+-----------+ | aaaaaaaaaaaaaaa | 0.5 | | aaaaaaaaaaaaaaa | NaN | | aaaaaaaaaaaaaaa | 1.0 | | aaaaaaaaaaaaaaa | NaN | | aaaaaaaaaaaaaaa | Infinity | | aaaaaaaaaaaaaaa | NaN | | aaaaaaaaaaaaaaa | -Infinity | | aaaaaaaaaaaaaaa | -1.0 | | aaaaaaaaaaaaaaa | -0.5 | +-----------------+-----------+ 9 rows in set Flink SQL> select * from S; +-----------------+-----------+ | a | b | +-----------------+-----------+ | aaaaaaaaaaaaaaa | -Infinity | | aaaaaaaaaaaaaaa | -Infinity | | aaaaaaaaaaaaaaa | -Infinity | | aaaaaaaaaaaaaaa | -Infinity | | aaaaaaaaaaaaaaa | -Infinity | | aaaaaaaaaaaaaaa | -Infinity | | aaaaaaaaaaaaaaa | -Infinity | | aaaaaaaaaaaaaaa | -1.0 | | aaaaaaaaaaaaaaa | -0.5 | +-----------------+-----------+ 9 rows in set Note that this issue may also affect FieldStatsCollector. ### What doesn't meet your expectations? Wrong result ### Anything else? _No response_ ### Are you willing to submit a PR? - [ ] I'm willing to submit a PR! -- 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: issues-unsubscr...@paimon.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
