PREDICT BY

Function

PREDICT BY uses a trained model to perform inference tasks.

Precautions

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

Syntax

PredictBy ::= PREDICT BY model_name [ (FEATURES attribute [, attribute]) ]

Parameter Description

• model_name

  Name of the model of a speculative task.

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

• attribute

  Name of the input feature column of a speculative task.

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

Examples

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

Helpful Links

CREATE MODEL and DROP MODEL