Discussion:
[influxdb] In Influxdb, how do I concat values in my query?
Dhawal Patel
2015-07-14 18:10:39 UTC
Permalink
I would like to query all rows where columnA = 'xyz' + columnB:

select * from myTable where colA = 'xyz' + colB
--
Remember to include the InfluxDB version number with all issue reports
---
You received this message because you are subscribed to the Google Groups "InfluxDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to influxdb+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at http://groups.google.com/group/influxdb.
To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/2d91c7db-a521-4094-98cc-d038a710b200%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
c***@wanderu.com
2018-01-24 17:10:53 UTC
Permalink
tables and rows don't exist in InfluxDB, but I think you're asking for 
`select * from measurement where tag = 'string' + another_tag`
That's not a valid query in the current syntax. Can you provide an actual use case for that? I'm not following what you're trying to accomplish.
Note that InfluxDB supports regular expression matching for tags, so `select * from measurement where tag =~ /xyx.*/` is valid
I would like to query all rows where columnA = 'xyz' + columnB:select * from myTable where colA = 'xyz' + colB
--
Remember to include the InfluxDB version number with all issue reports
---
You received this message because you are subscribed to the Google Groups "InfluxDB" group.
Visit this group at http://groups.google.com/group/influxdb.
To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/2d91c7db-a521-4094-98cc-d038a710b200%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Sean Beckett
Director of Support and Professional Services
InfluxDB
A use case is formatting for grafana annotations. I want to concatenate multiple fields for the text section of the grafana annotation.
--
Remember to include the version number!
---
You received this message because you are subscribed to the Google Groups "InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email to influxdb+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/ee187ca1-ee4d-4b54-b735-13fd71de4b19%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Loading...