1.1 - 8.10 - Antiselect_MLE Example - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Input

The input table, antiselect_input, is a sample set of sales data.

antiselect_input
rowids orderid orderdate priority quantity sales discount shipmode custname province region custsegment prodcat
1 3 2010-10-13 00:00:00 Low 6 261.54 0.04 Regular Air Muhammed MacIntyre Nunavut Nunavut Small Business Office Supplies
49 293 2012-10-01 00:00:00 High 49 10123 0.07 Delivery Truck Barry French Nunavut Nunavut Consumer Office Supplies
50 293 2012-10-01 00:00:00 High 27 244.57 0.01 Regular Air Barry French Nunavut Nunavut Consumer Office Supplies
80 483 2011-07-10 00:00:00 High 30 4965.76 0.08 Regular Air Clay Rozendal Nunavut Nunavut Corporate Technology
85 515 2010-08-28 00:00:00 Not Specified 19 394.27 0.08 Regular Air Carlos Soltero Nunavut Nunavut Consumer Office Supplies
86 515 2010-08-28 00:00:00 Not Specified 21 146.69 0.05 Regular Air Carlos Soltero Nunavut Nunavut Consumer Furniture
97 613 2011-06-17 00:00:00 High 12 93.54 0.03 Regular Air Carl Jackson Nunavut Nunavut Corporate Office Supplies

SQL Call

SELECT * FROM Antiselect_MLE(
  ON antiselect_input
  USING
  EXCLUDE ('rowids','orderdate','discount', 'province', 'custsegment')
) AS dt ;

Output

The output table excludes the specified columns and outputs the remaining columns.

 orderid priority   quantity sales     shipmode       custname           region  prodcat         
 ------- ---------- -------- --------- -------------- ------------------ ------- --------------- 
     613 high             12     93.54 regular air    carl jackson       nunavut office supplies
     293 high             49  10123.02 delivery truck barry french       nunavut office supplies
     515 not specif       19    394.27 regular air    carlos soltero     nunavut office supplies
       3 low               6    261.54 regular air    muhammed macintyre nunavut office supplies
     515 not specif       21    146.69 regular air    carlos soltero     nunavut furniture      
     483 high             30 4965.7595 regular air    clay rozendal      nunavut technology     
     293 high             27    244.57 regular air    barry french       nunavut office supplies

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.