Функции Агрегатные функции any_value approx_count_distinct approx_quantile approx_top_k arg_max arg_max_null arg_min arg_min_null array_agg avg bit_and bit_or bit_xor bitstring_agg bool_and bool_or count count(argument) corr covar_pop covar_samp count_if entropy favg first fsum geometric_mean histogram histogram_exact kurtosis kurtosis_pop last mad max min median mode product quantile_cont quantile_disc reservoir_quantile sem skewness stddev_pop stddev_samp string_agg sum var_pop var_samp weighted_avg Числовые функции abs acos acosh add asin asinh atan atan2 atanh bit_count cbrt ceil cos cot degrees divide even exp factorial fdiv floor fmod gamma 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 tan trunc xor Оператор + Оператор - Оператор * Оператор / Оператор % Оператор ^ Оператор < Оператор > Оператор <= Оператор >= Оператор = Оператор <> Оператор BETWEEN Текстовые функции array_extract array_slice bar bin bit_length chr concat_ws contains ends_with format formatReadableDecimalSize formatReadableSize from_base64 hex ilike_escape instr left left_grapheme length length_grapheme like_escape lower lpad ltrim md5_number_lower md5_number_upper nfc_normalize not_ilike_escape not_like_escape parse_dirname parse_dirpath parse_filename parse_path prefix printf position read_text repeat replace reverse right right_grapheme rpad rtrim split split_part starts_with strip_accents strlen substring substring_grapheme to_base to_base64 translate trim unbin unhex unicode upper url_decode url_encode Функции для регулярных выражений regexp_escape regexp_extract regexp_extract_all regexp_full_match regexp_matches regexp_replace regexp_split_to_array regexp_split_to_table Оператор ~ Функции для даты и времени current_date current_localtimestamp current_time dayname datepart date_diff date_trunc dayofmonth dayofweek dayofyear epoch era isodow isoyear julian monthname now strptime timezone_hour to_timestamp weekofyear yearweek Функции для JSON json json_array json_array_length json_contains json_each json_exists json_extract json_extract_string json_group_array json_group_object json_keys json_merge_patch json_object json_structure json_transform json_transform_strict json_tree json_type json_valid json_value read_json read_json_objects to_json Функции для двоичных данных concat md5 sha1 sha256 Оператор || Функции для списков array_length flatten list_aggregate list_concat list_contains list_cosine_distance list_cosine_similarity list_distance list_distinct list_extract list_grade_up list_has_all list_has_any list_inner_product list_negative_inner_product list_position list_resize list_reverse_sort list_select list_sort list_unique list_value list_where list_zip range Функции для геоданных ST_Point ST_Distance ST_Distance_Sphere Оконные функции cume_dist dense_rank fill first_value lag last_value lead nth_value ntile percent_rank rank row_number Утилиты cast coalesce generate_series hash nextval_tngri read_csv read_parquet read_xlsx try_cast unnest uuid uuidv7 uuid_extract_timestamp uuid_extract_version Оператор :: Функции модуля Python tngri tngri.create_table tngri.delete_file tngri.list_files tngri.run_notebook tngri.sql tngri.upload_df tngri.upload_file tngri.upload_s3 EXPLAIN Агрегатные функции
