All Products
Search

This Product

    Hologres:Function release notes

    Document Center

    Hologres:Function release notes

    Last Updated:Nov 07, 2025

    This topic describes the release notes for functions in Hologres V1.3 and later.

    V4.0

    Version

    Function type

    Function

    Category

    Description

    Execution engine

    References

    4.0.1

    Time and date conversion

    Multiple functions

    New

    Supports multiple time and date truncation functions to facilitate migration from ClickHouse and Apache Doris.

    HQE

    Date and time functions

    V3.2

    Version

    Function type

    Function

    Category

    Description

    Execution engine

    References

    3.2.1

    Array function

    • hg_array_map

    • hg_array_fill

    • hg_array_filter

    • hg_array_sort

    • hg_array_first_index

    New

    Supports Lambda expressions and higher-order array functions containing Lambda expressions.

    HQE

    LAMBDA expressions and related functions

    V3.1

    Version

    Function type

    Function

    Category

    Description

    Execution engine

    References

    3.1.1

    Roaring bitmap functions

    Multiple roaring bitmap functions support 64-bit.

    Enhanced feature

    Multiple roaring bitmap functions support 64-bit.

    HQE

    Roaring bitmap functions

    3.1.1

    Presto-compatible functions

    Multiple Presto-compatible functions are supported.

    New function

    Multiple Presto-compatible functions are supported.

    HQE

    Presto compatible functions

    3.1.1

    Spark-compatible functions

    Multiple Spark-compatible functions are supported.

    New function

    Multiple Spark-compatible functions are supported.

    HQE

    Spark compatible functions

    V3.0

    Version

    Function type

    Function

    Category

    Description

    Execution engine

    References

    3.0.1

    Data type conversion functions

    TRY_CAST

    Enhanced feature

    The following data types are supported by the TRY_CAST function:

    • DATE

    • TIMESTAMP

    • TIMESTAMP_TZ

    HQE

    Data type conversion function

    3.0.1

    Aggregate functions

    • STRING_AGG

    • ARRAY_AGG

    Performance improvement

    The following SQL functions that contain the deduplication and sorting clauses are supported by HQE:

    • STRING_AGG(distinct|order by col)

    • ARRAY_AGG(distinct|order by col)

    Note

    To use the functions, you must run the set hg_experimental_enable_distinct_or_orderby_agg_in_hqe=true; command to set the GUC parameter to true.

    HQE

    V2.2

    Version

    Function type

    Function

    Category

    Description

    Execution engine

    References

    2.2.7

    Data type conversion functions

    text::roaringbitmap

    Performance improvement

    Conversion between the TEXT and roaring bitmap data types is supported by HQE.

    HQE

    Roaring bitmap functions

    2.2.1

    Data type conversion functions

    TRY_CAST

    New function

    The data type conversion function TRY_CAST is supported by Hologres.

    HQE

    Data type conversion function

    2.2.0

    Traffic analysis functions

    Path analysis functions

    New function

    Path analysis functions are supported to facilitate business traffic analysis in an efficient manner.

    HQE

    Path analysis functions

    2.2.0

    General-purpose aggregate functions

    • CORR

    • COVAR_POP

    • COVAR_SAMP

    • REGR_AVGX

    • REGR_AVGY

    • REGR_INTERCEPT

    • REGR_R2

    • REGR_SLOPE

    • REGR_SXX

    • REGR_SXY

    • REGR_SYY

    Performance improvement

    Multiple general-purpose aggregate functions are supported by HQE.

    HQE

    General-purpose aggregate functions

    V2.1

    Version

    Function type

    Function

    Category

    Description

    Execution engine

    References

    2.1.33

    Data type conversion functions

    text::roaringbitmap

    Performance improvement

    Conversion between the TEXT and roaring bitmap data types is supported by HQE.

    HQE

    Roaring bitmap functions

    2.1.33

    Roaring bitmap functions

    ROARINGBITMAP_IN

    New function

    This function is used to convert data of the TEXT type into the roaring bitmap type.

    HQE

    Roaring bitmap functions

    2.1.0

    Funnel analysis functions

    • RANGE_FUNNEL

    • RANGE_FUNNEL_TIME

    • RANGE_FUNNEL_LEVEL

    New function

    The RANGE_FUNNEL, RANGE_FUNNEL_TIME, and RANGE_FUNNEL_LEVEL functions are supported by Hologres.

    • RANGE_FUNNEL: Calculates grouping statistics and aggregates the calculation results of a time window.

    • RANGE_FUNNEL_TIME: Decodes the event time in the result returned by the RANGE_FUNNEL function.

    • RANGE_FUNNEL_LEVEL: Decodes the event level in the result returned by the RANGE_FUNNEL function.

    HQE

    Funnel functions

    2.1.0

    Bit-sliced Index (BSI) functions

    • BSI constructor function

    • BSI expansion function

    • BSI query function

    • BSI aggregate and analytic function

    New function

    BSI functions are supported to improve user profile analysis capabilities.

    PQE

    BSI functions

    2.1.0

    Supported MySQL functions

    IF

    New function

    The IF function is supported by Hologres.

    HQE

    IF

    2.1.0

    Array functions

    • ARRAY[]

    • ARRAY_APPEND

    Performance improvement

    The ARRAY[] function that is used to obtain an array subscript and the ARRAY_APPEND function that is used to append elements to an array are supported by HQE.

    HQE

    Array functions

    2.1.0

    String functions

    REGEXP_SPLIT_TO_TABLE

    Performance improvement

    The REGEXP_SPLIT_TO_TABLE function that is used to split strings is supported by HQE.

    HQE

    String functions

    2.1.0

    Set returning functions

    GENERATE_SERIES

    Performance improvement

    The GENERATE_SERIES function that is used to generate a sequence is supported by HQE. The data types can be INT, BIGINT, or NUMERIC.

    HQE

    Set returning functions

    V2.0

    Version

    Function type

    Function

    Category

    Description

    Execution engine

    References

    2.0.31

    Date and time conversion functions

    • DATEADD

    • DATEDIFF

    • LAST_DAY

    New function

    The DATEADD, DATEDIFF, and LAST_DAY functions are supported by Hologres.

    HQE

    Date and time functions

    2.0.24

    JSONB functions

    TRY_CAST_TO_JSONB

    New function

    The TRY_CAST_TO_JSONB function is supported by Hologres.

    HQE

    JSON and JSONB data types

    2.0.8

    Geographic information analysis functions

    • ST_DISTANCE_SPHERE_S2

    • ST_DWITHIN_S2

    New function

    The ST_DISTANCE_SPHERE_S2 function that is used to calculate the spherical distance and the ST_DWITHIN_S2 function that is used to check the distance relationship are supported by Hologres.

    HQE

    PostGIS spatial functions

    2.0.1

    Supported ClickHouse functions

    HG_SIP_HASH_64(TEXT)

    New function

    The ClickHouse built-in function HG_SIP_HASH_64(TEXT) is added.

    HQE

    Supported ClickHouse functions

    2.0.1

    Data type conversion functions

    • TEXT::TIMESTAMP

    • CAST(TEXT AS TIMESTAMP)

    • TIMESTAMP::TEXT

    • CAST(TIMESTAMP AS TEXT)

    Performance improvement

    Conversion between the TEXT and TIMESTAMP data types is supported by HQE.

    HQE

    Optimize query performance

    2.0.1

    String functions

    • LEFT

    • RIGHT

    Performance improvement

    The string truncation functions LEFT and RIGHT are supported by HQE.

    HQE

    String functions

    V1.3

    Version

    Function type

    Function

    Category

    Description

    Execution engine

    References

    1.3.39

    Date and time functions

    • EXTRACT

    • DATE_PART

    • DATE_TRUNC

    Performance improvement

    The following date and time truncation functions are supported by HQE:

    • EXTRACT

    • DATE_PART

    • DATE_TRUNC

    HQE

    Date and time truncation functions

    1.3.39

    Roaring bitmap functions

    RB_BUILD

    Performance improvement

    The RB_BUILD function allows you to use columns of the ARRAY type as input parameters.

    HQE

    Roaring bitmap functions

    1.3.37

    Array operators

    ARRAY && ARRAY

    Performance improvement

    The && operator allows you to use columns of the ARRAY type as input parameters.

    HQE

    Array functions

    1.3.36

    Supported ClickHouse functions

    • TOSTRING

    • TOINT64

    • TOINT32

    • TODATE

    • TOFLOAT64

    New function

    Some ClickHouse type conversion functions are supported.

    HQE

    Supported ClickHouse functions

    1.3.36

    Aggregate functions

    • MAX_BY

    • MIN_BY

    New function

    The MAX_BY and MIN_BY functions are supported.

    HQE

    MAX_BY and MIN_BY

    1.3.19

    Array functions

    • ARRAY_MAX

    • ARRAY_MIN

    • ARRAY_CONTAINS

    • ARRAY_EXCEPT

    • ARRAY_DISTINCT

    • ARRAY_UNION

    New function

    Some array functions are supported.

    HQE

    Array functions

    1.3.18

    Array functions

    ARRAY_SORT

    Performance improvement

    The ARRAY_SORT function supports more types of arrays.

    HQE

    Array functions

    1.3.16

    Roaring bitmap operators

    • |

    • <<

    • >>

    • -

    New function

    The roaring bitmap operators are supported in specific scenarios.

    HQE

    Roaring bitmap functions

    1.3.16

    Roaring bitmap functions

    • RB_INDEX

    • RB_FILL

    • RB_CLEAR

    • RB_RANGE

    • RB_RANGE_CARDINALITY

    New function

    Some roaring bitmap functions are supported.

    HQE

    Roaring bitmap functions

    1.3.12

    JSON functions

    IS_VALID_JSON

    New function

    The IS_VALID_JSON function is supported to validate JSON strings.

    HQE

    JSON and JSONB data types

    1.3.1

    Aggregate functions

    UNIQ

    New function

    The UNIQ function is supported for precise deduplication.

    HQE

    UNIQ

    1.3.1

    • String functions

    • Array functions

    • ARRAY_AGG

    • STRING_AGG

    Performance improvement

    Filter conditions are supported in expressions.

    HQE

    1.3.1

    JSON functions

    ROW_TO_JSON

    New function

    A JSON function is supported.

    PQE

    row_to_json

    1.3.1

    String functions

    ROW()

    New function

    Some string functions are supported.

    HQE

    String functions

    1.3.1

    PostGIS spatial functions

    • Geometry Constructors

    • Geometry Accessors

    • Geometry Editors

    • Spatial Reference System

    • Geometry Input

    • Geometry Output

    • Spatial Relationships

    • Measurement

    • Overlay

    • Geometry Processing

    • Bounding Box

    • Linear Referencing

    Performance improvement

    HQE supports most spatial functions and supports PostGIS at the production level.

    HQE

    PostGIS spatial functions

    1.3.1

    Supported Oracle functions

    Other functions such as DATE functions and STRING functions

    New function

    The orafce extension is introduced to support Oracle functions.

    HQE

    Supported Oracle functions