TO_BASE64 FROM_BASE64 ASCII LENGTH BIT_LENGTH CHAR_LENGTH LPAD RPAD LOWER LCASE UPPER UCASE INITCAP REPEAT REVERSE CHAR CONCAT CONCAT_WS SUBSTR SUBSTRING SUB_RE...

Aggregate functions GROUP BY Using an identifier in GROUP BY Using an ordinal in GROUP BY Using an expression in GROUP BY SELECT Using aggregate expressions directly in SELECT ...

Scripts & functions Note Scripts & functions GreptimeDB supports running Python script inside the database. If the business logic is too complex to express via SQL, you can use...

Scripts & functions Getting Started Data Types Function API Cluster

JQ Functions The JQ Function Use Cases JSON Data Manipulation Calculate Averages by Removing Outliers Split One Messsage into Separate Messages Alternative Way for Splitting Me...

CURRENT_USER() CURRENT_ROLE() LAST_QUERY_ID() LAST_INSERT_ID()

Window Functions Overview DENSE_RANK() RANK() ROW_NUMBER()

Operators Functions

AVG COUNT MAX MIN SUM ANY_VALUE BIT_AND BIT_OR BIT_XOR STDDEV_POP VAR

LAST_QUERY_ID() LAST_INSERT_ID()