Functions Aggregate functions any_value array_agg avg count count(argument) count_if max min median sum Numerical functions abs add ceil cos divide even exp floor fmod gcd greatest isfinite isinf isnan lcm least lgamma ln log log2 multiply nextafter pi pow radians random round_even round setseed sign signbit sin sqrt subtract trunc Оператор + Оператор - Оператор * Оператор / Оператор % Оператор ^ Text functions contains length strlen trim ltrim rtrim lower upper split chr Functions for regular expressions regexp_extract regexp_extract_all regexp_full_match regexp_matches regexp_replace regexp_split_to_array regexp_split_to_table Оператор ~ Functions for date and time current_time now datepart date_diff date_trunc strptime Functions for JSON json_array_length json_contains json_exists json_extract json_extract_string json_group_array json_group_object json_keys json_transform json_transform_strict json_valid json_value json read_json Functions for binary data concat md5 sha1 sha256 Оператор || Window functions cume_dist dense_rank first_value lag last_value lead nth_value ntile percent_rank rank row_number Utilities coalesce generate_series hash unnest Python module tngri functions tngri.sql tngri.upload_df tngri.upload_file tngri.upload_s3 AS Aggregate functions
