Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
Auf dieser Seite werden Funktionen und Operatoren beschrieben, die in der Datenbricks-zu-Databricks-Ansichtsfreigabe unterstützt werden.
Um Ihre Daten sicher zu halten, ermöglicht databricks-to-Databricks-Ansichtsfreigabe nur die folgende Teilmenge von Azure Databricks built-in-Funktionen und -Operatoren:
- -
- !
- /
- /
- &
- %
- ^
- +
- <
<<- <=
- <=>
- =
- ==
- >
- >=
>>>>>- |
- ~
- abs
- acos
- acosh
- add_months
- aes_decrypt
- aes_encrypt
- Aggregat
- 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 sortieren
- array_union
- arrays_overlap
- arrays_zip
- ascii
- asin
- asinh
- assert_true
- atan
- atan2
- atanh
- avg
- base64
- zwischen
- bigint
- bin
- Binär
- 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
- Decke
- Decke
- char
- char_length
- Zeichenlänge
- charindex
- Chr
- coalesce
collatecollation- collect_list
- collect_set
- concat
- contains
- conv
- convert_timezone
- corr
- cos
- cosh
- cot
- anzahl
- 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
- Datum
- date_add
- Datum_Differenz
- date_format
- date_from_unix_date
- date_part
- date_sub
- date_trunc
- dateadd
- datediff
datepart- day
- dayofmonth
- dayofweek
- dayofyear
- dezimal
- decode
- degrees
- dense_rank
- div
- double
- e
- element_at
- encode
- endswith
- every
- exists
- exp
- explode
- explode_outer
- expm1
- extrahieren
- factorial
- filter
- find_in_set
- first
- first_value
- flatten
- float
- floor
- für alle
- format_number
- format_string
- from_unixtime
- from_utc_timestamp
- get
- getbit
- getdate
- greatest
- Gruppierung
- 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_Versuchsabstand
- 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
- Stunde
- hypot
- if
- iff
- ifnull
- Gefällt mir
- in
- inline
- inline_outer
- int
- isnan
- isnotnull
- isnull
- kurtosis
- lag
- last
- letzter_Tag
- last_value
- lead
- mindestens
- left
- len
- Länge
- levenshtein
- like
- Ln
localtimestamp- log
- log10
- log1p
- log2
- senken
- luhn_check
- make_date
- make_dt_interval
- make_interval
- make_timestamp
make_timestamp_ltzmake_timestamp_ntz- make_ym_interval
- Karte
- map_concat
- map_contains_key
- map_entries
- Kartenfilter
- 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
- nicht
- now
- nth_value
- ntile
- nullif
- octet_length
- oder
- overlay
- Prozent-Rang
- Perzentil
- percentile_approx
- percentile_cont
- percentile_disc
- Pi
- pmod
- position
- Positiv
- pow
- Macht
- printf
- quarter
- radians
- rand
- randn
- random
- rank
- reduzieren
- 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
- wiederholen
- ersetzen
- reverse
- right
- rint
- rlike
- round
- row_number
- rpad
- rtrim
- Sekunde
- Sekunde
- Reihenfolge
- session_window
- sha
- sha1
- sha2
- shiftleft
- shiftright
- shiftrightunsigned
- shuffle
- sign
- Signum
- sin
- sinh
- Größe
- skewness
- slice
- smallint
- einige
- sort_array
- split
- split_part
- sqrt
- stack
- startswith
- std
- stddev
- stddev_pop
- stddev_samp
- str_to_map
- String
stringdecode- struct
- substr
- substring
- substring_index
- Summe
- tan
- tanh
- Zeitstempel
- 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
- umwandeln
- 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
- Wochentag
- WocheDesJahres
when- width_bucket
- Fenster
- window_time
- Jahr
- zip_with