Function

📄️ Math Functions

Math functions are a collection of functions used to perform various mathematical operations and calculations.They include basic arithmetic functions (such as addition, subtraction, multiplication, division), trigonometric functions (such as sin, cos, tan), exponential functions, logarithmic functions, etc.These functions can help you perform numerical calculations, solve mathematical problems, and create mathematical models.

📄️ Conditional Functions

Conditional functions are a collection of functions used to perform different operations based on specific conditions.They include conditional statements, which can help you choose to execute different code logic based on different situations.Conditional functions are very useful for implementing program flow control and decision making.

📄️ String Functions

String functions are a collection of functions used to handle and manipulate text strings.They include operations such as string concatenation, string splitting, string searching and replacing, and string length calculation.String functions can help you manipulate and transform text data, perform string matching and processing.

📄️ Date/Time Functions

The time and date functions are a collection of functions used to handle and manipulate time and date data.They include operations such as getting the current time, formatting dates, comparing times, and calculating time intervals.Time and date functions can help you handle time-related tasks, such as calculating date differences, scheduling tasks, and calendar functions, etc.

📄️ Aggregate Functions

Aggregate functions are commonly used functions in databases for aggregating calculations and summaries.They take a set of values as input and return a single aggregated result.Aggregate functions can be used to perform various operations, such as calculating totals, averages, maximums, minimums, etc.

📄️ Two-step aggregation

First, create an intermediate aggregation by using aggregate functions instead of calculating the final result in one step.Then, calculate the final result using analytic functions.

📄️ Window Functions

A window function performs a calculation across a set of table rows that are somehow related to the current row.This is comparable to the type of calculation that can be done with an aggregate function.However, window functions do not cause rows to become grouped into a single output row like non-window aggregate calls would.Instead, the rows retain their separate identities.Behind the scenes, the window function is able to access more than just the current row of the query result

📄️ Geospatial Functions

Geospatial functions are a collection of functions used to handle and manipulate three-dimensional spatial data.

📄️ Quality functions

Used to assess the quality of time series data

📄️ Other Functions

Other functional functions include some general functions that do not belong to the above categories.