DataikuPredict Example Accumulate All | Vantage BYOM - DataikuPredict Example: Accumulate All - Teradata Vantage

Teradata Vantageā„¢ - Bring Your Own Model User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Vantage
Release Number
5.0
Published
October 2023
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
fee1607120608274.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
fee1607120608274
select * from mldb.DataikuPredict(
    on iris_test
    on (select * from dataiku_models where model_id='di_ir_dt_ann_thin') DIMENSION
    using
        Accumulate('*')
        ModelOutputFields('prob_class_1', 'prob_class_2', 'prob_class_3')
) as td;
 
 *** Query completed. 30 rows found. 10 columns returned.
 *** Total elapsed time was 1 second.
  id           sepal_length            sepal_width           petal_length            petal_width species prediction                          prob_class_1           prob_class_2           prob_c
----------- ---------------------- ---------------------- ---------------------- ---------------------- ------- ------------------------- ---------------------- ---------------------- ----------------
         80  5.70000000000000E 000  2.60000000000000E 000  3.50000000000000E 000  1.00000000000000E 000 2       '2'                        1.53854180948231E-001  5.72966922525834E-001        2.7317889
         45  5.10000000000000E 000  3.80000000000000E 000  1.90000000000000E 000  4.00000000000000E-001 1       '1'                        5.50278293446435E-001  2.08564801923961E-001        2.4115690
         15  5.80000000000000E 000  4.00000000000000E 000  1.20000000000000E 000  2.00000000000000E-001 1       '1'                        5.47614849489500E-001  2.46803242846266E-001        2.0558190
         30  4.70000000000000E 000  3.20000000000000E 000  1.60000000000000E 000  2.00000000000000E-001 1       '1'                        6.86033665041149E-001  2.44330841110628E-001        6.9635493
         25  4.80000000000000E 000  3.40000000000000E 000  1.90000000000000E 000  2.00000000000000E-001 1       '1'                        6.67344599359180E-001  2.23640791801192E-001        1.0901460
         70  5.60000000000000E 000  2.50000000000000E 000  3.90000000000000E 000  1.10000000000000E 000 2       '2'                        1.51616330779325E-001  5.98237479580355E-001        2.5014618
        115  5.80000000000000E 000  2.80000000000000E 000  5.10000000000000E 000  2.40000000000000E 000 3       '3'                        2.29643329432127E-001  2.71858285183762E-001        4.9849838
        135  6.10000000000000E 000  2.60000000000000E 000  5.60000000000000E 000  1.40000000000000E 000 3       '2'                        1.38068505504949E-001  4.76056849478520E-001        3.8587464
         50  5.00000000000000E 000  3.30000000000000E 000  1.40000000000000E 000  2.00000000000000E-001 1       '1'                        6.35244927358983E-001  2.73741307045712E-001        9.1013765
        100  5.70000000000000E 000  2.80000000000000E 000  4.10000000000000E 000  1.30000000000000E 000 2       '2'                        2.13397540533824E-001  4.66484351832557E-001        3.2011810
          5  5.00000000000000E 000  3.60000000000000E 000  1.40000000000000E 000  2.00000000000000E-001 1       '1'                        6.30796344874431E-001  2.41250774753956E-001        1.2795288
...