S02057

错误代码

S02057

报错信息

The 'kendall' function is not allowed in a distributed query. RefId: S02057

错误原因

查询分区表的语句中不能使用kendall 函数。如下 case 会报错：

dbName = "dfs://test"
if (existsDatabase(dbName)) {
    dropDatabase(dbName)
}
t = table(2023.01.01..2023.01.03 as tradeDate, 1..3 as val)
db = database(dbName, VALUE, 2023.01.01..2023.01.03)
pt = db.createPartitionedTable(t, `pt, `tradeDate)
pt.append!(t)

select kendall(val, val) from pt

解决办法

修改查询语句，避免在分区表的查询语句中使用 kendall 函数。