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

STRUCT NAMED_STRUCT STRUCT_ELEMENT

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

AES MD5 MD5SUM SM4 SM3 SM3SUM SHA SHA2

HLL_CARDINALITY HLL_EMPTY HLL_HASH

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

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

categories: [Convenience, Functions] Generic wrappers The strategy pattern layout: posttitle: “Functions as interfaces”description: “OO design patterns can be trivial when fun...

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