內建函式的字母清單
適用於: Databricks SQL Databricks Runtime
本文提供 Azure Databricks 中內建函式和運算符的依字母順序排列的清單。
abs
函式acos
函式acosh
函式add_months
函式aes_decrypt
函式aes_encrypt
函式aggregate
函式ai_analyze_sentiment
函式ai_classify
函式ai_extract
函式ai_fix_grammar
函式ai_gen
函式ai_generate_text
函式ai_mask
函式ai_query
函式ai_similarity
函式ai_summarize
函式ai_translate
函式&
(ampersand sign) 運算子and
謂詞any
聚合函數any_value
聚合函數approx_count_distinct
聚合函數approx_percentile
聚合函數approx_top_k
聚合函數array
函式array_agg
聚合函數array_append
函式array_compact
函式array_contains
函式array_distinct
函式array_except
函式array_insert
函式array_intersect
函式array_join
函式array_max
函式array_min
函式array_position
函式array_prepend
函式array_remove
函式array_repeat
函式array_size
函式array_sort
函式array_union
函式arrays_overlap
函式arrays_zip
函式ascii
函式asin
函式asinh
函式assert_true
函式*
(星號符號) 運算符atan
函式atan2
函式atanh
函式avg
聚合函數!=
(bangeq 符號) 運算子!
(砰记號) 運算符base64
函式between
謂詞bigint
函式bin
函式binary
函式bit_and
聚合函數bit_count
函式bit_get
函式bit_length
函式bit_or
聚合函數bit_reverse
函式bit_xor
聚合函數bitmap_bit_position
函式bitmap_bucket_number
函式bitmap_construct_agg
聚合函數bitmap_count
函式bitmap_or_agg
聚合函數bool_and
聚合函數bool_or
聚合函數boolean
函式[ ]
(括弧符號) 運算符號bround
函式btrim
函式cardinality
函式^
(插入號) 運算子case
運算式cast
函式cbrt
函式ceil
函式ceiling
函式char
函式char_length
函式character_length
函式charindex
函式chr
函式cloud_files_state
table-valued 函式coalesce
函式collect_list
聚合函數collect_set
聚合函數::
(冒號冒號) 運算符:
(冒號) 運算符concat
函式concat_ws
函式contains
函式conv
函式convert_timezone
函式corr
聚合函數cos
函式cosh
函式cot
函式count
聚合函數count_if
聚合函數count_min_sketch
聚合函數covar_pop
聚合函數covar_samp
聚合函數crc32
函式csc
函式cube
函式cume_dist
分析視窗函式curdate
函式current_catalog
函式current_database
函式current_date
函式current_metastore
函式current_recipient
函式current_schema
函式current_timestamp
函式current_timezone
函式current_user
函式current_version
函式date
函式date_add
(天) 函式date_add
函式date_diff
函式date_format
函式date_from_unix_date
函式date_part
函式date_sub
函式date_trunc
函式dateadd
函式dateadd
(天) 函式datediff
函式datediff
(timestamp) 函式day
函式dayofmonth
函式dayofweek
函式dayofyear
函式decimal
函式decode
(key) 函式decode
(字元集) 函式degrees
函式dense_rank
排名視窗函式div
運算子.
(點符號) 運算符號double
函式e
函式element_at
函式elt
函式encode
函式endswith
函式==
(eq eq 符號) 運算子=
(eq 符號) 運算符equal_null
函式event_log
table-valued 函式every
聚合函數exists
函式exp
函式explode
數據表值產生器函式explode_outer
數據表值產生器函式expm1
函式extract
函式factorial
函式filter
函式find_in_set
函式first
聚合函數first_value
聚合函數flatten
函式float
函式floor
函式forall
函式format_number
函式format_string
函式from_csv
函式from_json
函式from_unixtime
函式from_utc_timestamp
函式from_xml
函式get
函式get_json_object
函式getbit
函式getdate
函式greatest
函式grouping
函式grouping_id
函式>=
(gt eq 符號) 運算子>
(gt sign) 運算符h3_boundaryasgeojson
函式h3_boundaryaswkb
函式h3_boundaryaswkt
函式h3_centerasgeojson
函式h3_centeraswkb
函式h3_centeraswkt
函式h3_compact
函式h3_coverash3
函式h3_coverash3string
函式h3_distance
函式h3_h3tostring
函式h3_hexring
函式h3_ischildof
函式h3_ispentagon
函式h3_isvalid
函式h3_kring
函式h3_kringdistances
函式h3_longlatash3
函式h3_longlatash3string
函式h3_maxchild
函式h3_minchild
函式h3_pointash3
函式h3_pointash3string
函式h3_polyfillash3
函式h3_polyfillash3string
函式h3_resolution
函式h3_stringtoh3
函式h3_tessellateaswkb
函式h3_tochildren
函式h3_toparent
函式h3_try_distance
函式h3_try_polyfillash3
函式h3_try_polyfillash3string
函式h3_try_validate
函式h3_uncompact
函式h3_validate
函式hash
函式hex
函式hll_sketch_agg
聚合函數hll_sketch_estimate
函式hll_union
函式hll_union_agg
函式hour
函式hypot
函式if
函式iff
函式ifnull
函式ilike
運算子in
謂詞initcap
函式inline
數據表值產生器函式inline_outer
數據表值產生器函式input_file_block_length
函式input_file_block_start
函式input_file_name
函式instr
函式int
函式is_account_group_member
函式is_member
函式is distinct
運算子is false
運算子isnan
函式isnotnull
函式isnull
函式is null
運算子is true
運算子java_method
函式json_array_length
函式json_object_keys
函式json_tuple
數據表值產生器函式kurtosis
聚合函數lag
分析視窗函式last
聚合函數last_day
函式last_value
聚合函數lcase
函式lead
分析視窗函式least
函式left
函式len
函式length
函式levenshtein
函式like
運算子list_secrets
table 函式ln
函式locate
函式log
函式log10
函式log1p
函式log2
函式lower
函式lpad
函式<=>
(lt eq gt sign) 運算子<=
(lt eq sign) 運算子<>
(lt gt sign) 運算子ltrim
函式<
(lt sign) 運算符luhn_check
函式make_date
函式make_dt_interval
函式make_interval
函式make_timestamp
函式make_ym_interval
函式map
函式map_concat
函式map_contains_key
函式map_entries
函式map_filter
函式map_from_arrays
函式map_from_entries
函式map_keys
函式map_values
函式map_zip_with
函式mask
函式max
聚合函數max_by
聚合函數md5
函式mean
聚合函數median
聚合函數min
聚合函數min_by
聚合函數-
(減號) 運算符-
(減號) 一元運算符minute
函式mod
函式mode
聚合函數monotonically_increasing_id
函式month
函式months_between
函式named_struct
函式nanvl
函式negative
函式next_day
函式not
運算子now
函式nth_value
分析視窗函式ntile
排名視窗函式nullif
函式nvl
函式nvl2
函式octet_length
函式or
運算子overlay
函式parse_url
函式percent_rank
排名視窗函式percentile
聚合函數percentile_approx
聚合函數percentile_cont
聚合函數percentile_disc
聚合函數%
(百分比符號) 運算符pi
函式||
(管道管道標誌) 運算符|
(管道符號) 運算符號+
(加號) 運算符+
(加號) 一元運算符pmod
函式posexplode
數據表值產生器函式posexplode_outer
數據表值產生器函式position
函式positive
函式pow
函式power
函式printf
函式quarter
函式radians
函式raise_error
函式rand
函式randn
函式random
函式range
table-valued 函式rank
排名視窗函式read_files
table-valued 函式read_kafka
table-valued 函式read_kinesis
串流數據表值函式read_pubsub
串流數據表值函式read_pulsar
串流數據表值函式read_state_metadata
table-valued 函式read_statestore
table-valued 函式reduce
函式reflect
函式regexp
運算子regexp_count
函式regexp_extract
函式regexp_extract_all
函式regexp_instr
函式regexp_like
函式regexp_replace
函式regexp_substr
函式regr_avgx
聚合函數regr_avgy
聚合函數regr_count
聚合函數regr_intercept
聚合函數regr_r2
聚合函數regr_slope
聚合函數regr_sxx
聚合函數regr_sxy
聚合函數regr_syy
聚合函數repeat
函式replace
函式reverse
函式right
函式rint
函式rlike
運算子round
函式row_number
排名視窗函式rpad
函式rtrim
函式schema_of_csv
函式schema_of_json
函式schema_of_json_agg
聚合函數schema_of_xml
函式sec
函式second
函式secret
函式sentences
函式sequence
函式session_user
函式session_window
群組表達式sha
函式sha1
函式sha2
函式shiftleft
函式shiftright
函式shiftrightunsigned
函式shuffle
函式sign
函式signum
函式sin
函式sinh
函式size
函式skewness
聚合函數/
(斜線符號) 運算符號slice
函式smallint
函式some
聚合函數sort_array
函式soundex
函式space
函式spark_partition_id
函式split
函式split_part
函式sql_keywords
函式sqrt
函式stack
數據表值產生器函式startswith
函式std
聚合函數stddev
聚合函數stddev_pop
聚合函數stddev_samp
聚合函數str_to_map
函式string
函式struct
函式substr
函式substring
函式substring_index
函式sum
聚合函數table_changes
table-valued 函式tan
函式tanh
函式~
(圖格符號) 運算符號timediff
函式timestamp
函式timestamp_micros
函式timestamp_millis
函式timestamp_seconds
函式timestampadd
函式timestampdiff
函式tinyint
函式to_binary
函式to_char
函式to_csv
函式to_date
函式to_json
函式to_number
函式to_timestamp
函式to_unix_timestamp
函式to_utc_timestamp
函式to_varchar
函式to_xml
函式transform
函式transform_keys
函式transform_values
函式translate
函式trim
函式trunc
函式try_add
函式try_aes_decrypt
函式try_avg
聚合函數try_cast
函式try_divide
函式try_element_at
函式try_multiply
函式try_reflect
函式try_subtract
函式try_sum
聚合函數try_to_binary
函式try_to_number
函式try_to_timestamp
函式typeof
函式ucase
函式unbase64
函式unhex
函式unix_date
函式unix_micros
函式unix_millis
函式unix_seconds
函式unix_timestamp
函式upper
函式url_decode
函式url_encode
函式user
函式uuid
函式var_pop
聚合函數var_samp
聚合函數variance
聚合函數version
函式weekday
函式weekofyear
函式width_bucket
函式window
群組表達式window_time
函式xpath
函式xpath_boolean
函式xpath_double
函式xpath_float
函式xpath_int
函式xpath_long
函式xpath_number
函式xpath_short
函式xpath_string
函式xxhash64
函式year
函式zip_with
函式