V4.1 

Parameters, Value

Array Union function calculates, deduplicates, and returns all the elements of two arrays as array, i.e. returns the union of the two arrays (repeated elements are NOT allowed within the arrays).

If the two arrays are not homologous: when used in WITH, intersection() will first make a Cartesian Product Combination of all columns and its homologous columns before calculation; when used in RETURN, intersection() will trim all columns and their homologous columns before calculation.

Syntax:

• Format: array_union(<array1>, <array2>)
• Parameters: see table below
• Value: ARRAY

Common Usage

Example: Find all the neighbors of Card CA001 and CA002, deduplicate them and return as array

khop().src({_id == "CA001"}).depth(1) as n1
khop().src({_id == "CA002"}).depth(1) as n2
with collect(n1) as a1, collect(n2) as a2
return array_union(a1, a2)