可以把返回值转换成矩阵,利用concatMatrix()函数提高合并效率,代码如下所示: def getTable(n){ t = table(1..2500 as id) t["org"] = rand(n,2500) t["orgdiv3"] = rand(n\3,2500) t["orgdiv6"] = rand(n\6,2500) t["orgdiv9"] = rand(n\9,2500) t.rename!(t.colNames()+string(n)) matriX = matrix(t) colNa...
回答于 2023-03-21 15:18
您可以通过以下语句实现上述查询功能: tmp_t = select *,denseRank(qyt) as ranking from t context by area order by area ,ranking desc select id,area,qyt,rowNo(ranking)+1 as ranking from tmp_t context by area
回答于 2023-03-10 13:49
可以使用getJobReturn(job_id)函数获取后台作业的返回结果,job_id是后台作业的id。获取上例的结果可以这样写: result = getJobReturn("getTable")
回答于 2022-12-30 16:18