H2OPredict Example | Vantage BYOM - H2OPredict Example: Open Source Classification - Teradata Vantage

select * from mldb.H2OPredict(
                  on iris_test
    on (select * from mojo_models where model_id='iris_mojo_xgb') DIMENSION
    using
        Accumulate('id')
) as td;
 
 *** Query completed. 30 rows found. 3 columns returned.
 *** Total elapsed time was 1 second.

id prediction          	    json_report
--------------------- 	--------------------------------
10 setosa                   {"label":"setosa","labelIndex":0,"classProbabilities":{"setosa":0.9952736496925354,"versicolor":0.0033233845606446266,"virginica":0.0014030301244929433}}
65 versicolor               {"label":"versicolor","labelIndex":1,"classProbabilities":{"setosa":0.0035008604172617197,"versicolor":0.9940041899681091,"virginica":0.002494985004886985}}
15 setosa                   {"label":"setosa","labelIndex":0,"classProbabilities":{"setosa":0.9868437647819519,"versicolor":0.011778408661484718,"virginica":0.0013778334250673652}}
 5 setosa                   {"label":"setosa","labelIndex":0,"classProbabilities":{"setosa":0.9952869415283203,"versicolor":0.003323429264128208,"virginica":0.0013896218733862042}}
30 setosa                   {"label":"setosa","labelIndex":0,"classProbabilities":{"setosa":0.9952869415283203,"versicolor":0.003323429264128208,"virginica":0.0013896218733862042}}

...