EVALUATE_MODEL - Kinetica Docs

SELECT * FROM TABLE( EVALUATE_MODEL ( MODEL => '<model name>', DEPLOYMENT_MODE => 'BATCH', REPLICATIONS => <number of replications>, SOURCE_TABLE => INPUT_TABLE(<source data set>) ) )

EXECUTE FUNCTION EVALUATE_MODEL( MODEL => '<model name>', DEPLOYMENT_MODE => '<BATCH | CONTINUOUS>', REPLICATIONS => <number of replications>, SOURCE_TABLE => INPUT_TABLE(<source data set>), DESTINATION_TABLE => '<destination table name>' )

Parameters

MODEL

Name of the ML model on which to run an inference

DEPLOYMENT_MODE

Scheme used in making inferences on the ML model:

BATCH - inference tests are run against a batch of data in an existing table all at once
CONTINUOUS - inference tests are run automatically against records being streamed into an input table; inference results are inserted into an output table, which will be updated upon each subsequent inference
Continuous deployment mode is only available when using the EXECUTE FUNCTION syntax, as it creates a destination table with the continuously updated results.

REPLICATIONS

The number of replicas to launch on Kubernetes

SOURCE_TABLE

Table or query to use as input to the ML model, specified with either of these two forms:

INPUT_TABLE(<table name>) - Use the given table or view as input; e.g.:
INPUT_TABLE(price_history)
INPUT_TABLE(<query>) - Use the given query as input; e.g.:
INPUT_TABLE(SELECT ts, item, price FROM price_history)

DESTINATION_TABLE

Only applicable when using EXECUTE FUNCTION syntax. Name of the table in which to store the results of the inference, in [schema_name.]table_name format, using standard name resolution rules and meeting table naming criteria

Examples

EVALUATE_MODEL Table Function Example

SELECT * FROM TABLE(
    EVALUATE_MODEL
    (
        MODEL => 'raster_model',
        DEPLOYMENT_MODE => 'batch',
        REPLICATIONS =>1,
        SOURCE_TABLE => INPUT_TABLE(select raster_uri from ki_home.raster_input)
    )
)

EVALUATE_MODEL EXECUTE FUNCTION Example

EXECUTE FUNCTION EVALUATE_MODEL(
    MODEL => 'raster_model',
    DEPLOYMENT_MODE => 'batch',
    REPLICATIONS =>1,
    SOURCE_TABLE => INPUT_TABLE(select raster_uri from ki_home.raster_input),
    DESTINATION_TABLE => 'raster_output'
)

​Parameters

​Examples

Parameters

Examples