Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CONTINUOUS QUERIES result mismatch #10207

Closed
tinycolds opened this issue Aug 19, 2018 · 2 comments
Closed

CONTINUOUS QUERIES result mismatch #10207

tinycolds opened this issue Aug 19, 2018 · 2 comments

Comments

@tinycolds
Copy link

tinycolds commented Aug 19, 2018

System info:
Influxdb: 1.5.3
SySTEM: Linux 3.16.0-4-amd64 #1 SMP Debian 3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux

Steps to reproduce:

1. Create CONTINUOUS QUERIES:
Use CONTINUOUS QUERY to Calculate sum and count of filed1 into a new rention policy measurement.
CREATE CONTINUOUS QUERY "test" ON "default" BEGIN SELECT sum(field1) AS field1_count, count(filed1) AS all_filed1_count INTO "default"."test1"."test1" FROM "default"."test2"."test2" GROUP BY time(5m, 0s) fill(0) END

Expected behavior:
data match

Actual behavior:
1. Query from raw measurement:
SELECT sum(field1) AS filed1_count, count(field1) AS all_filed1_count FROM "test2"."test2" where time > 1534658300000000000 GROUP BY time(5m, 0s) fill(0) order by time desc
Result:

time                 filed1_count all_filed1_count
----                 ------------ ----------------
2018-08-19T07:05:00Z 52173        52173
2018-08-19T07:00:00Z 50041        50041
2018-08-19T06:55:00Z 50122        50124
2018-08-19T06:50:00Z 50368        50368
2018-08-19T06:45:00Z 50467        50471
2018-08-19T06:40:00Z 46652        46652
2018-08-19T06:35:00Z 42666        42666
2018-08-19T06:30:00Z 39984        39984
2018-08-19T06:25:00Z 41295        41295
2018-08-19T06:20:00Z 40886        40886

2. Query from Continuous queries measurement:
SELECT filed1_count, all_filed1_count FROM "test1"."test1" order by time desc limit 10;
Result:

time                 filed1_count all_filed1_count
----                 ------------ ----------------
2018-08-19T07:05:00Z 52156        52156
2018-08-19T07:00:00Z 50027        50027
2018-08-19T06:55:00Z 50116        50118
2018-08-19T06:50:00Z 50368        50368
2018-08-19T06:45:00Z 50304        50382
2018-08-19T06:40:00Z 46652        46652
2018-08-19T06:35:00Z 42666        42666
2018-08-19T06:30:00Z 39958        39958
2018-08-19T06:25:00Z 41295        41295
2018-08-19T06:20:00Z 40862        40886

Problem
The query result differs

@stale
Copy link

stale bot commented Jul 24, 2019

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

@stale stale bot added the wontfix label Jul 24, 2019
@stale
Copy link

stale bot commented Jul 31, 2019

This issue has been automatically closed because it has not had recent activity. Please reopen if this issue is still important to you. Thank you for your contributions.

@stale stale bot closed this as completed Jul 31, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants