Functions and operators

This chapter describes the SQL functions and operators supported by BDV. They allow you to implement complex functionality and behavior of the SQL executed by BDV operating on the underlying data sources.

If you are looking for a specific function or operator, see the full alphabetical list or the full list by topic.

Also see the SQL data types and the SQL statement and syntax reference.

• Aggregate
• Array
• Binary
• Bitwise
• Color
• Comparison
• Conditional
• Conversion
• Date and time
• Decimal
• Geospatial
• HyperLogLog
• IP Address
• JSON
• Lambda
• Logical
• Machine learning
• Map
• Math
• Quantile digest
• Regular expression
• Session
• Set Digest
• String
• System
• Teradata
• T-Digest
• URL
• UUID
• Window
• List of functions and operators
• List of functions by topic