​
Description

The EVALUATE statement evaluates predictions based on available metrics.

​
Syntax

Here is the syntax:

EVALUATE metric_name
FROM (SELECT real_value AS actual,
             predicted_value AS prediction
      FROM table_name);

Where:

NameDescription
metric_nameIt is the name of the metric to be evaluated chosen from here.
real_valueIt is the real value that will be compared with the predicted value.
predicted_valueIt is the value predicted by the model.
table_nameIt is the table that stores corresponding real and predicted values.

​
Example

This example calculates the mean absolute error.

EVALUATE mean_absolute_error
FROM (SELECT column_name_that_stores_real_value AS actual,
             column_name_that_stores_predicted_value AS prediction
      FROM table);

Was this page helpful?

Join Models with TablesCreate a Table