[
https://issues.apache.org/jira/browse/FLINK-33478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benchao Li reassigned FLINK-33478:
----------------------------------
Assignee: yunfan
> 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
> Assignee: 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)
