SQL 函数# 聚合 Aggregate AVG COUNT FIRST LAST MAX MEDIAN MIN QUANTILE_CONT QUANTILE_DISC STDDEV SUM VARIANCE 数组 Array ARRAY_AGG ARRAY_CONTAINS ARRAY_GET ARRAY_LENGTH ARRAY_LOWER ARRAY_MEAN ARRAY_REVERSE ARRAY_SUM ARRAY_TO_STRING ARRAY_UNIQUE ARRAY_UPPER UNNEST 位运算 Temporal BIT_AND BIT_COUNT BIT_OR BIT_XOR 条件 Conditional COALESCE GREATEST IF IFNULL LEAST NULLIF 数学 Math ABS CBRT CEIL DIV EXP FLOOR LN LOG LOG2 LOG10 LOG1P MOD PI POW ROUND SIGN SQRT 字符串 String BIT_LENGTH CONCAT CONCAT_WS DATE ENDS_WITH INITCAP LEFT LENGTH LOWER LTRIM OCTET_LENGTH REGEXP_LIKE REPLACE REVERSE RIGHT RTRIM STARTS_WITH STRPOS STRPTIME SUBSTR TIMESTAMP UPPER 时间 Temporal DATE_PART EXTRACT STRFTIME 三角学 Trigonometry ACOS ACOSD ASIN ASIND ATAN ATAND ATAN2 ATAN2D COT COTD COS COSD DEGREES RADIANS SIN SIND TAN TAND 类型 Types CAST TRY_CAST