PREDICT BY

Description

Uses a trained model to perform prediction tasks.

Precautions

The name of the invoked model can be viewed in the gs_model_warehouse system catalog.

Syntax

PREDICT BY model_name (FEATURES attribute [, attribute] +])

Parameters

• model_name

  Name of the model of a prediction task.

  Value range: a string. It must comply with the naming convention.

• attribute

  Name of the input feature column of a prediction task.

  Value range: a string. It must comply with the naming convention.

Examples

SELECT id, PREDICT BY price_model (FEATURES size,lot), price
FROM houses;

Helpful Links

CREATE MODEL and DROP MODEL