DataikuPredict Example: Results Stored in a Table | Vantage BYOM - DataikuPredict Example: Results Stored in a Table - 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
create table byomop AS (select * from mldb.DataikuPredict(
 on iris_test as InputTable
 on (select * from dataiku_models where model_id='di_ir_dt_ann_thin') DIMENSION
 using
 Accumulate('id')
) as td) with data;
 
 *** Table has been created.
 *** Total elapsed time was 1 second.
select * from byomop;
 
 *** Query completed. 30 rows found. 3 columns returned.
 *** Total elapsed time was 1 second.
 
         id prediction                json_report
----------- ------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------
         80 '2'                       {"species":"'2'","prob_class_3":0.2731788965259344,"all_class_labels":"['3', '2', '1']","prob_class_2":0.5729669225258344,"prob_class_1":0.15385418094823136,"all_
         45 '1'                       {"species":"'1'","prob_class_3":0.2411569046296039,"all_class_labels":"['3', '2', '1']","prob_class_2":0.20856480192396082,"prob_class_1":0.5502782934464352,"all_
         15 '1'                       {"species":"'1'","prob_class_3":0.20558190766423365,"all_class_labels":"['3', '2', '1']","prob_class_2":0.24680324284626629,"prob_class_1":0.5476148494895,"all_cl
         30 '1'                       {"species":"'1'","prob_class_3":0.06963549384822368,"all_class_labels":"['3', '2', '1']","prob_class_2":0.24433084111062764,"prob_class_1":0.6860336650411486,"all
         25 '1'                       {"species":"'1'","prob_class_3":0.10901460883962828,"all_class_labels":"['3', '2', '1']","prob_class_2":0.22364079180119173,"prob_class_1":0.66734459935918,"all_c
         70 '2'                       {"species":"'2'","prob_class_3":0.25014618964032026,"all_class_labels":"['3', '2', '1']","prob_class_2":0.5982374795803547,"prob_class_1":0.15161633077932507,"all
        115 '3'                       {"species":"'3'","prob_class_3":0.4984983853841108,"all_class_labels":"['3', '2', '1']","prob_class_2":0.2718582851837623,"prob_class_1":0.22964332943212684,"all_
        135 '2'                       {"species":"'2'","prob_class_3":0.38587464501653135,"all_class_labels":"['3', '2', '1']","prob_class_2":0.4760568494785199,"prob_class_1":0.13806850550494876,"all
         50 '1'                       {"species":"'1'","prob_class_3":0.09101376559530465,"all_class_labels":"['3', '2', '1']","prob_class_2":0.2737413070457125,"prob_class_1":0.635244927358983,"all_c
        100 '2'                       {"species":"'2'","prob_class_3":0.3201181076336191,"all_class_labels":"['3', '2', '1']","prob_class_2":0.46648435183255704,"prob_class_1":0.21339754053382382,"all
         40 '1'                       {"species":"'1'","prob_class_3":0.1154634220943346,"all_class_labels":"['3', '2', '1']","prob_class_2":0.26835594528848294,"prob_class_1":0.6161806326171825,"all_
...