[ https://issues.apache.org/jira/browse/FLINK-33478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
luoyuxia resolved FLINK-33478. ------------------------------ Fix Version/s: 1.19.0 Resolution: Fixed master: 9f04df35f51d63df8d98cd49d7c2bc5090e26004 > Fail to call unix_timestamp when it is in filter condition > ----------------------------------------------------------- > > Key: FLINK-33478 > URL: https://issues.apache.org/jira/browse/FLINK-33478 > Project: Flink > Issue Type: Bug > Components: Connectors / Hive > Reporter: yunfan > Priority: Major > Labels: pull-request-available > Fix For: 1.19.0 > > > It can reproduced by following sql. > select * from foo where cast(unix_timestamp() as bigint) > 0 > It caused by we are not do fold expr in filter expression. > And it is supported by default hive latest version: > Code of hive: > [https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java#L3739] > [https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java#L373] > [https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java#L1020] > https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzerFactory.java#L123 -- This message was sent by Atlassian Jira (v8.20.10#820010)