Nata
Norint pasiekti šį puslapį, reikalingas leidimas. Galite pabandyti prisijungti arba pakeisti katalogus.
Norint pasiekti šį puslapį, reikalingas leidimas. Galite pabandyti pakeisti katalogus.
This article describes functions and operators supported in Databricks-to-Databricks Delta Sharing shared views.
To keep your data secure, shared views for Databricks-to-Databricks Delta Sharing only allows the following subset of Azure Databricks built-in functions and operators:
- -
- !
- /
- /
- &
- %
- ^
- +
- <
<<- <=
- <=>
- =
- ==
- >
- >=
>>>>>- |
- ~
- abs
- acos
- acosh
- add_months
- aes_decrypt
- aes_encrypt
- aggregate
- 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
- 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
- cast
- cbrt
- ceil
- ceiling
- char
- char_length
- character_length
- charindex
- chr
- coalesce
collatecollation- collect_list
- collect_set
- concat
- contains
- conv
- convert_timezone
- corr
- cos
- cosh
- cot
- count
- count_if
- count_min_sketch
- covar_pop
- covar_samp
- crc32
- csc
- cume_dist
- curdate
- current_catalog
- current_database
- current_date
- current_metastore
- current_recipient
- current_schema
- current_timestamp
- current_timezone
- current_version
- date
- date_add
- date_diff
- date_format
- date_from_unix_date
- date_part
- date_sub
- date_trunc
- dateadd
- datediff
datepart- day
- dayofmonth
- dayofweek
- dayofyear
- decimal
- decode
- degrees
- dense_rank
- div
- double
- e
- element_at
- encode
- endswith
- 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_unixtime
- from_utc_timestamp
- get
- getbit
- getdate
- greatest
- grouping
- grouping_id
- 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_coverash3
- h3_try_coverash3string
- h3_try_distance
- h3_try_polyfillash3
- h3_try_polyfillash3string
- h3_try_tessellateaswkb
- h3_try_validate
- h3_uncompact
- h3_validate
- hash
- hex
- histogram_numeric
- hll_sketch_agg
- hll_union_agg
- hour
- hypot
- if
- iff
- ifnull
- ilike
- in
- inline
- inline_outer
- int
- isnan
- isnotnull
- isnull
- kurtosis
- lag
- last
- last_day
- last_value
- lead
- least
- left
- len
- length
- levenshtein
- like
- ln
localtimestamp- log
- log10
- log1p
- log2
- lower
- luhn_check
- make_date
- make_dt_interval
- make_interval
- make_timestamp
make_timestamp_ltzmake_timestamp_ntz- 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
- max
- max_by
- md5
- mean
- median
- min
- min_by
- minute
- mod
- mode
- month
monthname- months_between
- named_struct
- nanvl
- negative
- next_day
- not
- now
- nth_value
- ntile
- nullif
- octet_length
- or
- overlay
- percent_rank
- percentile
- percentile_approx
- percentile_cont
- percentile_disc
- pi
- pmod
- position
- positive
- pow
- power
- printf
- quarter
- radians
- rand
- randn
- random
- rank
- reduce
- regexp
- regexp_extract
- regexp_extract_all
- regexp_like
- regexp_replace
- 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
- sec
- second
- sequence
- session_window
- sha
- sha1
- sha2
- shiftleft
- shiftright
- shiftrightunsigned
- shuffle
- sign
- signum
- sin
- sinh
- size
- skewness
- slice
- smallint
- some
- sort_array
- split
- split_part
- sqrt
- stack
- startswith
- std
- stddev
- stddev_pop
- stddev_samp
- str_to_map
- string
stringdecode- struct
- substr
- substring
- substring_index
- sum
- tan
- tanh
- timestamp
- timestamp_micros
- timestamp_millis
- timestamp_seconds
- tinyint
- to_binary
- to_char
- to_date
to_geographyto_geometry- to_number
- to_timestamp
to_timestamp_ltzto_timestamp_ntz- to_unix_timestamp
- to_utc_timestamp
- to_varchar
- transform
- transform_keys
- transform_values
- trim
- trunc
- try_add
- try_avg
- try_divide
- try_mod
- try_multiply
try_remainder- try_subtract
- try_sum
- try_to_binary
try_to_geographytry_to_geometry- 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
- uuid
- var_pop
- var_samp
- variance
- version
- weekday
- weekofyear
when- width_bucket
- window
- window_time
- year
- zip_with