함수와 연산자 목록

함수와 연산자 목록 (List of functions and operators)

이 문서는 Trino의 모든 함수와 연산자를 알파벳 순으로 정리한 목록입니다. 원하는 함수의 이름을 찾아 각 문서의 해당 섹션으로 이동할 수 있어요.

출처: 문서

본문

연산자

• [] 부분 문자열 연산자 (array 문서의 subscript operator)
• || 연결 연산자 (array 문서의 concatenation operator)
• > 비교 연산자 (comparison 문서)
• >= 비교 연산자 (comparison 문서)
• = 비교 연산자 (comparison 문서)
• <> 비교 연산자 (comparison 문서)
• != 비교 연산자 (comparison 문서)
• -> 람다 표현식 (lambda 문서)
• + 수학 연산자 (math 문서)
• - 수학 연산자 (math 문서)
• * 수학 연산자 (math 문서)
• / 수학 연산자 (math 문서)
• % 수학 연산자 (math 문서)

A

• abs() — math
• acos() — math
• ALL — comparison (양화 비교 조건)
• all_match() — array
• AND — logical (논리 연산자)
• ANY — comparison (양화 비교 조건)
• any_match() — array
• any_value() — aggregate
• approx_distinct() — aggregate
• approx_most_frequent() — aggregate
• approx_percentile() — aggregate
• approx_set() — hyperloglog
• arbitrary() — aggregate
• array_agg() — aggregate
• array_distinct() — array
• array_except() — array
• array_first() — array
• array_histogram() — array
• array_intersect() — array
• array_join() — array
• array_last() — array
• array_max() — array
• array_min() — array
• array_position() — array
• array_remove() — array
• array_sort() — array
• array_union() — array
• arrays_overlap() — array
• asin() — math
• AT TIME ZONE — datetime (시간대 변환 연산자)
• at_timezone() — datetime
• atan() — math
• atan2() — math
• avg() — aggregate

B

• bar() — color
• beta_cdf() — math
• BETWEEN — comparison (범위 연산자)
• bing_tile() — geospatial
• bing_tile_at() — geospatial
• bing_tile_coordinates() — geospatial
• bing_tile_polygon() — geospatial
• bing_tile_quadkey() — geospatial
• bing_tile_zoom_level() — geospatial
• bing_tiles_around() — geospatial
• bit_count() — bitwise
• bitwise_and() — bitwise
• bitwise_and_agg() — aggregate
• bitwise_left_shift() — bitwise
• bitwise_not() — bitwise
• bitwise_or() — bitwise
• bitwise_or_agg() — aggregate
• bitwise_right_shift() — bitwise
• bitwise_right_shift_arithmetic() — bitwise
• bitwise_xor() — bitwise
• bool_and() — aggregate
• bool_or() — aggregate

C

• cardinality() — array
• CASE — conditional (CASE 표현식)
• cast() — conversion
• cbrt() — math
• ceil() — math
• ceiling() — math
• char2hexint() — teradata
• checksum() — aggregate
• chr() — string
• classify() — ml
• classifier — match_recognize (분류기 함수)
• coalesce — conditional (COALESCE 함수)
• codepoint() — string
• color() — color
• combinations() — array
• concat() — string
• concat_ws() — string
• contains() — array
• contains_sequence() — array
• convex_hull_agg() — geospatial
• corr() — aggregate
• cos() — math
• cosh() — math
• cosine_distance() — math
• cosine_similarity() — math
• count() — aggregate
• count_if() — aggregate
• covar_pop() — aggregate
• covar_samp() — aggregate
• crc32() — binary
• cume_dist() — window
• current_date — datetime
• current_groups() — session
• current_time — datetime
• current_timestamp — datetime
• current_timezone() — datetime
• current_user — session

D

• date() — datetime
• date_add() — datetime
• date_diff() — datetime
• date_format() — datetime
• date_parse() — datetime
• date_trunc() — datetime
• day() — datetime
• day_of_month() — datetime
• day_of_week() — datetime
• day_of_year() — datetime
• DECIMAL — decimal (십진수 리터럴)
• degrees() — math
• dense_rank() — window
• dow() — datetime
• doy() — datetime

E

• e() — math
• element_at() — array
• empty_approx_set() — hyperloglog
• ends_with() — string
• evaluate_classifier_predictions — ml
• every() — aggregate
• exclude_columns() — table
• extract() — datetime
• exp() — math

F

• features() — ml
• filter() — array
• first — match_recognize (논리 탐색 함수)
• first_value() — window
• flatten() — array
• floor() — math
• format() — conversion
• format_datetime() — datetime
• format_number() — conversion
• from_base() — math
• from_base32() — binary
• from_base64() — binary
• from_base64url() — binary
• from_big_endian_32() — binary
• from_big_endian_64() — binary
• from_encoded_polyline() — geospatial
• from_geojson_geometry — geospatial
• from_hex() — binary
• from_ieee754_32() — binary
• from_ieee754_64() — binary
• from_iso8601_date() — datetime
• from_iso8601_timestamp() — datetime
• from_iso8601_timestamp_nanos() — datetime
• from_unixtime() — datetime
• from_unixtime_nanos() — datetime
• from_utf8() — string

G

• geometric_mean() — aggregate
• geometry_collect_agg() — geospatial
• geometry_from_hadoop_shape() — geospatial
• geometry_invalid_reason() — geospatial
• geometry_nearest_points() — geospatial
• geometry_to_bing_tiles() — geospatial
• geometry_union() — geospatial
• geometry_union_agg() — geospatial
• great_circle_distance() — geospatial
• greatest() — comparison

H

• hamming_distance() — string
• hash_counts() — setdigest
• histogram() — aggregate
• hmac_md5() — binary
• hmac_sha1() — binary
• hmac_sha256() — binary
• hmac_sha512() — binary
• hour() — datetime
• human_readable_seconds() — datetime

I

• if — conditional (IF 표현식)
• index() — teradata
• infinity() — math
• intersection_cardinality() — setdigest
• inverse_beta_cdf() — math
• inverse_normal_cdf() — math
• is_finite() — math
• is_infinite() — math
• is_json_scalar() — json
• is_nan() — math
• IS NOT DISTINCT — comparison
• IS NOT NULL — comparison
• IS DISTINCT — comparison
• IS NULL — comparison

J

• jaccard_index() — setdigest
• json_array() — json
• json_array_contains() — json
• json_array_get() — json
• json_array_length() — json
• json_exists() — json
• json_extract() — json
• json_extract_scalar() — json
• json_format() — json
• json_object() — json
• json_parse() — json
• json_query() — json
• json_size() — json
• json_value() — json

K

• kurtosis() — aggregate

L

• lag() — window
• last — match_recognize (논리 탐색 함수)
• last_day_of_month() — datetime
• last_value() — window
• lead() — window
• learn_classifier() — ml
• learn_libsvm_classifier() — ml
• learn_libsvm_regressor() — ml
• learn_regressor() — ml
• least() — comparison
• length() — string
• levenshtein_distance() — string
• line_interpolate_point() — geospatial
• line_interpolate_points() — geospatial
• line_locate_point() — geospatial
• listagg() — aggregate
• ln() — math
• localtime — datetime
• localtimestamp — datetime
• log() — math
• log10() — math
• log2() — math
• lower() — string
• lpad() — string
• ltrim() — string
• luhn_check() — string

M

• make_set_digest() — setdigest
• map() — map
• map_agg() — aggregate
• map_concat() — map
• map_entries() — map
• map_filter() — map
• map_from_entries() — map
• map_keys() — map
• map_union() — aggregate
• map_values() — map
• map_zip_with() — map
• match_number — match_recognize
• max() — aggregate
• max_by() — aggregate
• md5() — binary
• merge() — hyperloglog
• merge_set_digest() — setdigest
• millisecond() — datetime
• min() — aggregate
• min_by() — aggregate
• minute() — datetime
• mod() — math
• month() — datetime
• multimap_agg() — aggregate
• multimap_from_entries() — map
• murmur3() — binary

N

• nan() — math
• next — match_recognize (물리 탐색 함수)
• ngrams() — array
• none_match() — array
• normal_cdf() — math
• normalize() — string
• NOT — logical (논리 연산자)
• NOT BETWEEN — comparison (범위 연산자)
• now() — datetime
• nth_value() — window
• ntile() — window
• nullif — conditional (NULLIF 함수)
• numeric_histogram() — aggregate

O

• objectid — mongodb 커넥터
• objectid_timestamp() — mongodb 커넥터
• OR — logical (논리 연산자)

P

• parse_datetime() — datetime
• parse_duration() — datetime
• parse_data_size() — conversion
• percent_rank() — window
• permute — match_recognize
• pi() — math
• position() — string
• pow() — math
• power() — math
• prev — match_recognize (물리 탐색 함수)

Q

• qdigest_agg() — qdigest
• quarter() — datetime

R

• radians() — math
• rand() — math
• random() — math
• random_string() — Faker 커넥터의 카탈로그 함수 (Faker 커넥터)
• rank() — window
• reduce() — array
• reduce_agg() — aggregate
• regexp_count() — regexp
• regexp_extract() — regexp
• regexp_extract_all() — regexp
• regexp_like() — regexp
• regexp_position() — regexp
• regexp_replace() — regexp
• regexp_split() — regexp
• regress() — ml
• regr_intercept() — aggregate
• regr_slope() — aggregate
• render() — color
• repeat() — array
• replace() — string
• reverse() — string
• rgb() — color
• round() — math
• ROW::fields() — row
• row_number() — window
• rpad() — string
• rtrim() — string

S

• second() — datetime
• sequence() — array (스칼라 함수)
• sequence() — table (테이블 함수)
• sha1() — binary
• sha256() — binary
• sha512() — binary
• shuffle() — array
• sign() — math
• simplify_geometry() — geospatial
• sin() — math
• sinh() — math
• skewness() — aggregate
• slice() — array
• SOME — comparison (양화 비교 조건)
• soundex() — string
• spatial_partitioning() — geospatial
• spatial_partitions() — geospatial
• split() — string
• split_part() — string
• split_to_map() — string
• split_to_multimap() — string
• spooky_hash_v2_32() — binary
• spooky_hash_v2_64() — binary
• sqrt() — math
• ST_Area() — geospatial
• ST_AsBinary() — geospatial
• ST_AsEWKB() — geospatial
• ST_AsEWKT() — geospatial
• ST_AsText() — geospatial
• ST_Boundary() — geospatial
• ST_Buffer() — geospatial
• ST_Centroid() — geospatial
• ST_Collect() — geospatial
• ST_Contains() — geospatial
• ST_ConvexHull() — geospatial
• ST_CoordDim() — geospatial
• ST_Crosses() — geospatial
• ST_Difference() — geospatial
• ST_Dimension() — geospatial
• ST_Disjoint() — geospatial
• ST_Distance() — geospatial
• ST_EndPoint() — geospatial
• ST_Envelope() — geospatial
• ST_EnvelopeAsPts() — geospatial
• ST_Equals() — geospatial
• ST_ExteriorRing() — geospatial
• ST_Force2D() — geospatial
• ST_Force3D() — geospatial
• ST_Geometries() — geospatial
• ST_GeometryFromText() — geospatial
• ST_GeometryN() — geospatial
• ST_GeometryType() — geospatial
• ST_GeomFromBinary() — geospatial
• ST_GeomFromEWKT() — geospatial
• ST_GeomFromKML() — geospatial
• ST_InteriorRingN() — geospatial
• ST_InteriorRings() — geospatial
• ST_Intersection() — geospatial
• ST_Intersects() — geospatial
• ST_IsClosed() — geospatial
• ST_IsEmpty() — geospatial
• ST_IsRing() — geospatial
• ST_IsSimple() — geospatial
• ST_IsValid() — geospatial
• ST_Length() — geospatial
• ST_LineFromText() — geospatial
• ST_LineMerge() — geospatial
• ST_LineString() — geospatial
• ST_MakeLine() — geospatial
• ST_MakePolygon() — geospatial
• ST_MinimumBoundingCircle() — geospatial
• ST_Multi() — geospatial
• ST_MultiPoint() — geospatial
• ST_Normalize() — geospatial
• ST_NumGeometries() — geospatial
• ST_NumInteriorRing() — geospatial
• ST_NumPoints() — geospatial
• ST_OrientedEnvelope() — geospatial
• ST_Overlaps() — geospatial
• ST_Point() — geospatial
• ST_PointN() — geospatial
• ST_PointOnSurface() — geospatial
• ST_Points() — geospatial
• ST_Polygon() — geospatial
• ST_Polygonize() — geospatial
• ST_Relate() — geospatial
• ST_ReducePrecision() — geospatial
• ST_SetSRID() — geospatial
• ST_SRID() — geospatial
• ST_StartPoint() — geospatial
• ST_SymDifference() — geospatial
• ST_Touches() — geospatial
• ST_Transform() — geospatial
• ST_Union() — geospatial
• ST_VoronoiPolygons() — geospatial
• ST_Within() — geospatial
• ST_X() — geospatial
• ST_XMax() — geospatial
• ST_XMin() — geospatial
• ST_Y() — geospatial
• ST_YMax() — geospatial
• ST_YMin() — geospatial
• ST_Z() — geospatial
• starts_with() — string
• stddev() — aggregate
• stddev_pop() — aggregate
• stddev_samp() — aggregate
• strpos() — string
• substr() — string
• substring() — string
• sum() — aggregate

T

• tan() — math
• tanh() — math
• tdigest_agg() — tdigest
• theta_sketch_cardinality() — datasketches
• theta_sketch_union() — datasketches
• timestamp_objectid() — mongodb 커넥터
• timezone() — datetime
• timezone_hour() — datetime
• timezone_minute() — datetime
• title_case() — string
• to_base() — math
• to_base32() — binary
• to_base64() — binary
• to_base64url() — binary
• to_big_endian_32() — binary
• to_big_endian_64() — binary
• to_char() — teradata
• to_date() — teradata
• to_encoded_polyline() — geospatial
• to_geojson_geometry — geospatial
• to_geometry() — geospatial
• to_hex() — binary
• to_ieee754_32() — binary
• to_ieee754_64() — binary
• to_iso8601() — datetime
• to_milliseconds() — datetime
• to_spherical_geography() — geospatial
• to_timestamp() — teradata
• to_unixtime() — datetime
• to_utf8() — string
• transform() — array
• transform_keys() — map
• transform_values() — map
• translate() — string
• trim() — string
• trim_array() — array
• truncate() — math
• try — conditional (TRY 함수)
• try_cast() — conversion
• typeof() — conversion

U

• upper() — string
• url_decode() — url
• url_encode() — url
• url_extract_fragment() — url
• url_extract_host() — url
• url_extract_parameter() — url
• url_extract_path() — url
• url_extract_protocol() — url
• url_extract_port() — url
• url_extract_query() — url
• uuid() — uuid

V

• value_at_quantile() — qdigest
• values_at_quantiles() — qdigest
• var_pop() — aggregate
• var_samp() — aggregate
• variance() — aggregate
• version() — system

W

• week() — datetime
• week_of_year() — datetime
• width_bucket() — math
• wilson_interval_lower() — math
• wilson_interval_upper() — math
• with_timezone() — datetime
• word_stem() — string

X

• xxhash64() — binary

Y

• year() — datetime
• year_of_week() — datetime
• yow() — datetime

Z

• zip() — array
• zip_with() — array

더 알아보기 (Learn more)

특정 함수의 상세한 설명은 주제별 함수 문서에서 확인할 수 있어요. 원하는 함수가 어떤 주제에 속하는지 헷갈린다면 주제별 함수 목록 문서도 함께 참고해보세요.