[SPARK-16850] Improve error message for greatest/least

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.1, 2.1.0
• Component/s: SQL
• Assignee: Peter Lee
• Reporter: Peter Lee
• Created: 02/Aug/16 06:15
• Updated: 02/Aug/16 17:22
• Resolved: 02/Aug/16 11:34

Description

Greatest/least function does not have the most friendly error message for data types:

Error in SQL statement: AnalysisException: cannot resolve 'greatest(CAST(1.0 AS DECIMAL(2,1)), "1.0")' due to data type mismatch: The expressions should all have the same type, got GREATEST (ArrayBuffer(DecimalType(2,1), StringType)).; line 1 pos 7

We should report the human readable data type instead, rather than having "ArrayBuffer" and "StringType".

Issue Links

• links to: [Github] Pull Request #14453 (petermaxlee)