[IMPALA-10175] Extend error message when cast(..format..) fails in parse phase

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: Backend
• Labels: supportability
• Target Version: Impala 4.0.0
• Epic Color: ghx-label-6
• Assignee: Gabor Kaszab
• Reporter: Gabor Kaszab
• Created: 18/Sep/20 11:20
• Updated: 06/Oct/20 06:09
• Resolved: 06/Oct/20 06:09

Description

select cast('0;367' as date format 'YY;DDD'); 
ERROR: UDF ERROR: String to Date parse failed. Invalid string val: "0;367"

Here the output contains the input string but would be more helpful for debugging if it also contained the original format string as well.

This applies to String to Date conversions only as String to Timestamp failures currently doesn't raise an error.