BasketGenerator Example | Teradata Vantage - BasketGenerator Example: Partition by player, Default BasketSize - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

Input

sports:

 league player    sport           
 ------ --------- --------------- 
 mens   Albert    baseball       
 womens Angela    tennis         
 mens   Albert    basketball     
 womens Angela    golf           
 mens   Albert    golf           
 womens Angela    baseball       
 mens   James     soccer         
 womens Barbara   basketball     
 mens   James     track and field
 womens Barbara   baseball       
 mens   James     tennis         
 womens Barbara   lacrosse       
 mens   Jerry     rugby          
 womens Christine basketball     
 mens   Louis     baseball       
 womens Christine baseball       
 mens   Louis     basketball     
 womens Christine soccer         
 mens   Martin    soccer         
 womens Dianne    rugby          
 mens   William   tennis         
 womens Dianne    lacrosse       
 mens   William   golf           
 womens Madeleine track and field
 womens Margrethe golf           
 womens Margrethe lacrosse       
 womens Nancy     track and field
 womens Nancy     soccer         
 womens Nancy     tennis         
 womens Ruth      soccer         
 womens Ruth      track and field

SQL Call

CREATE MULTISET TABLE sports_combinations_bg AS (
  SELECT * FROM BasketGenerator (
    ON sports PARTITION BY player
      USING
      TargetColumns('sport')
      Basketsize(2)
      Accumulate('player')
      OutputCombinations('true')
  ) AS dt
) WITH DATA;

Output

SELECT * FROM sports_combinations_bg;
 player    sport1     sport2          
 --------- ---------- --------------- 
 Barbara   basketball lacrosse       
 Louis     baseball   basketball     
 William   golf       tennis         
 Nancy     soccer     track and field
 Barbara   baseball   lacrosse       
 Margrethe golf       lacrosse       
 Nancy     soccer     tennis         
 Barbara   baseball   basketball     
 Angela    baseball   tennis         
 Nancy     tennis     track and field
 Angela    golf       tennis         
 Dianne    lacrosse   rugby          
 Angela    baseball   golf           
 Albert    basketball golf           
 Christine baseball   soccer         
 Albert    baseball   golf           
 Christine basketball soccer         
 Albert    baseball   basketball     
 Christine baseball   basketball     
 Ruth      soccer     track and field
 James     tennis     track and field
 James     soccer     track and field
 James     soccer     tennis