【详述】SQL查询报错: SQL 错误 [1064] [42000]: Row count of const column reach limit: 4294967296
【查询SQL】select VHCLE,avg(speed) as spd from (
select VHCLE,distance/TDF as speed from (
select VHCLE,GPS_TIME, ST_Distance_Sphere(LONGITUDE,LATITUDE,NLON,NLAT) AS distance,
date_diff(‘second’, GPS_TIME, NTIME) as TDF from (
select VHCLE,GPS_TIME,LONGITUDE,LATITUDE
,lag(GPS_TIME) over(partition by VHCLE order by GPS_TIME) as NTIME
,lag(LONGITUDE) over(partition by VHCLE order by GPS_TIME) as NLON
,lag(LATITUDE) over(partition by VHCLE order by GPS_TIME) as NLAT from (
select VHCLE,GPS_TIME,LONGITUDE,LATITUDE FROM V2X.ODS_JTT808_0200_T PARTITION(p20230930)
– where VHCLE between ‘0070686653’ and ‘0070686663’
)ta ) tb )tc where TDF!=0 and distance!=0 )td group by VHCLE
【StarRocks版本】3.1.3
【集群规模】：4fe+8be
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-邓平或者邮箱，谢谢
【附件】dump_file (23.9 KB)