Sheng Wang created IMPALA-11049:
-----------------------------------
Summary: Query order by clause contains cast expr execute failed
after 'SimplifyCastExprRule' rewrite
Key: IMPALA-11049
URL: https://issues.apache.org/jira/browse/IMPALA-11049
Project: IMPALA
Issue Type: Bug
Components: Frontend
Affects Versions: Impala 4.1.0
Reporter: Sheng Wang
Assignee: Sheng Wang
When add new rewrite rule 'SimplifyCastExprRule' in IMPALA-10836, this query
will execute failed:
{code:java}
explain
SELECT month(to_timestamp(cast(d_date_sk AS string),'yyyy-MM-dd')) aa
FROM date_dim
GROUP BY month(to_timestamp(cast(d_date_sk AS string),'yyyy-MM-dd'))
ORDER BY month(to_timestamp(cast(d_date_sk AS string),'yyyy-MM-dd')) LIMIT 10;
{code}
The exception is:
{code:java}
ERROR: AnalysisException: No matching function with signature:
to_timestamp(INT, STRING).
{code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
