是GUI->Preferences里的SSL勾选上了,把这个去掉;
回答于 2022-02-15 15:10
用rowNo函数, select * from t context by id having rowNo(id) < size(id) - 1
回答于 2022-02-09 12:50
t=table(1..500000 as id, take(['600000.SH','600001.SH','600002.SH','000002.SZ','000001.SZ'],500000) as x); 可以通过以下三种方法修改: update t set x = iif(right(x,3)=='.SH', take("1",size(x))+left(x,6),take("0",size(x))+left(x,6)) update t set x = iif(right(x,3)=='.SH',"1"+string(left(x,6)),"6"+s...
回答于 2022-02-08 16:53
你好 按旬统计的话semiMonthBegin这个函数不适合,这个函数请参考 https://www.dolphindb.cn/cn/help/200/FunctionsandCommands/FunctionReferences/s/semiMonthBegin.html?highlight=semimonthbegin 要实现按旬统计,可以自定义函数增加一列,再group by统计,代码如下 def f(x){ Count =x.size() res = array(STRIN...
回答于 2022-01-17 13:20
由于Python pandas中所有有关时间的数据类型均为datetime64,上传一个DataFrame到DolphinDB以后,所有时间类型的列均为nanotimestamp,每次使用tableInsert函数或者insert into语句往内存表或分布式表追加一个带有时间类型列的DataFrame时,都需要对时间列进行类型转换,非常麻烦。因此Python API提供了tableAppender对象,...
回答于 2021-12-18 21:55
用try..catch,异常抛出return double()就可以了,如下: t1 = select * from table_raw where date>2021.12.08 def myols(y,x) { r=ols(y,x,true,2) try {return r.RegressionStat.statistics[1]} catch(ex) {return double()} } select myols(price, volume) as r2 from t1 group by date, wind_code
回答于 2021-12-15 13:39