[SPARK-29737] Concat for array in Spark SQL is not the one in PostgreSQL but array_cat

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Later
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Kent Yao 2
• Created: 04/Nov/19 02:14
• Updated: 29/Dec/19 06:41
• Resolved: 01/Dec/19 23:17

Description

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)

// Some comments here
spark-sql> select concat(array(1,2), array(2));
[1,2,2]