Hi all,

I'm new to influxdb, so I may not be understanding something about it.  
However, I've been trying to do some queries against my data and I'm running 
into some unexpected results.  I've distilled the problem down to this very 
simple case:


> select * from testtable;
name: testtable
time                    value
----                    -----
1970-01-18T04:43:14.92Z 3

> select sum(value) from testtable where value > 0;
name: testtable
time                 sum
----                 ---
1970-01-01T00:00:00Z 3

> select sum(value) from (select value from testtable) where value > 0;
> 


What does it mean when it returns no result like that?  Am I missing something 
here?  Simpler queries with the subquery seem to work fine (withough the sum or 
without the where), I get the data back.

This is influxdb 1.2 on Fedora 25.



Thanks

Scot

-- 
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+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@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/d826cb0b-d83a-4a00-92e8-ab9c18ac9c63%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to