SEARCH¶

1. SEARCH Statement¶

The "SEARCH" statement allows users to search for content, meaning, or similarity from the unstructured data table.

2. SEARCH Syntax¶

query_statement:
    query_expr

SEARCH { IMAGE | AUDIO | VIDEO | TEXT | KEYWORD }
USING (model_name_expression)
OPTIONS (
    expression [ , ...]
    )
AS
(query_expr)

3. SEARCH Example¶

Note

Examples are specific to one model, and the required option values or the dataset used may differ from model to model. For a detailed description of each model, refer to the ThanoSQL Model Statement Reference
Because the example only works when a specific model and dataset are present, it may not run normally if copied and used as is.

%%thanosql
SEARCH IMAGE
USING my_image_search_model
OPTIONS (
    search_by='image',
    search_input='thanosql-dataset/mnist_data/test/923.jpg',
    emb_col='convert_result',
    result_col='search_result'
    )
AS
SELECT *
FROM mnist_test

AI Models That Can Be Used with 'SEARCH Statement'

SimCLR Model - SimCLR
CLIP Model - CLIP
XCLIP Model - XCLIP
SBERT Model - SBERTKo, SBERTEn

Last update: 2023-08-09