S02015
错误代码
S02015
报错信息
The table object must be a DFS table. RefId: S02015
错误原因
在 pivot by 查询中，对查询列应用 asis
函数展示所有查询结果（包含重复数据）时，要求查询的表必须是分布式分区表。若不是分布式分区表，则会出现这个报错，如下例：
time = [10:20:44,10:20:44,10:20:44,10:20:45,10:20:45,10:20:45,10:20:46,10:20:46,10:20:46,10:20:46,10:20:46,10:20:46]
sym = ["A","B","C","A","B","C","A","B","C","A","B","C"]
value = [510,434,999,837,402,615,495,885,745,968,975,165]
t = table(time,sym,value)
select asis(value) from t pivot by time,sym解决办法
根据 pivot by 中关于结合使用 asis 和
pivot by 的要求，检查所写的查询语句是否满足这些要求。