You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Greg Rahn (Jira)" <ji...@apache.org> on 2019/08/24 01:30:00 UTC
[jira] [Commented] (IMPALA-8891) concat_ws() null handling is
non-standard
[ 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-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org