我正在使用timeseries板条箱数据库。下面是我的table

Name         Type
parameterid TEXT
deviceid TEXT
gatewayid TEXT
timestamp DOUBLE PRECISION
reading DOUBLE PRECISION

我试图根据时间戳对数据进行分组。我在本地机器（cratedbdocker版本）中运行这个查询，它运行得非常好
sqlactionexception[sqlparseexception:无法在索引0处分析文本“1.6164576e9”]
查询是

select
    date_trunc('day', v.timestamp) as unixtime,
    sum(reading) as reading
from
    telemetryvct v(parameterid, reading, timestamp)
where
    parameterid = 1
    AND timestamp >= 1616457600
    AND timestamp <= 1619524054
group by
    (unixtime)
ORDER BY
    unixtime ASC

请帮帮我。。样本数据