influxdata / influxdata/kapacitor
Tick script with multiple tag values
- Dominant language
- Go
- Stars
- 2.4k
- Forks
- 479
- Avg merge
- 4d 16h
- Merged PRs (30d)
- 4
Description
I have a tick script where I have to run query with where clause on multiple interface_name which looks something like this:
`query('''SELECT last("state") as "value" FROM router.autogen.cisco_router where type = 'interface' and host = '10.66.14.82' and ("name"='GigabitEthernet0/0/0' OR "name"='GigabitEthernet0/0/1') ''')`
and this query run on influx db but kapacitor change this query to something like this:
`SELECT last("state") as "value" FROM router.autogen.cisco_router where type = 'interface' and host = '10.66.14.82' and (\"name\"='GigabitEthernet0/0/0' OR \"name\"='GigabitEthernet0/0/1')`
how to avoid \ befor " in tick script.
Contributor guide
Research direction
The report provides no source file or test; start by reproducing the shown TICK query and comparing the query sent to InfluxDB with the original text. Done means determining whether Kapacitor incorrectly adds backslashes before the quoted tag values and documenting a verified fix or limitation.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100