跳转至主要内容

函数

Timeplus Proton supports ANSI-SQL standard syntax. 以下功能适用于各种使用案例。 以下功能适用于各种使用案例。 Most of the functions in ClickHouse are available in Proton, with different naming conventions (for example array_join instead of arrayJoin). New functions are added for streaming processing. 如果您需要更多功能,请联系我们。 New functions are added for streaming processing. 如果您需要更多功能,请联系我们。

注意

Please note, in Proton 1.3.27 or the earlier versions, SQL functions were case-sensitive and always in lower-case. Since 1.3.28, function names are case-insensitive. For example count, COUNT and Count work in the same way. SQL Keywords such as SELECT or FROM are case-insensitive too. In the rest of the documentation, we use function names in lower case for demonstration. Since 1.3.28, function names are case-insensitive. For example count, COUNT and Count work in the same way. SQL Keywords such as SELECT or FROM are case-insensitive too. In the rest of the documentation, we use function names in lower case for demonstration.

类型转换

数组、地图、元组

处理日期和时间

处理 URL

处理 JSON

处理文本

哈希

聚合

逻辑(if, multi_if)

数学

财务

地理位置

流处理