select * from td_mldb.DataRobotPredict(
on iris_example_test
on (select * from datarobot_models where model_id='dr_iris_rf') DIMENSION
using
Accumulate('*')
ModelOutputFields('1', '2', '3')
) as td order by id;
*** 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 1 2 3
------ ------------------- ------------------- ------------------ ------------------ ----- ------------------ ----------------- ------------------- -----------
5 5.00000000000000E 000 3.60000000000000E 000 1.40000000000000E 000 2.00000000000000E-001 1 '1' 1.0 0.0 0.0
10 4.90000000000000E 000 3.10000000000000E 000 1.50000000000000E 000 1.00000000000000E-001 1 '1' 1.0 0.0 0.0
15 5.80000000000000E 000 4.00000000000000E 000 1.20000000000000E 000 2.00000000000000E-001 1 '1' 1.0 0.0 0.0
20 5.10000000000000E 000 3.80000000000000E 000 1.50000000000000E 000 3.00000000000000E-001 1 '1' 1.0 0.0 0.0
25 4.80000000000000E 000 3.40000000000000E 000 1.90000000000000E 000 2.00000000000000E-001 1 '1' 0.9993333333333333 6.666666666666666E-4 0.0
...