Functions Aggregate functions any_value array_agg avg count count(argument) count_if max min median sum 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 chr concat_ws contains ends_with format left length lower ltrim parse_filename parse_path position replace right rtrim split starts_with strlen substring to_base64 trim unicode upper 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_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 Оператор || Window functions cume_dist dense_rank first_value 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
