InfluxDB is not a relational database.
{
id = "ABC"
type="seen"
}
and
{
id = "ABC"
type = "received"
}
are different records entirely. The second does not modify the first, nor
do they create a single record. When you run the query as described you get
the first record returned but not the second. That is the proper behavior
for the system as designed.
The query you want to run is really "show me all IDs where type="seen" at
least once but type has never been equal to "received". I don't think
that's possible with InfluxDB. You could run two queries, one to get the
type="seen" and another to get type="received" and then remove the IDs in
the latter from the former.
On Wed, Jul 6, 2016 at 5:42 PM, Sumant Munjal <[email protected]>
wrote:
>
> 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
> <https://groups.google.com/d/msgid/influxdb/CACc9oUSHk-p%2BV8dWw5NTnhD6%3D_-OHS8jQbJY80D9tdTH_E6wKw%40mail.gmail.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/CALGqCvNz9%3DjzkYyu4qLrpXcBVNxVPu%2B%3DKF1D_aig%2B2wO-aTCPw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
