2.0 - H2OPredict Example: Open Source 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 energy)
    on (select * from mojo_models where model_id='reg_energy_mojo_glm') DIMENSION
    using
        Accumulate('id')
) as td;
 
 *** Query completed. 10 rows found. 3 columns returned.
 *** Total elapsed time was 1 second.
		id prediction                json_report
		----------- 			  ------------------------- 
       9054 12197.600119318555        {"value":12197.600119318555}
       6505 12692.12097360356         {"value":12692.12097360356}
      15090 18403.590703679583        {"value":18403.590703679583}
       9523 15207.681568032876        {"value":15207.681568032876}
       4425 20613.468027265342        {"value":20613.468027265342}
      27162 11816.958433805368        {"value":11816.958433805368}
      29711 13451.78074972952         {"value":13451.78074972952}
      17639 18187.92292658962         {"value":18187.92292658962}
      11603 12828.525899431042        {"value":12828.525899431042}
      19719 11215.42064619414         {"value":11215.42064619414}