Hologres:Function release notes

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)

HQE

• STRING_AGG

• ARRAY_AGG

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

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

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

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

• String functions

• Array functions

1.3.1

String functions

• ROW_TO_JSON

• 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