[IMPALA-11049] Order by clause contains cast expr execute failed after 'SimplifyCastExprRule' rewrite

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 4.1.0
• Fix Version/s: Impala 4.1.0
• Component/s: Frontend
• Epic Color: ghx-label-12
• Assignee: Sheng Wang
• Reporter: Sheng Wang
• Created: 07/Dec/21 13:15
• Updated: 14/Sep/22 09:27
• Resolved: 21/Feb/22 02:30

Description

When add new rewrite rule 'SimplifyCastExprRule' in IMPALA-10836, this query will execute failed:

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;

The exception is:

ERROR: AnalysisException: No matching function with signature: to_timestamp(INT, STRING).

Issue Links

• is caused by: IMPALA-10836 Add simplify cast rule