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}
         65 32.91362762451172         {"medv":32.91362762451172}
         70 20.848833084106445        {"medv":20.848833084106445}
         75 24.026567459106445        {"medv":24.026567459106445}
         80 20.555028915405273        {"medv":20.555028915405273}
         85 23.736927032470703        {"medv":23.736927032470703}
         90 28.79351043701172         {"medv":28.79351043701172}     

...