q1. select sum(d) from “sy_4” where M=‘22107NN00110’ AND time > 1541867400000000000 AND time <= 1541896200000000000
output
|time| sum|
|2018-11-10T16:30:00.000000001Z||
q2.select sum(d) from “sy_4” where M=‘22107NN00110’ AND time > 1541867400000000000 AND time <= 1541896300000000000
| time | sum |
|---|---|
| 2018-11-10T16:30:00.000000001Z | 28800000000000 |
for q1 data is not retriving
Hi ,
the queries are different so it is not a bug that they return different results …
If I translate your timestamps to GMT , you query as follows :
q1 :
time > GMT : Saturday, November 10, 2018 4:30:00 PM
and time <= GMT : Sunday, November 11, 2018 12:30:00 AM
q2 :
time > GMT : Saturday, November 10, 2018 4:30:00 PM
and time <= GMT : Sunday, November 11, 2018 12:31:40 AM
I guess it is a data issue ?
best regards ,
