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.

NOTE: In the Lite scenario, openGauss provides this syntax, but the AI capabilities are unavailable.

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