Kent Yao created SPARK-29737:
--------------------------------
Summary: Concat for array in Spark SQL is not the one in
PostgreSQL but array_cat
Key: SPARK-29737
URL: https://issues.apache.org/jira/browse/SPARK-29737
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 3.0.0
Reporter: Kent Yao
{code:sql}
postgres=# select array_cat(array[1,2], array[2]);
array_cat
-----------
{1,2,2}
(1 row)
postgres=# select concat(array[1,2], array[2]);
concat
----------
{1,2}{2}
(1 row)
{code}
{code:sql}
// Some comments here
spark-sql> select concat(array(1,2), array(2));
[1,2,2]
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
