09/11/2022, 9:27 AM
I have update questdb to 6.52 version but the invalid column error is very strange
select distinct a._timestamp_,sum((open/close-1)*rweight*rho)/sum(rweight*rho) as r
from ( select code,timestamp_floor('m',
_timestamp_)  _timestamp_,
open ,close from 'kline_5M' where
_timestamp_>to_timestamp('2022-09-09T00:15', 'yyyy-MM-ddTHH:mm')
) as a join 'factor_weight' as b on a.code=b.code group by groups ,sub_plate order by a.
Andrey Pechkurov

Andrey Pechkurov

09/11/2022, 9:34 AM
Hi Andy, Could you provide a bit more details on the error? Also, did you observe it on previous versions or it looks like a regression in 6.5.2?