[ https://issues.apache.org/jira/browse/IMPALA-8891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16914757#comment-16914757 ]
Greg Rahn commented on IMPALA-8891: ----------------------------------- {noformat} MariaDB [(none)]> select version(); +----------------+ | version() | +----------------+ | 10.4.6-MariaDB | +----------------+ MariaDB [(none)]> select concat_ws('-','foo',null,'bar') as expr1; +---------+ | expr1 | +---------+ | foo-bar | +---------+ {noformat} {noformat} impala> select version(); +-----------------------------------------------------------------------------------------+ | version() | +-----------------------------------------------------------------------------------------+ | impalad version 3.3.0-SNAPSHOT RELEASE (build df3e7c051e2641524fc53a0cd07c2a14decd55f7) | | Built on Thu Aug 22 19:28:57 UTC 2019 | +-----------------------------------------------------------------------------------------+ impala> select concat_ws('-','foo',null,'bar') as expr1; +-------+ | expr1 | +-------+ | NULL | +-------+ {noformat} {noformat} hive> select version(); +----------------------------------------------------+ | _c0 | +----------------------------------------------------+ | 3.1.2000.7.0.0.0-463 r7db8023511683e2b30c31bcb6ad5b372b1876eab | +----------------------------------------------------+ hive> select concat_ws('-','foo',null,'bar') as expr1; +----------+ | expr1 | +----------+ | foo-bar | +----------+ {noformat} > concat_ws() null handling is non-standard > ----------------------------------------- > > Key: IMPALA-8891 > URL: https://issues.apache.org/jira/browse/IMPALA-8891 > Project: IMPALA > Issue Type: Bug > Components: Backend > Affects Versions: Impala 3.2.0, Impala 3.3.0 > Reporter: Tim Armstrong > Priority: Major > Labels: newbie > > [~grahn] reports > {quote}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) > {quote} -- This message was sent by Atlassian Jira (v8.3.2#803003) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org