Functions Aggregate functions 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 Numerical functions 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 Text functions 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 Functions for regular expressions regexp_escape 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_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 Functions for 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 Functions for binary data concat md5 sha1 sha256 Оператор || List Functions 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 Window functions cume_dist dense_rank fill lag last_value lead nth_value ntile percent_rank rank row_number Utilities 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 module tngri functions tngri.create_table tngri.delete_file tngri.list_files tngri.run_notebook tngri.sql tngri.upload_df tngri.upload_file tngri.upload_s3 EXPLAIN Aggregate functions
