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

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

Product
Teradata Vantage
Release Number
2.0
Release Date
October 2021
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}}

...