select * from mldb.DataikuPredict(
on iris_test
on (select * from dataiku_models where model_id='di_ir_dt_ann_thin') DIMENSION
using
Accumulate('id')
ModelOutputFields('prob_class_1', 'prob_class_2', 'prob_class_3')
) as td;
*** Query completed. 30 rows found. 5 columns returned.
*** Total elapsed time was 1 second.
id prediction prob_class_1 prob_class_2 prob_class_3
----------- ------------------------- ---------------------- ---------------------- ----------------------
80 '2' 1.53854180948231E-001 5.72966922525834E-001 2.73178896525934E-001
45 '1' 5.50278293446435E-001 2.08564801923961E-001 2.41156904629604E-001
15 '1' 5.47614849489500E-001 2.46803242846266E-001 2.05581907664234E-001
30 '1' 6.86033665041149E-001 2.44330841110628E-001 6.96354938482237E-002
25 '1' 6.67344599359180E-001 2.23640791801192E-001 1.09014608839628E-001
70 '2' 1.51616330779325E-001 5.98237479580355E-001 2.50146189640320E-001
115 '3' 2.29643329432127E-001 2.71858285183762E-001 4.98498385384111E-001
135 '2' 1.38068505504949E-001 4.76056849478520E-001 3.85874645016531E-001
50 '1' 6.35244927358983E-001 2.73741307045712E-001 9.10137655953046E-002
100 '2' 2.13397540533824E-001 4.66484351832557E-001 3.20118107633619E-001
5 '1' 6.30796344874431E-001 2.41250774753956E-001 1.27952880371613E-001
...