DataRobotPredict Example regression model | Vantage BYOM - DataRobotPredict Example: Regression Model - Teradata Vantage

select * from td_mldb.DataRobotPredict(
 on boston_example_test
 on (select * from datarobot_models where model_id='dr_boston_xgb') DIMENSION
 using
  Accumulate('id')
) as td order by id;
 
 *** Query completed. 101 rows found. 3 columns returned.
 *** Total elapsed time was 1 second.

         id prediction                json_report
-----------------------------      --------------------------------------------------------------------------------------------------------------------------------
          5 36.11499786376953         {"medv":36.11499786376953}
         10 18.93526268005371         {"medv":18.93526268005371}
         15 18.264379501342773        {"medv":18.264379501342773}
         20 18.2293701171875          {"medv":18.2293701171875}
         25 15.62967586517334         {"medv":15.62967586517334}
         30 20.996551513671875        {"medv":20.996551513671875}
         35 13.5652437210083          {"medv":13.5652437210083}
         40 30.703725814819336        {"medv":30.703725814819336}
         45 21.263559341430664        {"medv":21.263559341430664}
         50 19.367938995361328        {"medv":19.367938995361328}
         55 18.808298110961914        {"medv":18.808298110961914}
         60 19.907033920288086        {"medv":19.907033920288086}
...