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

Teradata Vantageā„¢ - Bring Your Own Model User Guide

Product
Teradata Vantage
Release Number
3.0
Published
May 2022
Last Update
2022-06-02
Content Type
User Guide
Publication ID
B700-1111-051K
Language
English (United States)
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}}

...