You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
c.b.m.e.p.i.PaginationInnerInterceptor : optimize this sql to a count sql has exception, sql:"SELECT _wstart as ts ,avg(water_level) as water_level ,avg(water_level_elevation) as water_level_elevation,avg(battery) as battery
from db_cellar_platform.t_cellar_history_data
WHERE
1=1
and ts >= ?
and ts <= ?
and device_id in
(
?
)
interval(1d) fill(prev)", exception:
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "interval" "INTERVAL"
at line 17, column 4.
c.b.m.e.p.i.PaginationInnerInterceptor : optimize this sql to a count sql has exception, sql:"SELECT _wstart as ts ,avg(water_level) as water_level ,avg(water_level_elevation) as water_level_elevation,avg(battery) as battery
from db_cellar_platform.t_cellar_history_data
WHERE
1=1
and ts >= ?
and ts <= ?
and device_id in
(
?
)
interval(1d) fill(prev)", exception:
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "interval" "INTERVAL"
at line 17, column 4.
当前使用版本(必填,否则不予处理)
v3.5.3
该问题是如何引起的?(确定最新版也有问题再提!!!)
c.b.m.e.p.i.PaginationInnerInterceptor : optimize this sql to a count sql has exception, sql:"SELECT _wstart as ts ,avg(water_level) as water_level ,avg(water_level_elevation) as water_level_elevation,avg(battery) as battery
from db_cellar_platform.t_cellar_history_data
WHERE
1=1
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "interval" "INTERVAL"
at line 17, column 4.
Was expecting one of:
重现步骤(如果有就写完整)
报错信息
c.b.m.e.p.i.PaginationInnerInterceptor : optimize this sql to a count sql has exception, sql:"SELECT _wstart as ts ,avg(water_level) as water_level ,avg(water_level_elevation) as water_level_elevation,avg(battery) as battery
from db_cellar_platform.t_cellar_history_data
WHERE
1=1
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "interval" "INTERVAL"
at line 17, column 4.
Was expecting one of:
The text was updated successfully, but these errors were encountered: