KHyperLogLog Functions Data Structures Serialization Functions KHyperLogLog Functions Presto implements the KHyperLogLog algorithm and data structure. KHyperLogLog data str...

Array Functions Date Functions GIS Functions String Functions Struct Functions Combinators Aggregate Functions Bitmap Functions Bitwise Functions Conditional Functions JS...

JSON_PARSE JSON_EXTRACT JSON_EXISTS_PATH JSON_TYPE JSON_ARRAY JSON_OBJECT JSON_QUOTE JSON_UNQUOTE JSON_VALID JSON_CONTAINS JSON_LENGTH GET_JSON_DOUBLE GET_JSON_INT GET...

ST_X ST_Y ST_CIRCLE ST_DISTANCE_SPHERE ST_ANGLE ST_AZIMUTH ST_ANGLE_SPHERE ST_AREA ST_POINT ST_POLYGON,ST_POLYFROMTEXT,ST_POLYGONFROMTEXT ST_ASTEXT,ST_ASWKT ST_CONTAINS ...

Window functions Define a window with the OVER clause Window function reference Examples Known issues Window functions info Apache Druid supports two query languages: Druid...

LAST_QUERY_ID() LAST_INSERT_ID()

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 ...

AES MD5 MD5SUM SM4 SM3 SM3SUM SHA SHA2

HLL_CARDINALITY HLL_EMPTY HLL_HASH