bithw1 commented on issue #6412: URL: https://github.com/apache/hudi/issues/6412#issuecomment-1217664091
> @bithw1 Is `$T1` a string or not? As you use 0(integer type) instead of '0'(string type), I'm thinking spark might get the wrong cast, whereas giving the wrong compare result The following two queries get the same result: select * from tbl_order_incremental where _hoodie_commit_time > '20220817073931' and _hoodie_commit_time <= '20220817073953' select * from tbl_order_incremental where _hoodie_commit_time > 20220817073931 and _hoodie_commit_time <= 20220817073953. But the following two queries get different results: All Data: select * from tbl_order_incremental where _hoodie_commit_time > '0' and _hoodie_commit_time <= '20220817073953' Empty Data: select * from tbl_order_incremental where _hoodie_commit_time > 0 and _hoodie_commit_time <= '20220817073953' -- 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]
