spark内置函数

这里汇总了各大厂的Spark SQL面试真题，按公司分类整理，点击下方卡片可查看对应内容：

标签 417 个项目

OR

1abs2acos3acosh4add_months5aes_decrypt6aes_encrypt7aggregate8and9any10any_value11approx_count_distinct12approx_percentile13array14array_agg15array_append16array_compact17array_contains18array_distinct19array_except20array_insert21array_intersect22array_join23array_max24array_min25array_position26array_prepend27array_remove28array_repeat29array_size30array_sort31array_union32arrays_overlap33arrays_zip34ascii35asin36asinh37assert_true38atan39atan240atanh41avg42base6443between44bigint45bin46binary47bit_and48bit_count49bit_get50bit_length51bit_or52bit_xor53bitmap_bit_position54bitmap_bucket_number55bitmap_construct_agg56bitmap_count57bitmap_or_agg58bool_and59bool_or60boolean61bround62btrim63cardinality64case65cast66cbrt67ceil68ceiling69char70char_length71character_length72chr73coalesce74collect_list75collect_set76concat77concat_ws78contains79conv80convert_timezone81corr82cos83cosh84cot85count86count_if87count_min_sketch88covar_pop89covar_samp90crc3291csc92cume_dist93curdate94current_catalog95current_database96current_date97current_schema98current_timestamp99current_timezone100current_user101date102date_add103date_diff104date_format105date_from_unix_date106date_part107date_sub108date_trunc109dateadd110datediff111datepart112day113dayofmonth114dayofweek115dayofyear116decimal117decode118degrees119dense_rank120div121double122e123element_at124elt125encode126endswith127equal_null128every129exists130exp131explode132explode_outer133expm1134extract135factorial136filter137find_in_set138first139first_value140flatten141float142floor143forall144format_number145format_string146from_csv147from_json148from_unixtime149from_utc_timestamp150get151get_json_object152getbit153greatest154grouping155grouping_id156hash157hex158histogram_numeric159hll_sketch_agg160hll_sketch_estimate161hll_union162hll_union_agg163hour164hypot165if166ifnull167ilike168in169initcap170inline171inline_outer172input_file_block_length173input_file_block_start174input_file_name175instr176int177isnan178isnotnull179isnull180java_method181json_array_length182json_object_keys183json_tuple184kurtosis185lag186last187last_day188last_value189lcase190lead191least192left193len194length195levenshtein196like197ln198localtimestamp199locate200log201log10202log1p203log2204lower205lpad206ltrim207luhn_check208make_date209make_dt_interval210make_interval211make_timestamp212make_timestamp_ltz213make_timestamp_ntz214make_ym_interval215map216map_concat217map_contains_key218map_entries219map_filter220map_from_arrays221map_from_arrays222map_keys223map_values224map_zip_with225mask226max227max_by228md5229mean230median231min232min_by233minute234mod235mode236monotonically_increasing_id237month238months_between239named_struct240nanvl241negative242next_day243not244now245nth_value246ntile247nullif248nvl249nvl2250octet_length251or252overlay253parse_url254percent_rank255percentile256percentile_approx257pi258pmod259posexplode260posexplode_outer261position262positive263pow264power265printf266Spark Functions 隐私政策267quarter268radians269raise_error270rand271randn272random273rank274reduce275reflect276regexp277regexp_count278regexp_extract279regexp_extract_all280regexp_instr281regexp_like282regexp_replace283regexp_substr284regr_avgx285regr_avgy286regr_count287regr_intercept288regr_r2289regr_slope290regr_sxx291regr_sxy292regr_syy293repeat294replace295reverse296right297rint298rlike299round300row_number301repeat302rtrim303schema_of_csv304schema_of_json305sec306second307sentences308sequence309session_window310sha311sha1312sha2313shiftleft314shiftright315shiftrightunsigned316shuffle317sign318signum319sin320sinh321size322skewness323slice324smallint325some326sort_array327soundex328space329spark_partition_id330split331split_part332sqrt333stack334startswith335std336stddev337stddev_pop338stddev_samp339str_to_map340string341struct342substr343substring344substring_index345sum346tan347tanh348timestamp349timestamp_micros350timestamp_millis351timestamp_seconds352tinyint353to_binary354to_char355to_csv356to_date357to_json358to_number359to_timestamp360to_timestamp_ltz361to_timestamp_ntz362to_unix_timestamp363to_utc_timestamp364to_varchar365transform366transform_keys367transform_values368translate369trim370trunc371try_add372try_aes_decrypt373try_avg374try_divide375try_element_at376try_multiply377try_subtract378try_sum379try_to_binary380try_to_number381try_to_timestamp382typeof383ucase384unbase64385unhex386unix_date387unix_micros388unix_millis389unix_seconds390unix_timestamp391upper392url_decode393url_encode394user395uuid396var_pop397var_samp398variance399version400weekday401weekofyear402when403width_bucket404window405window_time406xpath407xpath_boolean408xpath_double409xpath_float410xpath_int411xpath_long412xpath_number413xpath_short414xpath_string415xxhash64416year417zip_with

📌 说明

1. 所有面试题均为真实大厂真题，包含详细解析；
2. 持续更新阿里、腾讯、美团等更多公司的面试题；
3. 如有疑问或补充，可在评论区反馈。