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 ​

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