Catatan
Akses ke halaman ini memerlukan otorisasi. Anda dapat mencoba masuk atau mengubah direktori.
Akses ke halaman ini memerlukan otorisasi. Anda dapat mencoba mengubah direktori.
Berlaku untuk:
Databricks SQL
Databricks Runtime
Artikel ini menyediakan daftar fungsi dan operator bawaan yang diurutkan menurut abjad di Azure Databricks.
-
absfungsi -
acosfungsi -
acoshfungsi -
add_monthsfungsi -
aes_decryptfungsi -
aes_encryptfungsi -
aggregatefungsi -
ai_analyze_sentimentfungsi -
ai_classifyfungsi -
ai_extractfungsi -
ai_fix_grammarfungsi -
ai_forecastfungsi -
ai_genfungsi -
ai_generate_textfungsi -
ai_maskfungsi -
ai_parse_documentfungsi -
ai_queryfungsi -
ai_similarityfungsi -
ai_summarizefungsi -
ai_translatefungsi -
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 -
arrayfungsi -
Fungsi agregat
array_agg -
array_appendfungsi -
array_compactfungsi -
array_containsfungsi -
array_distinctfungsi -
array_exceptfungsi -
array_insertfungsi -
array_intersectfungsi -
array_joinfungsi -
array_maxfungsi -
array_minfungsi -
array_positionfungsi -
array_prependfungsi -
array_removefungsi -
array_repeatfungsi -
array_sizefungsi -
array_sortfungsi -
array_unionfungsi -
arrays_overlapfungsi -
arrays_zipfungsi -
asciifungsi -
asinfungsi -
asinhfungsi -
assert_truefungsi -
(tanda bintang)
*operator -
atanfungsi -
atan2fungsi -
atanhfungsi -
Fungsi agregat
avg -
Operator
!=(tanda tidak sama dengan) -
Operator (tanda seru)
! -
base64fungsi -
Predikat
between -
bigintfungsi -
binfungsi -
binaryfungsi -
Fungsi agregat
bit_and -
bit_countfungsi -
bit_getfungsi -
bit_lengthfungsi -
Fungsi agregat
bit_or -
Fungsi agregat
bit_xor -
Fungsi agregat
bitmap_and_agg -
bitmap_bit_positionfungsi -
bitmap_bucket_numberfungsi -
Fungsi agregat
bitmap_construct_agg -
bitmap_countfungsi -
Fungsi agregat
bitmap_or_agg -
Fungsi agregat
bool_and -
Fungsi agregat
bool_or -
booleanfungsi -
[ ](tanda kurung siku) operator -
broundfungsi -
cardinalityfungsi -
Operator
^(tanda sisipan) -
caseEkspresi -
castfungsi -
cbrtfungsi -
ceilfungsi -
ceilingfungsi -
charfungsi -
char_lengthfungsi -
character_lengthfungsi -
chrfungsi -
cloud_files_statefungsi bernilai tabel -
coalescefungsi -
collateEkspresi -
collationfungsi -
collationsfungsi tabel -
Fungsi agregat
collect_list -
Fungsi agregat
collect_set -
Operator
::(tanda dua titik dua) -
:Operator (tanda titik dua) -
?::(tanda titik dua pertanyaan) operator -
concatfungsi -
concat_wsfungsi -
containsfungsi -
convfungsi -
convert_timezonefungsi -
Fungsi agregat
corr -
cosfungsi -
coshfungsi -
cotfungsi -
Fungsi agregat
count -
Fungsi agregat
count_if -
Fungsi agregat
count_min_sketch -
Fungsi agregat
covar_pop -
Fungsi agregat
covar_samp -
crc32fungsi -
cscfungsi -
cubefungsi -
cume_distfungsi jendela analitik -
curdatefungsi -
current_catalogfungsi -
current_databasefungsi -
current_datefungsi -
current_metastorefungsi -
current_recipientfungsi -
current_schemafungsi -
current_timestampfungsi -
current_timezonefungsi -
current_userfungsi -
current_versionfungsi -
datefungsi -
date_addfungsi -
date_addfungsi (hari) -
date_difffungsi -
date_formatfungsi -
date_from_unix_datefungsi -
date_partfungsi -
date_subfungsi -
date_truncfungsi -
dateaddfungsi -
dateaddfungsi (hari) -
datedifffungsi -
datedifffungsi stempel waktu -
dayfungsi -
daynamefungsi -
dayofmonthfungsi -
dayofweekfungsi -
dayofyearfungsi -
decimalfungsi -
decodefungsi kunci -
decode(set karakter) fungsi -
degreesfungsi -
dense_rankfungsi jendela peringkat -
divOperator -
operator
.(tanda titik) -
doublefungsi -
efungsi -
element_atfungsi -
eltfungsi -
encodefungsi -
endswithfungsi -
Operator
==(tanda sama dengan ganda) -
=(tanda sama dengan) operator -
equal_nullfungsi -
event_logfungsi bernilai tabel -
Fungsi agregat
every -
existsfungsi -
expfungsi -
explodefungsi generator bernilai tabel -
explode_outerfungsi generator bernilai tabel -
expm1fungsi -
extractfungsi -
factorialfungsi -
filterfungsi -
find_in_setfungsi -
Fungsi agregat
first -
Fungsi agregat
first_value -
flattenfungsi -
floatfungsi -
floorfungsi -
forallfungsi -
format_numberfungsi -
format_stringfungsi -
from_avrofungsi -
from_csvfungsi -
from_jsonfungsi -
from_unixtimefungsi -
from_utc_timestampfungsi -
from_xmlfungsi -
getfungsi -
getbitfungsi -
get_json_objectfungsi -
getdatefungsi -
greatestfungsi -
groupingfungsi -
grouping_idfungsi -
>=(tanda lebih besar atau sama dengan) Operator -
>(operator tanda gt) -
h3_coverash3fungsi -
h3_coverash3stringfungsi -
h3_boundaryasgeojsonfungsi -
h3_boundaryaswkbfungsi -
h3_boundaryaswktfungsi -
h3_centerasgeojsonfungsi -
h3_centeraswkbfungsi -
h3_centeraswktfungsi -
h3_compactfungsi -
h3_distancefungsi -
h3_h3tostringfungsi -
h3_hexringfungsi -
h3_ischildoffungsi -
h3_ispentagonfungsi -
h3_isvalidfungsi -
h3_kringfungsi -
h3_kringdistancesfungsi -
h3_longlatash3fungsi -
h3_longlatash3stringfungsi -
h3_maxchildfungsi -
h3_minchildfungsi -
h3_pointash3fungsi -
h3_pointash3stringfungsi -
h3_polyfillash3fungsi -
h3_polyfillash3stringfungsi -
h3_resolutionfungsi -
h3_stringtoh3fungsi -
h3_tessellateaswkbfungsi -
h3_tochildrenfungsi -
h3_toparentfungsi -
h3_try_coverash3fungsi -
h3_try_coverash3stringfungsi -
h3_try_distancefungsi -
h3_try_polyfillash3fungsi -
h3_try_polyfillash3stringfungsi -
h3_try_tessellateaswkbfungsi -
h3_try_validatefungsi -
h3_uncompactfungsi -
h3_validatefungsi -
hashfungsi -
hexfungsi -
Fungsi agregat
histogram_numeric -
Fungsi agregat
hll_sketch_agg -
hll_sketch_estimatefungsi -
hll_unionfungsi -
hll_union_aggfungsi -
hourfungsi -
http_requestfungsi -
hypotfungsi -
iffungsi -
ifffungsi -
ifnullfungsi -
ilikeOperator -
Predikat
in -
initcapfungsi -
inlinefungsi generator bernilai tabel -
inline_outerfungsi generator bernilai tabel -
input_file_block_lengthfungsi -
input_file_block_startfungsi -
input_file_namefungsi -
instrfungsi -
intfungsi -
is_memberfungsi -
is_valid_utf8fungsi -
is_variant_nullfungsi -
is_account_group_memberfungsi -
is distinctOperator -
is falseOperator -
isnanfungsi -
isnotnullfungsi -
isnullfungsi -
is nullOperator -
is trueOperator -
java_methodfungsi -
json_array_lengthfungsi -
json_object_keysfungsi -
json_tuplefungsi 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_bigintfungsi -
kll_sketch_get_n_doublefungsi -
kll_sketch_get_n_floatfungsi -
kll_sketch_get_quantile_bigintfungsi -
kll_sketch_get_quantile_doublefungsi -
kll_sketch_get_quantile_floatfungsi -
kll_sketch_get_rank_bigintfungsi -
kll_sketch_get_rank_doublefungsi -
kll_sketch_get_rank_floatfungsi -
kll_sketch_merge_bigintfungsi -
kll_sketch_merge_doublefungsi -
kll_sketch_merge_floatfungsi -
kll_sketch_to_string_bigintfungsi -
kll_sketch_to_string_doublefungsi -
kll_sketch_to_string_floatfungsi -
Fungsi agregat
kurtosis -
lagfungsi jendela analitik -
Fungsi agregat
last -
last_dayfungsi -
Fungsi agregat
last_value -
lcasefungsi -
leadfungsi jendela analitik -
leastfungsi -
leftfungsi -
lenfungsi -
lengthfungsi -
levenshteinfungsi -
likeOperator -
list_secretsfungsi tabel -
Fungsi agregat
listagg -
lnfungsi -
locatefungsi -
logfungsi -
log10fungsi -
log1pfungsi -
log2fungsi -
lowerfungsi -
lpadfungsi -
Operator
<=>(tanda lt eq gt) -
Operator (tanda 'kurang dari atau sama dengan')
<= -
<>operator (tanda kurung siku) -
ltrimfungsi -
<operator tanda 'lt' -
luhn_checkfungsi -
make_datefungsi -
make_intervalfungsi -
make_dt_intervalfungsi -
make_ym_intervalfungsi -
make_timestampfungsi -
make_valid_utf8fungsi -
mapfungsi -
map_concatfungsi -
map_contains_keyfungsi -
map_entriesfungsi -
map_filterfungsi -
map_from_arraysfungsi -
map_from_entriesfungsi -
map_keysfungsi -
map_valuesfungsi -
map_zip_withfungsi -
maskfungsi -
Fungsi agregat
max -
Fungsi agregat
max_by -
md5fungsi -
Fungsi agregat
mean -
Fungsi agregat
measure -
Fungsi agregat
median -
Fungsi agregat
min -
Fungsi agregat
min_by -
(tanda minus)
-operator -
Operator tunggal
-(tanda minus) -
minutefungsi -
modfungsi -
Fungsi agregat
mode -
monotonically_increasing_idfungsi -
monthfungsi -
months_betweenfungsi -
named_structfungsi -
nanvlfungsi -
negativefungsi -
next_dayfungsi -
notOperator -
nowfungsi -
nth_valuefungsi jendela analitik -
ntilefungsi jendela peringkat -
nulliffungsi -
nullifzerofungsi -
nvlfungsi -
nvl2fungsi -
octet_lengthfungsi -
orOperator -
overlayfungsi -
parse_jsonfungsi -
parse_urlfungsi -
percent_rankfungsi jendela peringkat -
Fungsi agregat
percentile -
Fungsi agregat
percentile_approx -
Fungsi agregat
percentile_cont -
Fungsi agregat
percentile_disc -
%(tanda persen) operator -
pifungsi -
||(tanda garis vertikal ganda) Operator -
Operator (tanda garis vertikal)
| -
(tanda plus) Operator
+ -
(tanda plus) operator tunggal
+ -
pmodfungsi -
posexplodefungsi generator bernilai tabel -
posexplode_outerfungsi generator bernilai tabel -
positionfungsi -
positivefungsi -
powfungsi -
powerfungsi -
printffungsi -
quarterfungsi -
radiansfungsi -
raise_errorfungsi -
randfungsi -
randnfungsi -
randomfungsi -
randstrfungsi -
rangefungsi bernilai tabel -
rankfungsi jendela peringkat -
read_filesfungsi bernilai tabel -
read_kafkafungsi bernilai tabel -
read_kinesisfungsi streaming bernilai tabel -
read_pubsubfungsi streaming bernilai tabel -
read_pulsarfungsi streaming bernilai tabel -
read_state_metadatafungsi bernilai tabel -
read_statestorefungsi bernilai tabel -
remote_queryfungsi bernilai tabel -
reducefungsi -
reflectfungsi -
regexpOperator -
regexp_countfungsi -
regexp_extractfungsi -
regexp_extract_allfungsi -
regexp_instrfungsi -
regexp_likefungsi -
regexp_replacefungsi -
regexp_substrfungsi -
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 -
repeatfungsi -
replacefungsi -
reversefungsi -
rightfungsi -
rintfungsi -
rlikeOperator -
roundfungsi -
row_numberfungsi jendela peringkat -
rpadfungsi -
rtrimfungsi -
schema_of_csvfungsi -
schema_of_jsonfungsi -
Fungsi agregat
schema_of_json_agg -
schema_of_variantfungsi -
Fungsi agregat
schema_of_variant_agg -
schema_of_xmlfungsi -
secfungsi -
secondfungsi -
secretfungsi -
sentencesfungsi -
sequencefungsi -
session_userfungsi -
Ekspresi pengelompokan
session_window -
shafungsi -
sha1fungsi -
sha2fungsi -
shiftleftfungsi -
shiftrightfungsi -
shiftrightunsignedfungsi -
shufflefungsi -
signfungsi -
signumfungsi -
sinfungsi -
sinhfungsi -
sizefungsi -
Fungsi agregat
skewness -
(tanda garis miring)
/operator -
slicefungsi -
smallintfungsi -
Fungsi agregat
some -
sort_arrayfungsi -
soundexfungsi -
spacefungsi -
spark_partition_idfungsi -
splitfungsi -
split_partfungsi -
sqrtfungsi -
st_addpointfungsi -
st_areafungsi -
st_asbinaryfungsi -
st_asewkbfungsi -
st_asewktfungsi -
st_asgeojsonfungsi -
st_astextfungsi -
st_aswkbfungsi -
st_aswktfungsi -
st_bufferfungsi -
st_centroidfungsi -
st_concavehullfungsi -
st_containsfungsi -
st_convexhullfungsi -
st_coversfungsi -
st_differencefungsi -
st_dimensionfungsi -
st_disjointfungsi -
st_distancefungsi -
st_distancespherefungsi -
st_distancespheroidfungsi -
st_dumpfungsi -
st_dwithinfungsi -
st_endpointfungsi -
st_envelopefungsi -
st_envelope_aggfungsi -
st_equalsfungsi -
st_exteriorringfungsi -
st_flipcoordinatesfungsi -
st_geogfromgeojsonfungsi -
st_geogfromtextfungsi -
st_geogfromwkbfungsi -
st_geogfromwktfungsi -
st_geohashfungsi -
st_geomfromgeojsonfungsi -
st_geomfromewkbfungsi -
st_geomfromgeohashfungsi -
st_geomfromtextfungsi -
st_geomfromwkbfungsi -
st_geomfromwktfungsi -
st_geometrynfungsi -
st_geometrytypefungsi -
st_interiorringnfungsi -
st_intersectionfungsi -
st_intersectsfungsi -
st_isemptyfungsi -
st_isvalidfungsi -
st_lengthfungsi -
st_mfungsi -
st_makelinefungsi -
st_multifungsi -
st_makepolygonfungsi -
st_ndimsfungsi -
st_npointsfungsi -
st_numgeometriesfungsi -
st_numinteriorringsfungsi -
st_perimeterfungsi -
st_pointfungsi -
st_pointfromgeohashfungsi -
st_pointnfungsi -
st_removepointfungsi -
st_reversefungsi -
st_rotatefungsi -
st_scalefungsi -
st_setpointfungsi -
st_setsridfungsi -
st_simplifyfungsi -
st_sridfungsi -
st_startpointfungsi -
st_touchesfungsi -
st_transformfungsi -
st_translatefungsi -
st_unionfungsi -
st_union_aggfungsi -
st_withinfungsi -
st_xfungsi -
st_xmaxfungsi -
st_xminfungsi -
st_yfungsi -
st_ymaxfungsi -
st_yminfungsi -
st_zfungsi -
st_zmaxfungsi -
st_zminfungsi -
sql_keywordsfungsi -
stackfungsi generator bernilai tabel -
startswithfungsi -
Fungsi agregat
std -
Fungsi agregat
stddev -
Fungsi agregat
stddev_pop -
Fungsi agregat
stddev_samp -
str_to_mapfungsi -
stringfungsi -
Fungsi agregat
string_agg -
structfungsi -
substrfungsi -
substringfungsi -
substring_indexfungsi -
Fungsi agregat
sum -
table_changesfungsi bernilai tabel -
tanfungsi -
tanhfungsi -
Operator (tanda gelombang)
~ -
timedifffungsi -
timestampfungsi -
timestamp_microsfungsi -
timestamp_millisfungsi -
timestamp_secondsfungsi -
timestampaddfungsi -
timestampdifffungsi -
tinyintfungsi -
to_avrofungsi -
to_binaryfungsi -
to_charfungsi -
to_csvfungsi -
to_datefungsi -
to_geographyfungsi -
to_geometryfungsi -
to_jsonfungsi -
to_numberfungsi -
to_timestampfungsi -
to_unix_timestampfungsi -
to_utc_timestampfungsi -
to_varcharfungsi -
to_variant_objectfungsi -
to_xmlfungsi -
transformfungsi -
transform_keysfungsi -
transform_valuesfungsi -
translatefungsi -
trimfungsi -
truncfungsi -
try_addfungsi -
try_aes_decryptfungsi -
Fungsi agregat
try_avg -
try_castfungsi -
try_dividefungsi -
try_element_atfungsi -
try_modfungsi -
try_multiplyfungsi -
try_parse_jsonfungsi -
try_reflectfungsi -
try_secretfungsi -
try_subtractfungsi -
Fungsi agregat
try_sum -
try_to_binaryfungsi -
try_to_geographyfungsi -
try_to_geometryfungsi -
try_to_numberfungsi -
try_to_timestampfungsi -
try_url_decodefungsi -
try_validate_utf8fungsi -
try_variant_getfungsi -
try_zstd_decompressfungsi -
typeoffungsi -
ucasefungsi -
unbase64fungsi -
unhexfungsi -
uniformfungsi -
unix_datefungsi -
unix_microsfungsi -
unix_millisfungsi -
unix_secondsfungsi -
unix_timestampfungsi -
upperfungsi -
url_decodefungsi -
url_encodefungsi -
userfungsi -
uuidfungsi -
validate_utf8fungsi -
Fungsi agregat
var_pop -
Fungsi agregat
var_samp -
Fungsi agregat
variance -
variant_explodefungsi bernilai tabel -
variant_explode_outerfungsi bernilai tabel -
variant_getfungsi -
vector_searchfungsi -
versionfungsi -
weekdayfungsi -
weekofyearfungsi -
width_bucketfungsi -
Ekspresi pengelompokan
window -
window_timefungsi -
xpathfungsi -
xpath_booleanfungsi -
xpath_doublefungsi -
xpath_floatfungsi -
xpath_intfungsi -
xpath_longfungsi -
xpath_numberfungsi -
xpath_shortfungsi -
xpath_stringfungsi -
xxhash64fungsi -
yearfungsi -
zeroifnullfungsi -
zip_withfungsi -
zstd_compressfungsi -
zstd_decompressfungsi -
bit_reversefungsi -
btrimfungsi -
charindexfungsi