As an example
I have 3 events like
{
id = "ABC"
type="seen"
}
{
id = "ABC"
type = "received"
}
{
id = 'XYZ"
type="seen"
}
So if query as
select id from events where type="seen" and type <> "received'
I am expecting only event with id "XYZ" to be returned, but I also see
event id "ABC" in the output
-Sumant
On Wed, Jul 6, 2016 at 4:22 PM Sean Beckett <[email protected]> wrote:
> I'm confused by your example. If the type = "seen" then by definition the
> type cannot also equal "opened". Also if you are GROUPing by the type, but
> set type equal to one value, you are only going to get one group and the
> entire GROUP BY clause is redundant.
>
> Can you provide actual input and output data to clarify? What query are
> you running, and what is it not returning?
>
> On Wed, Jul 6, 2016 at 5:00 PM, <[email protected]> wrote:
>
>> I have a field in my event called "type" and type can be either "seen",
>> "opened", "received" etc. Each on the incoming event type also has field
>> for "id" of the user. Based on used action event are generated with type
>> being "seen", "opened", "received" etc. I have to create a tag for the
>> "type" field, since we want to groupby on the field to get aggregation of
>> data based on type. I am trying to write a query to return only id which
>> have type = "seen" and type is not "opened" but the query return id's where
>> users have "seen" and "opened" too.
>>
>> Any help is appreciated.
>>
>> -Sumant
>>
>
>> --
>> 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/640533fd-eabf-43e7-aae1-3d4ecec6b3b9%40googlegroups.com
>> .
>> 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 a topic in the
> Google Groups "InfluxDB" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/influxdb/fXR5P8M52Oc/unsubscribe.
> To unsubscribe from this group and all its topics, 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/CALGqCvNjpmyVB7aap3%3DEMijVte-nFy7R2aGpXH9u01mKo9b48w%40mail.gmail.com
> <https://groups.google.com/d/msgid/influxdb/CALGqCvNjpmyVB7aap3%3DEMijVte-nFy7R2aGpXH9u01mKo9b48w%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>
--
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/CACc9oUSHk-p%2BV8dWw5NTnhD6%3D_-OHS8jQbJY80D9tdTH_E6wKw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
