Databricks SQL Functions

Built-in functions | Databricks on AWS

str_to_map function | Databricks on AWS

Alphabetical list of built-in functions | Databricks on AWS

• abs function
• acos function
• acosh function
• add_months function
• aes_decrypt function
• aes_encrypt function
• aggregate function
• ai_generate_text function
• ai_query function
• & (ampersand sign) operator
• and predicate
• any aggregate function
• any_value aggregate function
• approx_count_distinct aggregate function
• approx_percentile aggregate function
• approx_top_k aggregate function
• array function
• array_agg aggregate function
• array_append function
• array_compact function
• array_contains function
• array_distinct function
• array_except function
• array_insert function
• array_intersect function
• array_join function
• array_max function
• array_min function
• array_position function
• array_prepend function
• array_remove function
• array_repeat function
• array_size function
• array_sort function
• array_union function
• arrays_overlap function
• arrays_zip function
• ascii function
• asin function
• asinh function
• assert_true function
• * (asterisk sign) operator
• atan function
• atan2 function
• atanh function
• avg aggregate function
• != (bangeq sign) operator
• ! (bang sign) operator
• base64 function
• between predicate
• bigint function
• bin function
• binary function
• bit_and aggregate function
• bit_count function
• bit_get function
• bit_length function
• bit_or aggregate function
• bit_reverse function
• bit_xor aggregate function
• bitmap_bit_position function
• bitmap_bucket_number function
• bitmap_construct_agg aggregate function
• bitmap_count function
• bitmap_or_agg aggregate function
• bool_and aggregate function
• bool_or aggregate function
• boolean function
• [ ] (bracket sign) operator
• bround function
• btrim function
• cardinality function
• ^ (caret sign) operator
• case expression
• cast function
• cbrt function
• ceil function
• ceiling function
• char function
• char_length function
• character_length function
• charindex function
• chr function
• cloud_files_state table-valued function
• coalesce function
• collect_list aggregate function
• collect_set aggregate function
• :: (colon colon sign) operator
• : (colon sign) operator
• concat function
• concat_ws function
• contains function
• conv function
• convert_timezone function
• corr aggregate function
• cos function
• cosh function
• cot function
• count aggregate function
• count_if aggregate function
• count_min_sketch aggregate function
• covar_pop aggregate function
• covar_samp aggregate function
• crc32 function
• csc function
• cube function
• cume_dist analytic window function
• curdate function
• current_catalog function
• current_database function
• current_date function
• current_metastore function
• current_schema function
• current_timestamp function
• current_timezone function
• current_user function
• current_version function
• date function
• date_add (days) function
• date_add function
• date_diff function
• date_format function
• date_from_unix_date function
• date_part function
• date_sub function
• date_trunc function
  • > SELECT date_trunc('YEAR', '2015-03-05T09:32:05.359'); >>> 2015-01-01 00:00:00
• dateadd function
• dateadd (days) function
• datediff function
• datediff (timestamp) function
• day function
• dayofmonth function
• dayofweek function
• dayofyear function
• decimal function
• decode function
• decode (character set) function
• degrees function
• dense_rank ranking window function
• div operator
• . (dot sign) operator
• double function
• e function
• element_at function
• elt function
• encode function
• endswith function
• \==(eq eq sign) operator
• \= (eq sign) operator
• equal_null function
• event_log table-valued function
• every aggregate function
• exists function
• exp function
• explode table-valued generator function
• explode_outer table-valued generator function
• expm1 function
• extract function
• factorial function
• filter function
• find_in_set function
• first aggregate function
• first_value aggregate function
• flatten function
• float function
• floor function
• forall function
• format_number function
• format_string function
• from_csv function
• from_json function
• from_unixtime function
• from_utc_timestamp function
• get function
• get_json_object function
• getbit function
• greatest function
• grouping function
• grouping_id function
• >= (gt eq sign) operator
• > (gt sign) operator
• h3_boundaryasgeojson function
• h3_boundaryaswkb function
• h3_boundaryaswkt function
• h3_centerasgeojson function
• h3_centeraswkb function
• h3_centeraswkt function
• h3_compact function
• h3_coverash3 function
• h3_coverash3string function
• h3_distance function
• h3_h3tostring function
• h3_hexring function
• h3_ischildof function
• h3_ispentagon function
• h3_isvalid function
• h3_kring function
• h3_kringdistances function
• h3_longlatash3 function
• h3_longlatash3string function
• h3_maxchild function
• h3_minchild function
• h3_pointash3 function
• h3_pointash3string function
• h3_polyfillash3 function
• h3_polyfillash3string function
• h3_resolution function
• h3_stringtoh3 function
• h3_tochildren function
• h3_toparent function
• h3_try_polyfillash3 function
• h3_try_polyfillash3string function
• h3_try_validate function
• h3_uncompact function
• h3_validate function
• hash function
• hex function
• hll_sketch_agg aggregate function
• hll_sketch_estimate function
• hll_union function
• hll_union_agg function
• hour function
• hypot function
• if function
• iff function
• ifnull function
• ilike operator
• in predicate
• initcap function
• inline table-valued generator function
• inline_outer table-valued generator function
• input_file_block_length function
• input_file_block_start function
• input_file_name function
• instr function
• int function
• is_account_group_member function
• is_member function
• is distinct operator
• is false operator
• isnan function
• isnotnull function
• isnull function
• is null operator
• is true operator
• java_method function
• json_array_length function
• json_object_keys function
• json_tuple table-valued generator function
• kurtosis aggregate function
• lag analytic window function
• last aggregate function
• last_day function
• last_value aggregate function
• lcase function
• lead analytic window function
• least function
• left function
• len function
• length function
• levenshtein function
• like operator
• list_secrets table function
• ln function
• locate function
• log function
• log10 function
• log1p function
• log2 function
• lower function
• lpad function
• <=> (lt eq gt sign) operator
• <= (lt eq sign) operator
• <> (lt gt sign) operator
• ltrim function
• < (lt sign) operator
• luhn_check function
• make_date function
• make_dt_interval function
• make_interval function
• make_timestamp function
• make_ym_interval function
• map function
• map_concat function
• map_contains_key function
• map_entries function
• map_filter function
• map_from_arrays function
• map_from_entries function
• map_keys function
• map_values function
• map_zip_with function
• mask function
• max aggregate function
• max_by aggregate function
• md5 function
• mean aggregate function
• median aggregate function
• min aggregate function
• min_by aggregate function
• - (minus sign) operator
• - (minus sign) unary operator
• minute function
• mod function
• mode aggregate function
• monotonically_increasing_id function
• month function
• months_between function
• named_struct function
• nanvl function
• negative function
• next_day function
• not operator
• now function
• nth_value analytic window function
• ntile ranking window function
• nullif function
• nvl function
• nvl2 function
• octet_length function
• or operator
• overlay function
• parse_url function
• percent_rank ranking window function
• percentile aggregate function
• percentile_approx aggregate function
• percentile_cont aggregate function
• percentile_disc aggregate function
• % (percent sign) operator
• pi function
• || (pipe pipe sign) operator
• | (pipe sign) operator
• + (plus sign) operator
• + (plus sign) unary operator
• pmod function
• posexplode table-valued generator function
• posexplode_outer table-valued generator function
• position function
• positive function
• pow function
• power function
• printf function
• quarter function
• radians function
• raise_error function
• rand function
• randn function
• random function
• range table-valued function
• rank ranking window function
• read_files table-valued function
• read_kafka table-valued function
• reduce function
• reflect function
• regexp operator
• regexp_count function
• regexp_extract function
• regexp_extract_all function
• regexp_instr function
• regexp_like function
• regexp_replace function
• regexp_substr function
• regr_avgx aggregate function
• regr_avgy aggregate function
• regr_count aggregate function
• regr_intercept aggregate function
• regr_r2 aggregate function
• regr_slope aggregate function
• regr_sxx aggregate function
• regr_sxy aggregate function
• regr_syy aggregate function
• repeat function
• replace function
• reverse function
• right function
• rint function
• rlike operator
• round function
• row_number ranking window function
• rpad function
• rtrim function
• schema_of_csv function
• schema_of_json function
• sec function
• second function
• secret function
• sentences function
• sequence function
• session_window grouping expression
• sha function
• sha1 function
• sha2 function
• shiftleft function
• shiftright function
• shiftrightunsigned function
• shuffle function
• sign function
• signum function
• sin function
• sinh function
• size function
• skewness aggregate function
• / (slash sign) operator
• slice function
• smallint function
• some aggregate function
• sort_array function
• soundex function
• space function
• spark_partition_id function
• split function
• split_part function
• sql_keywords function
• sqrt function
• stack table-valued generator function
• startswith function
• std aggregate function
• stddev aggregate function
• stddev_pop aggregate function
• stddev_samp aggregate function
• str_to_map function
• string function
• struct function
• substr function
• substring function
• substring_index function
• sum aggregate function
• table_changes table-valued function
• tan function
• tanh function
• ~ (tilde sign) operator
• timediff function
• timestamp function
• timestamp_micros function
• timestamp_millis function
• timestamp_seconds function
• timestampadd function
• timestampdiff function
• tinyint function
• to_binary function
• to_char function
• to_csv function
• to_date function
• to_json function
• to_number function
• to_timestamp function
• to_unix_timestamp function
• to_utc_timestamp function
• to_varchar function
• transform function
• transform_keys function
• transform_values function
• translate function
• trim function
• trunc function
• try_add function
• try_aes_decrypt function
• try_avg aggregate function
• try_cast function
• try_divide function
• try_element_at function
• try_multiply function
• try_subtract function
• try_sum aggregate function
• try_to_binary function
• try_to_number function
• try_to_timestamp function
• typeof function
• ucase function
• unbase64 function
• unhex function
• unix_date function
• unix_micros function
• unix_millis function
• unix_seconds function
• unix_timestamp function
• upper function
• url_decode function
• url_encode function
• user function
• uuid function
• var_pop aggregate function
• var_samp aggregate function
• variance aggregate function
• version function
• weekday function
• weekofyear function
• width_bucket function
• window grouping expression
• window_time function
• xpath function
• xpath_boolean function
• xpath_double function
• xpath_float function
• xpath_int function
• xpath_long function
• xpath_number function
• xpath_short function
• xpath_string function
• xxhash64 function
• year function
• zip_with function