On Mon, Jun 13, 2016 at 12:14 PM, Michael Reed <[email protected]> wrote:
> Hi, > > Just starting off. I do a query and receive results (Yea!). > > But then I add to the WHERE clause, and don't get any results (Boo) > Your quoting syntax is off. It's not intuitive, but in queries string values must be single-quoted. Otherwise the parser interprets them as identifiers: https://docs.influxdata.com/influxdb/v0.13/troubleshooting/frequently_encountered_issues/#single-quoting-and-double-quoting-in-queries What you want is SELECT * FROM meter_1 WHERE time >= '2016-06-13T10:48:37-07:00' AND time <= '2016-06-13T10:49:37-07:00' AND test_id='1' > > Then I try an aggregate function, but only get results for COUNT() (Boo) > I'll bet dollars to donuts that your field values are strings, not floats. The COUNT() will still return, but all the other functions fail on string values. Check your write statements to make sure the numbers are being written WITHOUT double-quotes. This will write as a number: meter_1,test_id=1 units="foo",value=117.47 This will write as a string: meter_1,test_id=1 units="foo",value="117.47" > > What am I doing wrong? > > Thanks > > > > > SELECT * FROM meter_1 WHERE time >= '2016-06-13T10:48:37-07:00' AND > time <= '2016-06-13T10:49:37-07:00' > name: meter_1 > ------------- > time test_id units value > 2016-06-13T17:48:41Z 1 117.47 > 2016-06-13T17:48:46Z 1 119.88 > 2016-06-13T17:48:52Z 1 118.07 > 2016-06-13T17:48:56Z 1 118.32 > 2016-06-13T17:49:01Z 1 118.67 > 2016-06-13T17:49:06Z 1 119.47 > 2016-06-13T17:49:11Z 1 118.95 > 2016-06-13T17:49:16Z 1 117.78 > 2016-06-13T17:49:21Z 1 115.26 > 2016-06-13T17:49:26Z 1 117.74 > 2016-06-13T17:49:31Z 1 119.40 > 2016-06-13T17:49:36Z 1 115.25 > > > SELECT * FROM meter_1 WHERE time >= '2016-06-13T10:48:37-07:00' AND > time <= '2016-06-13T10:49:37-07:00' AND test_id="1" > > SELECT * FROM meter_1 WHERE time >= '2016-06-13T10:48:37-07:00' AND > time <= '2016-06-13T10:49:37-07:00' AND test_id=1 > > SELECT COUNT(value), MAX(value), MIN(value), SUM(value), MEAN(value) > FROM meter_1 WHERE time >= '2016-06-13T10:48:37-07:00' AND time <= > '2016-06-13T10:49:37-07:00' > name: meter_1 > ------------- > time count max min sum mean > 2016-06-13T17:48:37Z 12 0 0 0 0 > > > SHOW SERIES; > name: Meter_1 > ------------- > _key test_id > Meter_1,test_id=1 1 > > > name: Meter_2 > ------------- > _key test_id > Meter_2,test_id=1 1 > > > name: Meter_3 > ------------- > _key test_id > Meter_3,test_id=1 1 > > > name: Meter_4 > ------------- > _key test_id > Meter_4,test_id=1 1 > > > name: meter_1 > ------------- > _key test_id > meter_1,test_id=1 1 > > > name: meter_2 > ------------- > _key test_id > meter_2,test_id=1 1 > > > name: meter_3 > ------------- > _key test_id > meter_3,test_id=1 1 > > > name: temperature_2 > ------------------- > _key test_id > temperature_2,test_id=1 1 > > > SHOW MEASUREMENTS; > name: measurements > ------------------ > name > Meter_1 > Meter_2 > Meter_3 > Meter_4 > meter_1 > meter_2 > meter_3 > temperature_2 > > > SHOW TAG KEYS; > name: Meter_1 > ------------- > tagKey > test_id > > > name: Meter_2 > ------------- > tagKey > test_id > > > name: Meter_3 > ------------- > tagKey > test_id > > > name: Meter_4 > ------------- > tagKey > test_id > > > name: meter_1 > ------------- > tagKey > test_id > > > name: meter_2 > ------------- > tagKey > test_id > > > name: meter_3 > ------------- > tagKey > test_id > > > name: temperature_2 > ------------------- > tagKey > test_id > > > SHOW FIELD KEYS; > name: Meter_1 > ------------- > fieldKey > units > value > > > name: Meter_2 > ------------- > fieldKey > units > value > > > name: Meter_3 > ------------- > fieldKey > units > value > > > name: Meter_4 > ------------- > fieldKey > units > value > > > name: meter_1 > ------------- > fieldKey > units > value > > > name: meter_2 > ------------- > fieldKey > units > value > > > name: meter_3 > ------------- > fieldKey > units > value > > > name: temperature_2 > ------------------- > fieldKey > units > value > > > > > > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > 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/e2460c60-ea9a-4b15-9d88-8038c9902768%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/e2460c60-ea9a-4b15-9d88-8038c9902768%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- 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 [email protected]. To post to this group, send email to [email protected]. 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/CALGqCvPMViU8GP2VfZq_yk%3DVGf6ZBjeYZZ6g_9-uAicPJZbtJA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
