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