Input
sports, as in BasketGenerator Example: Partition by player, Default BasketSize
SQL Call
CREATE MULTISET TABLE sports_combinations_3 AS (
SELECT * FROM BasketGenerator (
ON sports PARTITION BY player
USING
TargetColumns('sport')
Basketsize(3)
Accumulate('player')
OutputCombinations('true')
) AS dt
) WITH DATA;
Output
SELECT * FROM sports_combinations_3;
player sport1 sport2 sport3 --------- -------- ---------- --------------- Barbara baseball basketball lacrosse Angela baseball golf tennis Nancy soccer tennis track and field Christine baseball basketball soccer Albert baseball basketball golf James soccer tennis track and field