556 questions
-1
votes
0
answers
38
views
Combine GROUP BY RANGE(ts) with another column (e.g. deviceid) - and still use FILL [closed]
Goal:
Hourly buckets per device, and return a row for every hour per device (use FILL(NULL) for missing hours).
Schema + Sample Data:
CREATE TABLE TSDB (
ts TIMESTAMP PRIMARY KEY, -- row key
...
- 989
0
votes
0
answers
24
views
Are multi-put/batched put() operations atomic across replicas, or can partial replication occur per partition?
I run a 3-node GridDB cluster (replication factor = 2). I insert time-series rows from multiple threads using the Python client, using a TIMESTAMP column as the row-key (client generates timestamps). ...
0
votes
0
answers
21
views
Latest Row ≤ a target timestamp per deviceid (single statement) [duplicate]
I’m on GridDB Cloud (Free). For a TimeSeries container I need, for a given :target_ts, the latest row at or before that timestamp per deviceid in one SQL statement.
Schema & Seed Data:
CREATE ...
- 989
0
votes
0
answers
59
views
Get hierarchical structure from a single table
Expected result is somewhat hierarchical structure from a single table in griddb cloud as shown in below table, where every row contains hourly data in a way that there is only one device entry per ...
- 108
0
votes
0
answers
86
views
What is data affinity in terms of SQL and how it is related to partitioning? [closed]
Data affinity is mentioned in SQL Reference Documentation
Option related to data affinity can be specified in the format "WITH
(property key = property value, ...)"
with a link to Feature ...
- 108
4
votes
0
answers
105
views
Unable to connect to GridDB Cloud using Python requests (Web API)
I’m trying to connect to GridDB Cloud from Python using the Web API to create a container (table), insert a row, and query it. However every request returns a 403 Forbidden error.
In my Python script ...
- 7
0
votes
0
answers
60
views
Composite key (ts, deviceid) with timeseries container
I’m on GridDB Cloud (Free). For a TimeSeries container, I want each device to have at most one row per timestamp, i.e., enforce uniqueness on (ts, deviceid).
Schema:
CREATE TABLE TSDB (
ts TIMESTAMP ...
- 989
0
votes
2
answers
82
views
Correct syntax for selecting data between NOW() and the previous hour
Considering that GridDB does not provide an INTERVAL keyword and will result in a syntax error, what is the correct syntax for selecting data between NOW() and the previous hour in GridDB/GridDB Cloud?...
- 108
0
votes
0
answers
44
views
Single-statement UPSERT for TimeSeries rows (e.g., MERGE / ON CONFLICT) [closed]
I’m on GridDB Cloud (Free) and need an idempotent write for a TimeSeries container: if a row with the same timestamp (row key) already exists, update it; otherwise insert it.
Minimal repro:
-- ...
- 989
1
vote
0
answers
160
views
Get hourly timestamped data using a string identifier
In the scenario where sensor data is attached to a specific string identifier in GridDb/GridDb Cloud, the SQL query should return hourly sensor data only matching with a certain combination of letters....
- 108
3
votes
0
answers
71
views
GridDB Cloud client failing with "Failed to import 'org.apache'" using JPype
I’m working on a demo project to simulate an IoT device using Python and GridDB.
I’m trying to connect to GridDB Cloud from a Windows environment.
I keep running into the following error:
Failed to ...
- 7
1
vote
1
answer
83
views
How to use FIXED_LIST instead of MULTICAST in griddb using jdbc driver
The GridDB server has been configured to use FIXED_LIST instead of MULTICAST and is functioning correctly. While the c_client and Java samples within GridDB operate as intended, the samples for JDBC ...
- 108
1
vote
1
answer
75
views
Efficiently query the latest row per device in a time-series container
I’m working with GridDB Cloud (Free Tier) using the Python client (latest version on Ubuntu 22.04).
I have a container called sensor_data with this schema:
device_id STRING,
created_at TIMESTAMP,
...
- 19
2
votes
1
answer
76
views
Create a composite row key in GridDB using NewSQL
How to create a composite row key in GridDB using NewSQL?
I am creating a collection container for storing thermostat data for multiple devices. I want to have the composite key on device_id and ...
- 73
0
votes
1
answer
31
views
GridDB Python client inserting datetime object into TIMESTAMP column
I’m using GridDB Cloud (Free Tier) with the official Python client (latest pip release) on Ubuntu 22.04.
My container schema looks like this:
device_id STRING,
created_at TIMESTAMP,
temperature DOUBLE
...
- 19