I'm currently exploring GridDB for storing IoT sensor data and device metadata.
I have two containers.
- devices
device_id
device_name
location
- sensor_data
device_id
temperature
timestamp
In many relational databases, I would normally join these tables to retrieve device information together with sensor readings.
Example SQL query:
sql
SELECT s.device_id, s.temperature, d.device_name
FROM sensor_data s
JOIN devices d
ON s.device_id = d.device_id;
What I expected
Example desired output:
device_id | device_name | temperature | timestamp
101 | Sensor_A | 26.5 | 2025-03-20
I expected that this query would return sensor readings together with the corresponding device name.
However, I could not find documentation confirming whether GridDB supports JOIN operations between containers.
Questions
• Does GridDB support JOIN operations between containers?
• If not, what is the recommended way to combine related data stored in different containers?
• Should this type of join logic be implemented in the application layer instead?
Any suggestions or best practices would be appreciated.