Daftar alfabet fungsi bawaan

Berlaku untuk: Databricks SQL Databricks Runtime

Artikel ini menyediakan daftar fungsi dan operator bawaan yang diurutkan menurut abjad di Azure Databricks.

• abs fungsi
• acos fungsi
• acosh fungsi
• add_months fungsi
• aes_decrypt fungsi
• aes_encrypt fungsi
• aggregate fungsi
• ai_analyze_sentiment fungsi
• ai_classify fungsi
• ai_extract fungsi
• ai_fix_grammar fungsi
• ai_forecast fungsi
• ai_gen fungsi
• ai_generate_text fungsi
• ai_mask fungsi
• ai_parse_document fungsi
• ai_query fungsi
• ai_similarity fungsi
• ai_summarize fungsi
• ai_translate fungsi
• Operator & (tanda ampersand)
• Predikat and
• Fungsi agregat any
• Fungsi agregat any_value
• Fungsi agregat approx_count_distinct
• Fungsi agregat approx_percentile
• Fungsi agregat approx_top_k
• array fungsi
• Fungsi agregat array_agg
• array_append fungsi
• array_compact fungsi
• array_contains fungsi
• array_distinct fungsi
• array_except fungsi
• array_insert fungsi
• array_intersect fungsi
• array_join fungsi
• array_max fungsi
• array_min fungsi
• array_position fungsi
• array_prepend fungsi
• array_remove fungsi
• array_repeat fungsi
• array_size fungsi
• array_sort fungsi
• array_union fungsi
• arrays_overlap fungsi
• arrays_zip fungsi
• ascii fungsi
• asin fungsi
• asinh fungsi
• assert_true fungsi
• (tanda bintang) * operator
• atan fungsi
• atan2 fungsi
• atanh fungsi
• Fungsi agregat avg
• Operator != (tanda tidak sama dengan)
• Operator (tanda seru) !
• base64 fungsi
• Predikat between
• bigint fungsi
• bin fungsi
• binary fungsi
• Fungsi agregat bit_and
• bit_count fungsi
• bit_get fungsi
• bit_length fungsi
• Fungsi agregat bit_or
• Fungsi agregat bit_xor
• Fungsi agregat bitmap_and_agg
• bitmap_bit_position fungsi
• bitmap_bucket_number fungsi
• Fungsi agregat bitmap_construct_agg
• bitmap_count fungsi
• Fungsi agregat bitmap_or_agg
• Fungsi agregat bool_and
• Fungsi agregat bool_or
• boolean fungsi
• [ ] (tanda kurung siku) operator
• bround fungsi
• cardinality fungsi
• Operator ^ (tanda sisipan)
• case Ekspresi
• cast fungsi
• cbrt fungsi
• ceil fungsi
• ceiling fungsi
• char fungsi
• char_length fungsi
• character_length fungsi
• chr fungsi
• cloud_files_state fungsi bernilai tabel
• coalesce fungsi
• collate Ekspresi
• collation fungsi
• collations fungsi tabel
• Fungsi agregat collect_list
• Fungsi agregat collect_set
• Operator :: (tanda dua titik dua)
• : Operator (tanda titik dua)
• ?:: (tanda titik dua pertanyaan) operator
• concat fungsi
• concat_ws fungsi
• contains fungsi
• conv fungsi
• convert_timezone fungsi
• Fungsi agregat corr
• cos fungsi
• cosh fungsi
• cot fungsi
• Fungsi agregat count
• Fungsi agregat count_if
• Fungsi agregat count_min_sketch
• Fungsi agregat covar_pop
• Fungsi agregat covar_samp
• crc32 fungsi
• csc fungsi
• cube fungsi
• cume_dist fungsi jendela analitik
• curdate fungsi
• current_catalog fungsi
• current_database fungsi
• current_date fungsi
• current_metastore fungsi
• current_recipient fungsi
• current_schema fungsi
• current_timestamp fungsi
• current_timezone fungsi
• current_user fungsi
• current_version fungsi
• date fungsi
• date_add fungsi
• date_add fungsi (hari)
• date_diff fungsi
• date_format fungsi
• date_from_unix_date fungsi
• date_part fungsi
• date_sub fungsi
• date_trunc fungsi
• dateadd fungsi
• dateadd fungsi (hari)
• datediff fungsi
• datediff fungsi stempel waktu
• day fungsi
• dayname fungsi
• dayofmonth fungsi
• dayofweek fungsi
• dayofyear fungsi
• decimal fungsi
• decode fungsi kunci
• decode (set karakter) fungsi
• degrees fungsi
• dense_rank fungsi jendela peringkat
• div Operator
• operator .(tanda titik)
• double fungsi
• e fungsi
• element_at fungsi
• elt fungsi
• encode fungsi
• endswith fungsi
• Operator == (tanda sama dengan ganda)
• = (tanda sama dengan) operator
• equal_null fungsi
• event_log fungsi bernilai tabel
• Fungsi agregat every
• exists fungsi
• exp fungsi
• explode fungsi generator bernilai tabel
• explode_outer fungsi generator bernilai tabel
• expm1 fungsi
• extract fungsi
• factorial fungsi
• filter fungsi
• find_in_set fungsi
• Fungsi agregat first
• Fungsi agregat first_value
• flatten fungsi
• float fungsi
• floor fungsi
• forall fungsi
• format_number fungsi
• format_string fungsi
• from_avro fungsi
• from_csv fungsi
• from_json fungsi
• from_unixtime fungsi
• from_utc_timestamp fungsi
• from_xml fungsi
• get fungsi
• getbit fungsi
• get_json_object fungsi
• getdate fungsi
• greatest fungsi
• grouping fungsi
• grouping_id fungsi
• >= (tanda lebih besar atau sama dengan) Operator
• > (operator tanda gt)
• h3_coverash3 fungsi
• h3_coverash3string fungsi
• h3_boundaryasgeojson fungsi
• h3_boundaryaswkb fungsi
• h3_boundaryaswkt fungsi
• h3_centerasgeojson fungsi
• h3_centeraswkb fungsi
• h3_centeraswkt fungsi
• h3_compact fungsi
• h3_distance fungsi
• h3_h3tostring fungsi
• h3_hexring fungsi
• h3_ischildof fungsi
• h3_ispentagon fungsi
• h3_isvalid fungsi
• h3_kring fungsi
• h3_kringdistances fungsi
• h3_longlatash3 fungsi
• h3_longlatash3string fungsi
• h3_maxchild fungsi
• h3_minchild fungsi
• h3_pointash3 fungsi
• h3_pointash3string fungsi
• h3_polyfillash3 fungsi
• h3_polyfillash3string fungsi
• h3_resolution fungsi
• h3_stringtoh3 fungsi
• h3_tessellateaswkb fungsi
• h3_tochildren fungsi
• h3_toparent fungsi
• h3_try_coverash3 fungsi
• h3_try_coverash3string fungsi
• h3_try_distance fungsi
• h3_try_polyfillash3 fungsi
• h3_try_polyfillash3string fungsi
• h3_try_tessellateaswkb fungsi
• h3_try_validate fungsi
• h3_uncompact fungsi
• h3_validate fungsi
• hash fungsi
• hex fungsi
• Fungsi agregat histogram_numeric
• Fungsi agregat hll_sketch_agg
• hll_sketch_estimate fungsi
• hll_union fungsi
• hll_union_agg fungsi
• hour fungsi
• http_request fungsi
• hypot fungsi
• if fungsi
• iff fungsi
• ifnull fungsi
• ilike Operator
• Predikat in
• initcap fungsi
• inline fungsi generator bernilai tabel
• inline_outer fungsi generator bernilai tabel
• input_file_block_length fungsi
• input_file_block_start fungsi
• input_file_name fungsi
• instr fungsi
• int fungsi
• is_member fungsi
• is_valid_utf8 fungsi
• is_variant_null fungsi
• is_account_group_member fungsi
• is distinct Operator
• is false Operator
• isnan fungsi
• isnotnull fungsi
• isnull fungsi
• is null Operator
• is true Operator
• java_method fungsi
• json_array_length fungsi
• json_object_keys fungsi
• json_tuple fungsi generator bernilai tabel
• Fungsi agregat kll_sketch_agg_bigint
• Fungsi agregat kll_sketch_agg_double
• Fungsi agregat kll_sketch_agg_float
• kll_sketch_get_n_bigint fungsi
• kll_sketch_get_n_double fungsi
• kll_sketch_get_n_float fungsi
• kll_sketch_get_quantile_bigint fungsi
• kll_sketch_get_quantile_double fungsi
• kll_sketch_get_quantile_float fungsi
• kll_sketch_get_rank_bigint fungsi
• kll_sketch_get_rank_double fungsi
• kll_sketch_get_rank_float fungsi
• kll_sketch_merge_bigint fungsi
• kll_sketch_merge_double fungsi
• kll_sketch_merge_float fungsi
• kll_sketch_to_string_bigint fungsi
• kll_sketch_to_string_double fungsi
• kll_sketch_to_string_float fungsi
• Fungsi agregat kurtosis
• lag fungsi jendela analitik
• Fungsi agregat last
• last_day fungsi
• Fungsi agregat last_value
• lcase fungsi
• lead fungsi jendela analitik
• least fungsi
• left fungsi
• len fungsi
• length fungsi
• levenshtein fungsi
• like Operator
• list_secrets fungsi tabel
• Fungsi agregat listagg
• ln fungsi
• locate fungsi
• log fungsi
• log10 fungsi
• log1p fungsi
• log2 fungsi
• lower fungsi
• lpad fungsi
• Operator <=> (tanda lt eq gt)
• Operator (tanda 'kurang dari atau sama dengan') <=
• <> operator (tanda kurung siku)
• ltrim fungsi
• < operator tanda 'lt'
• luhn_check fungsi
• make_date fungsi
• make_interval fungsi
• make_dt_interval fungsi
• make_ym_interval fungsi
• make_timestamp fungsi
• make_valid_utf8 fungsi
• map fungsi
• map_concat fungsi
• map_contains_key fungsi
• map_entries fungsi
• map_filter fungsi
• map_from_arrays fungsi
• map_from_entries fungsi
• map_keys fungsi
• map_values fungsi
• map_zip_with fungsi
• mask fungsi
• Fungsi agregat max
• Fungsi agregat max_by
• md5 fungsi
• Fungsi agregat mean
• Fungsi agregat measure
• Fungsi agregat median
• Fungsi agregat min
• Fungsi agregat min_by
• (tanda minus) - operator
• Operator tunggal - (tanda minus)
• minute fungsi
• mod fungsi
• Fungsi agregat mode
• monotonically_increasing_id fungsi
• month fungsi
• months_between fungsi
• named_struct fungsi
• nanvl fungsi
• negative fungsi
• next_day fungsi
• not Operator
• now fungsi
• nth_value fungsi jendela analitik
• ntile fungsi jendela peringkat
• nullif fungsi
• nullifzero fungsi
• nvl fungsi
• nvl2 fungsi
• octet_length fungsi
• or Operator
• overlay fungsi
• parse_json fungsi
• parse_url fungsi
• percent_rank fungsi jendela peringkat
• Fungsi agregat percentile
• Fungsi agregat percentile_approx
• Fungsi agregat percentile_cont
• Fungsi agregat percentile_disc
• % (tanda persen) operator
• pi fungsi
• || (tanda garis vertikal ganda) Operator
• Operator (tanda garis vertikal) |
• (tanda plus) Operator +
• (tanda plus) operator tunggal +
• pmod fungsi
• posexplode fungsi generator bernilai tabel
• posexplode_outer fungsi generator bernilai tabel
• position fungsi
• positive fungsi
• pow fungsi
• power fungsi
• printf fungsi
• quarter fungsi
• radians fungsi
• raise_error fungsi
• rand fungsi
• randn fungsi
• random fungsi
• randstr fungsi
• range fungsi bernilai tabel
• rank fungsi jendela peringkat
• read_files fungsi bernilai tabel
• read_kafka fungsi bernilai tabel
• read_kinesis fungsi streaming bernilai tabel
• read_pubsub fungsi streaming bernilai tabel
• read_pulsar fungsi streaming bernilai tabel
• read_state_metadata fungsi bernilai tabel
• read_statestore fungsi bernilai tabel
• remote_query fungsi bernilai tabel
• reduce fungsi
• reflect fungsi
• regexp Operator
• regexp_count fungsi
• regexp_extract fungsi
• regexp_extract_all fungsi
• regexp_instr fungsi
• regexp_like fungsi
• regexp_replace fungsi
• regexp_substr fungsi
• Fungsi agregat regr_avgx
• Fungsi agregat regr_avgy
• Fungsi agregat regr_count
• Fungsi agregat regr_intercept
• Fungsi agregat regr_r2
• Fungsi agregat regr_slope
• Fungsi agregat regr_sxx
• Fungsi agregat regr_sxy
• Fungsi agregat regr_syy
• repeat fungsi
• replace fungsi
• reverse fungsi
• right fungsi
• rint fungsi
• rlike Operator
• round fungsi
• row_number fungsi jendela peringkat
• rpad fungsi
• rtrim fungsi
• schema_of_csv fungsi
• schema_of_json fungsi
• Fungsi agregat schema_of_json_agg
• schema_of_variant fungsi
• Fungsi agregat schema_of_variant_agg
• schema_of_xml fungsi
• sec fungsi
• second fungsi
• secret fungsi
• sentences fungsi
• sequence fungsi
• session_user fungsi
• Ekspresi pengelompokan session_window
• sha fungsi
• sha1 fungsi
• sha2 fungsi
• shiftleft fungsi
• shiftright fungsi
• shiftrightunsigned fungsi
• shuffle fungsi
• sign fungsi
• signum fungsi
• sin fungsi
• sinh fungsi
• size fungsi
• Fungsi agregat skewness
• (tanda garis miring) / operator
• slice fungsi
• smallint fungsi
• Fungsi agregat some
• sort_array fungsi
• soundex fungsi
• space fungsi
• spark_partition_id fungsi
• split fungsi
• split_part fungsi
• sqrt fungsi
• st_addpoint fungsi
• st_area fungsi
• st_asbinary fungsi
• st_asewkb fungsi
• st_asewkt fungsi
• st_asgeojson fungsi
• st_astext fungsi
• st_aswkb fungsi
• st_aswkt fungsi
• st_buffer fungsi
• st_centroid fungsi
• st_concavehull fungsi
• st_contains fungsi
• st_convexhull fungsi
• st_covers fungsi
• st_difference fungsi
• st_dimension fungsi
• st_disjoint fungsi
• st_distance fungsi
• st_distancesphere fungsi
• st_distancespheroid fungsi
• st_dump fungsi
• st_dwithin fungsi
• st_endpoint fungsi
• st_envelope fungsi
• st_envelope_agg fungsi
• st_equals fungsi
• st_exteriorring fungsi
• st_flipcoordinates fungsi
• st_geogfromgeojson fungsi
• st_geogfromtext fungsi
• st_geogfromwkb fungsi
• st_geogfromwkt fungsi
• st_geohash fungsi
• st_geomfromgeojson fungsi
• st_geomfromewkb fungsi
• st_geomfromgeohash fungsi
• st_geomfromtext fungsi
• st_geomfromwkb fungsi
• st_geomfromwkt fungsi
• st_geometryn fungsi
• st_geometrytype fungsi
• st_interiorringn fungsi
• st_intersection fungsi
• st_intersects fungsi
• st_isempty fungsi
• st_isvalid fungsi
• st_length fungsi
• st_m fungsi
• st_makeline fungsi
• st_multi fungsi
• st_makepolygon fungsi
• st_ndims fungsi
• st_npoints fungsi
• st_numgeometries fungsi
• st_numinteriorrings fungsi
• st_perimeter fungsi
• st_point fungsi
• st_pointfromgeohash fungsi
• st_pointn fungsi
• st_removepoint fungsi
• st_reverse fungsi
• st_rotate fungsi
• st_scale fungsi
• st_setpoint fungsi
• st_setsrid fungsi
• st_simplify fungsi
• st_srid fungsi
• st_startpoint fungsi
• st_touches fungsi
• st_transform fungsi
• st_translate fungsi
• st_union fungsi
• st_union_agg fungsi
• st_within fungsi
• st_x fungsi
• st_xmax fungsi
• st_xmin fungsi
• st_y fungsi
• st_ymax fungsi
• st_ymin fungsi
• st_z fungsi
• st_zmax fungsi
• st_zmin fungsi
• sql_keywords fungsi
• stack fungsi generator bernilai tabel
• startswith fungsi
• Fungsi agregat std
• Fungsi agregat stddev
• Fungsi agregat stddev_pop
• Fungsi agregat stddev_samp
• str_to_map fungsi
• string fungsi
• Fungsi agregat string_agg
• struct fungsi
• substr fungsi
• substring fungsi
• substring_index fungsi
• Fungsi agregat sum
• table_changes fungsi bernilai tabel
• tan fungsi
• tanh fungsi
• Operator (tanda gelombang) ~
• timediff fungsi
• timestamp fungsi
• timestamp_micros fungsi
• timestamp_millis fungsi
• timestamp_seconds fungsi
• timestampadd fungsi
• timestampdiff fungsi
• tinyint fungsi
• to_avro fungsi
• to_binary fungsi
• to_char fungsi
• to_csv fungsi
• to_date fungsi
• to_geography fungsi
• to_geometry fungsi
• to_json fungsi
• to_number fungsi
• to_timestamp fungsi
• to_unix_timestamp fungsi
• to_utc_timestamp fungsi
• to_varchar fungsi
• to_variant_object fungsi
• to_xml fungsi
• transform fungsi
• transform_keys fungsi
• transform_values fungsi
• translate fungsi
• trim fungsi
• trunc fungsi
• try_add fungsi
• try_aes_decrypt fungsi
• Fungsi agregat try_avg
• try_cast fungsi
• try_divide fungsi
• try_element_at fungsi
• try_mod fungsi
• try_multiply fungsi
• try_parse_json fungsi
• try_reflect fungsi
• try_secret fungsi
• try_subtract fungsi
• Fungsi agregat try_sum
• try_to_binary fungsi
• try_to_geography fungsi
• try_to_geometry fungsi
• try_to_number fungsi
• try_to_timestamp fungsi
• try_url_decode fungsi
• try_validate_utf8 fungsi
• try_variant_get fungsi
• try_zstd_decompress fungsi
• typeof fungsi
• ucase fungsi
• unbase64 fungsi
• unhex fungsi
• uniform fungsi
• unix_date fungsi
• unix_micros fungsi
• unix_millis fungsi
• unix_seconds fungsi
• unix_timestamp fungsi
• upper fungsi
• url_decode fungsi
• url_encode fungsi
• user fungsi
• uuid fungsi
• validate_utf8 fungsi
• Fungsi agregat var_pop
• Fungsi agregat var_samp
• Fungsi agregat variance
• variant_explode fungsi bernilai tabel
• variant_explode_outer fungsi bernilai tabel
• variant_get fungsi
• vector_search fungsi
• version fungsi
• weekday fungsi
• weekofyear fungsi
• width_bucket fungsi
• Ekspresi pengelompokan window
• window_time fungsi
• xpath fungsi
• xpath_boolean fungsi
• xpath_double fungsi
• xpath_float fungsi
• xpath_int fungsi
• xpath_long fungsi
• xpath_number fungsi
• xpath_short fungsi
• xpath_string fungsi
• xxhash64 fungsi
• year fungsi
• zeroifnull fungsi
• zip_with fungsi
• zstd_compress fungsi
• zstd_decompress fungsi
• bit_reverse fungsi
• btrim fungsi
• charindex fungsi