MLeapPredict Example: Accumulate All - Teradata Vantage

select * from td_MLDB.MLeapPredict(
      on (select top 10 * from iris_example) as InputTable
      on (select model_id, model from mleap_models where model_id='scikit-iris.lr') as ModelTable DIMENSION
      using
      Accumulate('*')
      ModelInputFieldsMap('features=sepal_length, sepal_width, petal_length, petal_width')
  ) as dt;
 *** Query completed. 10 rows found. 8 columns returned. 
 *** Total elapsed time was 1 second.

          id         120
sepal_length  6.00000000000000E 000
 sepal_width  2.20000000000000E 000
petal_length  5.00000000000000E 000
 petal_width  1.50000000000000E 000
     species 3
  prediction 1.0
 json_report {"json_report":"{\"prediction\":\"1.0\"}","prediction":"1.0"}
          id         118
sepal_length  7.70000000000000E 000
 sepal_width  3.80000000000000E 000
petal_length  6.70000000000000E 000
 petal_width  2.20000000000000E 000
     species 3
  prediction 1.0
 json_report {"json_report":"{\"prediction\":\"1.0\"}","prediction":"1.0"}
          id          55
sepal_length  6.50000000000000E 000
 sepal_width  2.80000000000000E 000
petal_length  4.60000000000000E 000
 petal_width  1.50000000000000E 000
     species 2
  prediction 1.0
 json_report {"json_report":"{\"prediction\":\"1.0\"}","prediction":"1.0"}
          id          95
sepal_length  5.60000000000000E 000
 sepal_width  2.70000000000000E 000
petal_length  4.20000000000000E 000
 petal_width  1.30000000000000E 000
     species 2
  prediction 1.0
 json_report {"json_report":"{\"prediction\":\"1.0\"}","prediction":"1.0"}
          id          72
sepal_length  6.10000000000000E 000
 sepal_width  2.80000000000000E 000
petal_length  4.00000000000000E 000
 petal_width  1.30000000000000E 000
     species 2
  prediction 1.0
 json_report {"json_report":"{\"prediction\":\"1.0\"}","prediction":"1.0"}
          id         112
sepal_length  6.40000000000000E 000
 sepal_width  2.70000000000000E 000
petal_length  5.30000000000000E 000
 petal_width  1.90000000000000E 000
     species 3
  prediction 1.0
 json_report {"json_report":"{\"prediction\":\"1.0\"}","prediction":"1.0"}
          id         135
sepal_length  6.10000000000000E 000
 sepal_width  2.60000000000000E 000
petal_length  5.60000000000000E 000
 petal_width  1.40000000000000E 000
     species 3
  prediction 1.0
 json_report {"json_report":"{\"prediction\":\"1.0\"}","prediction":"1.0"}
          id          57
sepal_length  6.30000000000000E 000
 sepal_width  3.30000000000000E 000
petal_length  4.70000000000000E 000
 petal_width  1.60000000000000E 000
     species 2
  prediction 1.0
 json_report {"json_report":"{\"prediction\":\"1.0\"}","prediction":"1.0"}
          id          80
sepal_length  5.70000000000000E 000
 sepal_width  2.60000000000000E 000
petal_length  3.50000000000000E 000
 petal_width  1.00000000000000E 000
     species 2
  prediction 1.0
 json_report {"json_report":"{\"prediction\":\"1.0\"}","prediction":"1.0"}
          id          40
sepal_length  5.10000000000000E 000
 sepal_width  3.40000000000000E 000
petal_length  1.50000000000000E 000
 petal_width  2.00000000000000E-001
     species 1
  prediction 1.0
 json_report {"json_report":"{\"prediction\":\"1.0\"}","prediction":"1.0"}