[IMPALA-8891] concat_ws() null handling is non-standard

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 3.2.0, Impala 3.3.0
• Fix Version/s: Impala 3.4.0
• Component/s: Backend
• Labels: newbie
• Target Version: Impala 3.4.0
• Epic Color: ghx-label-5
• Assignee: jichen
• Reporter: Tim Armstrong
• Created: 23/Aug/19 23:56
• Updated: 27/Dec/19 07:19
• Resolved: 27/Dec/19 03:45

Description

grahn reports

Looks like Impala’s CONCAT_WS() does not behave correctly if an argument is NULL — it returns NULL and it should not. Mismatch between Hive/MySQL and Impala (and apologies for not filing a bug)