There are no JOINs in InfluxDB 0.9+. Instead, all series under a given measurement are automatically merged and are only separated by explicit filters in the WHERE or GROUP BY clauses.
There is no way to perform cross-measurement math or grouping. All related data must be under one measurement in order to query it together. Why not store all the user data together in one measurement? InfluxDB is NOT a relational database. Mapping tables are not good schema for InfluxDB and normalization is an anti-pattern for the most part. Just store *users:* time, value, username, users_group, more_tags, more values... On Mon, Jun 13, 2016 at 5:18 AM, Claudio Heidel <[email protected]> wrote: > > Hi guys, I'm looking for the best solution to the follow problem: > > I have 2 measurements, one with the values and users_activity tag and > other with the users_groups: > > *users_activity:* > > time, value, username, more_tags, more values... > > *users_groups:* > > time, user_name, users_group > > (every user could be inside more than one group) > > *Questions:* > > 1.- The InfluxDb 0.13 don't support inner joins , select in, cross > measurements matching ? > 2.- How to / what's the best practice to get all data from users activity > for a group of users? > > Thanks of lot! > Claudio > > > > > > > -- > 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/CAN6_Dy-UZJg19zqC2L9CGb%2BxNdfTF-OU90SmuCz0%3DCL-WGtWfA%40mail.gmail.com > <https://groups.google.com/d/msgid/influxdb/CAN6_Dy-UZJg19zqC2L9CGb%2BxNdfTF-OU90SmuCz0%3DCL-WGtWfA%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/CALGqCvPzoLhUEe5SyhC7wrWrXNHQq2Kd8hr5DUtcnne84mikag%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
