Updated on 2024-05-07 GMT+08:00

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