select * from mldb.H2OPredict( on (select top 10 * from boston_test) on (select * from h2o_models where model_id='pipeline_boston_model') DIMENSION using Accumulate('id') ModelType('DAI') ) as td order by id ; *** Query completed. 10 rows found. 3 columns returned. *** Total elapsed time was 1 second.
id prediction json_report ------------------------ --------------------------------- 40 29.16696548461914 {"MEDV":"29.16696548461914"} 60 19.89491844177246 {"MEDV":"19.89491844177246"} 80 20.544735590616863 {"MEDV":"20.544735590616863"} 160 21.778653462727863 {"MEDV":"21.778653462727863"} 265 35.91741053263346 {"MEDV":"35.91741053263346"} 305 34.44256337483724 {"MEDV":"34.44256337483724"} 320 20.114957173665363 {"MEDV":"20.114957173665363"} 345 28.41218439737956 {"MEDV":"28.41218439737956"} 385 9.526431401570639 {"MEDV":"9.526431401570639"} 425 15.553998947143555 {"MEDV":"15.553998947143555"}