Scalar functions

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

Function Categories

• Text Functions - String manipulation and pattern matching
• Math Functions - Mathematical and numeric operations
• Date & Time Functions - Timestamp and temporal operations
• JSON Functions - JSON parsing and querying
• Array Functions - Array manipulation
• Struct Functions - Struct field access and manipulation
• Regex Functions - Regular expression operations
• Conditional Functions - Conditional logic and null handling
• Hashing Functions - Hash computation
• Binary String Functions - Binary data operations
• Other Functions - Miscellaneous functions
• Aggregate Functions - Functions for computing over groups (SUM, AVG, COUNT, etc.)
• Window Functions - OVER-clause analytical functions (ROW_NUMBER, LAG, LEAD, etc.)