MLeapPredict Example: Regression Model - Teradata Vantage

select * from td_MLDB.MLeapPredict(
      on (select top 10 * from boston_example) as InputTable
      on (select model_id, model from mleap_models where model_id='mleap_lr_boston') as ModelTable DIMENSION
      using
      Accumulate('id')
      ModelInputFieldsMap('features=crim,zn,indus,chas,nox,rm,age,dis,rad,tax,ptratio,black,lstat')
  ) as dt;
 *** Query completed. 10 rows found. 3 columns returned. 
 *** Total elapsed time was 1 second.

         id         223
 prediction 32.25722302814063
json_report {"json_report":"{\"prediction\":\"32.25722302814063\"}","prediction":"32.25722302814063"}
         id          80
 prediction 22.078257345253938
json_report {"json_report":"{\"prediction\":\"22.078257345253938\"}","prediction":"22.078257345253938"}
         id         345
 prediction 28.496160806921697
json_report {"json_report":"{\"prediction\":\"28.496160806921697\"}","prediction":"28.496160806921697"}
         id         406
 prediction 6.948311422196614
json_report {"json_report":"{\"prediction\":\"6.948311422196614\"}","prediction":"6.948311422196614"}
         id         446
 prediction 12.637410246480488
json_report {"json_report":"{\"prediction\":\"12.637410246480488\"}","prediction":"12.637410246480488"}
         id         343
 prediction 21.74288980413595
json_report {"json_report":"{\"prediction\":\"21.74288980413595\"}","prediction":"21.74288980413595"}
         id         120
 prediction 20.281205605625015
json_report {"json_report":"{\"prediction\":\"20.281205605625015\"}","prediction":"20.281205605625015"}
         id         488
 prediction 20.1048540839263
json_report {"json_report":"{\"prediction\":\"20.1048540839263\"}","prediction":"20.1048540839263"}
         id         162
 prediction 36.0549742073533
json_report {"json_report":"{\"prediction\":\"36.0549742073533\"}","prediction":"36.0549742073533"}
         id          40
 prediction 31.351251241228603
json_report {"json_report":"{\"prediction\":\"31.351251241228603\"}","prediction":"31.351251241228603"}