influxdata / influxdata/kapacitor
querynode's error of tickscript
- Dominant language
- Go
- Stars
- 2.4k
- Forks
- 479
- Avg merge
- 4d 16h
- Merged PRs (30d)
- 4
Description
Hi,
I cannot get the data from influxdb when I use tickscript sometimes.



It seem wrong that kapacitor generate the wrong SQL . This is the reason why I can't get the data from influxdb correctly. In this case, How to get rid of the part "AND time >= '2018-08-16T07:13:00Z' AND time < '2018-08-16T07:13:00Z'"
AND time >= '2018-08-16T07:42:00Z' AND time < '2018-08-16T07:42:00Z'
I found that I have to use the .period() to avoid this problem.
Is the .period() method mandatory when we use queryNode?
Contributor guide
Research direction
The report names queryNode, .period(), and generated InfluxDB time predicates, but no source file or test. Start by reproducing the tickscript shown in the attached screenshots and inspect the generated query; the issue is resolved when queryNode no longer produces an empty time range or the required use of .period() is clearly documented.
Written by the indexing model from the issue text.
Assessment
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100