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