> ## Documentation Index
> Fetch the complete documentation index at: https://docs.e6data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Scalar functions

> Ingest Engine provides a comprehensive set of built-in SQL functions powered by Apache DataFusion.

## Function Categories

* [Text Functions](/ingest/sql/functions/text) - String manipulation and pattern matching
* [Math Functions](/ingest/sql/functions/math) - Mathematical and numeric operations
* [Date & Time Functions](/ingest/sql/functions/datetime) - Timestamp and temporal operations
* [JSON Functions](/ingest/sql/functions/json) - JSON parsing and querying
* [Array Functions](/ingest/sql/functions/array) - Array manipulation
* [Struct Functions](/ingest/sql/functions/struct) - Struct field access and manipulation
* [Regex Functions](/ingest/sql/functions/regex) - Regular expression operations
* [Conditional Functions](/ingest/sql/functions/conditional) - Conditional logic and null handling
* [Hashing Functions](/ingest/sql/functions/hashing) - Hash computation
* [Binary String Functions](/ingest/sql/functions/binary) - Binary data operations
* [Other Functions](/ingest/sql/functions/other) - Miscellaneous functions
* [Aggregate Functions](/ingest/sql/aggregate-window/aggregates) - Functions for computing over groups (SUM, AVG, COUNT, etc.)
* [Window Functions](/ingest/sql/aggregate-window/window) - OVER-clause analytical functions (ROW\_NUMBER, LAG, LEAD, etc.)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.