DAI Regression Example | Vantage BYOM - 2.0 - H2OPredict Example: DAI Regression - 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 (select top 10 * from boston_test)
    on (select * from h2o_models where model_id='pipeline_boston_model') DIMENSION
    using
        Accumulate('id')
        ModelType('DAI')
        OverWriteCachedModel('*')
) 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"}