请试试sqlUpdate函数https://www.dolphindb.cn/cn/help/FunctionsandCommands/FunctionReferences/s/sqlUpdate.html 在用户手册的最后有个对分布式表更新的例子如下:
if(existsDatabase("dfs://db1")){ $ dropDatabase("dfs://db1") $ } $ n=1000000 $ t=table(take(`A`B`C`D,n) as symbol, rand(10.0, n) as value) $ db = database("dfs://db1", VALUE, `A`B`C`D) $ Trades = db.createPartitionedTable(t, "Trades", "symbol") $ Trades.append!(t) $ x=exec sum(value) from Trades; $ Trades=loadTable("dfs://db1", "Trades") $ sqlUpdate(table=Trades, updates=<value+1 as value>, where=<symbol=`A>).eval() $ y=exec sum(value) from Trades;