DataRobotPredict Example ModelOutputFields | Vantage BYOM - DataRobotPredict Example: ModelOutputFields - 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 td_mldb.DataRobotPredict(
 on iris_example_test
 on (select * from datarobot_models where model_id='dr_iris_rf') DIMENSION
 using
  Accumulate('id')
  ModelOutputFields('1', '2', '3')
) as td order by id;
 
 *** Query completed. 30 rows found. 5 columns returned.
 *** Total elapsed time was 1 second.
    id  prediction                 1                          2                          3
------  -------------------------  -------------------------  -------------------------  -------------------------
     5  '1'                        1.0                        0.0                        0.0
    10  '1'                        1.0                        0.0                        0.0
    15  '1'                        1.0                        0.0                        0.0
    20  '1'                        1.0                        0.0                        0.0
    25  '1'                        0.9993333333333333         6.666666666666666E-4       0.0
    30  '1'                        1.0                        0.0                        0.0
    35  '1'                        1.0                        0.0                        0.0
    40  '1'                        1.0                        0.0                        0.0
    45  '1'                        0.9993333333333333         6.666666666666666E-4       0.0
    50  '1'                        0.9996                     4.0E-4                     0.0
    55  '2'                        0.0                        0.9924712121212121         0.00752878787878788
    60  '2'                        8.571428571428571E-4       0.9805166666666659         0.018626190476190484
    65  '2'                        0.0                        1.0                        0.0
    70  '2'                        0.0                        0.9996                     4.0E-4

...