Oharra
Orrialde honetara sartzeak baimena behar du. Saioa hasteko edo direktorioak aldatzen saia zaitezke.
Orrialde honetara sartzeak baimena behar du. Direktorioak aldatzen saia zaitezke.
En este artículo se describen las funciones y los operadores compatibles con las vistas compartidas de uso compartido de Delta de Databricks a Databricks.
Para proteger los datos, las vistas compartidas de Databricks a Databricks Delta Sharing solo permiten el siguiente subconjunto de funciones y operadores integrados de Azure Databricks:
- -
- !
- /
- /
- &
- %
- ^
- +
- <
<<- <=
- <=>
- =
- ==
- >
- >=
>>>>>- |
- ~
- abs
- acos
- acosh
- add_months
- aes_decrypt
- aes_encrypt
- aggregate
- y
- cualquiera
- 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
- tamaño_de_array
- 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
- cardinalidad
- conversión
- cbrt
- ceil
- techo
- char
- char_length
- longitud_de_caracteres
- charindex
- Chr
- coalesce
collatecollation- collect_list
- collect_set
- concat
- contiene
- 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
- destinatario_actual
- current_schema
- current_timestamp
- current_timezone
- current_version
- date
- date_add
- diferencia_fecha
- date_format
- date_from_unix_date
- date_part
- date_sub
- date_trunc
- dateadd
- datediff
datepart- day
- dayofmonth
- díadela semana
- día del año
- decimal
- decode
- grados
- dense_rank
- div
- double
- e
- element_at
- encode
- endswith
- every
- exists
- exp
- explode
- explode_outer
- expm1
- extract
- factorial
- filter
- find_in_set
- primero
- first_value
- flatten
- flotar
- floor
- forall
- format_number
- format_string
- from_unixtime
- from_utc_timestamp
- get
- getbit
- getdate
- greatest
- agrupación
- 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
- hora
- hipot
- si
- iff
- ifnull
- ilike
- en
- inline
- inline_outer
- Int
- isnan
- isnotnull
- isnull
- curtosis
- lag
- último
- último_día
- last_value
- lead
- least
- izquierda
- len
- length
- levenshtein
- like
- ln
localtimestamp- log
- log10
- log1p
- log2
- lower
- luhn_check
- crear_fecha
- make_dt_interval
- make_interval
- make_timestamp
make_timestamp_ltzmake_timestamp_ntz- make_ym_interval
- mapa
- map_concat
- map_contains_key
- entradas_del_mapa
- map_filter
- map_from_arrays
- map_from_entries
- map_keys
- map_values
- map_zip_with
- max
- max_by
- md5
- mean
- mediana
- min
- min_by
- minute
- modificación
- mode
- month
monthname- meses_entre
- named_struct
- nanvl
- negativa
- next_day
- no
- now
- nth_value
- ntile
- nullif
- octet_length
- o
- superposición
- percent_rank
- percentil
- percentil_aprox
- percentile_cont
- percentile_disc
- pi
- pmod
- position
- Positivo
- pow
- poder
- printf
- trimestre
- radianes
- rand
- randn
- aleatorio
- 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
- repetir
- reemplazar
- reverse
- right
- rint
- rlike
- round
- row_number
- rpad
- rtrim
- sec
- second
- secuencia
- session_window
- sha
- sha1
- sha2
- shiftleft
- shiftright
- shiftrightunsigned
- shuffle
- signo
- Signum
- sin
- sinh
- size
- asimetría
- 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
- transformar
- 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
- Versión
- día laborable
- semana del año
when- width_bucket
- window
- window_time
- año
- zip_with