Skip to main content

Scalar / Map Functions Overview

Scalar / Map functions in FlockMTL operate on data row-by-row, providing powerful operations for text processing, embeddings, and machine learning tasks directly within SQL queries.

1. Available Functions​

  • llm_complete: Generates text completions based on model and prompt

  • llm_complete_json: Generates text completions in JSON format for structured output

  • llm_filter: Filters rows based on a prompt and returns boolean values

  • llm_embedding: Generates vector embeddings for text data, used for similarity search and machine learning tasks

  • fusion_relative: Combines two numerical values into a single, unified relevance score.

2. Function Characteristics​

  • Applied row-by-row to table data
  • Supports text generation, filtering, and embeddings

3. Use Cases​

  • Text generation
  • Dynamic filtering
  • Semantic text representation
  • Machine learning feature creation