/* syntax version 1 */ select AGGREGATE_LIST_DISTINCT(x) from (select [[1,2],[1,2,3],YQL::LazyList([1,2])] as x) flatten list by x; select AGGREGATE_LIST_DISTINCT(x) from (select [YQL::LazyList([1,2]),[1,3], YQL::LazyList([1,2])] as x) flatten list by x;