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
...