ViLT

Notation Conventions

• Parentheses () indicate literal parentheses.
• Braces {} are used to bind combinations of options.
• The bracket [] indicates an optional clause.
• An ellipsis following a comma in brackets [,...] means that the preceding item can be repeated as a comma-separated list
• The vertical bar | represents the logic OR.
• VALUE represents a regular value.

• literal: a fixed or unchangeable value, also known as a Constant.

  Each literal has a special data type such as column, in the table.

PREDICT Syntax

Use the "PREDICT" statement to apply AI models to perform prediction, classification, recommendation, and more. The "PREDICT" statement can preprocess the dataset defined by the query_expr that comes after the "AS" clause.

query_statement:
    query_expr

PREDICT USING (model_name_expression)
OPTIONS (
    expression [ , ...]
    )
AS
(query_expr)

OPTIONS Clause

OPTIONS (
    (image_col=column_name),
    (question=expression),
    [result_col=column_name]
    )

The "OPTIONS" clause allows you to change the value of a parameter. The definition of each parameter is as follows.

• "image_col": the column containing the image path to be used for prediction (str, default: 'image_path')
• "question": the question text to be used for prediction (str)
• "result_col": defines the name of the column to contain the result (str, optional, default: "predict_result")

PREDICT Example

An example "PREDICT" query can be found in Use the Visual Question Answering Model.

%%thanosql
PREDICT USING tutorial_vilt
OPTIONS (
    image_col='image_path',
    question='How many people are there?',
    result_col='predict_result'
    )
AS
SELECT image_path
FROM coco_person_data

---

Last update: 2023-08-09