influxdata / influxdata/kapacitor

querynode's error of tickscript

Open
#2,026 1 comment 0 reactions 0 assignees View on GitHub
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.
![hxg x khp7 u6 14zctkway](https://user-images.githubusercontent.com/29338660/44195465-b7ade680-a16b-11e8-9ab6-5e6e35bdcf31.png)

![vv63 wwq y9r ynem3 w](https://user-images.githubusercontent.com/29338660/44195573-078cad80-a16c-11e8-91f4-e007b878a4a6.png)

![vvbjhewqns9fpfj vpeqh69](https://user-images.githubusercontent.com/29338660/44195652-44f13b00-a16c-11e8-8aa0-3e59cde9811e.png)

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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.