Skip to content

FUNCTION

1. FUNCTION Statement

The "FUNCTION" statement allows users to process data using ThanoSQL's functoins from the "FUNCTION" modules.

2. FUNCTION Syntax

The "FUNCTION" syntax with an "AS" clause.

query_statement:
    query_expr

FUNCTION (function_module_expression).(function_name_expression)
OPTIONS (
    expression [ , ...]
    )
AS
(query_expr)

The "FUNCTION" syntax with an "FROM" clause.

FUNCTION (function_module_expression).(function_name_expression)
OPTIONS (
    expression [ , ...]
    )
FROM (file_path_expression)

ThanoSQL's Modules and Functions That Can Be Used with 'FUNCTION Statement'

  • compute
    • groupby_emb_mean
    • similarity
  • preprocess
    • video_to_df

Last update: 2023-06-29