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