evaluate.mdx

title	EVALUATE
sidebarTitle	Evaluate Predictions

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:

Name	Description
metric_name	It is the name of the metric to be evaluated chosen from here.
real_value	It is the real value that will be compared with the predicted value.
predicted_value	It is the value predicted by the model.
table_name	It 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);