Left join in influx DB

database join relational-database left-join influxdb
Sajith picture Sajith · Oct 15, 2014 · Viewed 18.6k times · Source

I am new to influx DB. Now I need to migrate MySQL db into influxDB. I chose influx DB because it support SQL like queries. But I could not found left join in it. I have a series called statistics which contains browser_id and another series contains browser list. How can I join these 2 tables like relational database concept? I wrote this query but it is not giving any result.

select * from statistics as s inner join browsers as b where s.browser_type_id  = b.id

statistics

enter image description here

browsers

enter image description here

Answer

jvshahid picture jvshahid · Oct 15, 2014

You cannot join series in InfluxDB using arbitrary columns. InfluxDB only supports joining time series based on the time column. This is a special type of join unlike the one you're used to in relational databases. Time join in InfluxDB tries to correlate points from different time series that happened at approximately the same time. You can read more about joins in InfluxDB in the docs

Related questions

When and why are database joins expensive?

I'm doing some research into databases and I'm looking at some limitations of relational DBs. I'm getting that joins of large tables is very expensive, but I'm not completely sure why. What does the DBMS need to do to execute …

Read More
What are the uses for Cross Join?

A cross join performs a cartesian product on the tuples of the two sets. SELECT * FROM Table1 CROSS JOIN Table2 Which circumstances render such an SQL operation particularly useful?

Read More
How to store a one to many relation in my sql database ? (MySQL)

I'm making a website and I need to store a random number of data in my database. for example: User john may have one phone number where jack can have 3. I need to be able so store an infinite number …

Read More