[FLINK-33478] Fail to call unix_timestamp when it is in filter condition

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.19.0
• Component/s: Connectors / Hive
• Labels: pull-request-available
• Assignee: yunfan
• Reporter: yunfan
• Created: 07/Nov/23 11:17
• Updated: 13/Nov/23 11:35
• Resolved: 13/Nov/23 11:31

Description

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

Issue Links

• links to: GitHub Pull Request #23682