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) Then I try an aggregate function, but only get results for COUNT() (Boo) 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. For more options, visit https://groups.google.com/d/optout.
