[roadmap-track] functions

[BohuTANG]

Main issue tracking for functions.

Functions

Task	Status	Release Target	Comments
VERSION() #762	DONE	v0.5	Thanks @PsiACE
SLEEP() #802	DONE	v0.5
LIKE/NOT LIKE #784	DONE	v0.5	Thanks @b41sh
Conditional Functions #918	DONE	v0.5
window funnel function #966	DONE	v0.5
Type Conversion Functions #967	DONE	v0.5	Thanks @wangzhen11aaa
std #967	DONE	v0.5
runningDifference #1787	DONE	v0.5
Date/DateTime track #853	PROGRESS	v0.5	Very useful for timeseries queries
more functions working with number #2563	PROGRESS
EXTRACT #428	PLANNING	v0.5
IN (...) #826	PLANNING	v0.5
Encryption functions #2162	PLANNING	v0.5
[MATERIALIZE]	PLANNING

[zhang2014]

Add:
sleep(N seconds) for test: sleep function allows to suspend the query for N seconds
materialize([column1, column2, ...]) for performance test: materialize function allows Scalar columns to convert to Array columns. useful for performance testing.

[BohuTANG]

Add:
like not like

[BohuTANG]

Add:
EXTRACT #428

[zhang2014]

Add:
IN Operator #826

[zhang2014]

Add:
toStartOfInterval: https://clickhouse.tech/docs/en/sql-reference/functions/date-time-functions/#tostartofintervaltime-or-data-interval-x-unit-time-zone

[BohuTANG]

Add:
Date/DateTime : https://clickhouse.tech/docs/en/sql-reference/functions/date-time-functions/

[BohuTANG]

Add:
Conditional Functions #918

[BohuTANG]

Add:
window funnel function #966

[BohuTANG]

Add:
Type Conversion Functions #967

[BohuTANG]

Add:
runningDifference #1787|

[BohuTANG]

Add:
Encryption functions #2162

[Xuanwo]

Are we still tracking functions on this issue not?

• If true, we need to do some update
• If not, I prefer to close this issue.

[zhang2014]

Most the items in the list have been finished or there are other issues to track them. yes. Let's close it.